R3 4.7 Installation Error

[former_member220430]

I'm installing R3 4.7x110 SR1 on Oracle/HP-UX. During the database load phase, I am stopped due to the following error:

sapparam: sapargv( argc, argv) has not been called.

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

ERROR 2008-10-01 12:50:27 [iaxxbdbld.cpp:1001]

CR3ldStep::startR3ldProcesses lib=iamodload module=CR3ldStep

MSC-01015 Process finished with error(s), check log file /sapinstall/DBI/SAPSSEXC.log

SAPSSEXC.log is not the only log file to be checked but almost all SAP*.log files. All the files have similar logs as below:

Wed Oct 1 12:48:54 2008

***LOG BY2=> sql error 12154 performing CON [dblink#1 @ 419] [dblink 0419 ]

***LOG BY0=> ORA-12154: TNS:could not resolve service name [dblink#1 @ 419] [dbl

ink 0419 ]

(DB) ERROR: db_connect rc = 256

DbSl Trace: Logon as OPS$-user to get SAPDV1's password

DbSl Trace: Connecting as /@DV1 on connection 0 ...

DbSl Trace: Attaching to DB Server DV1 (con_hdl=0,svchp=600000000083def0,svrhp=6

0000000009cbd48)

DbSl Trace: OCI-call 'OCIServerAttach' failed: rc = 12154

DbSl Trace: CONNECT failed with sql error '12154'

DbSl Trace: Try to connect with default password

DbSl Trace: Connecting as SAPDV1/<pwd>@DV1 on connection 0 ...

DbSl Trace: Attaching to DB Server DV1 (con_hdl=0,svchp=600000000083def0,svrhp=6

0000000009d9258)

DbSl Trace: OCI-call 'OCIServerAttach' failed: rc = 12154

DbSl Trace: CONNECT failed with sql error '12154'

(DB) ERROR: DbSlErrorMsg rc = 99

/sapmnt/DV1/exe/R3load: job finished with 1 error(s)

/sapmnt/DV1/exe/R3load: END OF LOG: 20081001124854

Because it appears to be a problem with the DB, I tried to startup from sqlplus. Afterwards, I checked the processes that are running but it lacks oracleDV1 process. (The listener is up inherited from another syste as I have multiple oracle homes)

1. ps -ef|grep dv1

oradv1 10033 1 0 12:29:41 ? 0:00 ora_arc0_DV1

oradv1 10031 1 0 12:29:41 ? 0:00 ora_reco_DV1

root 10398 10359 0 12:33:53 pts/ta 0:00 grep DV1

oradv1 10011 1 0 12:29:40 ? 0:00 ora_pmon_DV1

oradv1 10027 1 0 12:29:41 ? 0:00 ora_ckpt_DV1

oradv1 10029 1 0 12:29:41 ? 0:00 ora_smon_DV1

oradv1 10035 1 0 12:29:41 ? 0:00 ora_arc1_DV1

oradv1 10017 1 0 12:29:41 ? 0:00 ora_dbw0_DV1

oradv1 10025 1 0 12:29:41 ? 0:00 ora_lgwr_DV1

I tried to execute startdb but the following error is listed:

$ startdb

Trying to start database ...

Log file: /home/oraDV1/startdb.log

/usr/sap/DV1/SYS/exe/run/startdb: Terminating with error code

$ more startdb.log

-

---

Wed Oct 1 12:39:26 EAT 2008

LOGFILE FOR STARTING ORACLE

Trying to start DV1 database ...

-

---

Wed Oct 1 12:39:26 EAT 2008

checking required environment variables

ORACLE_HOME is >/oracle/DV1/920_64<

ORACLE_SID is >DV1<

-

---

Wed Oct 1 12:39:26 EAT 2008

check initora

-

---

Wed Oct 1 12:39:26 EAT 2008

check initora

-

---

Wed Oct 1 12:39:26 EAT 2008

starting orasrv

/oracle/DV1/920_64/bin/orasrv missing or without set-user-ID bit. Terminating.

/usr/sap/DV1/SYS/exe/run/startdb: Terminating with error code

Can anyone help me so that I can proceed with my installation?

Thanks!

[former_member220430]

Thank you for all your suggestions. I have managed to resolve this by installing from scratch. I realized that the environment variables were not created properly during the install. As a key learning, after running the root.sh and other scripts that are prompted during Oracle installation, it is highly suggested to check the files that are being created with this scripts to verify that they are indeed created in the appropriate folders.

Regards!

[markus_doehr2]

>

> I'm installing R3 4.7x110 SR1 on Oracle/HP-UX. During the database load phase, I am stopped due to the following error:

When did you install Oracle? Before or during the sapinst run?

Markus

[former_member220430]

i installed it during the sapinst run when the popup message appeared: click OK after you have installed the oracle software. i continued with sapinst after the oracle software was installed

[markus_doehr2]

The database is running, the problem is, that the adm user can´t connect. Something went wrong during the installation.

Can you

tnsping <SID>

as adm user?

Markus

[former_member235680]

Hi,

It seems your system doesnt have the proper environment variables setup.

Could you please check environment variables on the unix, using the command env on the prompt? and can you the oracle parameter getting reflected there.

If not then you need to to set the proper env in the system.

Thanks

Abhishek

[former_member220430]

here's the result for the env command

_=/usr/bin/env

MANPATH=/usr/share/man/%L:/usr/share/man:/usr/contrib/man/%L:/usr/contrib/man:/usr/local/man/%L:/usr/local/man:/opt/VRTS/vxfs4.1/man:/opt/ldapux/share/man:/opt/ldapux/ypldapd/man:/opt/ipf/man:/opt/cifsclient/share/man:/usr/dt/share/man:/opt/samba/man:/opt/samba/WTEC_Support_Tools/man:/opt/resmon/share/man/%L:/opt/resmon/share/man:/opt/openssl/man:/opt/openssl/prngd/man:/opt/wbem/share/man:/opt/VRTS/man:/opt/graphics/common/man:/opt/sfmdb/pgsql/man:/opt/sfm/share/man:/opt/sec_mgmt/share/man:/opt/dsau/man:/opt/gnome/man:/opt/ignite/share/man/%L:/opt/ignite/share/man:/opt/perl/man:/opt/sec_mgmt/share/man/%L:/opt/ssh/share/man:/opt/gwlm/man/%L:/opt/gwlm/man:/opt/perf/man/%L:/opt/perf/man

PATH=/usr/sbin:/usr/bin:/usr/ccs/bin:/usr/contrib/bin:/usr/contrib/Q4/bin:/opt/ipf/bin:/opt/hparray/bin:/opt/nettladm/bin:/opt/fcms/bin:/opt/sas/bin:/usr/bin/X11:/opt/resmon/bin:/usr/contrib/kwdb/bin:/opt/wbem/bin:/opt/wbem/sbin:/opt/graphics/common/bin:/opt/sfm/bin:/opt/upgrade/bin:/opt/sec_mgmt/bastille/bin:/opt/dsau/bin:/opt/dsau/sbin:/opt/firefox:/opt/gnome/bin:/opt/ignite/bin:/opt/mozilla:/opt/perl/bin:/opt/sec_mgmt/spc/bin:/opt/ssh/bin:/opt/hpsmh/bin:/opt/thunderbird:/opt/gwlm/bin:/usr/contrib/bin/X11:/opt/perf/bin:/opt/java1.4/bin:/sbin:/home/root:/opt/java1.4/

COLUMNS=80

EDITOR=vi

HISTFILE=//.sh_history

LOGNAME=root

MAIL=/var/mail/root

ERASE=^H

PS1=hpsap1:$PWD

#

DISPLAY=hpsap1:0,0

SHELL=/usr/bin/sh

JAVA_HOME=/opt/java1.4/

HISTSIZE=128

HOME=/

TERM=xterm

PWD=/

TZ=EAT-8

LINES=24

but i always set the following before calling sapinst:

export dbms_type=ORA

export dbs_ora_tnsname=$DBSID

export dbs_ora_schema=SAPDV1

export ORACLE_PSRV=DV1

ORACLE_SID=DV1

export DB_SID=DV1

export ORACLE_HOME=/oracle/DV1/920_64

export ORACLE_BASE=/oracle

export ORA_NLS33=/oracle/DV1/920_64/ocommon/nls/admin/data

export NLS_LANG=AMERICAN_AMERICA.WE8DEC

export SAPDATA_HOME=/oracle/DV1

export DIR_LIBRARY=/usr/sap/DV1/SYS/exe/run

export SHLIB_PATH=usr/sap/DV1/SYS/exe/run:/oracle/DV1/920_64/lib

is there a way to set these permanently?

[markus_doehr2]

Did you install Oracle as root?

Markus

[markus_doehr2]

It´s not necessary to set anything manual, this is all done by sapinst.

I would start again from scratch and try the following:

- start sapinst an proceed until you reach the "install Oracle" point

- logon as "oradv1" and execute RUNINSTALLER (the capital one in the SAP subdirectory, not the default runInstaller)

- install the database

- install the latest patchset

- install the latest interim patch

- and then click on OK to proceed

Markus

[former_member220430]

i installed oracle as ora<sid>.

i think the problem is that the listener is not up. i am also wondering why there is no listener.ora and tnsnames.ora files in /oracle_home/network/admin after the installation.

as mentioned, multiple oracle homes exist which uses only one port for the listener. when I execute lsnrctl status with a different ora<sid> the listener is up. when it is for oradv1 this is the error:

Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

HPUX Error: 239: Connection refused

When i copied the listener.ora and tnsnames.ora from another instance, i get the following:

TNS-12618: TNS:versions are incompatible

The port I set was 1527 so it is odd that it is connecting to 1521.

If I will start from scratch, what are the steps to uninstall the oracle 9.2 software and what files should be deleted? The other instances are running on 10g.

[former_member227600]

Hi,

Please go through the following note

\[https://service.sap.com/sap/support/notes/443867]

it may help you

karan