OraFAQ Forum: Server Administration » Connecting Oracle to Oracle Forms

Home » RDBMS Server » Server Administration » Connecting Oracle to Oracle Forms

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

Connecting Oracle to Oracle Forms [message #58653]

Tue, 23 September 2003 21:57

Srilatha
Messages: 8
Registered: January 2000

Junior Member

I am trying to connect Oracle 9i with Oracle Forms 6.0 and i am getting this error
"TNS 12571 packet writer failure"

I checked out the tnsnames.ora and listener.ora. I think they are ok. Can anyone please help with the problem?

Thanks in advance.
Srilatha

Report message to a moderator

Re: Connecting Oracle to Oracle Forms [message #58655 is a reply to message #58653]

Wed, 24 September 2003 06:08

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Make sure you can connect using sqlplus plus (using the same tnsentries) also and
post your listner.ora / tnsanames.ora.
Enable tracing for more information, becuase  in Most cases packet writer failure will arise along with other symptoms.

Report message to a moderator

Re: Connecting Oracle to Oracle Forms [message #58689 is a reply to message #58655]

Thu, 25 September 2003 17:28

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Hi,

Thank you for your reponse. Here are the two files.

Tnsnames.ora
============

oradb =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = siril)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = oradb.siril)
)
)

Listener.ora
===========

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = siril)(PORT = 1521))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = c:Oracleora91)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = oradb.siril)
(ORACLE_HOME = c:Oracleora91)
(SID_NAME = oradb)
)
)

1.Will Oracle 9i connect with Forms 6i?
2.I have installed the Forms 6i after installing Oracle 9i. Is it ok?
3. I tried to connect sqlplus at the command prompt and it is working fine.
Can you tell me if the tnsnames and listener are ok?

Thanks in advance

Srilatha

Report message to a moderator

Re: Connecting Oracle to Oracle Forms [message #58702 is a reply to message #58653]

Fri, 26 September 2003 06:34

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

1 .Your service is different is listener.ora  and tnsnames.ora. check it out.
2. every client will have its own tnsnames.ora
   so goto $FORMS_HOME/network/admin and edit the tnsnames.ora to have the same entries.
3. WHY ARE U USING MY EMAIL AND MY NAME TO POST THE MESSAGES?
   IT WILL CREATE CONFUSIONS. PLEASE AVAOID IT.

Report message to a moderator

Previous Topic:	BITAND
Next Topic:	how will i know if a table data is fragmented or not

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 08:25:40 CDT 2024