Link to home
Start Free TrialLog in
Avatar of HERBET
HERBET

asked on

Error while trying to retrieve text for error ORA-12154

I have a problem in a client application which began occurring after an Oracle database installed Oracle 8.1.7.  Once the software installation has completed, to configure the Oracle Net8 client then the installer freezes at this point of the installation. when i try to configure Net8 manually it's not show up ( not working). so, what i gonna do? i cannot use application client i.e : toad, etc. plzz help me..

Any pointers would be greatly appreciated...

Thanks

Herbet
Avatar of ajaypappan
ajaypappan
Flag of United States of America image

try for a client update or uninstall and try to reinstall the client software..
ASKER CERTIFIED SOLUTION
Avatar of sujit_kumar
sujit_kumar
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of kripa_odba
kripa_odba

Hi HERBET,

  if you are using a windows system please go to the directory where oralce is installed.Under which go to network\admin. There you will find two files called tnsname.ora and sqlnet.ora.If you want to do a client configuration you have to edit this file(if you cannot use the gui tool,gui tools internaly edit these files).

   eg. of path where you can find C:\Oracle\Ora81\network\ADMIN\

  you can find entries like this in tnsnames.ora file.
 
   connectstring=
  (DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS =
          (PROTOCOL = TCP)
          (HOST = hostname or IP Address of the target computer)
          (PORT = 1521)
        )
    )
    (CONNECT_DATA = (SID = sidname of your database)
    )
  )


the connect string can be any string which you use while connecting to the database .

   eg.    connect scott/tiger@connectsting

       
   the main things you need to specify here is connect string,protocol which you are using(default it will be TCP),Host computer name ie. server name or the IP of the server.Default PORT is enough.
  The next thing you need to define is SID.Here you can specify your database name.


Once you specify all these details you can save the file.The next step you can open sqlnet.ora file

Check an entries like these in sqlnet.ora file.    names.directory_path = (TNSNAMES)

eg.


   testdb=
  (DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS =
          (PROTOCOL = TCP)
          (HOST = kripa)
          (PORT = 1521)
        )
    )
    (CONNECT_DATA = (SID = test)
    )
  )

in this case my connect string is testdb,i use this connect string while connecting to the database.my host computer name is kripa where oracle server is running.and my database name is test.'

you can connect to the database  like this.

 sql>connect scott/tiger@testdb


you can test the connection once you configure this tnsnames.ora using tnsping utility.

 eg.   tnsping testdb

once its responding you can connect to database.


Hope this will solve your problem.


Cheers
Kripa