0

We have an oracle 11g cloud database that was working fine until recently when it started throwing the ORA-12514 after every reboot. The instance is programmed to be started up every morning and shutdown two hours later.

To be able to fix this, I have to do the following every morning because it gets reinitialized after rebooting:

1) sudo su oracle
2) sqlplus /nolog
3) connect sys/xxxxxx as sysdba
4) shutdown abort;
5) startup
6) alter system set local_listener ='(ADDRESS=(PROTOCOL=TCP)(HOST=xxxxxx.subnet.vcn.oraclevcn.com)(PORT=1521))' SCOPE=BOTH;
7) alter system register
8) quit 

I have tried many things. First of all, I have tried tnsping the database and it works fine, so the listener is reachable.

I have seen in many other posts that we need to have the same service name in the database, in the listener.ora and tnsnames.ora files to fix this error, so I made sure of that.

Here are the tnsnames.ora file:

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

DB2020 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = xxxxx.subnet.vcn.oraclevcn.com)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = DB2020_lhr1vc.subnet.vcn.oraclevcn.com)
    )
  )
 

and the listener.ora file:

# listener.ora Network Configuration File: /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = xxxxx.subnet.vcn.oraclevcn.com)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

1 Answer 1

0

So it works fine when you add it back in manually, but not when it starts itself?
Sounds like the "LOCAL_LISTENER" Initialization Parameter in the database itself has been lost.

Not sure why you're using a non-standard Listener anyway, but then you're running an unsupported version anyway. Not sure which will give you more trouble.
You should seriously consider upgrading.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.