cancel
Showing results for 
Search instead for 
Did you mean: 

SAP is connecting to Database

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi

Error resolved.

This is bcoz of service error.

regards

bala

Former Member
0 Kudos

Hi, i have same problem. can you tell me how can you fix it?

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi ,

Do you get Time Out when you connect via sapr3 or APP1.

check your tnsnames.ora & listener.ora files.

check whether you are able to do tnsping.

Warm Regards

Sujith

Former Member
0 Kudos

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

Former Member
0 Kudos

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

debasissahoo
Active Contributor
0 Kudos

Hi,

Please cross check, if the user you're logging to the database with (I assume you are doing with <sid>adm)

this user must be a part of group ORA_<DBSID>_DBA or ORA_DBA. to have the sqplus "/as sysdba" work.

Regards,

Debasis.