How to login
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: How to login

  1. #1
    Join Date
    Aug 2005
    Posts
    10

    How to login

    I just installed Oracle 9.0.1 on SUSE 9.
    I started the listener.


    How do I log in to the database? I am trying this:


    sqlplus /nologin


    SQL> connect / as sysdba
    ERROR:
    ORA_01031: insufficient privileges


    I also tried scott/tiger without success.

  2. #2
    Join Date
    Jul 2000
    Posts
    521
    Try sqlplus /nolog

    Try sqlplus "/ as sysdba"

    Is there a database created ?
    svk

  3. #3
    Join Date
    Aug 2005
    Posts
    10
    sqlplus "/ as sysdba"
    results in:
    ORA_01031: insufficient privileges

  4. #4
    Join Date
    May 2003
    Location
    Pretoria, Rep of South Africa
    Posts
    191
    Your not defined as a Oracle user on the database.
    Try not to use OS authentication in the beginning until your db has been configurated
    Use db authentication : system or sysdba user/password

    conn system/system??@my_db?
    Able was I ere I saw Elba

  5. #5
    Join Date
    Aug 2005
    Posts
    10
    I don't understand, if my hostname is sun9 and my DB name is test, how would this command look?

    conn system/sun9@test

    this returns

    ERROR:
    ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist
    Linux Error: 2: No such file or directory

Posting Permissions

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



Click Here to Expand Forum to Full Width