Home » Developer & Programmer » Forms » Help For TNS
Help For TNS [message #276176] Wed, 24 October 2007 04:58 Go to next message
alijeyan
Messages: 180
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
Re: Help For TNS [message #276221 is a reply to message #276176] Wed, 24 October 2007 07:06 Go to previous messageGo to next message
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
Re: Help For TNS [message #276327 is a reply to message #276221] Wed, 24 October 2007 20:43 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Previous Topic: fetch whole records
Next Topic: capturing client operating system user name
Goto Forum:
  


Current Time: Thu Dec 08 20:11:10 CST 2016

Total time taken to generate the page: 0.06340 seconds