Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2004
    Posts
    4

    Unanswered: how to use SQLplus on DOS's command line

    hi
    i want to use my SqlPlus on DOS ,but after a long time ,i still can't
    connect it.
    My Env:
    oracle: 9i
    oracle service name: jp01
    use name: shi
    password: shi
    the database on the computer that ip is"192.XXX.X.12"
    in CommandLine:

    how to write the command on Dos? c:\>sqlplus <?>
    who can tell me?

  2. #2
    Join Date
    Jan 2004
    Posts
    370
    What error do you get?

    Make sure the ORACLE_HOME\bin directory is in your Path.

  3. #3
    Join Date
    Jun 2004
    Posts
    4
    i write:
    connect shien/shien@192.168.0.12:1521:jp01

    the error tell me : the [connect string] is not right

  4. #4
    Join Date
    Jan 2004
    Posts
    370
    Your connect string is wrong.
    It looks like an old SQL*Net V1 connect string which will not work with 9i

    See the following link to configure your client machine:

    http://download-west.oracle.com/docs...ngs.htm#483215

  5. #5
    Join Date
    Jun 2004
    Posts
    2
    Quote Originally Posted by wangunix
    hi
    i want to use my SqlPlus on DOS ,but after a long time ,i still can't
    connect it.
    My Env:
    oracle: 9i
    oracle service name: jp01
    use name: shi
    password: shi
    the database on the computer that ip is"192.XXX.X.12"
    in CommandLine:

    how to write the command on Dos? c:\>sqlplus <?>
    who can tell me?
    Please check the following.

    1.Check the TNS Connection in the dos prompt
    tnsping jp01
    2. If the connect string is pinging. try to connect like this
    sqlplus shi/shi@jp01
    3.If the TNS Connection is not pinging, you need to configure your tnsnames.ora enty, which is available in ORACLE_HOME/rdbms/network/admin.

    4.edit the tnsnames.ora, IP address for the connect string, port =1521, sid= database name., again check the tnsconnection using tnsping command, then connect to sqlplus shi/shy@jp01.

    regards
    Shyam

Posting Permissions

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