| RMAN-04015: error setting target database character set to US7ASCII [message #329392] |
Wed, 25 June 2008 05:38  |
sidkolar
Messages: 5
Registered: June 2008
|
Junior Member |
|
|
HI I am getting this error shown below while cloning a QA database using the production one.
even after exporting NLS_LANG and ORA_NLS33
export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
and export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
RMAN-04006: error from auxiliary database: ORA-00604: error occurred at recursive SQL level 1
ORA-01116: error in opening database file 1
ORA-01110: data file 1: '/san/vol2/oradata/disodsdv/system01.dbf'
ORA-27041: unable to open file
SVR4 Error: 2: No such file or directory
Additional information: 3
RMAN-04015: error setting target database character set to US7ASCII
|
|
|
|
|
|
|
|
|
|
| Re: RMAN-04015: error setting target database character set to US7ASCII [message #329424 is a reply to message #329407] |
Wed, 25 June 2008 07:10  |
sidkolar
Messages: 5
Registered: June 2008
|
Junior Member |
|
|
Actually it was listening to 9i listener. But the database has been registered in ORACLE NAMES SERVER. I unregistered it made it use oracle9i listener.
If i do a tnsping its using oracle9i tnsnames.ora file and listener.
TNS Ping Utility for Solaris: Version 9.2.0.6.0 - Production on 25-JUN-2008 08:09:08
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
/apps/oracle/product/9.2/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (description=(address=(protocol=TCP)(host=aries.lvs.dupont.com)(port=1526))(connect_data=(sid=disodsdv)))
OK (0 msec)
Please see the results.
Thanks and regards
Sidh
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
