DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: sqlplus "/ as sysdba"

  1. #1
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681

    sqlplus "/ as sysdba"

    Hi Friends,

    OS = AIX 5L
    Why does my > sqlplus "/ as sysdba" runs on 10g but will not in 9i

    But in windows 2k ora 9i it runs too

    How can i make it run please......

    Thanks a lot
    Last edited by yxez; 10-09-2006 at 01:53 AM.
    Behind The Success And Failure Of A Man Is A Woman

  2. #2
    Join Date
    Oct 2006
    Location
    Mumbai
    Posts
    184
    Hi,

    $ ORACLE_SID=
    $ export ORACLE_SID
    $ sqlplus "/ as sysdba"

    Try it.

    Hard code ORACLE_SID in your oracle user profile and export in that profile itself.

    Test if it has applied by

    $ echo $ORACLE_SID

  3. #3
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    echo $ORACLE_HOME and $PATH see where it is pointing to.
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  4. #4
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    thanks dear ....i try it later coz i reinstalled the DB.. it thought
    i was a bug
    Behind The Success And Failure Of A Man Is A Woman

  5. #5
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    I reinstall it and the same error

    I cant run sqlplus "/ as sysdba"
    But it will run> sqlplus "sys/sys as sysdba"

    What is wrong with it
    Behind The Success And Failure Of A Man Is A Woman

  6. #6
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    Quote Originally Posted by Thomasps
    echo $ORACLE_HOME and $PATH see where it is pointing to.
    Do you think the two commands above will differ in PATH? or HOME?
    Behind The Success And Failure Of A Man Is A Woman

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    you havent once put the error you are receiving

  8. #8
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    not allowed as sysdba
    Behind The Success And Failure Of A Man Is A Woman

  9. #9
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    thats not an oracle error, put a full copy and paste from your session showing eactly what you did and the error

  10. #10
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    hi davey...its the stubborn error ora-1031 : insufficient privilege
    Behind The Success And Failure Of A Man Is A Woman

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