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;
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-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
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.