-
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.
-
Do you have appropriate OS privileges?
-- Dilip
-
Use this.
sqlplus "/ as sysdba"
-
 Originally Posted by malay_biswal
Use this.
sqlplus "/ as sysdba"
eh? thats the same thing as what the op has done
-
> 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?
-
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
-
i'd expect people to help themselves and do some research, but we dont all get what we want do we
-
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
-
 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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|