Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

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

SOLVED
Go to solution
Ashraf_1
Frequent Advisor

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

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
ASHRAFM
10 REPLIES
Steven E. Protter
Exalted Contributor

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

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

I'm attaching it.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Massimo Bianchi
Honored Contributor

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

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

Ashraf_1
Frequent Advisor

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

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
ASHRAFM
Massimo Bianchi
Honored Contributor

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

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
Ashraf_1
Frequent Advisor

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

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
ASHRAFM
Steven E. Protter
Exalted Contributor

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


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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Charles Armstrong
Occasional Visitor
Solution

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

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.
Ashraf_1
Frequent Advisor

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

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
ASHRAFM
zhuchao
Advisor

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

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.
www.happyit.net
Ashraf_1
Frequent Advisor

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

Hi zhuchao,

You are 100% right.

This the actual prcess i tried.

With Best regards,
Ashraf
ASHRAFM