Home » RDBMS Server » Networking and Gateways » ORA ERROR 12560
ORA ERROR 12560 [message #452755] Fri, 23 April 2010 16:16 Go to next message
PanamDimas
Messages: 63
Registered: April 2010
Location: Maryland . U.S.A
Member
Hello,

While installing Oracle 11gR1 on Centos 4, I chose the Install soft ware only option.

That means It did not create my sqlnet.ora file.

HOW CAN I CREATE THE SQLNET.ORA FILE?

I only have listener.ora and TNSNAMES.ORA file on LINUX?

Because of its absence I am unable to establish a TNS connection between databases on windows and Linux

Thank you

[Updated on: Fri, 23 April 2010 16:18]

Report message to a moderator

Re: No SQLNET.ORA file [message #452759 is a reply to message #452755] Fri, 23 April 2010 17:07 Go to previous messageGo to next message
BlackSwan
Messages: 22804
Registered: January 2009
Senior Member
>Because of its absence I am unable to establish a TNS connection between databases on windows and Linux

SQLNET.ORA is NOT required to complete SQL*Net connection.

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: No SQLNET.ORA file [message #452761 is a reply to message #452759] Fri, 23 April 2010 17:43 Go to previous messageGo to next message
PanamDimas
Messages: 63
Registered: April 2010
Location: Maryland . U.S.A
Member


Ok. I hope I corrected my mistake.

I am trying to establish a TNS connection from Oracle 10g release 10.2.0.1.0 on Microsoft Windows XP prefessional version 2002 Service Pack 3 to a a database on Oracle 11g release 11.1.0.6.0 on Centos 4.5 Linux version2.6.9-98.EL(gcc version 3.4.6.20060404(Red Hat 3.4.6-11) which has listener.ora and TNSNAMEs.ORA file but no SQLNET.ORA file

The connection test throws back the following error:

"ORA-12560: TNS:Protocol adapter error
The test did not succeed.
SOme of the information you provided may be incorrect
Click Back to review the information provided for net service name, or click Login to change username"


Could anybody please help resolve this or can anybody help with clues on what to do?

I want to establish the connection so I can register the target database on the Rman catalogue database on the Linux

Thank you

David


[Updated on: Fri, 23 April 2010 17:47]

Report message to a moderator

Re: No SQLNET.ORA file [message #452762 is a reply to message #452761] Fri, 23 April 2010 17:48 Go to previous messageGo to next message
BlackSwan
Messages: 22804
Registered: January 2009
Senior Member
http://www.orafaq.com/search/12560

This is a FAQ

I am sorry to see both SEARCH & GOOGLE is broken for you
ORA ERROR 12560 [message #452815 is a reply to message #452755] Sat, 24 April 2010 22:39 Go to previous messageGo to next message
PanamDimas
Messages: 63
Registered: April 2010
Location: Maryland . U.S.A
Member
Hello,

I a new guy in Oracle and I need help
I am trying to establish a TNS connection from Oracle 10g release 10.2.0.1.0 on Microsoft Windows XP prefessional version 2002 Service Pack 3 to a a database on Oracle 11g release 11.1.0.6.0 on Centos 4.5 Linux version2.6.9-98.EL(gcc version 3.4.6.20060404(Red Hat 3.4.6-11)

The connection test throws back the following error:

"ORA-12560: TNS:Protocol adapter error
The test did not succeed.
Some of the information you provided may be incorrect
Click Back to review the information provided for net service name, or click Login to change username"


Could anybody please help resolve this or can anybody help with clues on what to do?

I want to establish the connection so I can register the target database on the Rman catalogue database on the Linux

Thank you

Re: ORA ERROR 12560 [message #452816 is a reply to message #452815] Sat, 24 April 2010 22:44 Go to previous messageGo to next message
BlackSwan
Messages: 22804
Registered: January 2009
Senior Member
http://www.orafaq.com/search/12560

This is a FAQ

What have have you confirmed is correct.
Post Proof
Re: ORA ERROR 12560 [message #452818 is a reply to message #452816] Sat, 24 April 2010 22:50 Go to previous messageGo to next message
PanamDimas
Messages: 63
Registered: April 2010
Location: Maryland . U.S.A
Member
Hello BlackSwan,

SO sorry I do not understand your question.

Sorry for my inability to understand all you postings

I have checked the link you sent but none of the solutions seems to help me.

Please go through the details I earlier posted

I am really frustrated here.

Please educate me
Re: ORA ERROR 12560 [message #452819 is a reply to message #452818] Sat, 24 April 2010 22:53 Go to previous messageGo to next message
BlackSwan
Messages: 22804
Registered: January 2009
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: ORA ERROR 12560 [message #452863 is a reply to message #452818] Sun, 25 April 2010 12:42 Go to previous messageGo to next message
BlackSwan
Messages: 22804
Registered: January 2009
Senior Member

on/from client system


post Operating System name & version
post client system hostname & IP number(w.x.y.z)

use COPY & PASTE whenever & whereever possible
open a command/terminal window

If Windows post results from following command

SET

If *NIX post results from following command

env | sort

post content of tnsnames.ora file

post results from following command

tnsping <SID>

post results from following command

sqlplus
username/password@remote_sid[/email]

TERMINATE sqlplus command


on/from DataBase Server system


post Operating System name & version
post DB server system hostname & IP number(w.x.y.z)


use COPY & PASTE whenever & whereever possible
open a command/terminal window

If Windows post results from following command

SET

If *NIX post results from following command

env | sort

post content of listener.ora file
post last 50 - 60 lines from listener.log

post results from following commands

lsnrctl status
lsnrctl service

post results from following command

sqlplus

TERMINATE sqlplus command

[Updated on: Sun, 25 April 2010 13:18]

Report message to a moderator

Re: ORA ERROR 12560 [message #452876 is a reply to message #452755] Sun, 25 April 2010 23:02 Go to previous messageGo to next message
PanamDimas
Messages: 63
Registered: April 2010
Location: Maryland . U.S.A
Member
Hi BlackSwan,

Thank you for the respone. I really appreciate your patience. This is day 4 of my frustration with this error.

Below is the result you asked for. They seem to be so much though.

please endure the size and kindly help me out. Thank you:

On client
C:\>SET
ALLUSERSPROFILE=C:\Documents and Settings\All Users
APPDATA=C:\Documents and Settings\David\Application Data
CLIENTNAME=Console
CommonProgramFiles=C:\Program Files\Common Files
COMPUTERNAME=DIMAS
ComSpec=C:\WINDOWS\system32\cmd.exe
DEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\DesktopProtection
FP_NO_HOST_CHECK=NO
HOMEDRIVE=C:
HOMEPATH=\Documents and Settings\David
LOGONSERVER=\\DIMAS
NUMBER_OF_PROCESSORS=2
OS=Windows_NT
Path=C:\oracle\product\10.2.0\db_1\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Common

Files\Roxio Shared\9.
DLLShared\;C:\Program Files\Common Files\Roxio Shared\DLLShared\;C:\Program Files\SSH Communications Security\SSH Secure

Shell
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PERL5LIB=C:\oracle\product\10.2.0\db_1\perl\5.8.3\lib\MSWin32-x86;C:\oracle\product\10.2.0\db_1\perl\5.8.3\lib;C:\oracle

\product\10.2.0\db_1
erl\5.8.3\lib\MSWin32-x86;C:\oracle\product\10.2.0\db_1\perl\site\5.8.3;C:\oracle\product\10.2.0\db_1\perl\site\5.8.3\li

b;C:\oracle\product\
.2.0\db_1\sysman\admin\scripts;
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 6 Model 15 Stepping 13, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=0f0d
ProgramFiles=C:\Program Files
PROMPT=$P$G
SESSIONNAME=Console
SystemDrive=C:
SystemRoot=C:\WINDOWS
TEMP=C:\DOCUME~1\David\LOCALS~1\Temp
TMP=C:\DOCUME~1\David\LOCALS~1\Temp
USERDOMAIN=DIMAS
USERNAME=David
USERPROFILE=C:\Documents and Settings\David
VSEDEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\DesktopProtection
windir=C:\WINDOWS
__COMPAT_LAYER=EnableNXShowUI


OS name:Microsoft Windows XP professional, version: 2002 Service Pack 3

hostname:dimas, Ip number:192.168.1.5

CONTENTS OF TNSNAMES.ORA:
# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

DIMASDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dimas.home)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dimasdb)
)
)

BOOMIEDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dimas.home)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = boomiedb)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

C:\>tnsping boomiedb

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 25-APR-2010 22:57:41

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:
C:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = dimas.home)(PORT = 1521)) (CONNECT_DATA =

(SERVER = DEDICATED) (SERVIC
E_NAME = boomiedb)))
OK (30 msec)

C:\>sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Apr 25 23:01:02 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Enter user-name: system/password@rmandb
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified

ON SERVER SYSTEM:

Name and version: Centos 4.5 Linux version2.6.9-98.EL(gcc version 3.4.6.20060404(Red Hat 3.4.6-11)

[oracle@marine ~]$ env | sort
_=/bin/env
CLASSPATH=/home/oracle/app/product/11.1.0/db_1/JRE:/home/oracle/app/product/11.1.0/db_1/jlib:/home/oracle/app/product/11.1.0/db_1/rdb ms/jlib
G_BROKEN_FILENAMES=1
HISTSIZE=1000
HOME=/home/oracle
HOSTNAME=marine
INPUTRC=/etc/inputrc
KDEDIR=/usr
LANG=en_US.UTF-8
LD_LIBRARY_PATH=/home/oracle/app/product/11.1.0/db_1/lib:/lib:/usr/lib
LESSOPEN=|/usr/bin/lesspipe.sh %s
LOGNAME=oracle
LS_COLORS=no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=01;32:*.cmd=01;32: *.exe=01;32:*.com=01;32:*.btm=01;32:*.bat=01;32:*.sh=01;32:*.csh=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*. zip=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.bz=01;31:*.tz=01;31:*.rpm=01;31:*.cpio=01;31:*.jpg=01;35:*.gif=01;35:*.bmp=01; 35:*.xbm=01;35:*.xpm=01;35:*.png=01;35:*.tif=01;35:
MAIL=/var/spool/mail/oracle
ORACLE_BASE=/home/oracle/app
ORACLE_HOME=/home/oracle/app/product/11.1.0/db_1
ORACLE_SID=dimasdb
ORACLE_TERM=xterm
ORAENV_ASK=NO
PATH=/home/oracle/app/product/11.1.0/db_1/bin:/usr/sbin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/home/oracle/bi n
PWD=/home/oracle
SHELL=/bin/bash
SHLVL=1
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
SSH_CLIENT=::ffff:192.168.1.5 2075 22
SSH_CONNECTION=::ffff:192.168.1.5 2075 ::ffff:192.168.1.4 22
SSH_TTY=/dev/pts/1
TERM=vt100
TMPDIR=/tmp
TMP=/tmp
USER=oracle


[oracle@marine admin]$ cat listener.ora
# listener.ora Network Configuration File: /home/oracle/app/product/11.1.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = marine.home)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)

lines from listener.log

<msg time='2010-04-25T20:29:18.136-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='marine'
host_addr='192.168.1.4'>
<txt>25-APR-2010 20:29:18 * service_update * rmandb * 0
</txt>
</msg>
<msg time='2010-04-25T20:33:27.186-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='marine'
host_addr='192.168.1.4'>
<txt>25-APR-2010 20:33:27 * service_update * rmandb * 0
</txt>
</msg>
<msg time='2010-04-25T20:43:27.309-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='marine'
host_addr='192.168.1.4'>
<txt>25-APR-2010 20:43:27 * service_update * rmandb * 0
</txt>
</msg>
<msg time='2010-04-25T20:43:39.312-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='marine'
host_addr='192.168.1.4'>
<txt>25-APR-2010 20:43:39 * service_update * rmandb * 0
</txt>
</msg>
<msg time='2010-04-25T20:53:27.429-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='marine'
host_addr='192.168.1.4'>
<txt>25-APR-2010 20:53:27 * service_update * rmandb * 0
</txt>
</msg>
<msg time='2010-04-25T20:53:33.432-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='marine'
host_addr='192.168.1.4'>
<txt>25-APR-2010 20:53:33 * service_update * rmandb * 0
</txt>
</msg>
<msg time='2010-04-25T21:03:27.550-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='marine'
host_addr='192.168.1.4'>
<txt>25-APR-2010 21:03:27 * service_update * rmandb * 0
</txt>
</msg>
<msg time='2010-04-25T21:03:33.555-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='marine'
host_addr='192.168.1.4'>
<txt>25-APR-2010 21:03:33 * service_update * rmandb * 0
</txt>
</msg>
<msg time='2010-04-25T21:03:39.556-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='marine'
host_addr='192.168.1.4'>
<txt>25-APR-2010 21:03:39 * service_update * rmandb * 0
</txt>
</msg>
<msg time='2010-04-25T21:13:27.674-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='marine'
host_addr='192.168.1.4'>
<txt>25-APR-2010 21:13:27 * service_update * rmandb * 0
</txt>
</msg>
<msg time='2010-04-25T21:23:27.793-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='marine'
host_addr='192.168.1.4'>
<txt>25-APR-2010 21:23:27 * service_update * rmandb * 0
</txt>
</msg>
<msg time='2010-04-25T21:23:39.797-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='marine'
host_addr='192.168.1.4'>
<txt>25-APR-2010 21:23:39 * service_update * rmandb * 0
</txt>
</msg>
<msg time='2010-04-25T21:25:57.826-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='marine'
host_addr='192.168.1.4'>
<txt>25-APR-2010 21:25:57 * service_update * rmandb * 0
</txt>
</msg>
<msg time='2010-04-25T21:33:27.917-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='marine'
host_addr='192.168.1.4'>
<txt>25-APR-2010 21:33:27 * service_update * rmandb * 0
</txt>
</msg>
<msg time='2010-04-25T21:43:28.037-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='marine'
host_addr='192.168.1.4'>
<txt>25-APR-2010 21:43:28 * service_update * rmandb * 0
</txt>
</msg>
<msg time='2010-04-25T21:49:19.108-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='marine'
host_addr='192.168.1.4'>
<txt>25-APR-2010 21:49:19 * service_update * rmandb * 0
</txt>
</msg>
<msg time='2010-04-25T21:53:28.158-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='marine'
host_addr='192.168.1.4'>
<txt>25-APR-2010 21:53:28 * service_update * rmandb * 0
</txt>
</msg>
<msg time='2010-04-25T21:53:34.162-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='marine'
host_addr='192.168.1.4'>
<txt>25-APR-2010 21:53:34 * service_update * rmandb * 0
</txt>
</msg>
<msg time='2010-04-25T22:03:28.281-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='marine'
host_addr='192.168.1.4'>
<txt>25-APR-2010 22:03:28 * service_update * rmandb * 0
</txt>
</msg>
<msg time='2010-04-25T22:03:34.284-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='marine'
host_addr='192.168.1.4'>
<txt>25-APR-2010 22:03:34 * service_update * rmandb * 0
</txt>
</msg>
<msg time='2010-04-25T22:03:40.287-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='marine'
host_addr='192.168.1.4'>
<txt>25-APR-2010 22:03:40 * service_update * rmandb * 0
</txt>
</msg>
<msg time='2010-04-25T22:04:16.296-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='marine'
host_addr='192.168.1.4'>
<txt>25-APR-2010 22:04:16 * service_update * rmandb * 0
</txt>
</msg>
<msg time='2010-04-25T22:05:01.296-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='marine'
host_addr='192.168.1.4'>
<txt>25-APR-2010 22:05:01 * service_update * rmandb * 0
</txt>
</msg>
<msg time='2010-04-25T22:13:28.397-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='marine'
host_addr='192.168.1.4'>
<txt>25-APR-2010 22:13:28 * service_update * rmandb * 0
</txt>
</msg>
<msg time='2010-04-25T22:23:28.517-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='marine'
host_addr='192.168.1.4'>
<txt>25-APR-2010 22:23:28 * service_update * rmandb * 0
</txt>
</msg>
<msg time='2010-04-25T22:23:34.520-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='marine'
host_addr='192.168.1.4'>
<txt>25-APR-2010 22:23:34 * service_update * rmandb * 0
</txt>
</msg>
<msg time='2010-04-25T22:33:28.639-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='marine'
host_addr='192.168.1.4'>
<txt>25-APR-2010 22:33:28 * service_update * rmandb * 0
</txt>
</msg>
<msg time='2010-04-25T22:43:28.760-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='marine'
host_addr='192.168.1.4'>
<txt>25-APR-2010 22:43:28 * service_update * rmandb * 0
</txt>
</msg>
<msg time='2010-04-25T22:43:40.765-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='marine'
host_addr='192.168.1.4'>
<txt>25-APR-2010 22:43:40 * service_update * rmandb * 0
</txt>
</msg>
<msg time='2010-04-25T22:43:49.758-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='marine'
host_addr='192.168.1.4'>
<txt>25-APR-2010 22:43:49 * service_update * rmandb * 0
</txt>
</msg>
<msg time='2010-04-25T22:53:28.874-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='marine'
host_addr='192.168.1.4'>
<txt>25-APR-2010 22:53:28 * service_update * rmandb * 0
</txt>
</msg>
<msg time='2010-04-25T23:00:46.951-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='marine'
host_addr='192.168.1.4'>
<txt>25-APR-2010 23:00:46 * service_update * rmandb * 0
</txt>
</msg>
<msg time='2010-04-25T23:01:49.966-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='marine'
host_addr='192.168.1.4'>
<txt>25-APR-2010 23:01:49 * service_update * rmandb * 0
</txt>
</msg>
<msg time='2010-04-25T23:03:28.987-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='marine'
host_addr='192.168.1.4'>
<txt>25-APR-2010 23:03:28 * service_update * rmandb * 0
</txt>
</msg>
<msg time='2010-04-25T23:13:29.106-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='marine'
host_addr='192.168.1.4'>
<txt>25-APR-2010 23:13:29 * service_update * rmandb * 0
</txt>
</msg>
<msg time='2010-04-25T23:19:20.176-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='marine'
host_addr='192.168.1.4'>
<txt>25-APR-2010 23:19:20 * service_update * rmandb * 0
</txt>
</msg>
<msg time='2010-04-25T23:20:38.193-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='marine'
host_addr='192.168.1.4'>
<txt>25-APR-2010 23:20:38 * service_update * rmandb * 0
</txt>
</msg>
<msg time='2010-04-25T23:21:11.191-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='marine'
host_addr='192.168.1.4'>
<txt>25-APR-2010 23:21:11 * service_update * rmandb * 0
</txt>
</msg>
<msg time='2010-04-25T23:23:29.220-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='marine'
host_addr='192.168.1.4'>
<txt>25-APR-2010 23:23:29 * service_update * rmandb * 0
</txt>
</msg>
<msg time='2010-04-25T23:33:29.341-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='marine'
host_addr='192.168.1.4'>
<txt>25-APR-2010 23:33:29 * service_update * rmandb * 0
</txt>
</msg>
<msg time='2010-04-25T23:34:29.353-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='marine'
host_addr='192.168.1.4'>
<txt>25-APR-2010 23:34:29 * service_update * rmandb * 0
</txt>
</msg>
<msg time='2010-04-25T23:39:38.197-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='marine'
host_addr='192.168.1.4'>
<txt>WARNING: Subscription for node down event still pending
</txt>
</msg>
<msg time='2010-04-25T23:39:38.198-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='marine'
host_addr='192.168.1.4'>
<txt>25-APR-2010 23:39:38 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=marine)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=185599488)) * status * 0
</txt>
</msg>
<msg time='2010-04-25T23:40:23.332-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='marine'
host_addr='192.168.1.4'>
<txt>25-APR-2010 23:40:23 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=marine)(USER=oracle))(COMMAND=services)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=185599488)) * services * 0
</txt>
</msg>
<msg time='2010-04-25T23:42:07.296-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='marine'
host_addr='192.168.1.4'>
<txt>25-APR-2010 23:42:07 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=marine)(USER=oracle))(COMMAND=services)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=185599488)) * services * 0
</txt>
</msg>
<msg time='2010-04-25T23:43:29.465-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='marine'
host_addr='192.168.1.4'>
<txt>25-APR-2010 23:43:29 * service_update * rmandb * 0
</txt>
</msg>


LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=marine.home)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.1.0.6.0 - Production
Start Date 25-APR-2010 00:12:01
Uptime 0 days 23 hr. 27 min. 36 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /home/oracle/app/product/11.1.0/db_1/network/admin/listener.ora
Listener Log File /home/oracle/app/diag/tnslsnr/marine/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=marine.home)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "rmandb.marine" has 1 instance(s).
Instance "rmandb", status READY, has 1 handler(s) for this service...
Service "rmandbXDB.marine" has 1 instance(s).
Instance "rmandb", status READY, has 1 handler(s) for this service...
Service "rmandb_XPT.marine" has 1 instance(s).
Instance "rmandb", status READY, has 1 handler(s) for this service...
The command completed successfully

LSNRCTL> service
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=marine.home)(PORT=1521)))
Services Summary...
Service "rmandb.marine" has 1 instance(s).
Instance "rmandb", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "rmandbXDB.marine" has 1 instance(s).
Instance "rmandb", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: marine, pid: 14781>
(ADDRESS=(PROTOCOL=tcp)(HOST=marine.home)(PORT=32787))
Service "rmandb_XPT.marine" has 1 instance(s).
Instance "rmandb", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER

[oracle@marine ~]$ sqlplus

SQL*Plus: Release 11.1.0.6.0 - Production on Sun Apr 25 23:49:47 2010

Copyright (c) 1982, 2007, Oracle. All rights reserved.




Re: ORA ERROR 12560 [message #452949 is a reply to message #452876] Mon, 26 April 2010 08:55 Go to previous messageGo to next message
BlackSwan
Messages: 22804
Registered: January 2009
Senior Member
I am still unsure if source of problem is on client or DB server.

On client a couple of concerns need to be addressed.

ORACLE_HOME is not defined.
I am not sure it needs to be defined, but it won't hurt to do so.
so please do so.


>C:\>tnsping boomiedb
>Enter user-name: system/password@rmandb[/email]

Why do you tnsping one alias & then use a different alias to connect with?

"rmandb" alias does not exist on client tnsnames.ora

EVERY alias used on client needs to exist in tnsnames.ora on client

After doing changes/fixes on client post results from commands
tnsping <tns_alias>
sqlplus <username>/<password>@<tns_alias>

on/from DB Server
post content of tnsnames.ora

post command & results using same tns_alias that fails on client

sqlplus <username>/<password>@<tns_alias>


We nned to verify DB Server can use SQL*Net to talk to itself.

[Updated on: Mon, 26 April 2010 09:37]

Report message to a moderator

Re: ORA ERROR 12560 [message #452961 is a reply to message #452949] Mon, 26 April 2010 10:25 Go to previous messageGo to next message
PanamDimas
Messages: 63
Registered: April 2010
Location: Maryland . U.S.A
Member
Hello BlackSwan,

Thanks for your patience and time to go through the very bulky information I send.

I have defined the ORACLE_HOME on the client:

C:\>SET
ALLUSERSPROFILE=C:\Documents and Settings\All Users
APPDATA=C:\Documents and Settings\David\Application Data
CLIENTNAME=Console
CommonProgramFiles=C:\Program Files\Common Files
COMPUTERNAME=DIMAS
ComSpec=C:\WINDOWS\system32\cmd.exe
DEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\DesktopProtection
FP_NO_HOST_CHECK=NO
HOMEDRIVE=C:
HOMEPATH=\Documents and Settings\David
LOGONSERVER=\\DIMAS
NUMBER_OF_PROCESSORS=2
ORACLE_HOME=c:\oracle\product\10.2.0\db_1
oracle_sid=boomiedb
OS=Windows_NT
Path=C:\oracle\product\10.2.0\db_1\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Common Files\Roxio Shared\9.0\
DLLShared\;C:\Program Files\Common Files\Roxio Shared\DLLShared\;C:\Program Files\SSH Communications Security\SSH Secure Shell
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PERL5LIB=C:\oracle\product\10.2.0\db_1\perl\5.8.3\lib\MSWin32-x86;C:\oracle\product\10.2.0\db_1\perl\5.8.3\lib;C:\oracle\product\10.2 .0\db_1\p
erl\5.8.3\lib\MSWin32-x86;C:\oracle\product\10.2.0\db_1\perl\site\5.8.3;C:\oracle\product\10.2.0\db_1\perl\site\5.8.3\lib;C:\oracle\p roduct\10
.2.0\db_1\sysman\admin\scripts;
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 6 Model 15 Stepping 13, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=0f0d
ProgramFiles=C:\Program Files
PROMPT=$P$G
SESSIONNAME=Console
SystemDrive=C:
SystemRoot=C:\WINDOWS
TEMP=C:\DOCUME~1\David\LOCALS~1\Temp
TMP=C:\DOCUME~1\David\LOCALS~1\Temp
USERDOMAIN=DIMAS
USERNAME=David
USERPROFILE=C:\Documents and Settings\David
VSEDEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\DesktopProtection
windir=C:\WINDOWS
__COMPAT_LAYER=EnableNXShowUI

I thought you asked me to connect to rmandb which is the Database I am trying to connect to on server.

rmandb exist on server tnsnames.ora while boomiedb is in client tnsnames.ora

CONTENTS OF CLIENT TNSNAMES.ORA:
# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

DIMASDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dimas.home)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dimasdb)
)
)

BOOMIEDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dimas.home)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = boomiedb)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
C:\>sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Apr 26 11:12:50 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Enter user-name: system
Enter password:

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> show user;
USER is "SYSTEM"
SQL> select host_name,instance_name from v$instance;

HOST_NAME
----------------------------------------------------------------
INSTANCE_NAME
----------------
DIMAS
boomiedb


CONTENTS OF SERVER TNSNAMES.ORA

[oracle@marine admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /home/oracle/app/product/11.1.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

RMANDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = marine.home)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = rmandb.marine)
)
)

DIMASDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = marine.home)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dimasdb)
)
)

[oracle@marine ~]$ sqlplus system/passsword@rmandb

SQL*Plus: Release 11.1.0.6.0 - Production on Mon Apr 26 11:03:54 2010

Copyright (c) 1982, 2007, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show user:
USER is "SYSTEM"
SQL> select host_name,instance_name from v$instance;

HOST_NAME
----------------------------------------------------------------
INSTANCE_NAME
----------------
marine
rmandb

Like I said am new to Oracle, can a database on 10g connect with another in 11g? cos The server is 11g but the client has 10g.




Re: ORA ERROR 12560 [message #452964 is a reply to message #452961] Mon, 26 April 2010 10:45 Go to previous messageGo to next message
BlackSwan
Messages: 22804
Registered: January 2009
Senior Member
RMANDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = marine.home)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = rmandb.marine)
)
)


The lines above need to be added into tnsnames.ora on client

then on/from client do

sqlplus system/passsword@rmandb
icon4.gif  Re: ORA ERROR 12560 [message #452994 is a reply to message #452964] Mon, 26 April 2010 13:07 Go to previous messageGo to next message
PanamDimas
Messages: 63
Registered: April 2010
Location: Maryland . U.S.A
Member
Hi BlackSwan,

Thank you for enduring me and my long issues.

I actually added the rmandb parameter( which resides in the server) to the tnsnames.ora file in the client:

# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

DIMASDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dimas.home)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dimasdb)
)
)

BOOMIEDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dimas.home)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = boomiedb)
)
)

RMANDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = marine.home)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = rmandb.marine)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

I went ahead to lauch NETCA and attempted to establish the tns connection but it still failed the test and threw the ora 12560 TNS protocal adapter error again.
I don't know what to do anymore. Sad

Re: ORA ERROR 12560 [message #453002 is a reply to message #452994] Mon, 26 April 2010 13:16 Go to previous messageGo to next message
BlackSwan
Messages: 22804
Registered: January 2009
Senior Member
from client do below & post results

tnsping RMANDB
Re: ORA ERROR 12560 [message #453005 is a reply to message #453002] Mon, 26 April 2010 13:29 Go to previous messageGo to next message
PanamDimas
Messages: 63
Registered: April 2010
Location: Maryland . U.S.A
Member
ON CLIENT:
C:\>tnsping RMANDB

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 26-APR-2010 14:27:57

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:
C:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = marine.home)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVI
CE_NAME = rmandb.marine)))
TNS-12560: TNS:protocol adapter error
Re: ORA ERROR 12560 [message #453006 is a reply to message #453005] Mon, 26 April 2010 13:35 Go to previous messageGo to next message
BlackSwan
Messages: 22804
Registered: January 2009
Senior Member
from/on client which commands below work?

ping marine
ping marine.home
ping 192.168.1.4
Re: ORA ERROR 12560 [message #453007 is a reply to message #453006] Mon, 26 April 2010 13:39 Go to previous messageGo to next message
PanamDimas
Messages: 63
Registered: April 2010
Location: Maryland . U.S.A
Member
They all work:
C:\>ping marine

Pinging marine.home [192.168.1.4] with 32 bytes of data:

Reply from 192.168.1.4: bytes=32 time=2ms TTL=64
Reply from 192.168.1.4: bytes=32 time=3ms TTL=64
Reply from 192.168.1.4: bytes=32 time=2ms TTL=64
Reply from 192.168.1.4: bytes=32 time=2ms TTL=64

Ping statistics for 192.168.1.4:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 2ms, Maximum = 3ms, Average = 2ms

C:\>ping marine.home

Pinging marine.home [192.168.1.4] with 32 bytes of data:

Reply from 192.168.1.4: bytes=32 time=2ms TTL=64
Reply from 192.168.1.4: bytes=32 time=3ms TTL=64
Reply from 192.168.1.4: bytes=32 time=2ms TTL=64
Reply from 192.168.1.4: bytes=32 time=4ms TTL=64

Ping statistics for 192.168.1.4:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 2ms, Maximum = 4ms, Average = 2ms

C:\>ping 192.168.1.4

Pinging 192.168.1.4 with 32 bytes of data:

Reply from 192.168.1.4: bytes=32 time=2ms TTL=64
Reply from 192.168.1.4: bytes=32 time=2ms TTL=64
Reply from 192.168.1.4: bytes=32 time=2ms TTL=64
Reply from 192.168.1.4: bytes=32 time=2ms TTL=64

Ping statistics for 192.168.1.4:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 2ms, Maximum = 2ms, Average = 2ms
Re: ORA ERROR 12560 [message #453008 is a reply to message #453007] Mon, 26 April 2010 13:41 Go to previous messageGo to next message
BlackSwan
Messages: 22804
Registered: January 2009
Senior Member
post content of C:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
Re: ORA ERROR 12560 [message #453009 is a reply to message #453007] Mon, 26 April 2010 13:44 Go to previous messageGo to next message
PanamDimas
Messages: 63
Registered: April 2010
Location: Maryland . U.S.A
Member
# sqlnet.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

Re: ORA ERROR 12560 [message #453010 is a reply to message #453009] Mon, 26 April 2010 13:47 Go to previous messageGo to next message
BlackSwan
Messages: 22804
Registered: January 2009
Senior Member
>SQLNET.AUTHENTICATION_SERVICES= (NTS)

likely does not work well on *NIX listener.

comment out the TOP line then do below

tnsping RMANDB
Re: ORA ERROR 12560 [message #453011 is a reply to message #453009] Mon, 26 April 2010 13:56 Go to previous messageGo to next message
PanamDimas
Messages: 63
Registered: April 2010
Location: Maryland . U.S.A
Member
I think so too. Cos I created it my self Cos I really never had it since I did Install the software only and then went ahead to create database and listerner using DBCA and NETCA
Re: ORA ERROR 12560 [message #453036 is a reply to message #453011] Mon, 26 April 2010 15:27 Go to previous messageGo to next message
BlackSwan
Messages: 22804
Registered: January 2009
Senior Member
on client

rename sqlnet.ora out of the way to new name then post results from following command

tnsping RMANDB
Re: ORA ERROR 12560 [message #453087 is a reply to message #453036] Tue, 27 April 2010 02:32 Go to previous messageGo to next message
PanamDimas
Messages: 63
Registered: April 2010
Location: Maryland . U.S.A
Member
Hi,

I apologise for the break.

I renamed the sqlnet.ora on client and pinged: Below the output

C:\>tnsping rmandb

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 27-APR-2010 03:30:11

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = marine.home)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVI
CE_NAME = rmandb)))
TNS-12560: TNS:protocol adapter error
Re: ORA ERROR 12560 [message #453170 is a reply to message #453087] Tue, 27 April 2010 10:24 Go to previous message
BlackSwan
Messages: 22804
Registered: January 2009
Senior Member
on/from client post results from following command

tail -60 $ORACLE_HOME/network/log/listener.log
Previous Topic: IP address settings
Next Topic: TNSNAMES.ora Questions
Goto Forum:
  


Current Time: Tue Sep 23 09:24:20 CDT 2014

Total time taken to generate the page: 0.12997 seconds