OraFAQ Forum: Linux » Trouble with restore to another oracle instance (rman - tsm) OS

Home » Infrastructure » Linux » Trouble with restore to another oracle instance (rman - tsm) OS - authentication problem

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Trouble with restore to another oracle instance (rman - tsm) OS - authentication problem [message #420573]

Mon, 31 August 2009 09:50

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

Report message to a moderator

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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.

Report message to a moderator

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

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

SQLNET.AUTHENTICATION_SERVICES = ALL

SQLNET.AUTHENTICATION_SERVICES = (NTS)

Regards
Michel

Report message to a moderator

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

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

Report message to a moderator

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

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Are you sure 504/dba is the osdba group for the current Oracle home?

Regards
Michel

Report message to a moderator

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

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!

Report message to a moderator

Previous Topic:	Oracle DBs Migration Windows to Linux
Next Topic:	Oracle 10g instalation error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 12 07:14:49 CST 2024