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
|
|
|
|
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
|
|
|
|
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
|
|
|
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
|
|
|
|
|
|
|
|
|
|
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
|
|
|