Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003

    Unanswered: SQL plus question /nolog

    I am trying to gain some knowledge on sqlplus parameters.

    When I issue the command
    1. sqlplus : the system asks me for a username and a password. On successful login, it gives me information that the instance is XYZ.
    2. sqlplus /nolog : it gives me the following message
    SQL*Plus: Release - Production on Wed Jul 23 10:06:30 2003

    (c) Copyright 2000 Oracle Corporation. All rights reserved.

    SP2-0640: Not connected

    It then asks for the value of the instance. (I am not sure what exactly we mean by the instance value).
    After entering a instance value, I get the prompt as
    10:07:32 ksj SQL> (where ksj is any instance value i entered).

    Then on this prompt itself, I issue command like connect as sysdba, it asks me for username and password

    I am not fully sure if I understand the sqlplus command line parameters and internal working of SQLPLUS, so please bear with this basic looking question.

    Thanx and Regards

  2. #2
    Join Date
    Jul 2003
    the instance is the SID which is normally also the DB_NAME.

    so, if you normally connect to a database with:
    sqlplus scott/tiger@sid

    then you could do that at commandline and THEN connect as sys with:
    connect / as sysdba

    Just connect as any old user and then connect as sysdba. Like this:
    bash-2.03$ sqlplus integration/integration
    SQL*Plus: Release - Production on Wed Jul 23 10:11:30 2003
    Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
    Connected to:
    Oracle9i Enterprise Edition Release - 64bit Production
    With the Partitioning and OLAP options
    JServer Release - Production
    kod:integration> connect / as sysdba
    kod:integration> show user
    USER is "SYS"
    you could also connect specifying the sid: sqlplus integration/integration@kod1
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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