two database on one host problem . thanks

[Former Member]

I have installed two database on one host. the two database are:"SMT","IDE". and I have changed the listener.ora, tnsnames.ora files following notes 98252, the I change to orasmt user to start the lsnrctl.

Then , is it necessary to start lsnrctl again by user oraide?? when I do that ,the system informed me that:the lsnrctl is already running.

then I change to user: smtadm to start sap. It failed as following:

Checking SMT Database

-

---

ABAP Database is not available via R3trans

Starting SAP-Collector Daemon

-

---

21:50:33 01.11.2008 LOG: Effective User Id is root

***********************************************************************

• This is Saposcol Version COLL 20.95 700 - v2.12, AMD/Intel x86_64 with Linux, 2008/01/02

• Usage: saposcol -l: Start OS Collector

• saposcol -k: Stop OS Collector

• saposcol -d: OS Collector Dialog Mode

• saposcol -s: OS Collector Status

• The OS Collector (PID 3462) is already running .....

************************************************************************

saposcol already running

Running /usr/sap/SMT/SYS/exe/run/startdb

Trying to start SMT database ...

Log file: /home/smtadm/startdb.log

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

DB startup failed

and startdb.log file says:

-

---

Sat Nov 1 21:50:33 CST 2008

LOGFILE FOR STARTING ORACLE

Trying to start SMT database ...

-

---

Sat Nov 1 21:50:33 CST 2008

checking required environment variables

ORACLE_HOME is >/oracle/SMT/102_64<

ORACLE_SID is >SMT<

-

---

Sat Nov 1 21:50:33 CST 2008

check initora

-

---

Sat Nov 1 21:50:33 CST 2008

check initora

-

---

Sat Nov 1 21:50:33 CST 2008

checking V2 connect

TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 01-NOV-2008 21:50:33

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:

/usr/sap/SMT/SYS/profile/oracle/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = KS1DIDES1) (PORT =

1527))) (CONNECT_DATA = (SID = SMT) (GLOBAL_NAME = SMT.WORLD)))

OK (0 msec)

tnsping: V2 connect to SMT

-

---

Sat Nov 1 21:50:33 CST 2008

Connect to the database to check the database state:

R3trans: connect check finished with return code: 12

Database not available

-

---

Sat Nov 1 21:50:33 CST 2008

Shutdown database

First trying to shutdown the database - May be,

the database is in the nomount or mount state

-

---

Sat Nov 1 21:50:33 CST 2008

starting database

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Nov 1 21:50:33 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

ERROR:

ORA-09925: Unable to create audit trail file

Linux-x86_64 Error: 13: Permission denied

Additional information: 9925

ORA-09925: Unable to create audit trail file

Linux-x86_64 Error: 13: Permission denied

Additional information: 9925

ORA-10997: another startup/shutdown operation of this instance inprogress

ORA-09967: unable to create or open lock file

Linux-x86_64 Error: 13: Permission denied

-

---

Sat Nov 1 21:50:33 CST 2008

Connect to the database to verify, that the database is now open

R3trans check finished with return code: 12

• ERROR: Startup of database failed

Notify Database Administrator.

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

[Former Member]

Oh, I get the answer, It is because I neglect the selinux setting.

after I run /usr/sbin/setenforce 0 to set it to permissive, I can startsap correctly.

and thanks for your answers, I can always get right answers from SDN.

thanks

[stefan_koehler]

Hello Victor,

• Ensure the directory $ORACLE_HOME/rdbms/audit or the directory specified by the init.ora <parameter:AUDIT_FILE_DEST> exists, is writable by the oracle software owner and that the disk is not full.

• Check $ORACLE_HOME/bin/oracle has permission of 6755. If not, then correct the permissions by executing this from the $ORACLE_HOME/bin directory: chmod 6755 oracle

Regards

Stefan

[Former Member]

I have checked that, user orasmt has the read write permission to the audit directory. and the permission of /$oracle_home/bin/oracle is 777. thanks

[Former Member]

Hi victor,

The same problem i already faced in window also.So what i have done update your tnsname.ora and listener.ora as given in note 98252 and then also copy same updated copy of tnsnames.ora to /usr/sap/SMT/SYS/profile/oracle and /usr/sap/IDE/SYS/profile/oracle.

Hope it will do.But for updating listener.ora and tnsnames.ora follow sap note completely.

verify changes using tnsping and r3trans utilities.

Regards,

Gagan Deep Kaushal

[Former Member]

thanks for your reply. I am sure that I changed these two files correctly.

and now, I can user oraide and orasmt to start oracle .

but when I change to user ideadm and smtadm to start sap, there always some error. It seems startsap command can not connect to the database.

when I run R3trans -d, it give back:

This is R3trans version 6.14 (release 700 - 14.02.08 - 14:55:00).

unicode enabled version

2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/IDE/SYS/exe/run') or dbms_type ('ORA')"

R3trans finished (0012).

[Former Member]

then I check the startdb.log. : the database is already start, but startsap seems can not connect to it.

-

---

Sun Nov 2 15:22:35 CST 2008

LOGFILE FOR STARTING ORACLE

Trying to start IDE database ...

-

---

Sun Nov 2 15:22:35 CST 2008

checking required environment variables

ORACLE_HOME is >/oracle/IDE/102_64<

ORACLE_SID is >IDE<

-

---

Sun Nov 2 15:22:35 CST 2008

check initora

-

---

Sun Nov 2 15:22:35 CST 2008

check initora

-

---

Sun Nov 2 15:22:35 CST 2008

checking V2 connect

TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 02-NOV-2008 15:22:35

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:

/usr/sap/IDE/SYS/profile/oracle/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = KS1DIDES1) (PORT =

1527))) (CONNECT_DATA = (SID = IDE) (GLOBAL_NAME = IDE.WORLD)))

OK (0 msec)

tnsping: V2 connect to IDE

-

---

Sun Nov 2 15:22:35 CST 2008

Connect to the database to check the database state:

R3trans: connect check finished with return code: 12

Database not available

-

---

Sun Nov 2 15:22:35 CST 2008

Shutdown database

First trying to shutdown the database - May be,

the database is in the nomount or mount state

-

---

Sun Nov 2 15:22:54 CST 2008

starting database

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Nov 2 15:22:54 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to an idle instance.

ORACLE instance started.

Total System Global Area 2332033024 bytes

Fixed Size 2022504 bytes

Variable Size 1174406040 bytes

Database Buffers 1140850688 bytes

Redo Buffers 14753792 bytes

Database mounted.

Database opened.

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

-

---

Sun Nov 2 15:23:05 CST 2008

Connect to the database to verify, that the database is now open

R3trans check finished with return code: 12

• ERROR: Startup of database failed

Notify Database Administrator.

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

[Former Member]

I run R3trans -x , get the trans.log :

4 ETW000 R3trans version 6.14 (release 700 - 14.02.08 - 14:55:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 02.11.2008 - 16:05:10

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -x

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Sun Nov 2 16:05:10 2008 78 0.000078

4 ETW000 [dev trc ,00000] db_con_init called 17 0.000095

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 29 0.000124

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/IDE/SYS/exe/run/dboraslib.so' ...

4 ETW000 34 0.000158

4 ETW000 [dlux.c ,00000] *** ERROR => DlLoadLib: dlopen()= /oracle/client/10x_64/instantclient/libnnz10.so: cannot restore se

gment prot after reloc: Permission denied -> DLENOACCESS (0,Success)

4 ETW000 4398 0.004556

4 ETW000 [dbcon.c ,00000] *** ERROR => Couldn't load library '/usr/sap/IDE/SYS/exe/run/dboraslib.so'

4 ETW000 21 0.004577

2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/IDE/SYS/exe/run') or dbms_type ('ORA')"

[Former Member]

>ERROR => DlLoadLib: dlopen()= /oracle/client/10x_64/instantclient/libnnz10.so: cannot restore segment prot after reloc: Permission denied -> DLENOACCESS (0,Success)

check above error.

also check variable for DIR_LIBRARY ('/usr/sap/IDE/SYS/exe/run') or dbms_type

looks like something wrong with environment variables. can you please paste here environment variables for both SIDs?

cheers,

-Sunil

[Former Member]

thanks.

the smtadm`s environment :

TERM=vt100

HOME=/home/smtadm

SHELL=/bin/csh

USER=smtadm

LOGNAME=smtadm

PATH=/oracle/SMT/102_64/bin:/opt/IBMJava2-amd64-142/bin:.:/home/smtadm:/usr/sap/SMT/SYS/exe/run:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin

HOSTTYPE=x86_64-linux

VENDOR=unknown

OSTYPE=linux

MACHTYPE=x86_64

SHLVL=1

PWD=/home/smtadm

GROUP=sapsys

HOST=KS1DIDES1

REMOTEHOST=10.20.48.77

MAIL=/var/spool/mail/smtadm

LS_COLORS=no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=01;32:.cmd=01;32:.exe=01;32:.com=01;32:.btm=01;32:.bat=01;32:.sh=01;32:.csh=01;32:.tar=01;31:.tgz=01;31:.arj=01;31:.taz=01;31:.lzh=01;31:.zip=01;31:.z=01;31:.Z=01;31:.gz=01;31:.bz2=01;31:.bz=01;31:.tz=01;31:.rpm=01;31:.cpio=01;31:.jpg=01;35:.gif=01;35:.bmp=01;35:.xbm=01;35:.xpm=01;35:.png=01;35:.tif=01;35:

G_BROKEN_FILENAMES=1

SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass

KDE_IS_PRELINKED=1

KDEDIR=/usr

LANG=en_US.UTF-8

LESSOPEN=|/usr/bin/lesspipe.sh %s

HOSTNAME=KS1DIDES1

INPUTRC=/etc/inputrc

SAPSYSTEMNAME=SMT

DIR_LIBRARY=/usr/sap/SMT/SYS/exe/run

LD_LIBRARY_PATH=/usr/sap/SMT/SYS/exe/run:/oracle/client/10x_64/instantclient

JAVA_HOME=/opt/IBMJava2-amd64-142

THREAD=NOPS

dbms_type=ORA

dbs_ora_tnsname=SMT

dbs_ora_schema=SAPSMT

ORACLE_SID=SMT

DB_SID=SMT

ORACLE_BASE=/oracle

TNS_ADMIN=/usr/sap/SMT/SYS/profile/oracle

ORACLE_HOME=/oracle/SMT/102_64

NLS_LANG=AMERICAN_AMERICA.UTF8

SAPDATA_HOME=/oracle/SMT

ideadm user`s environment :

TERM=vt100

HOME=/home/ideadm

SHELL=/bin/csh

USER=ideadm

LOGNAME=ideadm

PATH=/oracle/IDE/102_64/bin:/opt/IBMJava2-amd64-142/jre/bin:.:/home/ideadm:/usr/sap/IDE/SYS/exe/run:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin

HOSTTYPE=x86_64-linux

VENDOR=unknown

OSTYPE=linux

MACHTYPE=x86_64

SHLVL=1

PWD=/install/ora_client

GROUP=sapsys

HOST=KS1DIDES1

REMOTEHOST=10.20.48.77

MAIL=/var/spool/mail/ideadm

LS_COLORS=no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=01;32:.cmd=01;32:.exe=01;32:.com=01;32:.btm=01;32:.bat=01;32:.sh=01;32:.csh=01;32:.tar=01;31:.tgz=01;31:.arj=01;31:.taz=01;31:.lzh=01;31:.zip=01;31:.z=01;31:.Z=01;31:.gz=01;31:.bz2=01;31:.bz=01;31:.tz=01;31:.rpm=01;31:.cpio=01;31:.jpg=01;35:.gif=01;35:.bmp=01;35:.xbm=01;35:.xpm=01;35:.png=01;35:.tif=01;35:

G_BROKEN_FILENAMES=1

SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass

KDE_IS_PRELINKED=1

KDEDIR=/usr

LANG=en_US.UTF-8

LESSOPEN=|/usr/bin/lesspipe.sh %s

HOSTNAME=KS1DIDES1

INPUTRC=/etc/inputrc

SAPSYSTEMNAME=IDE

DIR_LIBRARY=/usr/sap/IDE/SYS/exe/run

LD_LIBRARY_PATH=/usr/sap/IDE/SYS/exe/run:/oracle/client/10x_64/instantclient

JAVA_HOME=/opt/IBMJava2-amd64-142/jre

THREAD=NOPS

dbms_type=ORA

dbs_ora_tnsname=IDE

dbs_ora_schema=SAPIDE

ORACLE_SID=IDE

DB_SID=IDE

ORACLE_BASE=/oracle

TNS_ADMIN=/usr/sap/IDE/SYS/profile/oracle

ORACLE_HOME=/oracle/IDE/102_64

NLS_LANG=AMERICAN_AMERICA.UTF8

SAPDATA_HOME=/oracle/IDE

[Former Member]

Hi Victor,

Check the permisions on the AUDIT_DEST folder. it's nomally set to $ORACLE_HOME\rdbms\audit.

Also check if there is sufficient space.

Regards,

Gagan Deep Kaushal

[Former Member]

Hi,

I had the same issue yesterday when a system was trying to load the library and connect to the database.

The actual problem was that the oracle user sapsr3 was locked.

So I unlocked the user (alter user sapsr3 account unlock) and set the FAILED_LOGIN_ATTEMPTS to unlimited (as described in SAP Note 951167).

Hope this helps,

Konstantina

[Former Member]

thanks for your help.

I unlock the user. but I still can not startsap.