In this practice you will perform simple
connection troubleshooting. The purpose of this practice is to familiarize you
with some of the more common Oracle Net error messages and their causes.
Instructions
1. Stop
the listener and attempt to connect from your client.
|
LSNRCTL> stop listener01 Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dpkirby-us)(PORT=8001))) The command completed successfully LSNRCTL> SQL> conn system/manager@david ERROR: ORA-12541: TNS:no listener Warning: You are no longer connected to ORACLE. SQL> |
2. Restart
the listener.
|
LSNRCTL> start listener01 Starting tnslsnr: please wait... TNSLSNR for 32-bit Windows: Version 9.0.1.1.1 -
Production System parameter file is
D:\oracle\901\network\admin\listener.ora Log messages written to
D:\oracle\901\network\log\listener01.log Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dpkirby-us.us.oracle.com )(PORT=8001))) Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dpkirby-us)(PORT=8001))) STATUS of the LISTENER ------------------------ Alias listener01 Version TNSLSNR for 32-bit Windows: Version 9.0.1.1.1
- Produc tion Start Date 15-FEB-2002 18:33:11 Uptime 0 days 0 hr. 0 min. 2 sec Trace Level off Security OFF SNMP OFF Listener Parameter File D:\oracle\901\network\admin\listener.ora Listener Log File D:\oracle\901\network\log\listener01.log Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dpkirby-us.us.oracle.com)(PORT=8001) )) The listener supports no services The command completed successfully LSNRCTL> |
3. Attempt
to connect to your database using a tnsnames entry that does not exist.
|
SQL> conn system/manager@davidxxx ERROR: ORA-12154: TNS:could not resolve service name SQL> |
This completes this
practice.
ã Oracle Corporation, 2002
In this practice you will perform simple
connection troubleshooting. The purpose of this practice is to familiarize you
with some of the more common Oracle Net error messages and their causes.
Instructions
1. Stop
the listener and attempt to connect from your client.
|
LSNRCTL> stop listener01 Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dpkirby-us)(PORT=8001))) The command completed successfully LSNRCTL> SQL> conn system/manager@david ERROR: ORA-12541: TNS:no listener Warning: You are no longer connected to ORACLE. SQL> |
2. Restart
the listener.
|
LSNRCTL> start listener01 Starting tnslsnr: please wait... TNSLSNR for 32-bit Windows: Version 9.0.1.1.1 -
Production System parameter file is
D:\oracle\901\network\admin\listener.ora Log messages written to
D:\oracle\901\network\log\listener01.log Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dpkirby-us.us.oracle.com )(PORT=8001))) Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dpkirby-us)(PORT=8001))) STATUS of the LISTENER ------------------------ Alias listener01 Version TNSLSNR for 32-bit Windows: Version 9.0.1.1.1
- Produc tion Start Date 15-FEB-2002 18:33:11 Uptime 0 days 0 hr. 0 min. 2 sec Trace Level off Security OFF SNMP OFF Listener Parameter File D:\oracle\901\network\admin\listener.ora Listener Log File D:\oracle\901\network\log\listener01.log Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dpkirby-us.us.oracle.com)(PORT=8001) )) The listener supports no services The command completed successfully LSNRCTL> |
3. Attempt
to connect to your database using a tnsnames entry that does not exist.
|
SQL> conn system/manager@davidxxx ERROR: ORA-12154: TNS:could not resolve service name SQL> |
This completes this
practice.
ã Oracle Corporation, 2002
In this practice you will perform simple
connection troubleshooting. The purpose of this practice is to familiarize you
with some of the more common Oracle Net error messages and their causes.
Instructions
1. Stop
the listener and attempt to connect from your client.
|
LSNRCTL> stop listener01 Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dpkirby-us)(PORT=8001))) The command completed successfully LSNRCTL> SQL> conn system/manager@david ERROR: ORA-12541: TNS:no listener Warning: You are no longer connected to ORACLE. SQL> |
2. Restart
the listener.
|
LSNRCTL> start listener01 Starting tnslsnr: please wait... TNSLSNR for 32-bit Windows: Version 9.0.1.1.1 -
Production System parameter file is
D:\oracle\901\network\admin\listener.ora Log messages written to
D:\oracle\901\network\log\listener01.log Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dpkirby-us.us.oracle.com )(PORT=8001))) Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dpkirby-us)(PORT=8001))) STATUS of the LISTENER ------------------------ Alias listener01 Version TNSLSNR for 32-bit Windows: Version 9.0.1.1.1
- Produc tion Start Date 15-FEB-2002 18:33:11 Uptime 0 days 0 hr. 0 min. 2 sec Trace Level off Security OFF SNMP OFF Listener Parameter File D:\oracle\901\network\admin\listener.ora Listener Log File D:\oracle\901\network\log\listener01.log Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dpkirby-us.us.oracle.com)(PORT=8001) )) The listener supports no services The command completed successfully LSNRCTL> |
3. Attempt
to connect to your database using a tnsnames entry that does not exist.
|
SQL> conn system/manager@davidxxx ERROR: ORA-12154: TNS:could not resolve service name SQL> |
This completes this
practice.
ã Oracle Corporation, 2002
In this practice you will perform simple
connection troubleshooting. The purpose of this practice is to familiarize you
with some of the more common Oracle Net error messages and their causes.
Instructions
1. Stop
the listener and attempt to connect from your client.
|
LSNRCTL> stop listener01 Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dpkirby-us)(PORT=8001))) The command completed successfully LSNRCTL> SQL> conn system/manager@david ERROR: ORA-12541: TNS:no listener Warning: You are no longer connected to ORACLE. SQL> |
2. Restart
the listener.
|
LSNRCTL> start listener01 Starting tnslsnr: please wait... TNSLSNR for 32-bit Windows: Version 9.0.1.1.1 -
Production System parameter file is
D:\oracle\901\network\admin\listener.ora Log messages written to
D:\oracle\901\network\log\listener01.log Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dpkirby-us.us.oracle.com )(PORT=8001))) Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dpkirby-us)(PORT=8001))) STATUS of the LISTENER ------------------------ Alias listener01 Version TNSLSNR for 32-bit Windows: Version 9.0.1.1.1
- Produc tion Start Date 15-FEB-2002 18:33:11 Uptime 0 days 0 hr. 0 min. 2 sec Trace Level off Security OFF SNMP OFF Listener Parameter File D:\oracle\901\network\admin\listener.ora Listener Log File D:\oracle\901\network\log\listener01.log Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dpkirby-us.us.oracle.com)(PORT=8001) )) The listener supports no services The command completed successfully LSNRCTL> |
3. Attempt
to connect to your database using a tnsnames entry that does not exist.
|
SQL> conn system/manager@davidxxx ERROR: ORA-12154: TNS:could not resolve service name SQL> |
This completes this
practice.
ã Oracle Corporation, 2002
