Hi Neil,
I did try the passwordaccess generate option for the
tdp oracle node but it gave me the error in rman:
----------------
:\Program Files\Tivoli\TSM\AgentOBA>rman target
"sys/password@orihrm" rcvcat "r
man/rman@orihrm"
Recovery Manager: Release 8.1.7.0.0 - Production
RMAN-06005: connected to target database: ORIHRM
(DBID=3027765092)
RMAN-06008: connected to recovery catalog database
RMAN> run
2> {
3> allocate channel t1 type 'sbt_tape' parms
4>
'ENV=(TDPO_OPTFILE=C:\progra~1\Tivoli\TSM\AgentOBA\tdpo_ori.opt)';
5> backup
6> full
7> filesperset 5
8> format 'df_%t_%s_%p'
9> (database);
10> release channel t1;
11> }
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: t1
RMAN-08500: channel t1: sid=13 devtype=SBT_TAPE
RMAN-08526: channel t1: Tivoli Data Protection for
Oracle: version 2.2.1.0
RMAN-03022: compiling command: backup
RMAN-03023: executing command: backup
RMAN-08008: channel t1: starting full datafile
backupset
RMAN-08502: set_count=74 set_stamp=489701281
creation_time=26-MAR-03
RMAN-08010: channel t1: specifying datafile(s) in
backupset
RMAN-08522: input datafile fno=00001
name=D:\ORACLE\ORADATA\ORIHRM\SYSTEM01.DBF
RMAN-08011: including current controlfile in backupset
RMAN-08522: input datafile fno=00003
name=D:\ORACLE\ORADATA\ORIHRM\USERS01.DBF
RMAN-08522: input datafile fno=00007
name=D:\ORACLE\ORADATA\ORIHRM\DR01.DBF
RMAN-08522: input datafile fno=00004
name=D:\ORACLE\ORADATA\ORIHRM\TEMP01.DBF
RMAN-00571:
===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK
FOLLOWS ===============
RMAN-00571:
===========================================================
RMAN-03007: retryable error occurred during execution
of command: backup
RMAN-07004: unhandled exception during command
execution on channel t1
RMAN-10035: exception raised in RPC: ORA-19506: failed
to create sequential file
, name="df_489701281_74_1", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: ANS0237E (RC2033) On dsmInit, the node is
not allowed when PASSWORDAC
CESS=generate.
RMAN-10031: ORA-19624 occurred during call to
DBMS_BACKUP_RESTORE.BACKUPPIECECRE
ATE
------------------
When i change it back to password access prompt, it
will give the "authentication failure" message as
bellow:
------------
RMAN> run
2> {
3> allocate channel t1 type 'sbt_tape' parms
4>
'ENV=(TDPO_OPTFILE=C:\progra~1\Tivoli\TSM\AgentOBA\tdpo_ori.opt)';
5> backup
6> full
7> filesperset 5
8> format 'df_%t_%s_%p'
9> (database);
10> release channel t1;
11> }
RMAN-08031: released channel: t1
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: t1
RMAN-08500: channel t1: sid=13 devtype=SBT_TAPE
RMAN-08526: channel t1: Tivoli Data Protection for
Oracle: version 2.2.1.0
RMAN-03022: compiling command: backup
RMAN-03023: executing command: backup
RMAN-08008: channel t1: starting full datafile
backupset
RMAN-08502: set_count=75 set_stamp=489701478
creation_time=26-MAR-03
RMAN-08010: channel t1: specifying datafile(s) in
backupset
RMAN-08522: input datafile fno=00001
name=D:\ORACLE\ORADATA\ORIHRM\SYSTEM01.DBF
RMAN-08011: including current controlfile in backupset
RMAN-08522: input datafile fno=00003
name=D:\ORACLE\ORADATA\ORIHRM\USERS01.DBF
RMAN-08522: input datafile fno=00007
name=D:\ORACLE\ORADATA\ORIHRM\DR01.DBF
RMAN-08522: input datafile fno=00004
name=D:\ORACLE\ORADATA\ORIHRM\TEMP01.DBF
RMAN-00571:
===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK
FOLLOWS ===============
RMAN-00571:
===========================================================
RMAN-03007: retryable error occurred during execution
of command: backup
RMAN-07004: unhandled exception during command
execution on channel t1
RMAN-10035: exception raised in RPC: ORA-19506: failed
to create sequential file
, name="df_489701478_75_1", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: ANS1025E (RC137) Session rejected:
Authentication failure
RMAN-10031: ORA-19624 occurred during call to
DBMS_BACKUP_RESTORE.BACKUPPIECECRE
ATE
------------
I even uninstall both BA client and TDP Oracle but
same errors occur.
Pls help me here.
Thx and regards
Ameerul
--- Neil Rasmussen <rasmussn AT us.ibm DOT com> wrote:
> Password generation is related to the node name, so
> there will only be two
> passwords if you are using two different node names
> for each TDP Oracle
> instance (which I hope you are).
>
>
> Regards,
>
> Neil Rasmussen
> Software Development
> TDP for Oracle
> rasmussn AT us.ibm DOT com
>
>
>
>
>
> Ameerul Mazli <ameerul_msb AT yahoo DOT com>
> 03/24/2003 10:26 PM
>
>
> To: ADSM-L AT VM.MARIST DOT EDU
> cc: Neil Rasmussen/San Jose/IBM@IBMUS
> Subject: Re: Password file for TDP
> Oracle on Windows platform
>
>
>
> Hi Neil,
> What if there are 2 instances of Oracle? Will there
> be
> 2 password in the registry too?
>
> Thanks and regards
> Ameerul Madzali
>
> Forwarded Message
> Date: Mon, 24 Mar 2003 08:36:29 -0800
> From: "Neil Rasmussen" <rasmussn AT US.IBM DOT COM>
> Subject: Re: Password file for TDP Oracle on Windows
> platform
>
> Ameerul,
>
> On Windows TDP Oracle uses password access generate.
> Therefore, the
> password is encrypted and stored in the registry.
> Have
> you generated a
> password before? In your dsm.opt file makesure that
> passwordaccess is
> set
> to generate and use 'tdpoconf passw' to create a
> password in the
> registry.
> Hope this helps.
>
>
----------------------------------------------------------------------
>
> Date: Sun, 23 Mar 2003 17:53:40 -0800
> From: Ameerul Mazli <ameerul_msb AT YAHOO DOT COM>
> Subject: Password file for TDP Oracle on Windows
> platform
>
> Hi All,
> Does anyone know where or what is the password file
> name if you have TDP Oracle on a Windows platform?
>
> 1. I know for Solaris, it will create a file called
> TDPO.nodename in the TDPO_PSWDPATH directory. What
> abt
> Windows NT/2000?
>
> 2. The thing is I've an error "authentication
> failure"
> when i do the tdpoconf showenv.
>
> Pls help me with the above. Thx in advance.
>
> Ameerul
>
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Platinum - Watch CBS' NCAA March Madness,
> live on your desktop!
> http://platinum.yahoo.com
>
>
>
__________________________________________________
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
|
