Question:
Hello all,
Thanks you for all of the help. The installation has gone fine until I get to 62% of the DB instance. It seems to me that tables are off by 1, does anyone know how i can fix it?
When I am done I will post my cookbook install!
------------------------------------------------
oradbusr.LOGFILE
old 3: if substr(upper('&&1'),1,5) = 'SAPR3' then
new 3: if substr(upper('NT'),1,5) = 'SAPR3' then
old 6: if upper('&&2') = 'NT' then
new 6: if upper('SRV1') = 'NT' then
Enter value for 3: SAPR3
old 13: :sDomain := upper('&&3');
new 13: :sDomain := upper('SAPR3');
old 17: :sSchema := upper('&&1');
new 17: :sSchema := upper('NT');
old 18: if upper('&&2') = 'NT' then
new 18: if upper('SRV1') = 'NT' then
old 25: :sDomain := upper('&&3');
new 25: :sDomain := upper('SAPR3');
using following Parameters:
.
. Oracle SID:
. Oracle Version: 8.1.7.0.0
. Parametervalue os_authent_prefix: OPS$
. Database User (Schema): NT
. SAP R/3 Administrator: OPS$ADM
.
unable to assign default tablespace to user: NT
begin
*
ERROR at line 1:
ORA-00959: tablespace 'PSAPUSR' does not exist
ORA-06512: at line 90
----------------------------------------------------------------------
Oradbusr.sql
connect / as sysdba
set feedback off
spool oradbusr.log
set serverout on
set termout on
--set echo on;
/*-------------------------------------------------------------------*/
/* oradbusr.sql creates the Oracle Default Users for Operating */
/* system based DB authentication */
/* */
/* usage: */
/* UNIX: sqlplus /NOLOG @oradbusrSD.sql SCHEMAOWNER UNIX SID */
/* NT: sqlplus /nolog @oradbusrSD.sql SCHEMAOWNER NT COMPUTER|DOMAIN */
/* */
/* if [SCHEMAOWNER] is ommited SAPR3 is automatically used as */
/* [SCHEMAOWNER]. The SCHEMAOWNER has to start with SAP and must */
/* must not exceed a length of 6 characters (example: SAPPRD) */
/* Domain must be specified if Oracle 8.1.5 or later is used on NT */
/* and must contain the Userdomain or Computername (if the user */
/* is only local to the computer */
/*-------------------------------------------------------------------*/
VARIABLE sPrefix varchar2(100)
VARIABLE sSID varchar2(100);
VARIABLE sVersion varchar2(100);
VARIABLE sDomain varchar2(100);
VARIABLE sR3user varchar2(100);
VARIABLE sSvcuser varchar2(100);
VARIABLE bONNT number;
VARIABLE bSCHEMA number;
VARIABLE sSchema varchar2(100);
VARIABLE cur number;
VARIABLE r number;
VARIABLE stmt varchar2(200);
VARIABLE errtxt1 varchar2(200);
WHENEVER SQLERROR EXIT SQL.SQLCODE
WHENEVER OSERROR EXIT FAILURE
/* --- initialization ---*/
/* SID, Oracle DB Version, Prefix, Domainname, number of sapuser tables */
begin
begin
if substr(upper('&&1'),1,5) = 'SAPR3' then
:bSCHEMA := 0;
:sSchema := 'SAPR3';
if upper('&&2') = 'NT' then
:bONNT := 1;
else
:bONNT := 0;
end if;
if :bONNT = 1 then
:sDomain := upper('&&3');
end if;
else
:bSCHEMA := 1;
:sSchema := upper('&&1');
if upper('&&2') = 'NT' then
:bONNT := 1;
else
:bONNT := 0;
end if;
if :bONNT = 1 then
:sDomain := upper('&&3');
end if;
end if;
end;
end;
/
set termout on
begin
declare
sPrefix varchar2(100);
nSchemaLen number;
begin
select instance_name, version into :sSID, :sVersion from v$instance;
select value into sPrefix from v$parameter where name='os_authent_prefix';
if :bSCHEMA = 1 then
:sSid := substr(:sSchema,4,3);
else
:sSid := upper(:sSid);
end if;
sPrefix := upper(sPrefix);
if :bONNT = 1 then
if :sVersion > '8.1.0.0.0' then
:sR3user := sPrefix || :sDomain || '\' || :sSID || 'ADM';
:sSvcuser := sPrefix || :sDomain || '\' || 'SAPSERVICE' || :sSID;
else
:sR3user := sPrefix || :sSid || 'ADM';
:sSvcuser := sPrefix || 'SAPSERVICE' || :sSID;
end if;
else
:sR3user := sPrefix || :sSid || 'ADM';
end if;
dbms_output.put_line('using following Parameters: ');
dbms_output.put_line('.');
dbms_output.put_line('. Oracle SID: '||:sSID);
dbms_output.put_line('. Oracle Version: '||:sVersion);
dbms_output.put_line('. Parametervalue os_authent_prefix: '||sPrefix);
dbms_output.put_line('. Database User (Schema): '||:sSchema);
dbms_output.put_line('. SAP R/3 Administrator: '||:sR3user);
if :bONNT = 1 then
dbms_output.put_line('. SAP R/3 Serviceuser: '||:sSvcuser);
end if;
dbms_output.put_line('.');
end;
end;
.
.
.
I can post the rest if neccessary
---------------------------------------------------------------------------
Answer:
Starting from MMC I start the SAP system
everything starts out fine but then disp+work.exe dies
The first entry in the Syslog is:
Database: Table SVERS is not in the database
Answer:
Can someone help?
Answer:
It seems to me that tables are off by 1
What do you mean by this?
ORA-00959: tablespace 'PSAPUSR' does not exist
You have to create the tablespace 'PSAPUSR'.
Answer:
It seems to me that tables are off by 1
What do you mean by this?
ORA-00959: tablespace 'PSAPUSR' does not exist
You have to create the tablespace 'PSAPUSR'.
old 3: if substr(upper('&&1'),1,5) = 'SAPR3' then
new 3: if substr(upper('NT'),1,5) = 'SAPR3' then
old 6: if upper('&&2') = 'NT' then
new 6: if upper('SRV1') = 'NT' then
new 3 'NT' should be SAPR3
new 6 should be NT
etc
Answer:
perhaps you mixed up servername and SID whrn enterring parameters?
_________________
SapFans Moderator
NetWeaver ‘04–SAP Web AS for ORACLE certified
Search: /forums/search.php
SAP Notes: http://service.sap.com/notes
SAP Help: http://help.sap.com
Basic Rules: /forums/viewtopic.php?t=222759
Answer:
perhaps you mixed up servername and SID whrn enterring parameters?
I don't thinks, there is also a "&&3" after that which is supposed to be sDomain.
my domain is the local computer "srv1"
Answer:
I followed OSS note 50088 regarding this problem. however it returns to me with errors.
Below is the note 50088 and <<<<my actions and the results>>>>. Should I consult with SAP or does anyone know how to proceed from here?
Ic Creating OPS$ users (as of Oracle 8.1.6)
On Oracle 8.1.6, security for OPS$ access has been enhanced by including the domain name in the OPS$ user names.
Creating the OPS$ user is done via script oradbusr.sql.
By mistake, there are two different scripts of the same name but with a different number of parameters. With the older script, two parameters are used; with the new script, three parameters ('schemaowner' added) are used.
The old version with two parameters is contained on the RDBMS CD, on earlier Kernel CDs, and in the installation directory.
The new version with three parameters is contained in the new installation kits. Use the new version as of Version 6.10 and in MCOD systems as of 4.6.
How to find out whether you have the new script of the old one installed:
Open script 'oradbusr.sql' using a text editor.
If 'oradbusrSD.sql' is listed under 'Usage', you have the new version.
If 'oradbusr.sql' is listed, you have the old version.
Execute the following command to set up the OPS$ user:
New script:
sqlplus /NOLOG @oradbusr.sql <schemaowner> NT <userdomain>
<<<<<<<<<<<<<<<<<ACTION AND RESULT>>>>>>>>>>>>>>>>>>>>>>
E:\USERS\C11ADM\INSTALL> sqlplus /NOLOG @oradbusr.sql SAPR3 NT srv1
E:\USERS\C11ADM\INSTALL>sqlplus /NOLOG @oradbusr.sql SAPR3 NT srv1
SQL*Plus: Release 8.1.7.0.0 - Production on Mon Jul 7 11:32:39 2003
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Connected.
old 3: if substr(upper('&&1'),1,5) = 'SAPR3' then
new 3: if substr(upper('SAPR3'),1,5) = 'SAPR3' then
old 6: if upper('&&2') = 'NT' then
new 6: if upper('NT') = 'NT' then
old 13: :sDomain := upper('&&3');
new 13: :sDomain := upper('srv1');
old 17: :sSchema := upper('&&1');
new 17: :sSchema := upper('SAPR3');
old 18: if upper('&&2') = 'NT' then
new 18: if upper('NT') = 'NT' then
old 25: :sDomain := upper('&&3');
new 25: :sDomain := upper('srv1');
using following Parameters:
.
. Oracle SID: C11
. Oracle Version: 8.1.7.0.0
. Parametervalue os_authent_prefix: OPS$
. Database User (Schema): SAPR3
. SAP R/3 Administrator: OPS$SRV1\C11ADM
. SAP R/3 Serviceuser: OPS$SRV1\SAPSERVICEC11
.
Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
Connected.
Connected.
Disconnected from Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
JServer Release 8.1.7.0.0 - Production
E:\USERS\C11ADM\INSTALL>
<<<<<<<<<<<<<<<<<ACTION AND RESULT>>>>>>>>>>>>>>>>>>>>>>
Old script:
sqlplus /NOLOG @oradbusr.sql NT <userdomain>
Set the domain name of the domain for <userdomain> in which the user
<SID>ADM was created. This usually corresponds to the value of the
environment variable USERDOMAIN if you have logged on as <SID>ADM. You
can find out what the current value of the environment variable is
by using the command.
set USER
in a command prompt.
For <schemaowner>, you need to set a different value if you use the new oradbusr.sql script:
Up to Version 4.6D, use 'SAPR3' for 'schemaowner'.
As of Version 6.10, use 'SAP<SID>' for 'schemaowner'.
You can also use the environment variable to check which value you need to set for 'schemaowner':
If the environment variable was set to DBS_ORA_SCHEMA, use the value specified there (SAPR3 or SAP<SID>).
If DBS_ORA_SCHEMA was not set, use 'SAPR3'.
Then, you need to set the password for user sapr3 acc. to IIb or IIc............
Answer:
"You may need to run PUPBLD.SQL as SYSTEM " this action was completed successfully; but did not help....
I think I must create the OPS$C11ADM as per note 400241.
Answer:
following not 400241 explicitly did not work for me so..but i got some help. And this seems to work.
When installation stalls out @ 62% or dbcreateuser_nt_ora
open a c prompt.
c:\svrmgrl
svrmgrl>connect system /manager
svrmgrl>create us OPS$SRV1\C11ADM identified externally;
svrmgrl>grant dba to OPS$C11ADM
exit
To run the oradbusr.sql script you may now run the following command.
\\Users\cd11\install>sqlplus /NOLOG @oradbusr.sql SAPR3 NT srv1
To continue installation you must hardcode in values for:
&&1=SAPR3
&&2=NT
&&3=srv1
QUESTION. how do I find dbcreateuser_nt_ora scrpit. If i can find this i don't have to modify the sql script?
Answer:
REVISION I did have to run the PUPBLD.SQL
Then I had to create the users.
Now I am stuck again.
**********************************************************
I now start the DB installation again I get an error just after the 62% about SVERS is missing got any ideas just after the DBCREATEUSER_NT_ORA but the procecess continues to the DBLOAD
[Thr 1444] Mon Jul 07 21:13:59 2003
[Thr 1444] db_con_init called
[Thr 1444] function DbSlExpFuns loaded from library dboraslib.dll
[Thr 1444] function dsql_db_init loaded from library dboraslib.dll
[Thr 1444] function dbdd_exp_funs loaded from library dboraslib.dll
[Thr 1444] db_con_connect (con_name=R/3)
[Thr 1444] Mon Jul 07 21:14:02 2003
***LOG BZA=> table SVERS doesn't exist on database [dblink 2054 ]
INFO 2003-07-07 21:14:02
Creating Data Dictionary Synonyms for SAP System
INFO 2003-07-07 21:14:12
Adding Parameters to Configuration File
*********************************************************
The installation error out during the DBR3LOAD. 17 processes finish unsuccessfully. oracle Agent, Data Gatherer, and TNSListener have been started.
*********************************************************
when I try the startup the SAP system through MMC I get the following error and the process eventually dies
R/3 Basis System: Initialization DB-Connect Failed, Return Code 000256
*********************************************************
DEV_* files during the DBR3LOAD
---------------------------------------------------
trc file: "dev_dbsl", trc level: 2, release: "46D"
---------------------------------------------------
[Thr 2344] load shared library (dboraslib.dll), hdl 0
DbSl Trace: dbsloci.c 6241 Got ORACLE_HOME=E:\oracle\ora81 from environment
DbSl Trace: dboci.c 2321 -->oci_initialize
DbSl Trace: dbsloci.c 6241 Got ORACLE_SID=C11 from environment
DbSl Trace: dbsloci.c 6745 Got NLS_LANG=AMERICAN_AMERICA.WE8DEC from environment
DbSl Trace: dbsloci.c 5112 Logon as OPS$-user to get SAPR3's password
DbSl Trace: dbsloci.c 6538 Connecting as /@C11 on connection 0 ...
DbSl Trace: dboci.c 2404 -->oci_logon(con_hdl=0, user='', dbname='C11')
DbSl Trace: dbsloci.c 6554 Now I'm connected to ORACLE
DbSl Trace: dbsloci.c 7344 ORA-1403 when accessing table SAPUSER
DbSl Trace: dbsloci.c 6464 Disconnecting from connection 0 ...
DbSl Trace: dboci.c 2356 -->oci_logoff(con_hdl=0)
DbSl Trace: dbsloci.c 6482 Now I'm disconnected from ORACLE
DbSl Trace: dbsloci.c 5158 Try to connect with default password
DbSl Trace: dbsloci.c 6538 Connecting as SAPR3/<pwd>@C11 on connection 0 ...
DbSl Trace: dboci.c 2404 -->oci_logon(con_hdl=0, user='SAPR3', dbname='C11')
DbSl Trace: dbsloci.c 6554 Now I'm connected to ORACLE
DbSl Trace: dbsloci.c 7581 Database instance c11 is running on SRV1 with ORACLE version 8.1.7.0.0 since 20030708
DbSl Trace: dbsloci.c 6464 Disconnecting from connection 0 ...
DbSl Trace: dboci.c 2356 -->oci_logoff(con_hdl=0)
DbSl Trace: dbsloci.c 6482 Now I'm disconnected from ORACLE
DbSl Trace: dbsloci.c 7344 ORA-1403 when accessing table SAPUSER
DbSl Trace: dbsloci.c 7344 ORA-1403 when accessing table SAPUSER
---------------------------------------------------------------------------------
---------------------------------------------------
trc file: "dev_disp", trc level: 1, release: "46D"
---------------------------------------------------
Tue Jul 08 11:32:26 2003
relno 4640
patchlevel 0
patchno 534
intno 0
pid 1244
***LOG Q00=> DpSapEnvInit, DPStart (00 1244) [dpxxdisp.c 877]
MtxInit: -2 0 0
MBUF state OFF
MBUF opmode USE
Tue Jul 08 11:32:27 2003
EmInit: MmSetImplementation( 2 ).
<ES> client 0 initializing ....
<ES> InitFreeList
<ES> block size is 1024 kByte.
Using implementation std
<ES> Memory Reset enabled as NT default
<EsNT> EsIUnamFileMapInit: Initialize the memory 768 MB
<ES> 767 blocks reserved for free list.
ES initialized.
***LOG Q0K=> DpMsAttach, mscon ( srv1) [dpxxdisp.c 7412]
MBUF set hwid_state to HWID_PENDING
CCMS: Initalizing shared memory of size 10000000 for monitoring segment.
CCMS: start to initalize 3.X shared alert area (first segment).
DpMsgAdmin: Set release to 4640, patchlevel 0
MBUF state PREPARED
MBUF component UP
MBUF set hwid_state to SAP_O_K (U0403887855 )
DpMsgAdmin: Set patchno for this platform to 534
Release check o.K.
Tue Jul 08 11:33:07 2003
*** ERROR => W0 (pid 2336) died [dpxxdisp.c 9544]
*** ERROR => W1 (pid 2332) died [dpxxdisp.c 9544]
*** ERROR => W2 (pid 2368) died [dpxxdisp.c 9544]
*** ERROR => W3 (pid 2316) died [dpxxdisp.c 9544]
*** ERROR => W4 (pid 2252) died [dpxxdisp.c 9544]
*** ERROR => W5 (pid 1352) died [dpxxdisp.c 9544]
*** ERROR => W6 (pid 2236) died [dpxxdisp.c 9544]
*** ERROR => W7 (pid 2508) died [dpxxdisp.c 9544]
*** ERROR => W8 (pid 2516) died [dpxxdisp.c 9544]
*** ERROR => W9 (pid 2524) died [dpxxdisp.c 9544]
*** ERROR => W10 (pid 2532) died [dpxxdisp.c 9544]
*** ERROR => W11 (pid 2540) died [dpxxdisp.c 9544]
*** ERROR => W12 (pid 2548) died [dpxxdisp.c 9544]
*** ERROR => W13 (pid 2556) died [dpxxdisp.c 9544]
*** ERROR => W14 (pid 2564) died [dpxxdisp.c 9544]
*** ERROR => W15 (pid 2572) died [dpxxdisp.c 9544]
*** ERROR => W16 (pid 2580) died [dpxxdisp.c 9544]
my types changed after wp death/restart 0x3f --> 0x0
*** ERROR => DpEnvCheck: no more work processes [dpxxdisp.c 11220]
Tue Jul 08 11:33:08 2003
***LOG Q0M=> DpMsDetach, ms_detach () [dpxxdisp.c 7617]
MBUF state OFF
MBUF component DOWN
***LOG Q05=> DpHalt, DPStop ( 1244) [dpxxdisp.c 6343]
-----------------------------------------------------------------------
---------------------------------------------------
trc file: "dev_rd", trc level: 1, release: "46D"
---------------------------------------------------
Tue Jul 08 11:32:28 2003
SemSpinning: 11674 usec for 481091 loops -> 41 loops per usec
***LOG S00=> GwInitReader, gateway started ( 2348) [gwxxrd.c 1471]
relno 4640
patchlevel 0
patchno 507
intno 0
pid 2348
Tue Jul 08 11:32:29 2003
Bind service sapgw00 to datagramm port 3300
Bind service sapgw00 (normal) to port 3300
GwPrintMyHostAddr: my host addresses are :
1 : [192.168.1.150] srv1
2 : [127.0.0.1] localhost
MtxInit: -2 0 0
Tue Jul 08 11:33:07 2003
*** ERROR => ShmDelete: Inv. Key=22 [shmnt.c 676]
*** ERROR => ShmCleanup: ShmDelete failed for Key: 22 [shmnt.c 747]
------------------------------------------------------------------------
---------------------------------------------------
trc file: "dev_w0", trc level: 1, release: "46D"
---------------------------------------------------
*
* ACTIVE TRACE LEVEL 1
* ACTIVE TRACE COMPONENTS all, M
*
B
B Tue Jul 08 11:32:28 2003
B create_con (con_name=R/3)
B Loading DB library 'E:\usr\sap\C11\SYS\exe\run\dboraslib.dll' ...
B
B Tue Jul 08 11:32:29 2003
B Library 'E:\usr\sap\C11\SYS\exe\run\dboraslib.dll' loaded
B Version of 'E:\usr\sap\C11\SYS\exe\run\dboraslib.dll' is '46D.00'
B New connection 0 created
M relno 4640
M patchlevel 0
M patchno 534
M intno 0
M pid 2336
M
M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 2336) [dpxxdisp.c 911]
I MtxInit: -2 0 0
X EmInit: MmSetImplementation( 2 ).
X <ES> client 0 initializing ....
X Using implementation std
M <ES> Memory Reset enabled
X ES initialized.
M ThSysUsrCheck: clear T0
M calling db_connect ...
B find_con found the following connection for reuse:
B 0: name = R/3, concnt= 000000 state = DISCONNECTED, perm = YES, reco = NO
C Got ORACLE_HOME=E:\oracle\ora81 from environment
C Got NLS_LANG=AMERICAN_AMERICA.WE8DEC from environment
C Logon as OPS$-user to get SAPR3's password
C Connecting as /@C11 on connection 0 ...
C
C Tue Jul 08 11:32:55 2003
C *** ERROR => OCI-call 'olog' failed: rc = 1092
[dboci.c 2423]
C *** ERROR => CONNECT failed with sql error '1092'
[dboci.c 6550]
C Try to connect with default password
C Connecting as SAPR3/<pwd>@C11 on connection 0 ...
C *** ERROR => OCI-call 'olog' failed: rc = 1092
[dboci.c 2423]
C *** ERROR => CONNECT failed with sql error '1092'
[dboci.c 6550]
C Got NLS_LANG=AMERICAN_AMERICA.WE8DEC from environment
C Logon as OPS$-user to get SAPR3's password
C Connecting as /@C11 on connection 0 ...
C *** ERROR => OCI-call 'olog' failed: rc = 1092
[dboci.c 2423]
C *** ERROR => CONNECT failed with sql error '1092'
[dboci.c 6550]
C Try to connect with default password
C Connecting as SAPR3/<pwd>@C11 on connection 0 ...
C *** ERROR => OCI-call 'olog' failed: rc = 1092
[dboci.c 2423]
C *** ERROR => CONNECT failed with sql error '1092'
[dboci.c 6550]
B ***LOG BY2=> sql error 1092 performing CON [dbsh 0695 ]
B ***LOG BY0=> [dbsh 0695 ]
B ***LOG BY2=> sql error 1092 performing CON [dblink 0627 ]
B ***LOG BY0=> [dblink 0627 ]
M ***LOG R19=> tskh_init, db_connect ( DB-Connect 000256) [thxxhead.c 1069]
M *** ERROR => tskh_init: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 7751]
M
M Info for wp 0
M
M stat = 4
M reqtype = 1
M act_reqtype = -1
M tid = -1
M mode = 255
M len = -1
M rq_id = -1
M rq_source = 255
M last_tid = 0
M last_mode = 0
M rfc_req = 0
M report = > <
M action = 0
M tab_name = > <
M
M *****************************************************************************
M *
M * LOCATION SAP-Server srv1_C11_00 on host srv1 (wp 0)
M * ERROR tskh_init: db_connect
M *
M * TIME Tue Jul 08 11:32:55 2003
M * RELEASE 46D
M * COMPONENT Taskhandler
M * VERSION 1
M * RC 13
M * MODULE thxxhead.c
M * LINE 7831
M * COUNTER 1
M *
M *****************************************************************************
M
M ***LOG Q02=> wp_halt, WPStop (Workproc 0 2336) [dpnttool.c 300]
-
Answer:
*** ERROR => OCI-call 'olog' failed: rc = 1092
[dboci.c 2423]
C *** ERROR => CONNECT failed with sql error '1092'
[dboci.c 6550]
meaning:
ORA-01092 Oracle instance terminated. Disconnection forced.
Cause: The instance this process was connected to was terminated abnormally (for example, from a shutdown abort). This process was forced to disconnect from the instance.
Action: When the instance has been restarted, retry action.
It looks like Oracle instance dies.....
investigate oracle's alert_SID.log
_________________
SapFans Moderator
NetWeaver ‘04–SAP Web AS for ORACLE certified
Search: /forums/search.php
SAP Notes: http://service.sap.com/notes
SAP Help: http://help.sap.com
Basic Rules: /forums/viewtopic.php?t=222759
Answer:
I did a search for alert_*.log
and I only forun alert_dg.log it was empty.