How to solve ORA-12631 (Username retrieval failed)

We need to provide access to Oracle database and start Oracle Warehouse Builder (OWB) from our internal network and outside world (the Internet) so we have created a private network called mynet.private. The OS is Window Server 2003 SP2 and Oracle DB 10g (10.2.0.3).  Oracle installation went very smoothly. The DB control worked fine.  Everything worked as expected only until I started configuring backups.

Since my backup needs to access remote servers so need to:

1. use a domain account (OracleServicesAdmin@mynet.private) to start services so that it can backup to remote servers

2. enable archive log mode

So I added OracleServicesAdmin@mynet.private to local admin group;  enabled the OracleServicesAdmin@mynet.private to have “Log on as a batch job” and “Log on as a service” user rights.

Once I enabled the Oracle server to start with OracleServicesAdmin@mynet.private, I found out that my database did not start up completely.  The window service for starting up database very fast, and the alert log shows :

starting up 1 shared server(s) …

Then do not go any further. The instance show the status is at “STARTED”.

idle> select status, database_status from v$instance;

STATUS       DATABASE_STATUS
———— —————–
STARTED         ACTIVE

I had to use SQLplus to manually start the database into mount and open:

alter database mount;

alter database open;

The database is up and running but I could not conduct backup.  The RMAN gives the following error:

C:\Oracle\sqls>rman target sys@owb1

Recovery Manager: Release 10.2.0.3.0 – Production on Mon Jul 20 14:12:15 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

target database Password:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-12631: Username retrieval failed

I have the exactly environment in our production network, the backup works. The only difference is now that I have it in the mynet.private domain. After talking to our network administrators, they think that there is something to do with active directory and might be Oracle does not like the “.private” domain.  Later, I found out that it has to do with the format of domain account in starting Oracle services.

The solution is to change  “OracleServicesAdmin@mynet.private” into “mynet.private\OracleServicesAdmin” in the window services for starting listner and database.  After I did this, the service was able to start the database completely and I was able to log into RMAN to conduct backups.

About these ads

Tags: , , , ,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


Follow

Get every new post delivered to your Inbox.

%d bloggers like this: