Check that you have a tnsnames.ora file with your service name properly defined.
Try to tnsping the service name. If successful, it should look something like this:
C:>tnsping oratst01 TNS Ping Utility for 32-bit Windows: Version 10.1.0.2.0 - Production on 09-NOV-2005 21:41:21 Copyright (c) 1997, 2003, Oracle. All rights reserved. Used parameter files: C:oracleproduct10.1.0db_1networkadminsqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = C373)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = ORATST01))) OK (30 msec)Also, check that the listener is up and that your database has registered with the listener. At the command prompt, type:
lsnrctl statusYou should see output similar to this and your instance registered with the listener:
C:>lsnrctl status LSNRCTL for 32-bit Windows: Version 10.1.0.2.0 - Production on 09-NOV-2005 21:43:04 Copyright (c) 1991, 2004, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=c373)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Production Start Date 09-NOV-2005 21:14:43 Uptime 0 days 0 hr. 28 min. 20 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File C:oracleproduct10.1.0db_1networkadminlistener.ora Listener Log File C:oracleproduct10.1.0db_1networkloglistener.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\.pipeEXTPROCipc))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=c373)(PORT=8080))(Presentation=HTTP)(Session=RAW)) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=c373)(PORT=2100))(Presentation=FTP)(Session=RAW)) Services Summary... Service "ORATST01XDB" has 1 instance(s). Instance "oratst01", status READY, has 1 handler(s) for this service... Service "PLSExtProc" has 1 instance(s). Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... Service "oratst01" has 1 instance(s). Instance "oratst01", status READY, has 1 handler(s) for this service... The command completed successfully
Dig deeper on Oracle database installation, upgrades and patches
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.