| Ora-01030 Insufficent previlage [message #537936] |
Tue, 03 January 2012 02:46  |
Bilal Khan
Messages: 128
Registered: April 2010
Location: Pakistan
|
Senior Member |
|
|
I want to create new database and i follow the following steps.
ORAPWD FILE=ORAPWDASIM.ORA PASSWORD=ASIM ENTRIES=6
ORADIM -NEW -SID ASIM -STARTMODE AUTO
THE TRY TO CONNECT TO SQLPLUS
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 #537989 is a reply to message #537951] |
Tue, 03 January 2012 05:54  |
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 |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
tim2boles wrote on Tue, 03 January 2012 06:54I 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 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
