samiuri
Active Newcomer
- Joined
- Apr 10, 2009
- Messages
- 12
- Reaction score
- 1
- Points
- 0
- Location
- Sesto San Giovanni - Milan - Italy
Hello, I need some help about an RMAN error:
On a win2000 oracle server 9.2 - 32 bit - service pack 4 I made an upgrade of tsm client version from the old-one 5.1.5 to the 5.3.6, and of the tdp for oracle version from the 5.2.0 to the 5.3.3.2.
I kept the old dsm.opt and tdpo.opt files and I put them in the new directory AgentOBA; I ran the 'tdpoconf password' and the 'tdpoconf showenv', the result is in the attached file 'showenv.doc'.
Oracle administrator runs this RMAN script, that ends with an error:
RMAN> #
2> #
3> #
4> run {
5> allocate channel t1 type 'sbt_tape' parms
6> 'ENV=(tdpo_optfile=C:\oracle\ora92\scripts\tdpo.opt)';
7> # allocate channel t2 type 'sbt_tape' parms
8> # 'ENV=(tdpo_optfile=C:\oracle\ora92\scripts\tdpo.opt)';
9> sql 'select sysdate from dual';
10>
11> set maxcorrupt for datafile 1 to 0;
12> sql 'alter system archive log current';
13> backup
14> filesperset 20
15> format 'infanzia_arc_logs_%d_%s-%t.bck'
16> (archivelog all delete input );
17> release channel t1;
18> sql 'select sysdate from dual';
19> # release channel t2;
20> }
21>
22> exit
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of allocate command on t1 channel at 05/28/2009 10:47:44
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer
OSD-00612: Message 612 not found; product=RDBMS; facility=SOSD
As you can see, the path of tdpo_optfile is 'tdpo_optfile=C:\oracle\ora92\scripts\tdpo.opt' (I don't know RMAN, but DBA told me the path is right, I put the tdpo.opt in that directory and before the upgrade it was correct...), so I ran again the 'tdpoconf showenv -tdpo_optfile= C:\oracle\ora92\scripts\tdpo.opt', and the result is in the attached file 'showenv_NEW.doc'
The RMAN script continues giving the same error, while the tdpoerror.log gives this error:
05/26/2009:13:30:46 TID<1132> ==> ANU0003S An internal processing error has occurred
05/26/2009:18:29:49 TID<2788> ==> Error: Could not initialize NLS object. Check that the message file, tdpoameng.txt, exists in the TDP for Oracle directory. rc = 612
05/26/2009:18:29:49 TID<2788> ==> ANU0003S An internal processing error has occurred
05/27/2009:13:29:44 TID<560> ==> Error: Could not initialize NLS object. Check that the message file, tdpoameng.txt, exists in the TDP for Oracle directory. rc = 612
05/27/2009:13:29:44 TID<560> ==> ANU0003S An internal processing error has occurred
05/27/2009:18:29:41 TID<1688> ==> Error: Could not initialize NLS object. Check that the message file, tdpoameng.txt, exists in the TDP for Oracle directory. rc = 612
In the API directory there are the two files 'tdpita.txt' and 'tdpenu.txt', anyway I downloaded the 'tdpoameng.txt' from ftp site of IBM and put it both in API than in AgentOBA, but the error remains...
Is it possible that one of client version or tdp version is wrong?
Thank you very much to anyone can help me.
On a win2000 oracle server 9.2 - 32 bit - service pack 4 I made an upgrade of tsm client version from the old-one 5.1.5 to the 5.3.6, and of the tdp for oracle version from the 5.2.0 to the 5.3.3.2.
I kept the old dsm.opt and tdpo.opt files and I put them in the new directory AgentOBA; I ran the 'tdpoconf password' and the 'tdpoconf showenv', the result is in the attached file 'showenv.doc'.
Oracle administrator runs this RMAN script, that ends with an error:
RMAN> #
2> #
3> #
4> run {
5> allocate channel t1 type 'sbt_tape' parms
6> 'ENV=(tdpo_optfile=C:\oracle\ora92\scripts\tdpo.opt)';
7> # allocate channel t2 type 'sbt_tape' parms
8> # 'ENV=(tdpo_optfile=C:\oracle\ora92\scripts\tdpo.opt)';
9> sql 'select sysdate from dual';
10>
11> set maxcorrupt for datafile 1 to 0;
12> sql 'alter system archive log current';
13> backup
14> filesperset 20
15> format 'infanzia_arc_logs_%d_%s-%t.bck'
16> (archivelog all delete input );
17> release channel t1;
18> sql 'select sysdate from dual';
19> # release channel t2;
20> }
21>
22> exit
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of allocate command on t1 channel at 05/28/2009 10:47:44
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer
OSD-00612: Message 612 not found; product=RDBMS; facility=SOSD
As you can see, the path of tdpo_optfile is 'tdpo_optfile=C:\oracle\ora92\scripts\tdpo.opt' (I don't know RMAN, but DBA told me the path is right, I put the tdpo.opt in that directory and before the upgrade it was correct...), so I ran again the 'tdpoconf showenv -tdpo_optfile= C:\oracle\ora92\scripts\tdpo.opt', and the result is in the attached file 'showenv_NEW.doc'
The RMAN script continues giving the same error, while the tdpoerror.log gives this error:
05/26/2009:13:30:46 TID<1132> ==> ANU0003S An internal processing error has occurred
05/26/2009:18:29:49 TID<2788> ==> Error: Could not initialize NLS object. Check that the message file, tdpoameng.txt, exists in the TDP for Oracle directory. rc = 612
05/26/2009:18:29:49 TID<2788> ==> ANU0003S An internal processing error has occurred
05/27/2009:13:29:44 TID<560> ==> Error: Could not initialize NLS object. Check that the message file, tdpoameng.txt, exists in the TDP for Oracle directory. rc = 612
05/27/2009:13:29:44 TID<560> ==> ANU0003S An internal processing error has occurred
05/27/2009:18:29:41 TID<1688> ==> Error: Could not initialize NLS object. Check that the message file, tdpoameng.txt, exists in the TDP for Oracle directory. rc = 612
In the API directory there are the two files 'tdpita.txt' and 'tdpenu.txt', anyway I downloaded the 'tdpoameng.txt' from ftp site of IBM and put it both in API than in AgentOBA, but the error remains...
Is it possible that one of client version or tdp version is wrong?
Thank you very much to anyone can help me.