Home » Developer & Programmer » Forms » TNS No Such Protocol adaptor Ora- 12222 and Unable to connect oracle :( (merged)
TNS No Such Protocol adaptor Ora- 12222 and Unable to connect oracle :( (merged) [message #220953] Thu, 22 February 2007 19:39 Go to next message
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 Go to previous messageGo to next message
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 #221047 is a reply to message #221013] Fri, 23 February 2007 07:55 Go to previous messageGo to next message
shahnazurs
Messages: 240
Registered: June 2005
Location: India
Senior Member
Hi.
I am also facing the same problem, i posted ready but no reply from anybody Sad

Thanks,
Shahnaz.
Re: TNS No Such Protocol adaptor Ora- 12222 [message #221081 is a reply to message #221047] Fri, 23 February 2007 12:39 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This is what Oracle says about it; see if it will help.
Oracle
ORA-12222: TNS:no support is available for the protocol indicated


Cause: The protocol requested in the ADDRESS portion of the connect descriptor identified through the net service name is not available. If the supplied ADDRESS is typographically correct then support for that protocol is not installed.

Action: Install support for the protocol or correct typographical error, as appropriate. Note: if the supplied address was derived from resolving the net service name, check the address in the appropriate file (TNSNAMES.ORA, LISTENER.ORA) or in the directory server.
Re: Unable to connect oracle :( [message #225377 is a reply to message #220953] Mon, 19 March 2007 18:03 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Have you solved your problem?

I should probably merge this thread into the other to which you have been added.

Have you installed a database on this PC?

The 'common wisdom' is to install the database, get it working via SQL*Plus. Install the older version of Forms (in your case 6i), get it working by making the newer TNSNAMES.ORA match the one used by the database. Then install the newer version of Forms and get this last copy of TNSNAEMS. ORA to match the other two.

David
Re: TNS No Such Protocol adaptor Ora- 12222 [message #225381 is a reply to message #221081] Mon, 19 March 2007 18:50 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Have you solved your problem?

If not, search this forum for 'tnsnames.ora'. Install the database, get SQL*Plus working, install Forms, copy the various files from the database 'network/admin' directory to the forms 'network/admin' directory. There are many threads, read the older ones first.

David
Re: TNS No Such Protocol adaptor Ora- 12222 [message #229441 is a reply to message #225381] Sun, 08 April 2007 00:32 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 #231400 is a reply to message #230096] Mon, 16 April 2007 23:11 Go to previous messageGo to next message
shahnazurs
Messages: 240
Registered: June 2005
Location: India
Senior Member
Thanks Martin for your advice.
Iam using Windows XP Professional.

copy of tnsnames.ora instace in to forms home is adviced in one of the thread's reply. I don't know what exactly to do now:(

Thanks,
Shahnaz.
Re: TNS No Such Protocol adaptor Ora- 12222 [message #232226 is a reply to message #231400] Thu, 19 April 2007 19:28 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Get SQL*Plus working against the database, read the database tnsnames and listener files. Read the forms tnsnames and listener files. Can you see that your database is not mentioned the last two files? Modify these Forms files so that your database is mentioned in them. Restart your server - if in doubt reboot your PC.

David
Re: TNS No Such Protocol adaptor Ora- 12222 [message #232597 is a reply to message #231400] Sat, 21 April 2007 20:07 Go to previous messageGo to next message
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 1950 times)

[Updated on: Sat, 21 April 2007 21:48]

Report message to a moderator

Re: TNS No Such Protocol adaptor Ora- 12222 [message #232660 is a reply to message #232597] Sun, 22 April 2007 21:13 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Which part of the following don't you understand?
read the database tnsnames and listener files. Read the forms tnsnames and listener files. Can you see that your database is not mentioned the last two files? Modify these Forms files so that your database is mentioned in them. Restart your server - if in doubt reboot your PC.

For the names of the files either search this forum for 'tnsnames' and 'listener', read the older entries first, or use the 'windows explorer' and search for 'tnsnames' and 'listener'.

David
Re: TNS No Such Protocol adaptor Ora- 12222 [message #232766 is a reply to message #232660] Mon, 23 April 2007 04:06 Go to previous messageGo to next message
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 #232891 is a reply to message #232766] Mon, 23 April 2007 18:32 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
If your system is working then you don't need to change the 'listener', if it is not working then you do need to change the 'listener'. There are three files tnsnames, listener, and sqlnet. The copies in the database home and the forms home must have your PC's database mentioned in them.

You install the database first, you get SQL*Plus and TOAD working aginst the database, you then modify the Forms files (which aren't working properly) to contain the information that is in the database files (which is working properly).

David
Re: TNS No Such Protocol adaptor Ora- 12222 [message #234400 is a reply to message #232891] Tue, 01 May 2007 07:58 Go to previous messageGo to next message
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 #236476 is a reply to message #234400] Thu, 10 May 2007 01:23 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
I said modify not copy. Open the files and see what is in there. Only bring across the defintions that you need.

David
Re: TNS No Such Protocol adaptor Ora- 12222 [message #237568 is a reply to message #236476] Mon, 14 May 2007 23:34 Go to previous messageGo to next message
shahnazurs
Messages: 240
Registered: June 2005
Location: India
Senior Member
Please tell me what to modify?

Do you mean i need to modify sqlnet.ora and tnsnames.ora? if so please let me know.

Thanks.
Re: TNS No Such Protocol adaptor Ora- 12222 [message #237852 is a reply to message #237568] Wed, 16 May 2007 00:17 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Have you opened the files and looked at what is stored in them?

David
Re: TNS No Such Protocol adaptor Ora- 12222 [message #240013 is a reply to message #237852] Wed, 23 May 2007 20:53 Go to previous messageGo to next message
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 #250106 is a reply to message #240013] Sat, 07 July 2007 23:10 Go to previous messageGo to next message
shahnazurs
Messages: 240
Registered: June 2005
Location: India
Senior Member
Is there any update?

I am still facing ORA-12222 no protocal adapter error.

Thanks.
Re: TNS No Such Protocol adaptor Ora- 12222 [message #252772 is a reply to message #250106] Thu, 19 July 2007 23:29 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Have you solved your problem?

David
Re: TNS No Such Protocol adaptor Ora- 12222 [message #255196 is a reply to message #252772] Tue, 31 July 2007 00:19 Go to previous messageGo to next message
shahnazurs
Messages: 240
Registered: June 2005
Location: India
Senior Member
No David,
It is still the same error?

Thanks,
Shahnaz.
Re: TNS No Such Protocol adaptor Ora- 12222 [message #256047 is a reply to message #255196] Thu, 02 August 2007 20:13 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Okay Shahnaz ... lets go back to the beginning. In February you said you are running XP on your machine, that you had installed the Oracle 9i database and that you can communicate with it via TOAD and the SQL*Plus which, I assume, is in the database home. In May you said that you are running the database on a remote server.

I know I have asked you the same questions in numerous posts but lets forget that and work our way through where you are currently.

Question 1: Do you have Oracle 9i database running on your PC?

Question 2: Can you access it via TOAD and SQL*Plus?

Request 1: Please put your 9i database versions of tnsnames.ora, listener.ora, and sqlnet.ora into a zip file labelled database_files and attach it to your next post.

Request 2: Please put your 6i forms versions of tnsnames.ora, listener.ora, and sqlnet.ora into a zip file labelled forms_files and attach it to your next post.

Lets see what you have and lets get you working.

Question 3: Have you uninstalled and / or reinstalled any of these Oracle products?

David
Re: TNS No Such Protocol adaptor Ora- 12222 [message #459415 is a reply to message #256047] Fri, 04 June 2010 17:05 Go to previous messageGo to next message
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 Go to previous message
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
Previous Topic: Unable to save the record in the database
Next Topic: error in calling reports
Goto Forum:
  


Current Time: Thu Mar 28 14:01:43 CDT 2024