ADSM-L

Re: Password file for TDP Oracle on Windows platform

2003-03-28 10:44:08
Subject: Re: Password file for TDP Oracle on Windows platform
From: Neil Rasmussen <rasmussn AT US.IBM DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 28 Mar 2003 07:43:38 -0800
Try generating your password first with 'tdpoconf passw 
-tdpo_optfile=C:\progra~1\Tivoli\TSM\AgentOBA\tdpo_ori.opt'. You should really 
read the manual on password generation it should
explain all the particulars about Windows and using
passwordaccess=generate. Also, pay attention to the section about using
the utilities like 'tdpoconf'.

>From the error I see below, though, I am just going to guess that you set
TDPO_NODE in your tdpo_ori.opt file. The only nodename that you should set
is in your TSM API dsm.opt file. Hope this helps.


Regards,

Neil Rasmussen
Software Development
TDP for Oracle
rasmussn AT us.ibm DOT com





Ameerul Mazli <ameerul_msb AT yahoo DOT com>
03/27/2003 05:19 PM


        To:     Neil Rasmussen/San Jose/IBM@IBMUS
        cc:     ADSM-L AT VM.MARIST DOT EDU
        Subject:        Re: Password file for TDP Oracle on Windows platform



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