Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Location
    US
    Posts
    314

    Unanswered: SQL plus question /nolog

    Hi
    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 8.1.7.0.0 - 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
    Aruneesh

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    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:
    Code:
    bash-2.03$ sqlplus integration/integration
    
    SQL*Plus: Release 9.2.0.2.0 - Production on Wed Jul 23 10:11:30 2003
    
    Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
    
    
    Connected to:
    Oracle9i Enterprise Edition Release 9.2.0.2.0 - 64bit Production
    With the Partitioning and OLAP options
    JServer Release 9.2.0.2.0 - Production
    
    kod:integration> connect / as sysdba
    Connected.
    kod:integration> show user
    USER is "SYS"
    kod:integration>
    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
  •