cancel
Showing results for 
Search instead for 
Did you mean: 

Install two instances in Solaris 9 + Oracle 10.2

peter_yu3
Participant
0 Kudos

Hi all,

I am trying to install portal DEV and QAS(NW 7.0) in same Sun Solaris box, I have finished the DEV installation with 'Central System Installation' option. It ran OK. I try to install QAS in it with same option 'Central System Instalation', when it run to install database step, sapinst popup me change to dir /oracle/stage/102_64/database/SAP, run ./RUNINSTALLER, but when i run it, it give me below error:

Preparing response files. Please wait:

Working on /oracle/stage/102_64/database/SAP/SVRCUSTOM.RSP

..........................................................

/oracle/stage/102_64/database/SAP/SVRCUSTOM.RSP -> /tmp/.orainst_rsp.4815:Done

You do not have sufficient permissions to access the inventory '/oracle/oraInven

tory/locks'. Installation cannot continue. Make sure that you have read/write pe

rmissions to the inventory directory and restart the installer.: Permission denied

I checked dir /oracle/oraInventory, it belong to the DEV user. So my questions is:

1. Can i change my QAS's inventory dir to let the installation continue? I tried to change QAS user's environment, let ORACLE_BASE point to another dir(i change user's profile .dbenv.sh, .dbenv.csh), but it doesn't work for me. What i should do for change the inventory dir...

2. If i cannot use above way, how should i do for finish the installation? My target is just install DEV and QAS in same box.

Thanks.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Before calling ./RUNINSTALLER try as follwoings.

  1. su - ora<sid>

  2. export ORACLE_BASE=/oracle/<SID>

  3. cd /oracle/stage/102_64/database/SAP

  4. ./RUNINSTALLER

Then, /oracle/<SID>/oraInventory will be used for Inventory.

Or there might be already oraInst.loc under /var/opt/oracle,

in that case you can change the path manually.

inventory_loc=/oracle/PR1/oraInventory

SAP Note.

Note 350251 - Creating a New or 2nd Oracle SID with runInstaller

peter_yu3
Participant
0 Kudos

Thanks, Yoshimasa, it works, but now i have another issue, how to change the listener's port...

Best regards,

Peter

stefan_koehler
Active Contributor
0 Kudos

Hello Peter,

- Go to the directory "/oracle/<SID>/102_64/network/admin" and open the listener.ora file. You will find a parameter called "PORT" and there you can change it.

- Go to the directory "/oracle/<SID>/102_64/network/admin" and open the tnsnames.ora file and change the port there too.

For more informations:

http://download-east.oracle.com/docs/cd/B14117_01/network.101/b10776/listener.htm

Regards

Stefan

peter_yu3
Participant
0 Kudos

I changed listener.ora and tnsnames.ora file to reflect my second instances, right now it went to 'Import ABAP' steps, but i faced another issue now, it show me:

sapinst.log

WARNING 2007-12-27 14:49:25

Execution of the command "/usr/sap/EP2/SYS/exe/run/R3load -testconnect" finished with return code 2. Output: sapparam: sapargv( argc, argv) has not been called.sapparam(1c): No Profile used.sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline/usr/sap/EP2/SYS/exe/run/R3load: START OF LOG: 20071227144924

(DB) ERROR: db_connect rc = 256

DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12505

(DB) ERROR: DbSlErrorMsg rc = 99

ERROR 2007-12-27 14:49:25

CJS-30023 Process call '/usr/sap/EP2/SYS/exe/run/R3load -testconnect' exits with error code 2. For details see log file(s) R3load.exe.log.

ERROR 2007-12-27 14:49:25

FCO-00011 The step testDatabaseConnection with step key |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_ABAP_Import_Dialog|ind|ind|ind|ind|5|0|NW_ABAP_Import|ind|ind|ind|ind|0|0|testDatabaseConnection was executed with status ERROR .

and R3load.exe.log is

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

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

/usr/sap/EP2/SYS/exe/run/R3load: START OF LOG: 20071227144924

/usr/sap/EP2/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#13 $ SAP

/usr/sap/EP2/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]

Compiled Jul 14 2007 01:53:54

/usr/sap/EP2/SYS/exe/run/R3load -testconnect

DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12505

DbSl Trace: CONNECT failed with sql error '12505'

DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12505

DbSl Trace: CONNECT failed with sql error '12505'

(DB) ERROR: db_connect rc = 256

DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12505

DbSl Trace: CONNECT failed with sql error '12505'

DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12505

DbSl Trace: CONNECT failed with sql error '12505'

(DB) ERROR: DbSlErrorMsg rc = 99

/usr/sap/EP2/SYS/exe/run/R3load: job finished with 1 error(s)

/usr/sap/EP2/SYS/exe/run/R3load: END OF LOG: 20071227144925

I guess R3load cannot find out correct listener and db, as i changed it after i started sapinst. So if anybody can tell me where is R3load's parameter files... so that i can change the listener setting and let it connect to correct database.

Best regards,

Peter

stefan_koehler
Active Contributor
0 Kudos

Hello Peter,

you are receiving a TNS-12505 error. (http://tns-12505.ora-code.com/)

This means that the listener is not providing the given service (=SID).

1) Do you have the oracle parameter LOCAL_LISTENER set?

2) Please post the listener.ora and the tnsnames.ora

3) Please post the environment ( command: env | grep -i <SID> )

Regards

Stefan

peter_yu3
Participant
0 Kudos

Hi Stefan,

1. I didn't have para LOCAL_LISTENER

2. tnsnames.ora

################

  1. Filename......: tnsnames.ora

  2. Created.......: created by SAP AG, R/3 Rel. >= 6.10

  3. Name..........:

  4. Date..........:

  5. @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/TNSNAMES.ORA#4 $

################

EP2.WORLD=

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = epdev)

(PORT = 1528)

)

)

(CONNECT_DATA =

(SID = EP2)

(GLOBAL_NAME = EP2.WORLD)

)

)

listener.ora

################

  1. Filename......: listener.ora

  2. Created.......: created by SAP AG, R/3 Rel. >= 6.10

  3. Name..........:

  4. Date..........:

  5. @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/LISTENER.ORA#4 $

################

ADMIN_RESTRICTIONS_LISTENER = on

LISTENER2 =

(ADDRESS_LIST =

(ADDRESS =

(PROTOCOL = IPC)

(KEY = EP2.WORLD)

)

(ADDRESS=

(PROTOCOL = IPC)

(KEY = EP2)

)

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = epdev)

(PORT = 1528)

)

)

STARTUP_WAIT_TIME_LISTENER = 0

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = EP2)

(ORACLE_HOME = /oracle/EP2/102_64)

)

)

3.

epdev:oraep2 47% env | grep -i EP2

DB_SID=EP2

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

DTAPPSEARCHPATH=/oracle/EP2/.dt/appmanager:/usr/dt/appconfig/appmanager/%L:/usr/dt/appconfig/appmanager/C

DTDATABASESEARCHPATH=/oracle/EP2/.dt/types,/usr/dt/appconfig/types/%L,/usr/dt/appconfig/types/C

DTHELPSEARCHPATH=/oracle/EP2/.dt/help/oraep2-172.16.128.20-1/%H:/oracle/EP2/.dt/help/oraep2-172.16.128.20-1/%H.sdl:/oracle/EP2/.dt/help/oraep2-172.16.128.20-1/%H.hv:/oracle/EP2/.dt/help/%H:/oracle/EP2/.dt/help/%H.sdl:/oracle/EP2/.dt/help/%H.hv:/usr/dt/appconfig/help/%L/%H:/usr/dt/appconfig/help/%L/%H.sdl:/usr/dt/appconfig/help/%L/%H.hv:/usr/dt/appconfig/help/C/%H:/usr/dt/appconfig/help/C/%H.sdl:/usr/dt/appconfig/help/C/%H.hv

DTUSERSESSION=oraep2-172.16.128.20-1

HOME=/oracle/EP2

LD_LIBRARY_PATH=/usr/sap/EP2/SYS/exe/run:/oracle/EP2/102_64/lib

LOGNAME=oraep2

MAIL=/var/mail/oraep2

ORACLE_BASE=/oracle/EP2

ORACLE_HOME=/oracle/EP2/102_64

ORACLE_SID=EP2

PATH=/oracle/EP2/102_64/bin:/oracle/EP2:/usr/sap/EP2/SYS/exe/run:/usr/bin:.:/usr/dt/bin:/usr/openwin/bin:/bin:/usr/ucb:/usr/ccs/bin

SAPDATA_HOME=/oracle/EP2

SAPSYSTEMNAME=EP2

USER=oraep2

XMICONBMSEARCHPATH=/oracle/EP2/.dt/icons/%B%M.bm:/oracle/EP2/.dt/icons/%B%M.pm:/oracle/EP2/.dt/icons/%B:/usr/dt/appconfig/icons/%L/%B%M.bm:/usr/dt/appconfig/icons/%L/%B%M.pm:/usr/dt/appconfig/icons/%L/%B:/usr/dt/appconfig/icons/C/%B%M.bm:/usr/dt/appconfig/icons/C/%B%M.pm:/usr/dt/appconfig/icons/C/%B

XMICONSEARCHPATH=/oracle/EP2/.dt/icons/%B%M.pm:/oracle/EP2/.dt/icons/%B%M.bm:/oracle/EP2/.dt/icons/%B:/usr/dt/appconfig/icons/%L/%B%M.pm:/usr/dt/appconfig/icons/%L/%B%M.bm:/usr/dt/appconfig/icons/%L/%B:/usr/dt/appconfig/icons/C/%B%M.pm:/usr/dt/appconfig/icons/C/%B%M.bm:/usr/dt/appconfig/icons/C/%B

dbs_ora_tnsname=EP2

PWD=/oracle/EP2/102_64/bin

Best regards,

Peter

stefan_koehler
Active Contributor
0 Kudos

Hello Peter,

your configuration looks fine.

Have you started the SAPINST as "epdev" and was the listener started?

Because as i remember... you have to start sapinst as root and then the environment is not set.. which would explain the TNS error.

If both anwers are yes - please do the following:

>find <SAPINSTDIR> -name "*.ora*"

>env | grep -i TNS (as root and as epdev)

Regards

Stefan

peter_yu3
Participant
0 Kudos

Thanks you, Stefan, i cannot figure that out, so i start a new installation, it seems working now, have passed the import ABAP phase.

Answers (3)

Answers (3)

peter_yu3
Participant
0 Kudos

done

Former Member
0 Kudos

Hi Peter,

You've probably already found a solution to the problem but from a simple perspective, I had the same issue and reduced my profile parameter from 1500 gradually:

em/initial_size_MB = 1000

I tried to ramp it back up again to 1200 but it failed - we are heavily loading the application server with other instances though, so we'll need to tweak a lot of instances to find the best balance. This only happened after installing a new Kernel (640 vers 190 ish) and some support packages, but I think the support packages are probably a red herring.

All the best.

Stephen

peter_yu3
Participant
0 Kudos

Now, i finished installing two instances in one solaris box, both are 'central system installation', right now, i face another issue, i can just access one instance, for example, EP1 and EP2 are SID

1. i start EP1, and stop EP2, i can access to EP1 in sapgui;

2. with EP1 started, then if i start EP2, i cannot access it in sapgui;

3. if i stop EP1 and start EP2, then i can access EP2;

4, with EP2 start and try start EP1, i cannot ass EP1 too.

It installed it with default options, the server have 8G RAM.

in dev_disp.trc, i found some error:

Fri Dec 28 19:32:37 2007

      • ERROR => DpIcmCreate: fork (12: Not enough space) [dpuxdisp.c 790]

***LOG Q0I=> DpIcmCreate, fork ( fork 12) [dpuxdisp.c 793]

DpProcCreate: ICM could not be started (rc = -1)

      • ERROR => DpForkExecJava: fork (12: Not enough space) [dpuxdisp.c 1613]

***LOG Q0I=> DpForkExecJava, fork ( fork 12) [dpuxdisp.c 1616]

DpJ2eeStart: j2ee state = INIT

      • ERROR => DpProcCreate: DpJ2eeStart failed [dpxxdisp.c 12451]

      • ERROR => DpWpCreate: fork (12: Not enough space) [dpuxdisp.c 907]

***LOG Q0I=> DpWpCreate, fork ( fork 12) [dpuxdisp.c 910]

      • ERROR => DpWpDynCreate: DpWpCreate [dpuxdisp.c 296]

      • ERROR => DpProcCreate: DpWpDynCreate [dpxxdisp.c 12465]

      • DP_FATAL_ERROR => DpSapEnvInit: DpProcCreate

      • DISPATCHER EMERGENCY SHUTDOWN ***

it seems lack of space, but my machine's disk is ok, i check it with df -h. does it means memory...?

Any suggestion is appreciated, thanks

Happy holiday!

Peter

Edited by: Peter Yu on Dec 29, 2007 8:06 AM