Ask the Expert

Can't connect to database after changing domain on Oracle Windows 2000 server

I changed the domain for an Oracle Windows 2000 server, then I shutdown and restarted the database, but now I cannot connect using "connect internal," and the database cannot be stopped or started. I am prompted with an "ORA-01031 insufficient privileges" error. How this can be resolved? No password file is used.

    Requires Free Membership to View

Try shutting down the service using the services GUI, especially the tns and agent services, then remove the snmp.ro and snmp.rw in the ORACLE_HOMEnetworkadmin directory, then restart the services. Make sure the entries in the tnsnames file are proper and any entries in the listener.ora as well.

This was first published in September 2004

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: