TNS No Such Protocol adaptor Ora- 12222 and Unable to connect oracle :( (merged) [message #220953] |
Thu, 22 February 2007 19:39 |
shahnazurs
Messages: 240 Registered: June 2005 Location: India
|
Senior Member |
|
|
Hi.
I am facing exactly same proble, but no solution till now
i installed oracle 9i release 2 on windows xp professional then i installed form 6i in different home.
i copied tnsnames.ora file from ORACLE_HOME\network\admin to forms home NET80\admin folder....
Once i installed both i can see in the PATH variable both homes then bin directory....
ORACLE_HOME/bin
FORMS_HOME/bin
in these two locations you can find sqlplus.exe file, when i try to login from the command prompt like below
sqlplus "/as sysdba"
it is not going, instead it is coming to command prompt... if i remove FORMS_HOME/bin from the PATH variable i can able to do that...just keep this problem aside.
When i try to connect oracle from the forms it is giving error like "ORA-12222 TNS no such protocol adapter...."
could you please tell me why?
what is need to do to get rid of this?
Thanks.
|
|
|
TNS No Such Protocol adaptor Ora- 12222 [message #221013 is a reply to message #220953] |
Fri, 23 February 2007 04:02 |
sauami
Messages: 54 Registered: October 2005 Location: india
|
Member |
|
|
Dear sir,
I am using forms 6i on oracle database 9.2 on oracle apps 11.5.0
i can connect database through toad or pl/sql developer but unable to connect forms and report when i try to connect my forms builder it give the error TNS No Such Protocol adaptor Ora- 12222.
print screen is attached.
Pls. help me.
Thanks,
Saurabh
|
|
|
|
|
|
|
Re: TNS No Such Protocol adaptor Ora- 12222 [message #229441 is a reply to message #225381] |
Sun, 08 April 2007 00:32 |
shahnazurs
Messages: 240 Registered: June 2005 Location: India
|
Senior Member |
|
|
Hi,
I am still having problem connecting oracle from forms.
i am using forsm6i and oracle 9i, i installed oracle first then forms. but both are in different homes.then i have copied tnsnames.ora and sqlnet.ora from oracle_home/ora92/network/admin
and placed under forms_home/net80/admin folder. Still i am having ORA-12222:TNS:nu such protocal adapter
Thanks,
Shahnaz
|
|
|
Re: TNS No Such Protocol adaptor Ora- 12222 [message #230096 is a reply to message #229441] |
Tue, 10 April 2007 20:39 |
|
djmartin
Messages: 10181 Registered: March 2005 Location: Surges Bay TAS Australia
|
Senior Member Account Moderator |
|
|
What operating system are you each using?
Search this forum for 'ORA-12222 TNS no such protocol adapter'. There are numerous threads, look at the older ones first.
Don't blindly copy the database TNSNAMES.ORA file over the Forms copy. Look at it and understand what it is doing. There is also the LISTENER.ORA and another file that may also need to be changed.
David
Upd: three typos, sorry.
[Updated on: Thu, 19 April 2007 19:25] Report message to a moderator
|
|
|
|
|
Re: TNS No Such Protocol adaptor Ora- 12222 [message #232597 is a reply to message #231400] |
Sat, 21 April 2007 20:07 |
shahnazurs
Messages: 240 Registered: June 2005 Location: India
|
Senior Member |
|
|
Hi Martin,
I could able to connect via sql*plus,toad...but not from form:( i am using standalone pc where my oracle server is installed. tell me how form connect to oracle, what are the different parameter files it read?
is it going to read tnsnames.ora and sqlnet.ora under net80/admin of form_home?
Please see the attachment is the registry entry.
Shahnaz.
-
Attachment: Snapshot.GIF
(Size: 51.37KB, Downloaded 2039 times)
[Updated on: Sat, 21 April 2007 21:48] Report message to a moderator
|
|
|
|
Re: TNS No Such Protocol adaptor Ora- 12222 [message #232766 is a reply to message #232660] |
Mon, 23 April 2007 04:06 |
shahnazurs
Messages: 240 Registered: June 2005 Location: India
|
Senior Member |
|
|
Hi Martin,
Thanks for your kind reply.
I have checked both tnsnames.ora and sqlnet.ora under FORM_HOME/net80/admin and ORACLE_HOME/network/admin, they are same and database is mentioned in the tnsnames.ora
Tell me martin how come oracle can able to connect from sql*plus if database name is not mentioned in tnsnames.ora file?
Do i need to create any listner.ora file? i don't think so it required because i am connecting oracle which is installed in my PC.
Shahnaz.
|
|
|
|
Re: TNS No Such Protocol adaptor Ora- 12222 [message #234400 is a reply to message #232891] |
Tue, 01 May 2007 07:58 |
shahnazurs
Messages: 240 Registered: June 2005 Location: India
|
Senior Member |
|
|
I have done ready all but it didn't work.
1> Database (oracle 9i R2)is running in remote server.
2> I installed again in my m/c forms 6i.
3> I copied tnsnames.ora from my oracle client home to forms home
i.e ORACLE_HOME/network/admin to FORM_HOME/net80/admin
unable to resolve service name??
Could you please tell me anything else can be done apart from this?
Thanks.
|
|
|
|
|
|
Re: TNS No Such Protocol adaptor Ora- 12222 [message #240013 is a reply to message #237852] |
Wed, 23 May 2007 20:53 |
shahnazurs
Messages: 240 Registered: June 2005 Location: India
|
Senior Member |
|
|
Hi Martin,
step 1) i copied tnsnames.ora from oracle home to form home
step 2) to do something with sqlnet.ora
Tell me whether first step is OK?
if step is correct then i need to modify sqlnet.ora in form home.
Am i right?
Thanks.
|
|
|
|
|
|
|
Re: TNS No Such Protocol adaptor Ora- 12222 [message #459415 is a reply to message #256047] |
Fri, 04 June 2010 17:05 |
black_cisne10
Messages: 1 Registered: June 2010
|
Junior Member |
|
|
hi, i neeed any help please.
i have the same error: ora-12222 trying to log in with oracle forms 6i
i am trying to log in this way
user: blackcisne i create the blackcisne user as a dbadmin
password: ****** the password i set
database: orcl
i dont want to log in in sql*plus, i want to connect my oracle 10g database with my oracle forms 6i.
my tnsnames:
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.101)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
now my sqlnet
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
and the last my listener
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.101)(PORT = 1521))
)
)
please help
|
|
|
Re: TNS No Such Protocol adaptor Ora- 12222 [message #463891 is a reply to message #459415] |
Mon, 05 July 2010 02:02 |
|
djmartin
Messages: 10181 Registered: March 2005 Location: Surges Bay TAS Australia
|
Senior Member Account Moderator |
|
|
Sorry that I have been so long in replying. Have you solved your problem?
I know you want to use Forms but you have to test that SQL*Plus works first.
Also, use the environment variable 'tns_admin' so that you only have to maintain a single copy of the 'tnsnames.ora' file.
David
|
|
|