RE: rman resisterring target

Tom,
Actually, I set up new tnsnames definitions on the W2000 machine to various unix DBs and got
'ORA-12705: invalid or unknown NLS parameter value specified '

The W2000 set-up is lang/region/characterset AMERICAN_AMERICA.WE9ISO8859P1 and all unix DBs are AMERICAN_AMERICA.US7ASCII

I haven't had to concentrate on NT much before (hurray!) but I may have to now (bah!). I've also only ever had AMERICAN_AMERICA.US7ASCII set. This NLS stuff seems to be a bit of a black art! Anyone know of any docs that explain the interaction of differing settings between databases?

• Mike ..Looking forward to the annual Beer festival tomorrow, held in the same building I work in !...

Mike Jenner
Database Administrator

-----Original Message-----
Sent: 20 June 2002 12:47
To: 'ORACLE-L_at_fatcity.com'
Cc: 'M.Jenner_at_southampton.gov.uk'

Mike,

It looks like you are using Rman from the Unix box. Try using Rman from your NT box - run Rman from NT and see what happens.

Hope this helps.

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
Sent: Thursday, June 20, 2002 7:33 AM
To: Multiple recipients of list ORACLE-L

OK, When I can't find what I want in the docs, I usually give Metaling a try. Unfortunately their suggestions for this have made me give up.. Has anyone here come accross this one before?

I have an RMAN catalog on solaris 2.7, oracle 8.1.7.2. I would like to use it to catalog backups for a database on NT (w2k) oracle 8.1.7.0.
The problem seems to be a characterset mismatch between the catalog and the target.

Unix environment and catalog database is AMERICAN_AMERICA.US7ASCII, target database is AMERICAN_AMERICA.WE9ISO8859P1.

>rman catalog rman/pw_at_db_a
 

Recovery Manager: Release 8.1.7.2.0 - Production  

RMAN-06008: connected to recovery catalog database  

RMAN> connect target sys/pw_at_db_b  

RMAN-06005: connected to target database: db_b (DBID=2132931294)  

RMAN> register database;  

RMAN-03022: compiling command: register

RMAN-03023: executing command: register

RMAN-03026: error recovery releasing channel resources

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-07005: error during channel cleanup

RMAN-07004: unhandled exception during command execution on channel default

RMAN-10032: unhandled exception during execution of job step 1: ORA-12703: this
character set conversion is not supported

RMAN-10031: ORA-12703 occurred during call to DBMS_BACKUP_RESTORE.DEVICESTATUS
RMAN-03006: non-retryable error occurred during execution of command: register
RMAN-07004: unhandled exception during command execution on channel default

RMAN-20002: target database already registered in recovery catalog                                                                         

Mike Jenner
Database Administrator

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jenner Mike
  INET: M.Jenner_at_southampton.gov.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jenner Mike
  INET: M.Jenner_at_southampton.gov.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).