Question:
dear sap gurus....
after upgrading my database from 8.0.6 to 8.1.7....i got an error starting sap....i cudnt connect to r3.....after going through errors i noted that most probably i will have to drop and recreate my schema for ops$ that is, my database instance name is jer and my sap instance name is tom. So my sap username is supposed to be tomadm but while i check to initialize sap connect thru sapdba it says my sapr3 user is jeradm and it says to drop and recreate the schema ops$jeradm. But my sap admin name is tomadm. So how did this happen.... here is log of one of my work process
---------------------------------------------------
trc file: "dev_w9", trc level: 1, release: "46D"
---------------------------------------------------
*
* ACTIVE TRACE LEVEL 1
* ACTIVE TRACE COMPONENTS all, M
*
B
B Sat Apr 29 12:13:34 2006
B create_con (con_name=R/3)
B Loading DB library 'D:\usr\sap\TOM\SYS\exe\run\dboraslib.dll' ...
B Library 'D:\usr\sap\TOM\SYS\exe\run\dboraslib.dll' loaded
B Version of 'D:\usr\sap\TOM\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 1124
M
M ***LOG Q0Q=> tskh_init, WPStart (Workproc 9 1124) [dpxxdisp.c 911]
I MtxInit: -2 0 0
X
X Sat Apr 29 12:13:35 2006
X EmInit: MmSetImplementation( 2 ).
X <ES> client 9 initializing ....
X Using implementation std
M <ES> Memory Reset enabled
X ES initialized.
M ThSysUsrCheck: clear T9
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 Found ORACLE_HOME=D:\orant in Registry
C Got NLS_LANG=AMERICAN_AMERICA.WE8DEC from environment
C Logon as OPS$-user to get SAPR3's password
C Connecting as /@JER on connection 0 ...
C
C Sat Apr 29 12:13:47 2006
C *** ERROR => OCI-call 'olog' failed: rc = 1017
[dboci.c 2423]
C *** ERROR => CONNECT failed with sql error '1017'
[dboci.c 6550]
C Try to connect with default password
C Connecting as SAPR3/<pwd>@JER on connection 0 ...
C *** ERROR => OCI-call 'olog' failed: rc = 1017
[dboci.c 2423]
C *** ERROR => CONNECT failed with sql error '1017'
[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 /@JER on connection 0 ...
C
C Sat Apr 29 12:13:48 2006
C *** ERROR => OCI-call 'olog' failed: rc = 1017
[dboci.c 2423]
C *** ERROR => CONNECT failed with sql error '1017'
[dboci.c 6550]
C Try to connect with default password
C Connecting as SAPR3/<pwd>@JER on connection 0 ...
C *** ERROR => OCI-call 'olog' failed: rc = 1017
[dboci.c 2423]
C *** ERROR => CONNECT failed with sql error '1017'
[dboci.c 6550]
B ***LOG BY2=> sql error 1017 performing CON [dbsh 0695 ]
B ***LOG BY0=> [dbsh 0695 ]
B ***LOG BY2=> sql error 1017 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 9
M
M stat = 4
M reqtype = 4
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 max_TOM_00 on host max (wp 9)
M * ERROR tskh_init: db_connect
M *
M * TIME Sat Apr 29 12:13:48 2006
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 9 1124) [dpnttool.c 300]
I wud like to know how can we recreate ops$ schema
I hope someone wud help me ......please snowy see to this if u can...
Your valauble suggestions are appreciated....
regards ,
kurian
Answer:
This is a Basis question, not a SAP Security question...
_________________
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