2
Answers

error while accessing the orale 9i(sql plus)

ashwini bhingole

ashwini bhingole

12y
1.9k
1
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.




Answers (2)
0
Shankar M

Shankar M

NA 3.6k 1.7m 12y


Hi User,

Add the Connection String to the remote database in the TNSNAMES.ora usually located in $ORACLE_HOME\ora81\network\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\network\admin\sqlnet.ora

C:\oracle\ora81\network\admin\tnsnames.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

0
Akkiraju Ivaturi

Akkiraju Ivaturi

NA 9.5k 2.5m 12y
Please go through the following link. It may help:

http://www.dba-oracle.com/t_ora_12500_listener_process.htm.