Re: Password file for TDP Oracle on Windows platform

Amreeul

U may specify the opt file using the parameter tdpo_optfile when giving 
password.

Thanks and regards
Gagan Singh Rana

"Ability is what you're capable of doing...
Motivation determines what you do...
Attitude determines how well you do it. "

the Business Enterprise Solutions Team

QuantM Systems Pvt. Ltd.
79 Amrit Nagar, NDSE Part I
New Delhi - 110003

Voice : 91-11-4691575/4602217
Fax    : 91-11-4691188
Hand Phone : 91-9868091938

DISCLAIMER :
The information in this e-mail is confidential and may be legally privileged. 
It is
intended SOLELY for the addressee. Access to this e-mail by anyone else is 
unauthorized.
If you are NOT the intended recipient, any disclosure, copying, distribution or 
any action
taken on it is prohibited and may be unlawful. Any opinions or advice contained 
in this
e-mail are subject to the terms and conditions expressed in the governing client
relationship engagement letter.
______________________________________________________________
Visit us at www.quantm.com



----- Original Message -----
From: "Ameerul Mazli" <ameerul_msb AT YAHOO DOT COM>
To: <ADSM-L AT VM.MARIST DOT EDU>
Sent: Monday, April 07, 2003 10:16 AM
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
>
>