ADSM-L
[Top] [All Lists]
<prev [Date] next>
[Advanced]
 <prev [Thread] next>

Re: Password file for TDP Oracle on Windows platform

2003-04-07 10:56:46
Subject: Re: Password file for TDP Oracle on Windows platform
From: Bill Boyer <bill.boyer AT VERIZON DOT NET>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 7 Apr 2003 10:55:58 -0400 
The DSM.OPT file to use is specified in the TDP for Oracle options file
(TDPO.OPT) as the DSMI_ORC_CONFIG parameter. You will need to set up
different TDPO.OPT files for the different nodes. You then specify the
TDPO_OPTFILE parameter on the ALLOCATE CHANNEL in RMAN and on the TDPOCONF
command to set the password. I have this running and I use a naming scheme
of

TDPO_<instance>.OPT which points to DSM_<instance>.OPT file.

Bill Boyer
"I haven't lost my mind -- it's backed up on tape somewhere." - ???

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Ameerul Mazli
Sent: Monday, April 07, 2003 12:46 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Password file for TDP Oracle on Windows platform


Hi Neil,

If both nodes (oracle nodes) is referring to the
dsm.opt in the TSM API director, how do you
differentiate the dsm.opt in the TSM API if there are
2 oracle instances (excluding the ba client instance)?
one is tdpo_ori.opt, the other is tdpo_sun.opt.

Thanks and regards
Ameerul

--- Neil Rasmussen <rasmussn AT us.ibm DOT com> wrote:
> 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).
> >
> >
>
=== message truncated ===


__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more
http://tax.yahoo.com
[More with this subject...]
<Prev in Thread] Current Thread [Next in Thread>
Previous by Date:  Re: Turning collocation off?, Andrew Raibeck
Next by Date:  Server upgrade hung, Thomas Denier
Previous by Thread:  Re: Password file for TDP Oracle on Windows platform, Gagan Singh Rana
Next by Thread:  Library sharing setup problem, Jozef Zatko
Indexes:  [Date] [Thread] [Top] [All Lists]