Component : Oracle -

Solution : https://service.sap.com/sap/support/notes/563574 (SAP Service marketplace login required)

Summary :
The SAP Note addresses ORA-12514 error, which surfaces when the Oracle listener fails to resolve the SERVICE_NAME in a Net8 environment setup. The issue often arises from configuration inconsistencies between tnsnames.ora, listener.ora, and init.ora. The solution suggests verifying these configurations align correctly across SERVICE_NAME, SERVICE_NAMES, DB_DOMAIN, and GLOBAL_DBNAME parameters. Best practices include using the ‘ALTER SYSTEM REGISTER’ command for immediate registration of database instances with the listener or modifying the STARTDB script to incorporate delay for proper listener registration to prevent timing-related errors during database startup under STARTSAP routines.

Key words :
database failed' >> $log              echo '    notify database administrator, /dev/null > /dev/null 2>&1          # save returncode, lsnrctl  set displaymode raw  servicesthe result, oracle_home = /oracle/<sid>/817_64/bin, ' >> $log              errorexit $error_dbinconsistent          fi, incorrect net8 configuration files, echo 'r3trans check finished, database instances automatically register, database instance registers, alter system register

Related Notes :

562403	FAQ: Oracle Net
445038	Problems when accessing Net8 configuration files