cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle Instant Client installation

Former Member
0 Kudos

Hi Friends,

I have restored the SCM5.0 installed on our development server having HP-UX v2 oracle 10.2.0.2. on a test server and which is having HP-UX v3 . Restore has completed successfyl and application is running.

Now I have upgraded Oracle 10.2.0.4 on test server this has been completed but there is problem in instaling Oracle Instant client. When I execute ./runInstaller in /oracle/stage/102_64/client then it is giving message that OS should be HP-UX v2.

From where can I find the oracle instant client for oracle 10.2.0.4 which can be installed on HP-UX 11v3.

Regards

Ganesh Datt Tiwari

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

Good support from all the team

nicholas_chang
Active Contributor
0 Kudos

Hi,

as agreed with Stefan Koehler, download the OCI in SMP and extract it to /oracle/client/10x_64

Ensure OCI path is correctly set in SIDadm environment variable -> .dbenv_Hostname.csh & dbenv_Hostname.sh

if you need to change OCI path due to incorrectly set, perform as below:

1) stopsap (sap & db)

2) stop listener

3) change the correct OCI path

4) as SIDadm, run ldd dboraslib.so and ensure the result returns is point to correct OCI

5) start listener & DB

6) run R3trans -d & check OCI version

7) if everything correct, startsap

Thanks,

Nicholas Chang

Former Member
0 Kudos

Hi Tiwari,

Check the verion of the OS in oraparam.ini file under install directory. If HPv3 exists then comment the line and change it to HPv2

Regards,

Shoeb

stefan_koehler
Active Contributor
0 Kudos

Hello Ganesh,

you don't need the oracle installer for a SAP/Oracle instant client. Just download the SAR file and extract it into the instant client folder. The SAP/Oracle instant client is a "self build mix" of libraries and jdbc drivers by SAP.

Software Downloads -> Support Packages und Patches -> Database Patches -> Oracle -> Oracle 10.2.0.4 -> Instant Client - IC -> HP-UX

For further information check sapnote #819829.

Regards

Stefan

Former Member
0 Kudos

Hi Stefan,

Thanks for your reply.

I have done that but as per below information

jkeccbc>ll

total 32

-rrr-- 1 oradvp dba 112 Oct 6 2010 dbclient.lst

lrwxr-x--- 1 110 sapsys 41 Sep 5 18:03 instantclien

t -> /oracle/client/10x_64/instantclient_10201

drwxrwx--- 2 oradvp dba 8192 May 25 2007 instantclien

t_10201

jkeccbc>pwd

/oracle/client/10x_64

jkeccbc>

There is a link between instantclient and instantclient_10201. I have uncar that SAR file this place and tried to creat link between instantclient and instantclient_10204 but it is not creating.

Please help.

Regards

Ganesh Datt Tiwari

Former Member
0 Kudos

Hello,

First delete the old link to instantclient_10201

Thanks

Former Member
0 Kudos

Hi Friend

Thanks fro your reply.

I am upgrading oracle 11.2.0.2 from oracle 10.2.0.4 and I am getting the error as below.

SQL> SELECT TO_NUMBER('MUST_BE_AS_SYSDBA') FROM DUAL

2 WHERE USER != 'oradvp';

SELECT TO_NUMBER('MUST_BE_AS_SYSDBA') FROM DUAL

*

ERROR at line 1:

ORA-01034: ORACLE not available

SQL> startup upgrade

ORACLE instance started.

Total System Global Area 5855248384 bytes

Fixed Size 2064632 bytes

Variable Size 2936016648 bytes

Database Buffers 2902458368 bytes

Redo Buffers 14708736 bytes

Database mounted.

Database opened.

SQL> SELECT TO_NUMBER('MUST_BE_AS_SYSDBA') FROM DUAL

2 WHERE USER != 'oradvp';

SELECT TO_NUMBER('MUST_BE_AS_SYSDBA') FROM DUAL

*

ERROR at line 1:

ORA-01722: invalid number

SQL> SELECT TO_NUMBER('MUST_BE_11_2') FROM v$instance

2 WHERE substr(version,1,6) != '11.2.0';

SELECT TO_NUMBER('MUST_BE_11_2') FROM v$instance

*

ERROR at line 1:

ORA-01722: invalid number

SQL>

Regards

Ganesh Datt Tiwari

Former Member
0 Kudos

Hello,

Did you execute these queries or these were automatically executed by some script ?

Thanks

Former Member
0 Kudos

HI,

These queries has been executed during the upgrade process.

I have received the error message "Can not Identify the control files."

Regards

Ganesh Datt Tiwari

former_member182034
Active Contributor
0 Kudos

hi Tiwari,

if you have S-user then you can download Oracle client form following link.

"service.sap.com/swdc -> Software downloads -> Database patches -> Oracle

Regards,