Home » RDBMS Server » Server Administration » Ora-01030 Insufficent previlage (10G, XP)
Ora-01030 Insufficent previlage [message #537936] Tue, 03 January 2012 02:46 Go to next message
Bilal Khan
Messages: 128
Registered: April 2010
Location: Pakistan
Senior Member
I want to create new database and i follow the following steps.

C:\SET ORACLE_SID=ASIM

ORAPWD FILE=ORAPWDASIM.ORA PASSWORD=ASIM ENTRIES=6

ORADIM -NEW -SID ASIM -STARTMODE AUTO

THE TRY TO CONNECT TO SQLPLUS

SQLPLUS /NOLOG

AFTER THAT I WRITE THE CODE TO CONNECT THE SYS

Connect sys/ASIM as SYSDBA

BUT IT DISPLAY ERROR ORA-01030, INSUFICENT PREVILAGES.

pLEASE HELP ME TO SOLVE THIS PROBLEM. ITS VERY FIRST TIME THAT THIS PROBLEM ARISES.

rEGARDS
Re: Ora-01030 Insufficent previlage [message #537940 is a reply to message #537936] Tue, 03 January 2012 03:05 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do NOT post in UPPER case.

Regards
Michel
Re: Ora-01030 Insufficent previlage [message #537946 is a reply to message #537940] Tue, 03 January 2012 03:25 Go to previous messageGo to next message
Bilal Khan
Messages: 128
Registered: April 2010
Location: Pakistan
Senior Member
o Really sorry Michel, next time i will send in lower case, at this time please solve my problem.

Regards.
Re: Ora-01030 Insufficent previlage [message #537951 is a reply to message #537946] Tue, 03 January 2012 03:33 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Are you sure ORACLE_SID is set?
2/ Do not explain what you do, SHOW US.
3/ Use dbca instead.

Regards
Michel
Re: Ora-01030 Insufficent previlage [message #537989 is a reply to message #537951] Tue, 03 January 2012 05:54 Go to previous messageGo to next message
tim2boles
Messages: 38
Registered: August 2008
Location: Clarksburg, WV
Member
I agree with Michel that you need to show use the commands and the responses ...not just tell us what you did.

Example:
ORAPWD FILE=ORAPWDASIM.ORA PASSWORD=ASIM ENTRIES=6


I have no idea where that password file you created actually resides. You did not show us that you changed your directory or anything. Perhaps your password file is not in the correct directory...but I have no way of knowing.

Regards
Tim
Re: Ora-01030 Insufficent previlage [message #538052 is a reply to message #537989] Tue, 03 January 2012 13:19 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
tim2boles wrote on Tue, 03 January 2012 06:54
I agree with Michel that you need to show use the commands and the responses ...not just tell us what you did.

Example:
ORAPWD FILE=ORAPWDASIM.ORA PASSWORD=ASIM ENTRIES=6


Actually, that is not really "showing" us anything. It's just "telling" us what you did, so different than what OP did.

This is "showing"

[localhost.localdomain] /home/foo> sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jan 3 13:41:31 2012

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> connect sys/asim as sysdba
ERROR:
ORA-12162: TNS:net service name is incorrectly specified


SQL>
Re: Ora-01030 Insufficent previlage [message #538062 is a reply to message #538052] Tue, 03 January 2012 13:37 Go to previous message
tim2boles
Messages: 38
Registered: August 2008
Location: Clarksburg, WV
Member
I was not clear....I was giving the example from his original posting to say that this is just "telling us what you did" and NOT showing. I guess it would have been better to have quoted the original posting and followed it with an example such as you put out there.

Good job.

Tim

Previous Topic: Cant install SQLT - user cant log in
Next Topic: pre-allocate space for temporary tablespace?
Goto Forum:
  


Current Time: Fri Mar 29 05:55:35 CDT 2024