Home » RDBMS Server » Networking and Gateways » TNS ERROR (Linux)
TNS ERROR [message #452420] Thu, 22 April 2010 00:20 Go to next message
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 -
Re: TNS ERROR [message #452423 is a reply to message #452420] Thu, 22 April 2010 00:45 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Maybe posting what you did and what you had (that is copying and pasting your session) may help to help you faster, don't you think?

Regards
Michel
Re: TNS ERROR [message #452532 is a reply to message #452420] Thu, 22 April 2010 08:30 Go to previous messageGo to next message
PanamDimas
Messages: 63
Registered: April 2010
Location: Maryland . U.S.A
Member
thanks for the advise.
I tried to copy and paste in the session in the box but it did not work so I attached it in word format.

At the end I changed login and replaced it with the rman sys password but it still failed. NEED HELP PLEASE.

Thank you

Panam
Re: TNS ERROR [message #452540 is a reply to message #452532] Thu, 22 April 2010 09:03 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is nothing attached but you must be aware that many of us can't or don't want to download files.

Regards
Michel
Re: TNS ERROR [message #452545 is a reply to message #452420] Thu, 22 April 2010 09:37 Go to previous messageGo to next message
PanamDimas
Messages: 63
Registered: April 2010
Location: Maryland . U.S.A
Member
So sorry about that Michel,

Just new in the business.

I have the whole sessin screen printed on a word document i am trying to paste it to the box but it is not giving me the option of pasting.

Let try and explain the session:

i typed netca on in command promt to launch the configuration assistant.

These are the order of the options I chose in the session:

1.Choose the configuration you would like to do:

I chose Local Net Sersvice Name Configuration

2. Select what you want to do:
I chose Add
3.Service name:
I typed in rmandb.marine (Name of the database on linux machine called marine)
4.Select the protocol used for the database you want to access:
I chose TCP
5.Host Name I chose marine.home (name of machine) and chose 1521 which is the listener port
6. so i run the test and changed loging when it fails the test and put in the system password for rmandb yet it failed.

I have the content of the TNSNAMES.ORA and LISTENER.ORA files in my early posting.

I wish these info is good enough to muster solution. Please help
Re: TNS ERROR [message #452547 is a reply to message #452545] Thu, 22 April 2010 09:39 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Previous Topic: interesting connection problem
Next Topic: application hostname
Goto Forum:
  


Current Time: Thu Mar 28 03:25:04 CDT 2024