Oracle 8 installation-----Error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Oracle 8 installation-----Error

  1. #1
    Join Date
    Jul 2002
    Posts
    8

    I installed oracle 8 on Windows 2000 Advance Server,after installation i tried to connect oracle

    through SVRMGRL i am getting the error TNS Not configured and even from SqlPlus also when i give

    scott/Tiger with empty Host it is not allowing to inter ito oracle.

    Please any body can help me.

    Thanks
    MAM
    Mohammed A.Musaddique
    SAudi Arabia

  2. #2
    Join Date
    Jun 2002
    Posts
    64
    Hi,

    Check whether the ORACLE_SID, ORACLE_HOME etc. set

    Cheers

  3. #3
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,591
    You've installed the oracle software, i presume.
    Have you also created a database?
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  4. #4
    Join Date
    Jun 2002
    Posts
    64
    Did that help you to solve the problem?

  5. #5
    Join Date
    Apr 2002
    Posts
    14

    Unhappy

    OK, I did this one....

    Your TNSNAMES.ORA file should be in the [drive]:\[*oracle]\ora81\network\ADMIN\ directory. *ORACLE is the directory I loading the files onto, replace this with the file directory you set your copy of ORA into.

    It needs to be double checked for the proper desc and protocol and IP mapping information in order to mount and open the db over the network.

    My file is marked, 'Generated by Oracle configuration tools.' and is only 2k in size. It is normally set up as part of your install


    I accidently crushed this file when I installed Ora 8.1.7.0.0 local to my system and overwrote our network generated copy of the tnsname.ora file. As for rebuilding it, I can only hope that you can find the

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width