Home » RDBMS Server » Networking and Gateways » Connecting String Problem
Connecting String Problem [message #192316] Mon, 11 September 2006 16:34 Go to next message
boseinfo
Messages: 22
Registered: December 2005
Location: Bahrain
Junior Member
Hi

I am using Oracle on Linux box. when I connect to oracle directly on server using apps/apps it is getting connected.

SQL> conn apps/apps
Connected.


But when I use apps/apps@prod it is throwing an error as below

SQL> conn apps/apps@prod
ERROR:
ORA-12560: TNS:protocol adapter error


Warning: You are no longer connected to ORACLE.

The following are already done
1. Database started.

2. tnsnames.ora content
PROD = (DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=apps)(PORT=1521))
(CONNECT_DATA=(SID=PROD))
)

3. listener.ora content
PROD =
(ADDRESS_LIST =
(ADDRESS= (PROTOCOL= IPC)(KEY= PROD))
(ADDRESS= (PROTOCOL= TCP)(HOST= apps)(Port= 1521))
)

SID_LIST_PROD =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME= PROD)
(ORACLE_HOME= /visdb/proddb/9.2.0)
(SID_NAME = PROD)
)
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /visdb/proddb/9.2.0)
(PROGRAM = extproc)
)
)

STARTUP_WAIT_TIME_PROD = 0
CONNECT_TIMEOUT_PROD = 10
TRACE_LEVEL_PROD = OFF

LOG_DIRECTORY_PROD = /visdb/proddb/9.2.0/network/admin
LOG_FILE_PROD = PROD
TRACE_DIRECTORY_PROD = /visdb/proddb/9.2.0/network/admin
TRACE_FILE_PROD = PROD


Please let me know what exactly went wrong.

Thank u
Bose
Re: Connecting String Problem [message #192324 is a reply to message #192316] Mon, 11 September 2006 18:45 Go to previous messageGo to next message
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
Senior Member
Listener started?
lsnrctl start
Re: Connecting String Problem [message #192523 is a reply to message #192316] Tue, 12 September 2006 13:18 Go to previous messageGo to next message
boseinfo
Messages: 22
Registered: December 2005
Location: Bahrain
Junior Member
Listener started.

Listener info....

[oracle@apps 9.2.0]$ lsnrctl start

LSNRCTL for Linux: Version 9.2.0.3.0 - Production on 12-SEP-2006 23:42:06

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

Starting /visdb/proddb/9.2.0/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 9.2.0.3.0 - Production
System parameter file is /visdb/proddb/9.2.0/network/admin/PROD_apps/listener.or a
Log messages written to /visdb/proddb/9.2.0/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=apps.oracle.com)(PORT=15 21)))

Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 9.2.0.3.0 - Production
Start Date 12-SEP-2006 23:42:06
Uptime 0 days 0 hr. 0 min. 3 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /visdb/proddb/9.2.0/network/admin/PROD_apps/listener.o ra
Listener Log File /visdb/proddb/9.2.0/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=apps.oracle.com)(PORT=1521)))
The listener supports no services
The command completed successfully
Re: Connecting String Problem [message #192836 is a reply to message #192523] Wed, 13 September 2006 16:49 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
How does your SQLNET.ORA file looks like?
Re: Connecting String Problem [message #192873 is a reply to message #192316] Thu, 14 September 2006 01:04 Go to previous messageGo to next message
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
Senior Member
.

[Updated on: Thu, 14 September 2006 01:27]

Report message to a moderator

Re: Connecting String Problem [message #192882 is a reply to message #192316] Thu, 14 September 2006 01:28 Go to previous messageGo to next message
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
Senior Member
SQLNET.ORA Network Configuration File: C:\Oracle\817\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
NAMES.DEFAULT_DOMAIN = WORLD
Re: Connecting String Problem [message #192888 is a reply to message #192882] Thu, 14 September 2006 01:44 Go to previous message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Unless you, nmacdannald, and OP boseinfo are the same persons, how could your SQLNET.ORA help to figure out what's wrong with boseinfo's configuration?

Or is there something here that I don't understand/see?
Previous Topic: Multiple oidldapd processes are created by oidctl connect=oidp server=oidldapd
Next Topic: TNSPing anwsers ok but sqlplus can't connect
Goto Forum:
  


Current Time: Sat Dec 14 00:35:48 CST 2024