Home » RDBMS Server » Networking and Gateways » ora-12560 error,unable to solve
ora-12560 error,unable to solve [message #195129] Wed, 27 September 2006 02:35 Go to next message
honeyapps
Messages: 45
Registered: March 2005
Location: pune
Member
hi Friends,
I installed oracle database 10.2.0 on linux os.
when i log in from client machiene i am getting ora-12560 protocol adopter error
can any one give me solution how to solve this.

Thanks & Regards

[Updated on: Thu, 28 September 2006 00:53]

Report message to a moderator

Re: ora-12560 error,unable to solve [message #195490 is a reply to message #195129] Fri, 29 September 2006 01:16 Go to previous messageGo to next message
honeyapps
Messages: 45
Registered: March 2005
Location: pune
Member
Hi,
i am still struggling with the ora-12560 error when iam trying to connect the server from the client,eventhogh all my tnsnames,and sqlnet.ora file are correct,Please look at this tnsnames file,

My clent machiene is having 2 oracle home called BIhome and bitoolshome,the following are the tnsnames files,in both the homesSQlnet.ora files are empty,

can anyone give me how to resolve this.

# tnsnames.ora Network Configuration File: E:\oracle\BIHome\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = HOSTNAME)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PLSExtProc)
)
)

ap =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ipaddress)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ap)
)
)

ORCL=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ipaddress)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)


BITOOLSHOME tnsnmaes file:
# tnsnames.ora Network Configuration File: E:\oracle\BIToolsHome\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

AP=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ipaddress)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ap)
)
)

orcl =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =ipaddress)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)


thaks& regards

[Updated on: Fri, 29 September 2006 01:17]

Report message to a moderator

Re: ora-12560 error,unable to solve [message #195844 is a reply to message #195490] Mon, 02 October 2006 14:40 Go to previous messageGo to next message
dbcop
Messages: 37
Registered: September 2006
Location: india
Member
Why do u need two oracle homes in your client machine.


One tnsnames.ora can help u connect several oracle servers provided u have proper tnsentry.

Do u find Oracle home selector under Oracle Installation Products....

Have u ever tried installating oracle server on that machine...



The best idea would be to remove all oracle installation from that client machine and just install Oracle client freshly on that machine.

Protocol adapter error normally i find occurs due to improper setting of Oracle_sid or problem with network adapter...

[Updated on: Mon, 02 October 2006 14:43]

Report message to a moderator

Re: ora-12560 error,unable to solve [message #196075 is a reply to message #195844] Wed, 04 October 2006 01:20 Go to previous messageGo to next message
honeyapps
Messages: 45
Registered: March 2005
Location: pune
Member
hi dbcop,
Thanks for the reply,i am even facing the problem while connecting from other linux server also.Here also the same here i am facing.
Regards

[Updated on: Wed, 04 October 2006 01:40]

Report message to a moderator

Re: ora-12560 error,unable to solve [message #196091 is a reply to message #196075] Wed, 04 October 2006 02:18 Go to previous messageGo to next message
dbcop
Messages: 37
Registered: September 2006
Location: india
Member
Then I would suggest you to look into the network configuration of that server.
Re: ora-12560 error,unable to solve [message #196097 is a reply to message #196091] Wed, 04 October 2006 02:45 Go to previous messageGo to next message
honeyapps
Messages: 45
Registered: March 2005
Location: pune
Member
hi dbcop ,
can u give me steps clearly what to do for this,i really struggling a lot to solve this problem,but i am unable to solve,is there any problem with the swap space,as my server is having 512 RAM.
Regards
Honey

[Updated on: Thu, 05 October 2006 01:14]

Report message to a moderator

Re: ora-12560 error,unable to solve [message #199822 is a reply to message #196097] Thu, 26 October 2006 06:59 Go to previous message
honeyapps
Messages: 45
Registered: March 2005
Location: pune
Member
hi all,
finally the problem is identified and i am replying for others help,actually the database needs minimum of 1 gb ram and it was only 512ram.so with 1gb ram it is working fine.
thanks&regards
honey
Previous Topic: Tns: protocol adapter error
Next Topic: OLE DB, Linux and Oracle 10g
Goto Forum:
  


Current Time: Thu Dec 08 18:30:33 CST 2016

Total time taken to generate the page: 0.09022 seconds