on 12-27-2007 2:14 AM
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.
Hi,
Before calling ./RUNINSTALLER try as follwoings.
su - ora<sid>
export ORACLE_BASE=/oracle/<SID>
cd /oracle/stage/102_64/database/SAP
./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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
Hi Stefan,
1. I didn't have para LOCAL_LISTENER
2. tnsnames.ora
################
Filename......: tnsnames.ora
Created.......: created by SAP AG, R/3 Rel. >= 6.10
Name..........:
Date..........:
@(#) $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
################
Filename......: listener.ora
Created.......: created by SAP AG, R/3 Rel. >= 6.10
Name..........:
Date..........:
@(#) $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
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
done
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.