-
Ora-12560
Hi,
I'm new in this forum.
I have to following situation installed in one machine:
- xp pro with oralce8174 (server and client)
- rhel4 (vmware) with: oracle9i (server and client)
Now, I would like to connect xp onto rhel4 using sqlplus.
After started oracle9i and cofigurated the tnsnames.ora in xp
RHEL4.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.33.99)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = MATRIX.WORLD)
)
)
The HOST value is the IP for the network adapter per vmWare.
When I try to connect myself I caught the error in title.
can somebody help me ??
PS:I have to tell that when I installed the rhel4 the db, I called it Matrix (sid) but it's also the machine name for xp
-
Welcome to Forum.
You are trying to connect XP as Client to a database server on RHEL4, Right?
I will take the following steps
1) On XP - Ping the ip address (ping 192.168.33.99)
2) On RHEL4 - Make sure listener is running on RHEL4
3) On XP - TNSPING RHEL4.WORLD
4) SQL+
If 1-3 fails, you can not connect using SQL+. Good Luck.
-
thanks for answer,
yes, I would try to connect XP on RHEL4 .
I did the following steps:
1) ping from xp to rhel4, ok !
2) the listener works fine on rhel4
3) tnsping RHEL4.WORLD does not work , and I caught the error ORA-12560 protocol adaptor error .
I don't know what wrong !
-
Could you post the lsnrctl services output?
"What is past is PROLOGUE"
-
this is the listener.ora:
# LISTENER.ORA Network Configuration File: /app/oracle/product/9.2.0/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rhel4)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /app/oracle/product/9.2.0)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = MATRIX.WORLD)
(ORACLE_HOME = /app/oracle/product/9.2.0)
(SID_NAME = MATRIX)
)
)
And this is wath happens with:
$ lsnrctl start
LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 31-DEC-2006 09:24:11
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Starting /app/oracle/product/9.2.0/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 9.2.0.4.0 - Production
System parameter file is /app/oracle/product/9.2.0/network/admin/listener.ora
Log messages written to /app/oracle/product/9.2.0/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rhel4)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 9.2.0.4.0 - Production
Start Date 31-DEC-2006 09:24:11
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /app/oracle/product/9.2.0/network/admin/listener.ora
Listener Log File /app/oracle/product/9.2.0/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Services Summary...
Service "MATRIX" has 1 instance(s).
Instance "MATRIX", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
thanks for help.
-
You run the service Matrix but not Matrix.world. Correct this in your tnsnames and try sql+
"What is past is PROLOGUE"
-
I changed it, but doesn't work !!
-
Sorry to everybody ..... I have forgotten to disable the firewall linux side.
Now it works !!
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
|