Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

ora-12547 when upgrade to hp-ux 64bit

Jason Shao
Occasional Visitor

ora-12547 when upgrade to hp-ux 64bit

Hello,

I have read previous aricles like Rita.

I have relinked all libraries as Rita's suggestion. But ora-12547 still occured.

The database was running on K580 HP-UX 11.0 32 bits. I migrated database to N4000 11.0 64 bits yesterday. I cpied all oracle disectories to N4000 disks. I also relinked all libraries. But ora-12547 still occured.

In HP-UX 64 bits environment, my Oracle is still 32 bits. Which places do I need to mention?

Could someone help me?

8 REPLIES
harry d brown jr
Honored Contributor

Re: ora-12547 when upgrade to hp-ux 64bit

Although you should upgrade oracle to the 64 bit version, you might be able to use one of Rita's other answers:

http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x5400a22d6d27d5118fef0090279cd0f9,00.html

http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x61c153921f1ad5118fef0090279cd0f9,00.html

http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x9bccd06ed8c8d4118fef0090279cd0f9,00.html

and most point to patch PHSS_24303.

Then go to search, select patches and 11.00 and enter in the string "oracle" for other patches that might apply.

live free or die
harry
Live Free or Die
Jason Shao
Occasional Visitor

Re: ora-12547 when upgrade to hp-ux 64bit

Thanks very much for Berlene,

But unfortunately, it did not work.

I have installed patch PHSS_24303 which replaced PHSS_22514 and followed your suggestion to relink all libraries.
I did not have permission denied message. When I execute svrmgrl, only ora-12547 log displayed.
Oracle_SID is exported correctly.
DNS setup is ok.

But ora-12547 still occured.

Do you have another idea for me?

harry d brown jr
Honored Contributor

Re: ora-12547 when upgrade to hp-ux 64bit

This could describe your problem
http://www.orafaq.com/msgboard/sqlnet/messages/569.htm

and this could be your solution:
http://www.orafaq.com/msgboard/sqlnet/messages/1216.htm


Can you connect via:
sqlplus userid/password@tns_alias


live free or die
harry
Live Free or Die
Jason Shao
Occasional Visitor

Re: ora-12547 when upgrade to hp-ux 64bit

Thank you for your quick response. you are so kind.

I have read your suggested articles,but my problem is not similiar. The migrated directory was the same.


I tried to execute sqlplus userid/password@tns_alias. There was a new error message ora-12500. As oerr, TNS: lstener failed to start a dedicated server process.

My exported environment parameters are following:

NLS_LANG=American_America.ZHT16BIG5
ORATERMPATH=/ora1/oracle/ora734/forms30/admin/resource
ORAKITPATH=.
ORACLE_SID=acct
ORACLE_DOC=/ora1/oracle/ora734/doc
TNS_ADMIN=/ora1/oracle/ora734/network
ORACLE_SERVER=
LD_LIBRARY_PATH=/ora1/oracle/ora734/lib
ORACLE_HOME=/ora1/oracle/ora734
TZ=EAT-8
MENU5PATH=/ora1/oracle/ora734/forms30/admin/resource
harry d brown jr
Honored Contributor

Re: ora-12547 when upgrade to hp-ux 64bit

I'm out of my league here. You might be able to "install" oracle to "fix" it? Hopefully you can wait til Rita chimes in, but that might not be til monday. You might want to place a call to oracle, or try an oracle users web site. Good luck!


live free or die
harry
Live Free or Die
Jason Shao
Occasional Visitor

Re: ora-12547 when upgrade to hp-ux 64bit

Anyway, thanks very much.

I will call Oracle for more support.
Jack Fan
Regular Advisor

Re: ora-12547 when upgrade to hp-ux 64bit

You may try to this solution,

Problem:
========

You have just finished relinking a 64-bit version of Oracle8 or Oracle8i on
HP-UX 11.00 64-bit. This might be after a fresh installation, or after applying
an Oracle or HP-UX patch(set). When attempting to use SVRMGRL or SQL*PLUS, the
following error messages are displayed:

sh: /u01/app/oracle/product/8.1.7/bin/oracle: Execute permission denied.
sh: /u01/app/oracle/product/8.1.7/bin/oracle: Execute permission denied.

ORA-12547: TNS:lost contact

Executing the Oracle executable by itself also fails with a similar error:

% ./oracle
/usr/bin/sh: ./oracle: Execute permission denied.

You may see the following relinking error in the make.log file:

ld: Error at line 0 : error in writing to output file. (7204)
Stop.
*** Error exit code 254


Solution:
=========

Install HP-UX linker tools cumulative patch PHSS_22514 or later.

After you install this patch, all of the Oracle executables need to be relinked:

For Oracle8i:

1) Change to the "bin" directory:

% cd $ORACLE_HOME/bin

2) Use the "relink" utility with the "all" argument:

% relink all

3) Use the "relink" utility with the "utilities" argument:

% relink utilities

4) Change to the "sqlplus/lib" directory:

% cd $ORACLE_HOME/sqlplus/lib

5) Use the "make" command to relink "sqlplus":

% make -f ins_sqlplus.mk install

For Oracle8:

1) Change to the "rdbms/lib" directory:

% cd $ORACLE_HOME/rdbms/lib

2) Use the "make" command to relink the RDBMS:

% make -f ins_rdbms.mk install

3) Change to the "sqlplus/lib" directory:

% cd $ORACLE_HOME/sqlplus/lib

4) Use the "make" command to relink sqlplus:

% make -f ins_sqlplus.mk install

5) Change to the "network/lib" directory:

% cd $ORACLE_HOME/network/lib

6) Use the "make" command to relink the Intelligent Agent:

% make -f ins_agent.mk install

7) Use the "make" command to relink Net8:

% make -f ins_network.mk install
Jason Shao
Occasional Visitor

Re: ora-12547 when upgrade to hp-ux 64bit

After I reinstalled Oracle 7.3.4 RDBMS from CDROM, the svrmgrl and sqlplus are workable.

Thanks a lot,