Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2002
    Posts
    11

    Unhappy Unanswered: Oracle 9i connect system /manager continues!

    Hi again,

    I tried loging as connect system/manager @mydb as sysdba but I got the following error

    ORA-12154: TNS:could not resolve service name

    can anyone tell me what does this error mean, or tell me how can figure this out to log on as system/manager


    thank again!

    Michelle

  2. #2
    Join Date
    Nov 2002
    Location
    Toronto
    Posts
    5
    I think that it was a little misunderstanding. In the answer to your question (from "jsorense") you have an EXAMPLE :


    connect system/manager@mydb as sysdba

    In this command "mydb" is a name of the database. Oracle try to find information about this name in the tnsnames.ora file (TNSNAMES.ORA is located in a directory similar to the following:
    <Oracle Home>\Net80\Admin
    <Oracle Home>\Network\Admin )
    You have an error becouse Oracle can't find information about "mydb" in tnsnames.ora file.

    ----
    I have a very bit experience with Oracle personal editions, but as I know, you don't need construction @<database_name>.

    You can use

    connect system/manager as sysdba

  3. #3
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482

    Cool

    That is wrong:

    system/manager @mydb

    No blank spaces in the string !!! Should be system/manager@mydb


    Hope that helps,

    clio_usa
    OCP - DBA

Posting Permissions

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