OraFAQ Forum: Forms » ORA-12560 TNS:protocol adapter error

Home » Developer & Programmer » Forms » ORA-12560 TNS:protocol adapter error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-12560 TNS:protocol adapter error [message #137654]

Thu, 15 September 2005 23:50

binzaman
Messages: 30
Registered: March 2005
Location: Lahore

Member

i have installed Oracle Developer suite 10g n personal 10g database on the same machine. SQL, iSQL, and developer is connecting to database n displaying result but when i run my form from developer forms it give me the following error
ORA-12560 TNS:protocol adaper error
my operating system is win2000 professional
plz provide me the solution
Thanx n Regards

Report message to a moderator

Re: ORA-12560 TNS:protocol adapter error [message #137656 is a reply to message #137654]

Fri, 16 September 2005 00:00

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

You probably have a tnsnames.ora error. You have two homes, therefore you need to have two tnsnames.ora, one in each network/admin directory.

Search this forum for 'tnsnames.ora' and 'ifile'. Read, at least, three threads from top to bottom. Try what they suggest and then come back to us with any specific issues you may be having with your configuration.

David

Report message to a moderator

Re: ORA-12560 TNS:protocol adapter error [message #137669 is a reply to message #137654]

Fri, 16 September 2005 01:35

binzaman
Messages: 30
Registered: March 2005
Location: Lahore

Member

Dear David!
thanx for ur prompt reply
after reading many post
i have modified my tnsnames.ora in my developer home with this line
ifile=tnsnames.ora in my oracle home
but problem is still there
now tell me wat to do

Report message to a moderator

Re: ORA-12560 TNS:protocol adapter error [message #137671 is a reply to message #137669]

Fri, 16 September 2005 01:39

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Please reply with the contents of both of your tnsnames.ora files. Also confirm that you only have two Oracle homes.

David

Report message to a moderator

Re: ORA-12560 TNS:protocol adapter error [message #137676 is a reply to message #137654]

Fri, 16 September 2005 01:51

binzaman
Messages: 30
Registered: March 2005
Location: Lahore

Member

tnsname.ora in oracle db

# tnsnames.ora Network Configuration File: D:\oracle\product\10.1.0\Db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

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

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

tnsnames.ora in dev home

# TNSNAMES.ORA Network Configuration File: e:\dev10g\product\10.1.0\Db\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(Key = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
)
)

YASIR =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = YASIR)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
)

IFILE=D:\oracle\product\10.1.0\Db_1\NETWORK\ADMIN\tnsnames.ora

Report message to a moderator

Re: ORA-12560 TNS:protocol adapter error [message #137678 is a reply to message #137654]

Fri, 16 September 2005 01:56

binzaman
Messages: 30
Registered: March 2005
Location: Lahore

Member

Dear i have four oracle homes in my registry two are not being used as they were here due to unsucessful installations
i have
HOME0
home1
home2
home3

home3 containts dev10g

home 1 conts oracle

also recommend me if there is need to delete home 0 n home 2
thnx for your precious time

Report message to a moderator

Re: ORA-12560 TNS:protocol adapter error [message #137680 is a reply to message #137678]

Fri, 16 September 2005 01:59

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

I have to go ... someone else will have to help you today and this weekend. I will look at it next week.

Try to get rid of the 'spare' Oracle homes. If necessary delete the Oracle directory and register entry tree and start again but without the two false starts. Smile

David

Report message to a moderator

Re: ORA-12560 TNS:protocol adapter error [message #137703 is a reply to message #137654]

Fri, 16 September 2005 03:04

wucis
Messages: 60
Registered: March 2005

Member

Hello,

try to copy the TNSNAMES.ORA from the db into the according network/admin directory of your Developer Suite.

Report message to a moderator

Re: ORA-12560 TNS:protocol adapter error [message #137729 is a reply to message #137703]

Fri, 16 September 2005 06:14

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Just use the IFILE clause in your devs TNSNAMES.

Get rid of the rest.

I've noticed some inconsistencies:

your db's tnsnames

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

your delevopers's tnsnames

YASIR =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = YASIR)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
)

Just clean out the developer's tnsnames.

@wucis: bad idea to copy, it makes maintenance harder.

HTH,
MHE

Report message to a moderator

Re: ORA-12560 TNS:protocol adapter error [message #137771 is a reply to message #137654]

Fri, 16 September 2005 12:58

binzaman
Messages: 30
Registered: March 2005
Location: Lahore

Member

i have cleaned my developer tnsnames.ora it now only contain

# TNSNAMES.ORA Network Configuration File:
e:\dev10g\product\10.1.0\Db\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

IFILE=D:\oracle\product\10.1.0\Db_1\NETWORK\ADMIN\tnsnames.ora

but erorr is still same Sad

Report message to a moderator

Re: ORA-12560 TNS:protocol adapter error [message #137773 is a reply to message #137654]

Fri, 16 September 2005 13:25

binzaman
Messages: 30
Registered: March 2005
Location: Lahore

Member

also i have copied my existing oracle tnsnames.ora to developer home n replaced. but the error is the same i think problem is with some other thing ?? now wat u suggest?

Report message to a moderator

Re: ORA-12560 TNS:protocol adapter error [message #137788 is a reply to message #137773]

Fri, 16 September 2005 15:47

Maaher
Messages: 7065
Registered: December 2001

Senior Member

You can set the TNS_ADMIN registry key for both Oracle homes to the same location (i.e. where the correct one resides)

1) You have double checked the connect string? It has been changed from 'YASIR' to 'ORCL'...

2) Have you verified the database is up?

3) Is your listener up?

4) Can you TNSPING your database from a DOS box?

MHE

Report message to a moderator

Re: ORA-12560 TNS:protocol adapter error [message #137826 is a reply to message #137788]

Sat, 17 September 2005 03:56

binzaman
Messages: 30
Registered: March 2005
Location: Lahore

Member

Dear Martin!
thanx alot for your precious help....really you are angle's hand . you always helped me when i m in trouble.
Dear..it is working now but i don't know what happend
my listner is up, my db is up , tnsping is fine
i have added tns_admin in both of the oracle homes
when i run it by giving scott/tiger it gave me the same error but then i entered scott/tiger@orcl it is working fine... Smile

but i don't know where was the error can u plz explain
one thing more the execution of my system n oracle forms is too much slow...
thanx again for ur time
Regards

Report message to a moderator

Re: ORA-12560 TNS:protocol adapter error [message #137916 is a reply to message #137826]

Sun, 18 September 2005 19:36

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

'orcl' has to be defined as your default database ... in Unix this is done via 'TWO_TASK' and in Windows via 'default'.

Search this forum for these two keywords and there should be something to help you. If all else fails, google them.

If your system is too slow, then use something like TOAD to look at the queries that are running and use the Explain Plan facility to see what is 'wrong' with the query.

David

[Updated on: Sun, 18 September 2005 19:38]

Report message to a moderator

Previous Topic:	Calling a standard form form a custom form
Next Topic:	How To Sort the Table Through Push Buttons (ASC & Desc)???

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 05:50:30 CDT 2024