-
ORA-12537: TNS:connection closed
I am trying to connect remotely to another linux server. When my servers are started as user 'A' and I connect through sqlplus as system/password@hos from the user 'oracle' i get this error message from the logs:
TNS-12518: TNS:listener could not hand off client connection
TNS-12547: TNS:lost contact
TNS-12560: TNS: protocol adapter error
TNS-00517: Lost contact
Linux Error: 32: Broken pipe
Our processes are set to 2000 so it isn't the processes. Can anyone help me out?
Thanks
DBA
-
Can you post what you have in listener.ora, listener.log and /var/log/messages?
-
How connecting via ssh as user oracle:
for example
$ ssh oracle@server
login as sys as sysdba
-
Sorry guys, got busy with other things. Here is the info you requested.
Listener.ora:
LISTEN_1521 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST=
(ADDRESS = (PROTOCOL = TCP)(HOST = IP ADDRESS)(PORT = 1521))
(SERVICE_NAME = SID)
)
listen.log:
type='UNKNOWN' level='16' host_id='hostname'
host_addr='IP ADDRESS'>
18-JUN-2009 10:25:50 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=hostname)(USER=user 'A'))(COMMAND=status)(ARGUMENTS=64)(SERVICE=listen_1521)(VERSION=185599744)) * status * 0
I can connect as user oracle via ssh.
when I am in sqlplus and try to connect remotely I get the error when the listener is started as the user 'A'.
SQL> conn user/password@hostname.world;
ERROR:
ORA-12537: TNS:connection closed
-
Your listener seems not configured properly. Please post 'lsnrctl status listner' and 'tnsping' command outputs.
Thanks,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
TNS:Connection closed
Thanks guys, I think I found out the problem. I still have to test it but it appears that when I do a nslookup it isn't configured correctly. It still has the old domain name. Once I change this hopefully it will fix the issue. Thanks again for your help.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|