The following error occur when migrating certain Oracle Applications Objects - XML templates:
java.sql.SQLException: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
This only applies to Oracle Ebiz on RAC:
1. Go to Maintenance | General | Oracle applications connect
2. Locate the column called use tns and check this option
3. Locate the column called tns entry and enter the tns entry. The format should be on the same line with no carriage return. See example below:
(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = alv1.test.com)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = Alv2.test.com)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = Alv3.test.com)(PORT = 1521))(LOAD_BALANCE = no)(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = st564)))
4. Hold down to Ctrl key to select multiple Ebiz dbs to do test connection. Make sure the test connection is successful for the client and agent,
5. Bounce the stat oa (oracle ebiz agent)
