Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. #1
    Join Date
    Nov 2002
    Posts
    25

    Unanswered: insufficient Priviledge

    Hi All,

    I'm using Windows XP and I would like to create an oracle instance. I successfully installed the oracle software but I did not install the sample database or create any database because I want to create it manually.

    What i did is i executed the ff:

    $ sqlplus /nolog
    $ connect / as sysdba

    I got an error insufficient priviledge. I cannot create a database anymore because i can't login.

    Any help????

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    did you read the manual?
    did you set your ORACLE_SID? and all other environment settings?
    this is a great site for steps to manually create a database:
    PHP Code:
    http://www.adp-gmbh.ch/ora/admin/creatingdbmanually.html 
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool



    Try using dbca to create the database. If you DO NOT want to create the database with dbca, you can use it to generate the scripts to create the database manually.

    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  4. #4
    Join Date
    Nov 2002
    Posts
    25
    i already set

    $ORACLE_SID=orasvr1
    ORACLE_HOME=d:\oracle\ora92

  5. #5
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    Quote Originally Posted by tungaw2001
    i already set

    $ORACLE_SID=orasvr1
    ORACLE_HOME=d:\oracle\ora92

    Remove the$

    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  6. #6
    Join Date
    Jul 2003
    Posts
    2,296
    Quote Originally Posted by LKBrwn_DBA

    Remove the$
    doh!!
    nice catch.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  7. #7
    Join Date
    Nov 2002
    Posts
    25
    i already set oracle_sid. this is what i post using set command on windows environment.

    SET ORACLE_SID=orasvr1
    SET ORACLE_HOME=d:\oracle\ora92

  8. #8
    Join Date
    Jul 2003
    Posts
    2,296
    did you install the CLIENT version or the full Edition (Standard/Enterprise)?

    goto $ORACLE_HOME/dbs
    is there a directory there?
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  9. #9
    Join Date
    May 2004
    Location
    Dominican Republic
    Posts
    721
    tell us about the SQLNET.AUTHENTICATION_SERVICES entry on the SQLNET.ORA file, it is set to NTS ?

  10. #10
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Quote Originally Posted by tungaw2001
    $ connect / as sysdba
    As you got the insufficient privilege error, perhaps this might help: in order to use this syntax, user must be member of both Administrator AND ora_dba user group (check XP's Control Panel, User Accounts) (plus Advanced User management, User, Properties, Member of tab in order to add it to the ora_dba's).

  11. #11
    Join Date
    Aug 2004
    Location
    France
    Posts
    754
    On our Linux platforms, when connected as the oracle user, we don't need the SYS password in order to connect as sysdba since OS authentification is used.

    With the Express Edition I installed on Windows though, if I don't give the SYS password, I get the same "Insufficient privileges" error. If I give the SYS password though, it works.

    I think it must be the same for non-XE Oracle versions, but I'm not sure. I think it's definitely worth a try though, don't you agree ?

    Code:
    connect sys/sys_password as sysdba
    HTH & Regards,

    rbaraer
    ORA-000TK : No bind variable detected... Shared Pool Alert code 5 - Nuclear query ready .

  12. #12
    Join Date
    Nov 2002
    Posts
    25

    Insufficient Priviledge

    Hi All,

    Thanks for the help. Upon reviewing all the docs, I found out that the error is the way i log in.

    before i used

    sqlplus /nolog
    connect / as sysdba, then the Insufficient Priviledge came out.



    after reading again,

    sqlplus /nolog
    connect sys as sysdba
    enter password : *******

    i was able to login. problem fixed. I executed:

    startup;
    # cannot start up because the controlfile is missing. I have no other controlfile available.

    How can I recreate the controlfile from scratch??

  13. #13
    Join Date
    Aug 2004
    Location
    France
    Posts
    754
    Quote Originally Posted by RBARAER
    connect sys/sys_password as sysdba
    Quote Originally Posted by tungaw2001
    connect sys as sysdba
    enter password : *******
    Just as I said .

    Regards,

    rbaraer
    ORA-000TK : No bind variable detected... Shared Pool Alert code 5 - Nuclear query ready .

  14. #14
    Join Date
    Nov 2002
    Posts
    25
    thanks a lot.

  15. #15
    Join Date
    May 2004
    Location
    Dominican Republic
    Posts
    721
    If you dont have any backup of the control file, startup the database in nomount and create the control file manually (you will have to especify the redo/data files manually on it). After that, recover the database and open it.

    Also, about your login problem, connect / as sysdba only works with priviledges users (that is, users that belong to the dba group on your operating system).

Posting Permissions

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