Home » RDBMS Server » Server Administration » Oracle9i client can not connect
Oracle9i client can not connect [message #61162] Thu, 01 April 2004 16:25 Go to next message
chenghf
Messages: 2
Registered: April 2004
Junior Member
I install Oracle9.2.0.4 on RedHat AS 3 success;

I execute sqlplus on server, but can connect on client

error: TNS-12560

[[oracle@smsdb oracle]]$ lsnrctl status

LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 02-APR-2004 10:09:17

Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 9.2.0.4.0 - Production
Start Date                02-APR-2004 10:08:41
Uptime                    0 days 0 hr. 0 min. 35 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter File   /home/oracle/OraHome1/network/admin/listener.ora
Listener Log File         /home/oracle/OraHome1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.1.1.21)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "smsdb" has 1 instance(s).
  Instance "smsdb", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[[oracle@smsdb oracle]]$
Re: Oracle9i client can not connect [message #61163 is a reply to message #61162] Thu, 01 April 2004 19:00 Go to previous messageGo to next message
Raja
Messages: 57
Registered: March 2000
Member
If the SqlPlusw client try connecting thru iSqlPlus.
Re: Oracle9i client can not connect [message #61166 is a reply to message #61162] Thu, 01 April 2004 19:19 Go to previous messageGo to next message
Anatol Ciolac
Messages: 113
Registered: December 2003
Senior Member
This error semm that your listener cannot to find a database based on instructions, that you are writed in listener.ora. Edit your listener.ora and try again.
Re: Oracle9i client can not connect [message #61183 is a reply to message #61166] Sun, 04 April 2004 01:48 Go to previous message
chenghf
Messages: 2
Registered: April 2004
Junior Member
thanks.

I had found the cause. it's fairwall caused.
Previous Topic: Connection with PE 8i and Forms6i
Next Topic: Installing oracle on Linux
Goto Forum:
  


Current Time: Mon Sep 08 11:12:30 CDT 2025