Troubleshooting

If you receive the below error message.

* ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

You must configure your service name in

$ ORACLE_HOME/NETWORK/ADMIN/ tnsnames.ora.

Examle :

ADAPTIME =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = adaptime75)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ADAP)
)
)

* ORA-00257:archiver error. Connect internal only, until freed.


Solution : Check archiver trace file for a detailed description of the problem. Also verify that the device specified in the initialization parameter ARCHIVE_LOG_DEST is set up properly for archiving.