OraFAQ Forum: Forms » Help For TNS

Home » Developer & Programmer » Forms » Help For TNS

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

Help For TNS [message #276176]

Wed, 24 October 2007 04:58

alijeyan
Messages: 184
Registered: January 2007
Location: IRAN

Senior Member

Hi

I installed Oracle DATABASE 9 on a WInXP system .
and then install Oracle DEVELOPER 6i on another XP system.

i put IP Address and SID name in TNSNAMES.ora at the DEVELOPER system : like this :

MYDATA.world =
  (DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS =
          (PROTOCOL = TCP)
          (Host = 172.16.25.33)
          (Port = 1521)
        )
    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )

and SQLNET.ORA is :


TRACE_LEVEL_CLIENT = OFF
#sqlnet.authentication_services = (NONE)
names.directory_path = (TNSNAMES, HOSTNAME)
names.default_domain = world
name.default_zone = world
automatic_ipc = off

Oracle Database on XP started and work . but when i connect from DEVELOPER folowing error :

ORA-12751 : TNS : Packet writer failure

Report message to a moderator

Re: Help For TNS [message #276221 is a reply to message #276176]

Wed, 24 October 2007 07:06

sd_md_rizwan@yahoo.com
Messages: 37
Registered: September 2007
Location: Saudi Arabia

Member

Hi nothing to worry
first go to the drive in which you have installed your developer6i and open the folder orant then open the folder net80 then open the folder admin and cut the files sqlnet.ora and tnsnames.ora and past it to any other place
(orant->net80->admin)

then go to the drive in which you have installed your database9i
then open the folder oracle then ora90 then network then admin
you will find same files here like sqlnet.ora and tnsnames.ora
(oracle->ora90->network->admin)

copy them to the developer folder from where you have removed the same files
(orant->net80->admin)

and now try plsql editor and forms and reports
they should run
if success let me know

Report message to a moderator

Re: Help For TNS [message #276327 is a reply to message #276221]

Wed, 24 October 2007 20:43

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

Senior Member
Account Moderator

Alternatively, use the environment variable 'TNS_ADMIN" and point it at the one copy of tnsnames.ora with which you wish to work.

David

Report message to a moderator

Previous Topic:	fetch whole records
Next Topic:	capturing client operating system user name

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 10 01:23:38 CST 2024