| ORA ERROR 12560 [message #452755] |
Fri, 23 April 2010 16:16  |
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 #452761 is a reply to message #452759] |
Fri, 23 April 2010 17:43  |
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 |
|
|
|
|
|
| ORA ERROR 12560 [message #452815 is a reply to message #452755] |
Sat, 24 April 2010 22:39 |
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 #452818 is a reply to message #452816] |
Sat, 24 April 2010 22:50 |
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 #452863 is a reply to message #452818] |
Sun, 25 April 2010 12:42 |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
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 |
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 |
|
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
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 |
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 #453005 is a reply to message #453002] |
Mon, 26 April 2010 13:29 |
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 #453007 is a reply to message #453006] |
Mon, 26 April 2010 13:39 |
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 #453009 is a reply to message #453007] |
Mon, 26 April 2010 13:44 |
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 #453011 is a reply to message #453009] |
Mon, 26 April 2010 13:56 |
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 #453087 is a reply to message #453036] |
Tue, 27 April 2010 02:32 |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
