on 10-22-2008 5:37 AM
Hi
We have planned to homogenous copy of our APO 3.1. So we have installed windows 2003 32 bit server. and installed software and central instance. and successfully restored the database also.
now when we try to connect to the database it hangs
when we tried in command prompt it could login as
sqlplus "/as sysdba" bu it does not able to login as
sqlplus /@APP or sqlplus sapr3/sap@APP these two methods of connecting it fails. if we start the sap in mmc ity hangs and the dev_w0 details as follows
-
trc file: "dev_w0", trc level: 1, release: "46D"
-
*
ACTIVE TRACE LEVEL 1
ACTIVE TRACE COMPONENTS all, M
*
B
B Tue Oct 21 14:59:14 2008
B create_con (con_name=R/3)
B Loading DB library 'F:\usr\sap\APP\SYS\exe\run\dboraslib.dll' ...
B Library 'F:\usr\sap\APP\SYS\exe\run\dboraslib.dll' loaded
B Version of library 'F:\usr\sap\APP\SYS\exe\run\dboraslib.dll' is "46D.00", patchlevel (0.2311)
B New connection 0 created
M relno 4640
M patchlevel 0
M patchno 2415
M intno 0
M pid 3820
M
M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 3820) [dpxxdisp.c 976]
I MtxInit: -2 0 0
I *** ERROR => New Process with the same PID
[semnt.c 1513]
I *** ERROR => New Process with the same PID
[semnt.c 1513]
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 ...
C Got NLS_LANG=AMERICAN_AMERICA.WE8DEC from environment
C Logon as OPS$-user to get SAPR3's password
C Connecting as /@APP on connection 0 ... (dbsl BIN 150808)
then it hangs . p
please check whether is there nay things to be checked.
regards
bala
Hi
Error resolved.
This is bcoz of service error.
regards
bala
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
dear experts
Thanks for the prompt reply.
I have already done the OPS$ note and recreated the users. and moreover the user is already in the ORA_DBA and ORA_APP_DBA group.
it is able to login with sqlplus "/as sysdba" but not with
sqlplus /@APP or sqlplus sapr3/sap@APP it hangs.
for an sample i have created a database in this server thro dbca where i could able to login with sqlplus @APP1 .
please check
regards
bala
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi Bala,
it is a problem with the OPS$ user. Check notes 50088
and run the scripts attached to it oradbusr.sql and sapdba_role.sql.
regards / Jay
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Actually the error is flashed is nothing we have restarted the server then also it hanged the log is
-
trc file: "dev_w0", trc level: 1, release: "46D"
-
*
ACTIVE TRACE LEVEL 1
ACTIVE TRACE COMPONENTS all, M
*
B
B Tue Oct 21 11:56:20 2008
B create_con (con_name=R/3)
B Loading DB library 'F:\usr\sap\APP\SYS\exe\run\dboraslib.dll' ...
B Library 'F:\usr\sap\APP\SYS\exe\run\dboraslib.dll' loaded
B Version of library 'F:\usr\sap\APP\SYS\exe\run\dboraslib.dll' is "46D.00", patchlevel (0.2311)
B New connection 0 created
M relno 4640
M patchlevel 0
M patchno 2415
M intno 0
M pid 396
M
M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 396) [dpxxdisp.c 976]
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 ...
C Got NLS_LANG=AMERICAN_AMERICA.WE8DEC from environment
C Logon as OPS$-user to get SAPR3's password
C Connecting as /@APP on connection 0 ... (dbsl BIN 150808)
M
regards
bala
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
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.