Re: Connect Internal - can the password be changed?

Shutdown the database
Delete the orapw file
Re-create it with the password you want (ex. 1) Start the database

ex. 1
orapwd file=<file_name> password=<password>

Alex Ivascu

"Anus" <anus_at_anus.anus> wrote in message news:o9meou0qr1gkf45m4b167t37ls05vo1nbt_at_4ax.com...
> I've created an 8.1.7 database and left the default passwords
>
> "SYS" and "SYSTEM" accts have had thier passwords changed
>
> ....but INTERNAL stiil connects with the "default" password and I
> cannot seem to be able to change it.
>
>
> i connect as internal and run the following:
>
> SQL>
> SQL> ALTER USER "INTERNAL" IDENTIFIED BY "AAAAAA";
> ALTER USER "INTERNAL" IDENTIFIED BY "AAAAAA"
> *
> ERROR at line 1:
> ORA-01918: user 'INTERNAL' does not exist
>
>
> SQL> show user
> USER is "SYS"
> SQL>
>
>
> Can it be done ???
Received on Tue Sep 17 2002 - 20:04:11 CEST