- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: ORA-12547 when copying from 32-bit to 64-bit
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-13-2003 01:28 AM
тАО10-13-2003 01:28 AM
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-13-2003 01:31 AM
тАО10-13-2003 01:31 AM
Re: ORA-12547 when copying from 32-bit to 64-bit
I'm attaching it.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-13-2003 01:32 AM
тАО10-13-2003 01:32 AM
Re: ORA-12547 when copying from 32-bit to 64-bit
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-13-2003 02:26 AM
тАО10-13-2003 02:26 AM
Re: ORA-12547 when copying from 32-bit to 64-bit
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/
and then frecover them into the target machine.
2. rename the following according the new server hostname:
/oracle/
/oracle/
/home/
/home/
/home/
/home/
/sapmnt/
/sapmnt/
/sapmnt/
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-13-2003 02:36 AM
тАО10-13-2003 02:36 AM
Re: ORA-12547 when copying from 32-bit to 64-bit
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-13-2003 04:29 AM
тАО10-13-2003 04:29 AM
Re: ORA-12547 when copying from 32-bit to 64-bit
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-13-2003 04:40 AM
тАО10-13-2003 04:40 AM
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
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-05-2003 08:40 AM
тАО11-05-2003 08:40 AM
Solution- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-05-2003 07:05 PM
тАО11-05-2003 07:05 PM
Re: ORA-12547 when copying from 32-bit to 64-bit
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-11-2003 11:27 PM
тАО11-11-2003 11:27 PM
Re: ORA-12547 when copying from 32-bit to 64-bit
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.