Problem when using SQLPlus in Oracle 9i

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Alex

    Problem when using SQLPlus in Oracle 9i

    Hi Everybody,

    I am new to Oracle.
    I just installed the Oracle9i (personal edition) on my Window XP
    system. I am trying to simply run some basic SQL commands using
    SQLPlus. After entering userid (system) password(manage r) and Host
    String (my global database name), I am getting the following error and
    it does not logme in:
    can not run the service.

    Would you please help me? Is default user name and password are
    correct?

    Sincerely,
    AlexSM
  • Nicolas Payre

    #2
    Re: Problem when using SQLPlus in Oracle 9i

    Sound like the Instance your trying to connect isn't started...
    Check for Services into the "Computer management consol" if you can see it.
    Otherwise you can startt it manually with the following command

    z:\your_oracle_ home\ORACLE.EXE <global database name>



    "Alex" <alexsm@eudoram ail.comwrote in message
    news:29ff93bc.0 307200745.3c9f3 274@posting.goo gle.com...
    Hi Everybody,
    >
    I am new to Oracle.
    I just installed the Oracle9i (personal edition) on my Window XP
    system. I am trying to simply run some basic SQL commands using
    SQLPlus. After entering userid (system) password(manage r) and Host
    String (my global database name), I am getting the following error and
    it does not logme in:
    can not run the service.
    >
    Would you please help me? Is default user name and password are
    correct?
    >
    Sincerely,
    AlexSM

    Comment

    • Mark D Powell

      #3
      Re: Problem when using SQLPlus in Oracle 9i

      alexsm@eudorama il.com (Alex) wrote in message news:<29ff93bc. 0307231254.7962 4abe@posting.go ogle.com>...
      I tried that and I am still getting the following error when I try to
      login to SQL PLUS:
      >
      Error:
      ORA-12560: TNS: Protocol Adaptor Error
      >
      Any idea?
      >
      Sincerely,
      Alex
      >
      >
      "Nicolas Payre" <nicpayre[junk]@sympatico.cawr ote in message news:<O9zSa.449 $1I5.55399@news 20.bellglobal.c om>...
      Sound like the Instance your trying to connect isn't started...
      Check for Services into the "Computer management consol" if you can see it.
      Otherwise you can startt it manually with the following command

      z:\your_oracle_ home\ORACLE.EXE <global database name>



      "Alex" <alexsm@eudoram ail.comwrote in message
      news:29ff93bc.0 307200745.3c9f3 274@posting.goo gle.com...
      Hi Everybody,
      >
      I am new to Oracle.
      I just installed the Oracle9i (personal edition) on my Window XP
      system. I am trying to simply run some basic SQL commands using
      SQLPlus. After entering userid (system) password(manage r) and Host
      String (my global database name), I am getting the following error and
      it does not logme in:
      can not run the service.
      >
      Would you please help me? Is default user name and password are
      correct?
      >
      Sincerely,
      AlexSM
      A 12560 error would indicate that Oranet (sqlnet, net8) either is not
      installed or not configured correctly. First if you have not already
      done so re-boot the machine. Then if the problem still exists open
      the Oracle Net Configuration Assistent and look at the settings. The
      ID used to install Oracle on your PC should have almost full
      administration privileges.

      HTH -- Mark D Powell --

      Comment

      Working...