Unsolved
This post is more than 5 years old
6 Posts
0
2614
September 19th, 2011 14:00
Unable to add Application Set to replicate an Oracle database RM 5.4
New Replication Manager environment with configuration details as specified below.
We are able to do a file system replication with no problem.
When we attempt to add a new Application Set to replicate an Oracle database, it fails.
The database shows up in the application set wizard. However when we try to set the application login information it fails with an error as follows:
026490 ERROR:Oracle query or command returns error: status:-1 Error code: 12705 Error message: ORA-12705:
Cannot access NLS data files or invalid environment specified
001577 ERROR:Replication Manager could not connect to Oracle because of error 12705. /*e*/
We read the Oracle configuration section of the RM product guide and the EMC RM integration with Oracle white paper and followed all guidelines as far as I can tell.
Also this database uses ASM but the application wizard only shows the Oracle login, there is no place to input the 'sys' user which has the SYSASM and SYSDBA privileges. tnsping alias verifies the listener is up.
Here are the details of our enviornment:
RM server is Windows 2008 R2 64-bit
RM client is AIX 6.1 TL 6
Server and client are RM version 5.4.0.0
Solutions Enabler is version 7.3.0.1.1214
PowerPath 5.3 SP 1
Storage Array is VMAX with Enginuity 5875.139.93
Oracle is 11.2.0.2 with ASM
DMXuser1
6 Posts
0
September 20th, 2011 12:00
Well, we made some progress. It turns out that there was some problem with the install of the RM client files. There were no .nlb files in /opt/emc/rm/client/lib/nls. It looked like the nlsfiles.tar file there was not untarred during the install. So I uninstalled and re-installed the client. Now there are approximately 500 .nlb files in that directory.
After this change, we are able to connect to oracle using the oradba user. This allows you to go to the next step in the application creation, where it prompts for the ASM credentials.
I entered the credentials for the sys user, and it fails with this error:
Sep 20, 2011 2:43:30 PM cmh1vamms03 026490 ERROR: Oracle query or command returns error: status:-1 Error code: 12546 Error message: Error while trying to retrieve text for error ORA-12546.
Sep 20, 2011 2:43:30 PM cmh1vamms03 030215 ERROR: Replication Manager could not connect to the Oracle ASM instance because of error 12,546.
I'm wondering if we need to set the NLS_LANG environment variable for the ASM instance, or if we need to add it to rc.irclient?
DMXuser1
6 Posts
0
September 21st, 2011 06:00
Checked the compatability guide. Oracle ASM 11.1 is listed, but Oracle 11.2.0.2 with ASM is not. Perhaps that is the issue.
JamesBEMC
257 Posts
0
September 21st, 2011 08:00
Glad you found the nls files issue, that was an issue with some downloads due to ascii transfers over binary.
The error you add has not surfaced the actual problem. The errocode on the rm client side did not retrieve an error from the errcode library in rm client.
CAn you make sure the oracle client is set in debug mode please (gui, ora prod client, properties, options, debug).
Then from the rm ora prod client log, try the appset again and grab the errors which line ends in /3* please.
Also check if ORACLE_HOME differs for ASM from Oracle
thanks
J.
DMXuser1
6 Posts
0
September 21st, 2011 11:00
Verified with support that AIX 6.1 Oracle 11.2.0.2 and ASM 11.2.0.2 is currently not supported.
This configuration is expected to be supported in Replication Manager b5.4 SP1 due out in the December 2011 time frame.
Debug logging is enabled. I did not see any lines that ended in /3* but here is the section of the debug log where the error occurs. It appears to be an issue authenticating with ASM.
2011 09 20 16:22:21 (545) main. creating ORA_ASM_LOGON request 1 /*1*/
2011 09 20 16:22:21 (545) main. Added tag ORA_ASM_LOGON /*1*/
2011 09 20 16:22:21 (545) main. Writing buffer size: 56 /*1*/
2011 09 20 16:22:22 (545) main.
UTIL_read_retry: logs:read(): Sleeping for 1 second , interruptedReadCount: 1.. .... /*1*/
2011 09 20 16:22:22 (545) main. Purged request ACK: ACK /*1*/
2011 09 20 16:22:22 (545) main. wrote 56 bytes for the request so far /*1*/
2011 09 20 16:22:22 (545) main. Total bytes of the request 56 /*1*/
2011 09 20 16:22:22 (545) main. request was 2 1 /*1*/
2011 09 20 16:22:22 (545) main. Read from the child: 28 bytes Buffer: 178 : /*1*/
2011 09 20 16:22:22 (545) main. total message size to read is: 178 /*1*/
2011 09 20 16:22:22 (545) main. Writing buffer to ACK: ACK /*1*/
2011 09 20 16:22:23 (545) main.
UTIL_read_retry: logs :read(): Sleeping for 1 second , interruptedReadCount: 1.. .... /*1*/
2011 09 20 16:22:23 (545) main. Read bytes after ACK: 178 /*1*/
2011 09 20 16:22:23 (545) main.
Received from child: 2 12546 status:-1 Error co
de: 12546 Error message: Error while trying to retrieve text for error ORA-12546
/*1*/
2011 09 20 16:22:23 (545) main. Status of command: 12546 /*1*/
2011 09 20 16:22:23 (545) main.
026490 ERROR:Oracle query or command returns error: status:-1 Error code: 12546 Error message: Error while
trying to retrieve text for error ORA-12546
. /*e*/
2011 09 20 16:22:23 (545) main.
Returning from failed call to ORA_CON_I_logonOracleUser with nonzero status /*1*/
2011 09 20 16:22:23 (545) main.
INFO:Replication Manager could not connect to the Oracle ASM instance because of error 12546. /*e*/
2011 09 20 16:22:23 (545) main.
getLastError_event: No message (showApplication) to send to event queue /*1*/
2011 09 20 16:22:23 (545) main. showApplication failed from group agent /*1*/
2011 09 20 16:22:23 (545) main. agent call to showApplication failed /*1*/
JamesBEMC
257 Posts
0
September 22nd, 2011 01:00
What I suspect.
Something in the new version is breaking RM's ability to parse. Looks like you will need to wait for the new release, but you could work with support if extremely urgent to see if a hotfix could be available (if that is possible).
James.