on 09-08-2011 11:02 AM
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
Good support from all the team
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.