INTERNAL User has disappeared !

[MarkWilliamson]

Trying to log onto the DB via INTERNAL. Says user does not exist.

Thinking I was using the wrong pwd I tried changing itand go the following error.

SQL> ALTER USER INTERNAL IDENTIFIED BY NEWPASS;
ALTER USER INTERNAL IDENTIFIED BY NEWPASS
*
ERROR at line 1:
ORA-01918: user 'INTERNAL' does not exist

Any help would be appreciated.

 

[sem]

Normally INTERNAL is user as a synonym for SYS AS SYSDBA. It have never been a real Oracle user. What is your Oracle version? Do you try to connect locally or via sql*net?

Regards, Dima

 

[MarkWilliamson]

Well the problem is that the Networking Group needs the Internal username / password for their backup processes. This error is prohibiting them from backing up the db.

 

[bainy]

Are you on version 9 ? I believe the Internal user does not exist anymore from that version onwards.

Bainy

 

[karluk]

If no one in your place knows the internal password, you will have to reset it. Do this from a command prompt with the "orapwd" command. The syntax is

orapwd file=<file name here> passord=<new password here> entries=<number>

The file location on Windows is typically your {oracle home}\database directory. The default number of entries is 5.

Be very cautious using this command. Rename the old password file before running it, so you can restore it in case things go wrong. It's very possible there are scripts on your system that will fail if the internal password is changed.

 

[Turkbear]

Hi,
I would also add that no one except the DBA should be
connecting as Internal..Use System instead; it can do everything needed for a backup.
Internal is simply too powerful for any regular use except starting and stopping the database instances - if the backup software requires stopping and starting the instance, get better software.

 

[MarkWilliamson]

Thanks to all who gave advice ! I was able to solve the problem by recreating the password file. Not the backup police are off my back and more importantly the db is getting backed up correctly !

Again thanks to all !!!

 

[sbix]

1) INTERNAL is not an user
2) CONNECT INTERNAL is not supported anymore from Rel 9.x
3) try &quot;CONNECT / AS SYSDBA&quot;