HP-UX 11.31 install 4.6C issue

[Former Member]

Hi Experts

Here is a strange issue regarding the R/3 4.6C installation on HP-UX 11.31, Oracle: 9.2.0.0;

After I finished the Oracle 9.2.0.0 installation, I try to installation the patch, patch 9.2.0.6 only supports HP-UX 11.11;

So, I canceled the patch installation and restarted the "./R3SETUP -f CENTRAL.R3S" process,

then I got the following error message:

===========

INFO 2010-03-31 21:50:57

Creating the Database User

SQL*Plus: Release 9.2.0.1.0 - Production on Wed Mar 31 21:50:58 2010

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected.

old 6: if length('&&1') = 5 then

new 6: if length('SAPR3') = 5 then

old 7: if substr(upper('&&1'),1,5) = 'SAPR3' then

new 7: if substr(upper('SAPR3'),1,5) = 'SAPR3' then

old 10: if upper('&&2') = 'NT' then

new 10: if upper('UNIX') = 'NT' then

old 17: :sDomain := upper('&&3');

new 17: :sDomain := upper('T50');

old 18: :sSapSid := upper('&&4');

new 18: :sSapSid := upper('x');

old 20: :sSapSid := upper('&&3');

new 20: :sSapSid := upper('T50');

old 36: :sSchema := upper('&&1');

new 36: :sSchema := upper('SAPR3');

old 37: if upper('&&2') = 'NT' then

new 37: if upper('UNIX') = 'NT' then

old 44: :sDomain := upper('&&3');

new 44: :sDomain := upper('T50');

old 45: :sSapSid := upper('&&4');

new 45: :sSapSid := upper('x');

old 47: :sSapSid := upper('&&3');

new 47: :sSapSid := upper('T50');

begin

*

ERROR at line 1:

ORA-01219: database not open: queries allowed on fixed tables/views only

Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production

With the Partitioning and Oracle Data Mining options

JServer Release 9.2.0.1.0 - Production

ERROR 2010-03-31 21:50:58 ORADBUSR_IND_ORA ExecuteCheck:0

Exit code from /oracle/T50/920_64/bin/sqlplus: 195.

ERROR 2010-03-31 21:50:58 ORADBUSR_IND_ORA InternalInstallationDo:0

Phase failed.

ERROR 2010-03-31 21:50:58 ORADBUSR_IND_ORA InstallationDo:0

Phase failed.

ERROR 2010-03-31 21:50:59 Main

Installation aborted.

=================

I have checked the listner and database status via "sqlplus /nolog -> connect /as sysdba -> startup",

Information as following:

=========

SQL> conn /as sysdba;

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 1977765272 bytes

Fixed Size 736664 bytes

Variable Size 855638016 bytes

Database Buffers 1120067584 bytes

Redo Buffers 1323008 bytes

ORA-00205: error in identifying controlfile, check alert log for more info

============

Could somebody give me some suggestions?

Many thanks.

Charles

[former_member204746 · Accepted solution]

*ORA-00205: error in identifying controlfile, check alert log for more info ============ *

maybe you should have a look at the alert log.

it should be located in /oracle/T50/saptrace/background/alert_T50.log

[markus_doehr2 · Accepted solution]

> *ORA-00205: error in identifying controlfile, check alert log for more info ============ *

>

> maybe you should have a look at the alert log.

>

> it should be located in /oracle/T50/saptrace/background/alert_T50.log

Pointless exercise - that version is ancient and full of bugs.

Markus

[Former Member · Accepted solution]

Hi all

Many thanks for your advice!

The situation at my site is: we need to migrate the old system R3 4.6C ( on IBM machine) to HP-UX 11.31.

In order to ensure the action could be done somothly,

I need to simulate the migration scenario with the same database version.

Due to the old system version is: R/3 4.6C, Oracle 9.2.0.6.

That's why I need to install this old version on HP-UX 11.31 machine.

On the other hand,

it is hard for me to persuade the business sector accepting the higher version of database & SAP.

Did you meet the same situation before?

Thanks.

Charles

[Former Member · Accepted solution]

HI Charles,

As marku said your source version it self its a old one.

So before migrating you should have to upgrade the source from 9.2.0.6 to 9.2.0.8 and then migrate it to HP UNIX.

thats the better option.

Thanks,

Chaitanya

[Former Member · Accepted solution]

Hi all

Many thanks for your support.

Enclosed is part of "alert<sid>log" :

=================

PMON started with pid=2

DBW0 started with pid=3

LGWR started with pid=4

CKPT started with pid=5

SMON started with pid=6

RECO started with pid=7

Wed Mar 31 21:50:26 2010

ARCH: STARTING ARCH PROCESSES

ARC0 started with pid=8

ARC0: Archival started

ARC1 started with pid=9

Wed Mar 31 21:50:26 2010

ARCH: STARTING ARCH PROCESSES COMPLETE

Wed Mar 31 21:50:26 2010

ARC0: Thread not mounted

Wed Mar 31 21:50:26 2010

ARC1: Archival started

ARC1: Thread not mounted

Wed Mar 31 21:50:26 2010

ALTER DATABASE MOUNT

Wed Mar 31 21:50:26 2010

ORA-00202: controlfile: '/oracle/T50/sapdata1/cntrl/cntrlT50.dbf'

ORA-27037: unable to obtain file status

HP-UX Error: 2: No such file or directory

Additional information: 3

Wed Mar 31 21:50:29 2010

ORA-205 signalled during: ALTER DATABASE MOUNT...

=============

for ORA-00202: controlfile: '/oracle/T50/sapdata1/cntrl/cntrlT50.dbf', actually,

the directory structure has been created under HP-UX.

I try to install R/3 4.6C ( same platform, diff host: HP-UX 11.31,Oracle 9.2.0.1) twice, the same result.

Is it reasonable that I copy the cntrl file to the specific directory?

Thanks.

Charles

[Former Member · Accepted solution]

Charles,

HP-UX 11.31 will not support oracle 9i, it will support oracle 10g.

HP-UX 11.2 supports Oracle 9i .

I would suggest to go through the pam once and plan accordingly with your available infra.

If you want to go with HP-UX 11.31 you have to go with 10g.

>

> for ORA-00202: controlfile: '/oracle/T50/sapdata1/cntrl/cntrlT50.dbf', actually, 
> the directory structure has been created under HP-UX. 
> I try to install R/3 4.6C ( same platform, diff host: HP-UX 11.31,Oracle 9.2.0.1) twice, the same result. 
> Is it reasonable that I copy the cntrl file to the specific directory? 
> Charles

Not at all reasonable doing that way.

[markus_doehr2 · Accepted solution]

> The situation at my site is: we need to migrate the old system R3 4.6C ( on IBM machine) to HP-UX 11.31.

You have a consultant on-site to do the migration? If not then you'll be lost in case of problems; if you open an OSS call SAP will bill that separately. Are you aware of that?

> In order to ensure the action could be done somothly,

> I need to simulate the migration scenario with the same database version.

> Due to the old system version is: R/3 4.6C, Oracle 9.2.0.6.

> That's why I need to install this old version on HP-UX 11.31 machine.

I understand your situation.

> On the other hand,

> it is hard for me to persuade the business sector accepting the higher version of database & SAP.

Oracle 9.2 is out of support - that means that neither SAP nor Oracle will provide you fixes for unknown problems if they arise.

You can install patchset 9.2.0.6 - you'll need to modify the oraparam.ini so runInstaller will accept HP-UX 11.31.

Markus

[Former Member · Accepted solution]

Hi Markus

Many thanks for your support!

I have modified the "oraparam.ini" with adding "B.11.31" at row of "[Certified Versions]";

then I run the installer again, log as following:

./runInstaller

Starting Oracle Universal Installer...

Checking installer requirements...

Checking operating system version: must be B.11.00, B.11.11 or B.11.31. Actual B.11.31 Passed

All installer requirements met.

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2010-04-01_07-51-21PM. Please wait ...

Cannot exec - /tmp/OraInstall2010-04-01_07-51-21PM/jre/1.4.2/bin/IA64N/java

execvp(): No such file or directory

Actually, the directory is exist.

Is it possible that I readjust the specific file to re-direct the jre directory to the correct one(such as /opt/...)?

Optional, adding the jre directory in .profile ?

Thanks.

Charles

[former_member1375360 · Accepted solution]

Hi, Charles,

I think it's OS acess rights problem. You may check the access right of the dir. In fact, you will find more problem in the following installation. I think you should present the situation to your business and they will make the right decision. The possible way,

1. Downgrade the OS, you may need HP to help you do this, you still have database risk.

2. Upgrade the Oracle, it's better way and I do not see there's any impact to your migration

3. Keep on current plan, I think it will require a long time , and there's many problem you can not plan now both in database and OS

Hope it's helpful.

BR,

YF.

Edited by: yfzhou72 on Apr 4, 2010 4:13 PM

[Former Member · Accepted solution]

Hi Charles,

Please see if you have set the below parameters in ROOT users login profile (.profile).

export JAVA_HOME=/opt/java1.4
export SAPINST_JRE_HOME=/opt/java1.4/jre

export PATH=$PATH:$JAVA_HOME/bin

Log off and login again as ROOT user in order to make the changes effective.

Then retry the installation...

Regards.

Rajesh Narkhede

[Former Member · Accepted solution]

Dear all

Many thanks for your advices!

Due to the compatible reason, I have to down-grade HP-UX from 11.31 to 11.23.

Now, the installation procedure still goes on.

There is an other issue regarding the installation,

The OPS$ authencation is missing, using "R3trans -d ",

error log as following:

4 ETW000 [developertrace,0] Logon as OPS$-user to get SAPR3's password

4 ETW000 1046 0.061610

4 ETW000 [developertrace,0] Connecting as /@E50 on connection 0 ...

4 ETW000 178 0.061788

4 ETW000 [developertrace,0] -->oci_logon(con_hdl=0, user='', dbname='E50')

4 ETW000 95 0.061883

4 ETW000 [dboci.c ,0] *** ERROR => OCI-call 'olog' failed: rc = 12541

4 ETW000 63973 0.125856

4 ETW000 [dbsloci.,0] *** ERROR => CONNECT failed with sql error '12541'

4 ETW000 113 0.125969

4 ETW000 [developertrace,0] Try to connect with default password

4 ETW000 304 0.126273

4 ETW000 [developertrace,0] Connecting as SAPR3/<pwd>@E50 on connection 0 ...

4 ETW000 115 0.126388

4 ETW000 [developertrace,0] -->oci_logon(con_hdl=0, user='SAPR3', dbname='E50')

4 ETW000 58 0.126446

4 ETW000 [dboci.c ,0] *** ERROR => OCI-call 'olog' failed: rc = 12541

4 ETW000 10458 0.136904

4 ETW000 [dbsloci.,0] *** ERROR => CONNECT failed with sql error '12541'

4 ETW000 76 0.136980

4 ETW000 [developertrace,0] Got ORACLE_SID=E50 from environment

4 ETW000 1077 0.138057

4 ETW000 [developertrace,0] Got NLS_LANG=AMERICAN_AMERICA.WE8DEC from environment

4 ETW000 53 0.138110

4 ETW000 [developertrace,0] Logon as OPS$-user to get SAPR3's password

4 ETW000 512 0.138622

4 ETW000 [developertrace,0] Connecting as /@E50 on connection 0 ...

4 ETW000 65 0.138687

4 ETW000 [developertrace,0] -->oci_logon(con_hdl=0, user='', dbname='E50')

4 ETW000 44 0.138731

4 ETW000 [dboci.c ,0] *** ERROR => OCI-call 'olog' failed: rc = 12541

4 ETW000 8963 0.147694

4 ETW000 [dbsloci.,0] *** ERROR => CONNECT failed with sql error '12541'

4 ETW000 129 0.147823

4 ETW000 [developertrace,0] Try to connect with default password

4 ETW000 37 0.147860

4 ETW000 [developertrace,0] Connecting as SAPR3/<pwd>@E50 on connection 0 ...

4 ETW000 41 0.147901

4 ETW000 [developertrace,0] -->oci_logon(con_hdl=0, user='SAPR3', dbname='E50')

4 ETW000 41 0.147942

4 ETW000 [dboci.c ,0] *** ERROR => OCI-call 'olog' failed: rc = 12541

4 ETW000 8121 0.156063

4 ETW000 [dbsloci.,0] *** ERROR => CONNECT failed with sql error '12541'

4 ETW000 96 0.156159

4 ETW000 [dblink ,627] ***LOG BY2=>sql error 12541 performing CON

4 ETW000 671 0.156830

4 ETW000 [dblink ,627] ***LOG BY0=> 52 0.156882

Refering with SAP Note: 609332, checking listener, I could not find any diff with my prod. environment.

I am confused of the old version........

Thanks.

Charles

[Former Member]

with SAP Kernel CD 51013657 fixing this issue.

[markus_doehr2]

> After I finished the Oracle 9.2.0.0 installation, I try to installation the patch, patch 9.2.0.6 only supports HP-UX 11.11;

>

> So, I canceled the patch installation and restarted the "./R3SETUP -f CENTRAL.R3S" process,

9.2.0.1 was never supported by SAP and has serious bugs.

I suggest you install 9.2.0.8 or better install 4.6c with 10.2 - which is supported.

Markus