Connecting Internal or as SYSDBA

[tlmason74]

I have an Oracle Database system that I have been given which I need to change the initorcl.ora file. I have tried to connect internal without a password and the system denies me with an invalid username/password error. I have also tryed connecting as as sysdba but that didn't work either. I was not here when this system was configured and none of the people who did the configuration work here any longer. Any ideas as to how I can get into the system so to shutdown the database make the changes and restart?

Oracle Version 8.05 (Yuk, but what my company owns)
WIN NT 4.0


Thanks!!

[Tarry]

What version? note that 9i doesn't support internal.

[davey23uk]

also post your os version

[abhaysk]

Create new pswd file with ur new pswd using ORAPWD utility.

Or if ur OS is windows its pretty easy to get into DB as sysdba.

In SQLNET.ora make the authentication NTS and put the NT user in ORA_DBA group. U can get into DB as SYSDBA without pswd.


Abhay.

[tlmason74]

My Oracle Version is 8.05
OS is Win NT 4.0

[akhadar]

Delete your old password and enter into your OS with Administrative user and follow the steps mentioned by Abhay to create the New password file.

[dasari98]

Originally posted by tlmason74
Oracle Version 8.05 (Yuk, but what my company owns)

Hi 8.05 is neither extint nor bad.As long as it server u'r business purpose it is good enough.

anyway comming to u'r question.
i understand that u need to make some changes in u'r parameter file.

Create new pswd file with ur new pswd using ORAPWD utility.

This should work.
If u just want to shutdown the database in winnt u can stop the service make the necessacary changes and start the service.
u can Also try the System/manager to get into the database(hope the default pwd for system is not changed).

[akhadar]

Originally posted by dasari98
u can Also try the System/manager to get into the database(hope the default pwd for system is not changed).

Without sysdba can he shutdown his database. which is what he wants.