Home » RDBMS Server » Networking and Gateways » Oracle client-server Communication
Oracle client-server Communication [message #274380] Mon, 15 October 2007 21:53 Go to next message
Oracle_Thunder
Messages: 7
Registered: October 2007
Junior Member
Hi Friends,
I am new to this forum and this is my first posting.
I am using Oracle 9i with client-server installation.
I am trying to access Oracle Database which is located on a remote server.But I am not able to login.The error what I am getting is

ORA-12560: TNS: protocol adapter error

But when I PING the IP address of the remot server, it is PINGING.
I tried UserName and Password which are mentioned in tnsnames.ora file.Also I tried default username and password scott/tiger etc different combinations.But I am getting the same error.
Also I tried to start listener service in my system,but I dont have access rights,not given by our clients.

So is this related to Firewall??

Please Help Me Friends..

Thanks in Advance...

Report message to a moderator

Re: Oracle client-server Communication [message #274383 is a reply to message #274380] Mon, 15 October 2007 22:04 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I tried UserName and Password which are mentioned in tnsnames.ora file
I have NEVER seen username or password in tnsnames.ora file.

12560, 00000, "TNS:protocol adapter error"
// *Cause: A generic protocol adapter error occurred.
// *Action: Check addresses used for proper protocol specification. Before
// reporting this error, look at the error stack and check for lower level
// transport errors. For further details, turn on tracing and reexecute the
// operation. Turn off tracing when the operation is complete.


>So is this related to Firewall??
Possibly

Can you tnsping the Oracle listener

What is database server OS name & version?
What is client OS name & version?
What is database version to 4 decimal places?

Report message to a moderator

Re: Oracle client-server Communication [message #274431 is a reply to message #274380] Tue, 16 October 2007 01:12 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
What is the connection command you tried?

Regards
Michel

Report message to a moderator

Re: Oracle client-server Communication [message #274637 is a reply to message #274383] Tue, 16 October 2007 12:03 Go to previous messageGo to next message
Oracle_Thunder
Messages: 7
Registered: October 2007
Junior Member

Hi Michel,
Thanks for your reply.I am sorry for late response.
The connection command I have used is ping command.So the IP address is pinging.But when I try to login using SQL Plus, I get the ORA-12560: TNS: protocol adapter error.
I this because of Firewall? Alternatively Can I connect to Oracle through My Java Application using JDBC(By setting proxy in My java application).Will this solve the firewall issue.
Your guidance needed...

Thanks in Advance....

Report message to a moderator

Re: Oracle client-server Communication [message #274642 is a reply to message #274380] Tue, 16 October 2007 12:15 Go to previous messageGo to next message
Oracle_Thunder
Messages: 7
Registered: October 2007
Junior Member
Hi anacedent,
Thanks for your reply and guidance.I am very Sorry for My late response.You asked..

1.What is database server OS name & version?
Ans: Windows and Oracle 9i

2.What is client OS name & version?
Ans: Windows XP and Oracle 9i

3.What is database version to 4 decimal places?
Ans: I dont know

So in order to overcome Firewall issue,can I do some Proxy settings in my java(JDBC) application(which is the front end),So that I access Database on a remote server?

Your help and guidance needed..

Thanks in advance..

[Updated on: Tue, 16 October 2007 12:19]

Report message to a moderator

Re: Oracle client-server Communication [message #274808 is a reply to message #274642] Wed, 17 October 2007 03:56 Go to previous messageGo to next message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
1/ You must have an Oracle Client in your Client machine. Or, you have some special applications such as TOAD, SQL Navigator, SQL Developer... which can connect to your Database.

2/ For the Oracle Client, open the file called as TNSname.ora.
Modify something in, it look like:

REPO =  //your SID//
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.222.15.186)(PORT = 1521)) //your Database IP and port
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = REPO) //your Database name
    )
  )

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


After finish modifying, you can check it again by
[code]
C:\> tnsping yourSID

Example with below Tnsname.ora
C:\>tnsping REPO
....
[code]

3/You can check your Database version and release by
[code]
SQL> show parameter compatible;
[code]

Report message to a moderator

Re: Oracle client-server Communication [message #274826 is a reply to message #274380] Wed, 17 October 2007 06:12 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member
Quote:


3/You can check your Database version and release by
[code]
SQL> show parameter compatible;
[code]



Not right.

Use, select * from v$version 


SQL>show parameter compatible

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
compatible                           string      10.2.0.1.0
SQL>select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Prod
PL/SQL Release 10.2.0.2.0 - Production
CORE    10.2.0.2.0      Production
TNS for Solaris: Version 10.2.0.2.0 - Production
NLSRTL Version 10.2.0.2.0 - Production

Elapsed: 00:00:00.01

Report message to a moderator

Re: Oracle client-server Communication [message #274953 is a reply to message #274808] Wed, 17 October 2007 21:50 Go to previous messageGo to next message
Oracle_Thunder
Messages: 7
Registered: October 2007
Junior Member

Hi,
Thanks for your reply.It was really helpful.But when I try
"tnsping" command I get following error..

TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 18-OCT-20
07 08:11:32

Copyright (c) 1997 Oracle Corporation. All rights reserved.

Used parameter files:

TNS-03505: Failed to resolve name


I need your solution...

Thanks and Regrads,

Report message to a moderator

Re: Oracle client-server Communication [message #274955 is a reply to message #274380] Wed, 17 October 2007 22:01 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member
Use IP address instead of host and ensure that you have provided correct service name in tnsnames.ora.

[Updated on: Wed, 17 October 2007 22:03]

Report message to a moderator

Re: Oracle client-server Communication [message #274956 is a reply to message #274953] Wed, 17 October 2007 22:02 Go to previous messageGo to next message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
What's your exactly command TNSPING?
Note: TNSPING yourSID

Or, you can add it by Netca or Net Manager application!


Report message to a moderator

Re: Oracle client-server Communication [message #274957 is a reply to message #274380] Wed, 17 October 2007 22:11 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member
Quote:

What's your exactly command TNSPING?
Note: TNSPING yourSID


Not true.

See what you told?
-bash-3.00$ echo $ORACLE_SID
JUST
-bash-3.00$ tnsping JUST

TNS Ping Utility for Solaris: Version 10.2.0.2.0 - Production on 17-OCT-2007 23:07:54

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

Used parameter files:
/oracle/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora

TNS-03505: Failed to resolve name


The right is,
tnsping net_service_name count


net_service_name: must exist in tnsnames.ora file or the name service in use.

Report message to a moderator

Re: Oracle client-server Communication [message #274958 is a reply to message #274957] Wed, 17 October 2007 22:22 Go to previous message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Yes, Aruj! Thanks! I mean that it existed in tnsname.ora

Report message to a moderator

Previous Topic: query regading listener.ora file
Next Topic: Instance not getting registered with listener
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Nov 25 19:58:57 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.