8i - service up, cannot start database, error 1031?
Oracle 8i on a machine that has recently changed domains.
Services start ok. Database not started.
Using DBA Studio, I connect as a sysdba and try to open the instance (or start, mount, etc) using same config files as before. This fails almost immediately.
In the system event viewer we get the following message (verbatim)...
"Audit trail: ACTION : 'connect INTERNAL' OSPRIV : OPER CLIENT USER: TRIBALDATA\TDS^Admin CLIENT TERMINAL: DEV2K STATUS: FAILED ( 1031 ) . "
Have tried this with several user accounts. Get paired messages in the event log, one with the above message and status "SUCCEEDED ( 0 ) " and this one that fails, same timestamp.
We have inherited this database and the account info may be wrong.
As far as I know the only thing that has changed is that the OS domain has changed. Operating System is Windows 2000 Server.
Any ideas anyone please, about where to look or what the cause may be?
Services start ok. Database not started.
Using DBA Studio, I connect as a sysdba and try to open the instance (or start, mount, etc) using same config files as before. This fails almost immediately.
In the system event viewer we get the following message (verbatim)...
"Audit trail: ACTION : 'connect INTERNAL' OSPRIV : OPER CLIENT USER: TRIBALDATA\TDS^Admin CLIENT TERMINAL: DEV2K STATUS: FAILED ( 1031 ) . "
Have tried this with several user accounts. Get paired messages in the event log, one with the above message and status "SUCCEEDED ( 0 ) " and this one that fails, same timestamp.
We have inherited this database and the account info may be wrong.
As far as I know the only thing that has changed is that the OS domain has changed. Operating System is Windows 2000 Server.
Any ideas anyone please, about where to look or what the cause may be?
ASKER
OK, thanks for the comment, but it wasn't greatly helpful - the message was ORA-01017, "insufficient priviliges", despite correct user/password.
I have found the problem (I think), and it could be of note for others...
The OS administrator account has also changed - name and password - and the new administrator was not in user group ORA_DBA.
I put the new admin user into this group and I was then able to log into oracle dba studio as a sys_dba and start the database successfully.
So, I was logged into the OS as the admin user, who was not in the ORA_DBA group, and was not able to log in as a SYS_DBA under oracle. This seems strange to me, but there may be a link-up to do with services (which are running as local account rather than explicit admin account), OS user and oracle user.
Any ideas - this is a low priority now, since it is sorted.
The Coriolis book "Oracle 8 and Windows NT Black Book" was helpful to me by giving a hint on setting up nt-authenticated users as oracle DBAs.
I have found the problem (I think), and it could be of note for others...
The OS administrator account has also changed - name and password - and the new administrator was not in user group ORA_DBA.
I put the new admin user into this group and I was then able to log into oracle dba studio as a sys_dba and start the database successfully.
So, I was logged into the OS as the admin user, who was not in the ORA_DBA group, and was not able to log in as a SYS_DBA under oracle. This seems strange to me, but there may be a link-up to do with services (which are running as local account rather than explicit admin account), OS user and oracle user.
Any ideas - this is a low priority now, since it is sorted.
The Coriolis book "Oracle 8 and Windows NT Black Book" was helpful to me by giving a hint on setting up nt-authenticated users as oracle DBAs.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Run up a commad window;
Run Server Manager by typing "svrmgrl"
Connect as SYS using "Connect SYS/<Password>@<Instance> As SysDBA
Try to startup the instance using "Startup PFile=<your parameter file including path>
If that does not work then please paste the command line errors into this thread.
Regards
Chedgey