error while accessing the orale 9i(sql plus)

Question

hi..
Am installed oracle 9i on my laptop.when am accessing sql plus then it gives the error.

ERROR:-
ORA-12500: TNS:listener failed to start a dedicated server process.

so, tell me how to solve this error.

Shankar M · Answer

Hi User, Add the Connection String to the remote database in the TNSNAMES.ora usually located in $ORACLE_HOME\ora81
etwork\ADMIN And, Once added you can check the Service for the database can be reached using http://www.oracleutilities.com/OSUtil/ping.html Something like this, From Command Prompt, C:\Documents and Settings\s0891811>tnsping orcl TNS Ping Utility for 32-bit Windows: Version 9.0.1.3.1 - Production on 13-OCT-20 12 10:59:11 Copyright (c) 1997 Oracle Corporation. All rights reserved. Used parameter files: C:\oracle\ora81
etwork\admin\sqlnet.ora C:\oracle\ora81
etwork\admin	nsnames.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 17.12.1.9)(PORT = 1521))) (CONNECT_DATA = (SID = orcl))) OK (70 msec) C:\Documents and Settings\s0891811> Here orcl is the database you are trying to connect. Thanks, Shankar

Akkiraju Ivaturi · Answer

Please go through the following link. It may help: http://www.dba-oracle.com/t_ora_12500_listener_process.htm .