Home » RDBMS Server » Networking and Gateways » TNS ERROR (Linux)
 TNS ERROR [message #452420] |
Thu, 22 April 2010 00:20  |
PanamDimas
Messages: 63
Registered: April 2010
Location: Maryland . U.S.A
|
Member |
|
|
Hi,
I am trying to to connect to a backup database on oracle 11g on a linux box( I have 2 database here) from oracle 10g database on windows system using TNS connection so I can create catalog and register my database.
At a stage in the process it keeps failing and giving me this error:
Connecting...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 Change Login to change username.
I really need help ASAP so i won't lose my mind cos I've been on this issue for 3 days now!
Here is the content of my TNSNAMES.ORA and LISTERNER.ORA files and other info that my paint a picture of my linux system:
[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 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))
)
)
[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)
)
)
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.1.0.6.0 - Production
Start Date 21-APR-2010 23:11:08
Uptime 0 days 0 hr. 47 min. 53 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 "dimasdb" has 1 instance(s).
Instance "dimasdb", status READY, has 1 handler(s) for this service...
Service "dimasdbXDB" has 1 instance(s).
Instance "dimasdb", status READY, has 1 handler(s) for this service...
Service "dimasdb_XPT" has 1 instance(s).
Instance "dimasdb", status READY, has 1 handler(s) for this service...
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
[oracle@marine ~]$ ps -ef | grep pmon
oracle 14930 1 0 Apr21 ? 00:00:00 ora_pmon_dimasdb
oracle 15036 1 0 Apr21 ? 00:00:00 ora_pmon_rmandb
oracle 16444 16293 0 00:01 pts/1 00:00:00 grep pmon
[oracle@marine ~]$ su -
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Goto Forum:
Current Time: Fri May 02 11:03:05 CDT 2025
|
] 
Blog
Search
Help
Members
Register
Login
Home
