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

Thread: Error creating db manually

  1. #1
    Join Date
    Jan 2006
    Location
    Bangalore,IND
    Posts
    47

    Unhappy Error creating db manually

    I am getting errors when creating the database manually in windows 2003 oracle 9i. Below is the error msg.

    Code:
    SQL> connect / as sysdba
    ERROR:
    ORA-01031: insufficient privileges


    I have created the init file and service first and when i login to create db i get this error. Unable to proceed. I have browsed the metalink docs for the error and could not find a valueable solution to my problem.

  2. #2
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    Do you have appropriate OS privileges?
    -- Dilip

  3. #3
    Join Date
    Nov 2002
    Location
    Mooresville, NC
    Posts
    349
    Use this.
    sqlplus "/ as sysdba"
    http://www.perf-engg.com
    A performance engineering forum

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    Quote Originally Posted by malay_biswal
    Use this.
    sqlplus "/ as sysdba"
    eh? thats the same thing as what the op has done

  5. #5
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    > Check your OS login user is a member of ORA_DBA group to login with out password. Or you may try as malay_biswal wrote which would ask you the password, and are you successfull.
    > Check the registry for the init file creation and you have write privileges. Is the Oracle home listed correctly?

    then you are good to go?

  6. #6
    Join Date
    Jan 2006
    Location
    Bangalore,IND
    Posts
    47
    Hi all,

    Patel_dil, What do you mean by appropriate OS privileges? brief??

    davey23uk, I did expect some thing more from a senior guy

    dbasan, I did check all you posted, still getting the error!

    I looking at that odd thing that I am missing

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    i'd expect people to help themselves and do some research, but we dont all get what we want do we

  8. #8
    Join Date
    Oct 2006
    Location
    Mumbai
    Posts
    184
    Dear,

    Could you please paste the oradim command you attempted to create the service?

    Did you use "-intpwd" clause by any chance while creating service?

    Paresh

  9. #9
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Quote Originally Posted by pareshjavkar
    Could you please paste the oradim command you attempted to create the service?

    Did you use "-intpwd" clause by any chance while creating service?
    Had a good feeling this morning
    it was a beautiful day,
    read your posting... oh my!
    you just ruined my day.

    oerr ORA 1031
    01031, 00000, "insufficient privileges"
    // *Cause: An attempt was made to change the current username or password
    // without the appropriate privilege. This error also occurs if
    // attempting to install a database without the necessary operating
    // system privileges.
    // When Trusted Oracle is configure in DBMS MAC, this error may occur
    // if the user was granted the necessary privilege at a higher label
    // than the current login.
    // *Action: Ask the database administrator to perform the operation or grant
    // the required privileges.
    // For Trusted Oracle users getting this error although granted the
    // the appropriate privilege at a higher label, ask the database
    // administrator to regrant the privilege at the appropriate label.
    Last edited by PAVB; 06-08-2007 at 09:02 AM.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  10. #10
    Join Date
    Jan 2006
    Location
    Bangalore,IND
    Posts
    47
    Thanks for all who has replied to my post. Could anyone brief this?

    This error also occurs if attempting to install a database without the necessary operating system privileges.

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