shutdown insufficient privileges while being user "sys"

[erixire]

Hi,

Is it possible that the user "sys" don't has all the privileges? I tried to shutdown the database and it didn't worked? I tried to do "connect as/ sysdba" before, but I didn't had the rights. Can somebody help me? (I also tried has the user "system&quot.

 

[THoey]

Did you try to log in as INTERNAL with SYSDBA privs? The default password for that is ORACLE, if it hasn't been changed... Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...

 

[erixire]

Is it possible that there is no "internal" user? Because if I do a select USERNAME from ALL_USERS, there is no "internal" user.

 

[vr76413]

same problem...i going thru now...

i need to connect as INTERNAL...so logged in as SYSTEM.
then i said CONNECT INTERNAL@INSTANCENAME AS SYSDBA..and it asks for password.., when i issue the default password )oracle), it says "insufficient privileges"...

does anyone has any idea ?

thanks

 

[karluk]

Perhaps you are using the wrong password. I can reproduce your ORA-01031 error by intentionally typing the wrong password while logging in as internal.

 

[vr76413]

i think you are right....

for 1 database, it went thru fine with INTERNAL command, but with other database it not working...perhaps its the password problem...

How do we change the INTERNAL password or reset it ?

 

[Hagen]

We had passed throw this problem with an 8i(8.1.7) database; it was because there were not free space in the filesystem where was Oracle installed.
If you are using aix operative system you can use the command df -k to see the free space in the filesystems and note if you are having this problem.
If it happens you can move or delete the files that doesn't belong to the oracle installation. Of course you most be extremely carefull with that.

 

[karluk]

You can reset the Internal password using the ORAPWD command from an O/S prompt. If I remember correctly, the syntax of the command is

orapwd file={full path of pwd file} password=new_password

I think you will have to shutdown your database in order to do this. This could be a problem, since you can't log in to do the shutdown. If you're on Windows you can just stop the services. That will bring down the db. I'm not sure about Unix platforms.

 

[erixire]

Thanks for your answer karluk, but can you tell me how to stop the services under win2000?

Thanks again.

 

[karluk]

Microsoft changed the location of the Services panel in W2K. As I recall it's now in Start/Programs/Administrative tools. Stop all services with names starting with "Oracle" and do your password change. Then restart the services and open your database.