Search This Blog

Tuesday, February 13, 2007

Ora-12162 On linux after ORacle Installation

[oracle@alwarid-taj bin]$ ./sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Feb 13 19:17:55 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Enter user-name: system
Enter password:
ERROR:
ORA-12162: TNS:net service name is incorrectly specified

[oracle@alwarid-taj bin]$ ./netca

Oracle Net Services Configuration:


We have to configure LISTENER.ORA or TNSNAMES.ORA or SQLNET.ORA file. if files are not already created then we have to created.












SQLNET.ORA FILE










TNSNAMES.ORA
























1 comment:

Anonymous said...

I am getting the same error as below while trying to login to oracle db.

ERROR:
ORA-12162: TNS:net service name is incorrectly specified

where do i found "netca" fine to execute?