Home » Infrastructure » Linux » Trouble with restore to another oracle instance (rman - tsm) OS - authentication problem
Trouble with restore to another oracle instance (rman - tsm) OS - authentication problem [message #420573] Mon, 31 August 2009 09:50 Go to next message
enojado
Messages: 3
Registered: August 2009
Junior Member
Hi!

I think I have an authentication problem in my new environment.
I want to restore oracle databases from prod. to a test -environment.
But I got these messages.
Production environment is a cluster, test environment is not a cluster.

Error number1
****************************************

sqlnet.ora-->> : SQLNET.AUTHENTICATION_SERVICES = NONE

$SQLPLUS /NOLOG
SQL> conn sys/password@$oracle_sid as sysdba
ERROR:
ORA-01031: insufficient privileges

Now, I trying to fix problem number1.

Number2
****************************************
sqlnet.ora: -->> SQLNET.AUTHENTICATION_SERVICES = ALL

SQL> SHUTDOWN immediate
ORA-01507: database not mounted
ORACLE instance shut down.

shell$ sqlplus / as sysdba
SQL> conn sys/password@$oracle_sid as sysdba

ERROR:
ORA-12641: Authentication service failed to initialize
Warning: You are no longer connected to ORACLE.

****************



Im here now ! ->>
****************

shell$ sqlplus / as sysdba

SQL> SHUTDOWN immediate

SQL> startup nomount (nomount because of the restore)

SQL> connect sys/password@oracle_sid as sysdba
-->>> ERROR: ORA-12641: Authentication service failed to initialize


AND

****************
Rman connection

SHELL$ rman target sys/password@oracle_sid

Recovery Manager: Release 10.2.0.1.0 - Production on Mon Aug 31 16:11:16 2009

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

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-12641: Authentication service failed to initialize





Regards
Enojado
Re: Trouble with restore to another oracle instance (rman - tsm) OS - authentication problem [message #420582 is a reply to message #420573] Mon, 31 August 2009 11:02 Go to previous messageGo to next message
BlackSwan
Messages: 24912
Registered: January 2009
Senior Member
Post Operating System (OS) name & version for DB server system.
Post results of SELECT * from v$version.

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.
Re: Trouble with restore to another oracle instance (rman - tsm) OS - authentication problem [message #420585 is a reply to message #420573] Mon, 31 August 2009 11:24 Go to previous messageGo to next message
Michel Cadot
Messages: 63807
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-12641: Authentication service failed to initialize
 *Cause:  The authentication service failed during initialization.
 *Action: Enable tracing to determine the exact error.

Regards
Michel
Re: Trouble with restore to another oracle instance (rman - tsm) OS - authentication problem [message #420586 is a reply to message #420573] Mon, 31 August 2009 11:27 Go to previous messageGo to next message
Michel Cadot
Messages: 63807
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
SQLNET.AUTHENTICATION_SERVICES = ALL

SQLNET.AUTHENTICATION_SERVICES = (NTS)

Regards
Michel
Re: Trouble with restore to another oracle instance (rman - tsm) OS - authentication problem [message #420617 is a reply to message #420586] Tue, 01 September 2009 00:11 Go to previous messageGo to next message
enojado
Messages: 3
Registered: August 2009
Junior Member
Thanks for replys!

OS centos 5.2 - Oracle 10.2.0.

When I type the command $id i got this -->
id: uid=502(oracle) gid=504(dba) groups=3(sys),504(dba)

I tried this one too, but i got another authentication error.
SQLNET.AUTHENTICATION_SERVICES = (NTS)


$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Aug 31 17:27:53 2009

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

ERROR:
ORA-01031: insufficient privileges

Enter user-name:

#" this repeats 3 times"




I thinks its something wrong with the users and groups ??
But i dont know.

Regards
Enojado

Re: Trouble with restore to another oracle instance (rman - tsm) OS - authentication problem [message #420622 is a reply to message #420617] Tue, 01 September 2009 00:38 Go to previous messageGo to next message
Michel Cadot
Messages: 63807
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Are you sure 504/dba is the osdba group for the current Oracle home?

Regards
Michel
Re: Trouble with restore to another oracle instance (rman - tsm) OS - authentication problem [message #420633 is a reply to message #420622] Tue, 01 September 2009 01:41 Go to previous message
enojado
Messages: 3
Registered: August 2009
Junior Member
I think I fixed user and group policy. -->

4. Create groups and user for Oracle Installation

In this step, we create "oinstall" and "dba" groups and "oracle" user to install Oracle Software, and create new Database

groupadd oinstall

groupadd dba

useradd -m -g oinstall -G dba -d /home/oracle -s /bin/bash -c "Oracle Software Owner" oracle

passwd oracle

link-> kamranagayev.wordpress.com/2009/05/01/step-by-step-installing-oracle-database-10g-release-2-on-linux-centos-and-automate-the-installa tion-using-linux-shell-script/

$id --> uid=502(oracle) gid=502(oinstall) groups=502(oinstall),503(dba)

I think this is right, but I still got error! ->,

sqlplus / as sysdba

#OK - connectin to a db.

But I have to shutdown immediate and startup nomount because of the restore -->
sql> shutdown immediate
sql> startup nomount
ORACLE instance started.

Total System Global Area 2147483648 bytes
Fixed Size 1220432 bytes
Variable Size 486539440 bytes
Database Buffers 1644167168 bytes
Redo Buffers 15556608 bytes

#Then i trying to connect with
sql>connect sys/password@oracle_sid as sysdba

ERROR:
ORA-12641: Authentication service failed to initialize
Warning: You are no longer connected to ORACLE.


#Trying with RMAN!!
oracle@vswlopora004 admin$ rman target sys/password@oracle_sid

Recovery Manager: Release 10.2.0.1.0 - Production on Tue Sep 1 08:29:20 2009

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

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-12641: Authentication service failed to initialize

Sqlnet.ora ->

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
SQLNET.AUTHENTICATION_SERVICES = ALL

(all - none - nts) trying them all!

Thanks!
Previous Topic: Oracle DBs Migration Windows to Linux
Next Topic: Oracle 10g instalation error
Goto Forum:
  


Current Time: Wed Sep 28 14:15:48 CDT 2016

Total time taken to generate the page: 0.13129 seconds