topic Re: ORA-12547 when copying from 32-bit to 64-bit in Operating System - HP-UX

ORA-12547 when copying from 32-bit to 64-bit

Ashraf_1 — Mon, 13 Oct 2003 08:28:46 GMT

Hi All,

I copied sap (3.0f)/oracle (7.3.3.4) database from H50 (hp-ux 10.20:32-bit) to L-Class (hp-ux 11.0:64bit) via sam fbackup and then relinked all oracle executable and done all the required modification. When i issue svrmgrl i got the following error:
yanpetdb:orayp1ï 1>ï svrmgrl

Oracleï Serverï Managerï Releaseï 2.3.4.0.0ï -ï Production

Copyrightï (c)ï Oracleï Corporationï 1994,ï 1995.ï Allï rightsï reserved.

ORA-12547:ï TNS:lostï contact
SVRMGR>ï

Anybody knows how to resolve this issue? And can oracle 7.3.4 be inst

Re: ORA-12547 when copying from 32-bit to 64-bit

Steven E. Protter — Mon, 13 Oct 2003 08:31:53 GMT

Have you run the 32 bit to 64 bit word conversion process?

I'm attaching it.

SEP

Re: ORA-12547 when copying from 32-bit to 64-bit

Massimo Bianchi — Mon, 13 Oct 2003 08:32:41 GMT

Hi,
AFAIK you should not have relinked.
I never succeded in installink 7.3.4 on a 11, i always copied the executable and they worked.

Did you already tried it ? Much simpler...

Massimo

Re: ORA-12547 when copying from 32-bit to 64-bit

Ashraf_1 — Mon, 13 Oct 2003 09:26:48 GMT

Thanks All,

Stephen i hadn't tried yours.

Massimo: could you please advice me on what i missed in my procedure,
1. I used fbackup preserving the same ownership as the source machine and copied the following directories:
/oracle/
/usr/sap/
/sapmnt/
/home/ora
/home/adm
and then frecover them into the target machine.
2. rename the following according the new server hostname:
/oracle//dbs/.dbenv_.csh
/oracle/ /dbs/.dbenv_.sh
/home//startsap__00.
/home//stopsap__00
/home//.dbenv_.csh
/home//.dbenv_.csh
/sapmnt//profile/_DVEMGS00_
/sapmnt//profile/START_ DVEMGS00_
/sapmnt//profile/DEFAULT.PFL
edit
/usr/sap/trans/tnsnames.ora
/usr/sap/trans/listener.ora

3. Relink all oracle executable with:
cd $ORACLE_HOME/rdbms
make â f ins_rdbms.mk install
4. start svrmgrl and got ora-12547 error.

Appreciate your assisstant,
Ashr

Re: ORA-12547 when copying from 32-bit to 64-bit

Massimo Bianchi — Mon, 13 Oct 2003 09:36:50 GMT

As mentioned, i would have missed the

3. Relink all oracle executable with:
cd $ORACLE_HOME/rdbms
make Ã¢Â Â f ins_rdbms.mk install

Then:

I would also check:

/etc/*.ora

old versions used listener.ora and tnsnames.ora also in /etc

TNS_ADMIN maybe it pointed somewhere else, like /usr/sap/trans, but you alredy copied it.

- MLOCK privilege to dba group
- /dev/async existance and ownership

After copyinf the oracle executable, did you still have the error ?

M

Re: ORA-12547 when copying from 32-bit to 64-bit

Ashraf_1 — Mon, 13 Oct 2003 11:29:18 GMT

Hi massimo,

I set the dba group to MLOCK. unfurtantely, no change. The listener can startup but the server manager not. Note: i don't have /dev/async file and this server have a delete oracle 817 installation. will that affect ==> i delete all /oracle/* with rm -rf /oracle/.

Thank you,
Ashraf

Re: ORA-12547 when copying from 32-bit to 64-bit

Steven E. Protter — Mon, 13 Oct 2003 11:40:48 GMT

Your migration procedure is unsupported by oracle. You MUST do a word size conversion to properly operate the database on a 64 bit OS.

With all respect, copying the binaries will probably get the database binaries to work, but it will not sovle the fundamental problem with the data that is generating the error.

We got the very same error code with a migration of an oracle 8.1.7.0.0 database (32 bit HP-UX 11.00) to 8.1.7.4.0 HP-UX 11.11 64 bit.

We fixed the problem by following the procedure I attached to my first post.

These posts are the result of substantive hours dealing with the problem.

Obviously you are free to do what you'd like, but I think I've provided at least a solid path of investigation if not a solution.

I now return you to your regular foruming.

SEP

Re: ORA-12547 when copying from 32-bit to 64-bit

Charles Armstrong — Wed, 05 Nov 2003 16:40:34 GMT

You need to get the Oracle 7.3.3 32 bit binaries for HP-UX 11, install them on your HP-UX 11 64 bit machine. You have copied the datafiles, log files, and control files. You may need to modify your tnsnames.ora file to reference the database on your new machine, since it probably has a different hostname and/or IP address than the HP-UX 10.20 machine. You should not copy the Oracle 7.3 binaries for HP-UX 10.20 to the HP-UX 11.0 machine, as they are not compatible. You may also need to ensure that your SHMMAX and other shared memory kernel parameters are set according to Oracle's recommendations. Also, another thing to look at is the amount of swap space allocated. You need at least two times the actual physical memory allocated to swap space, as I experienced several TNS errors, including this one, that was finally tracked down to this cause. We experienced this problem intermittently when we upgraded an Oracle 8.0.6 32 bit database on HP-UX 11i 64 bit to Oracle 8.1.7 64 bit, and once we added the necessary swap space, those errors disappeared.

Re: ORA-12547 when copying from 32-bit to 64-bit

Ashraf_1 — Thu, 06 Nov 2003 03:05:35 GMT

Thanks all,

Armstrong Answer was the one i used. I copied all SAP/Oracle files from the following directories:
/sapmnt
/oracle
/usr/sap
Then removed the old oracle 7.3.4 version and install oracle 7.3.4 version for Hp-ux 11. update listenerr.ora, using ./NETV2.

Unfortunately the word conversion is not supported in oracle 7.3.4 version so it was very difficult to use. However, it was an excellent suggestion.
Now this application is working fine in the new server.

Thanks for all gotten responses.

Regards,
Ashraf

Re: ORA-12547 when copying from 32-bit to 64-bit

zhuchao — Wed, 12 Nov 2003 07:27:14 GMT

I am just an oracle guy and I only say about Oracle.
For your database migration, just install the same 32bit Oracle 7.3 on the new hpux and copy your database to new server.
Install old oracle executable on new hp is supported by hp.Tune the kernel os parameter and make changes necessary.
Then just do:
svrmgrl
connect internal
startup

You got the error has nothing to do with word size, as svrmgrl itself gives out error. It still has not try to startup instance/mount controlfile/open database.

DO a fresh install of 7.3 first.

Re: ORA-12547 when copying from 32-bit to 64-bit

Ashraf_1 — Sat, 15 Nov 2003 02:15:21 GMT

Hi zhuchao,

You are 100% right.

This the actual prcess i tried.

With Best regards,
Ashraf