| ora-12560 error,unable to solve [message #195129] |
Wed, 27 September 2006 02:35  |
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  |
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 |
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 #199822 is a reply to message #196097] |
Thu, 26 October 2006 06:59 |
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®ards
honey
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
