error in sapmmc

hai all,

i started and refershed the sapmmc console but there was an error showing in wp table and process in the process list is stopped plz help me to solve this problem.

SAP Managed Tags:
NW AS Java Administrator (NWA)

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (1)

Can you please check whether your database is running or not.

or else you can check whether LISTENER is running or not.

If not please start LISTENER from SERVICES.MSC from RUN.

or from command prompt

c:\> LSNRCTL

LSNRCTL> start

and check whether database is started or not at this stage.

goto command prompt

c:\> sqlplus "/as sysdba"

sql> startup

then try to start your SAPMMC.

Thanks and regards

Khurshid

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

plz help me.

Hi,

Please confirm whether your database and listner is running or not.If not as Khurshid Ahmed says you have to start the databse and listener and then try.

Thanks,

Satyabrat

i followed the steps but in sqlplus "/as sysdba"

sql>startup command i got the message

cannot start already- running ORACLE - shut it down first

wat cani do now i wil shut it down and re type the startup

reply me as soon plz.

Hi pugazh raj

Execute

shutdown immediate

startup

execute command r3trans -d in a new command prompt and paste the generated log file trans.log here.

Regards

Ashok

Edited by: Ashok Dalai on Sep 29, 2008 2:30 PM

where to find the generated log file trans.log? plz tell me

Tue Sep 30 09:29:05 2008

Shutting down instance (normal)

License high water mark = 2

Tue Sep 30 09:29:05 2008

ALTER DATABASE CLOSE NORMAL

ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...

archiving is disabled

Tue Sep 30 09:29:08 2008

ARCH shutting down

ARC0: Archival stopped

Starting up ORACLE RDBMS Version: 8.1.7.0.0.

System parameters with non-default values:

processes = 80

sessions = 96

timed_statistics = TRUE

shared_pool_size = 170917888

shared_pool_reserved_size= 17091788

enqueue_resources = 8000

control_files = E:\oracle\DRS/saparch/cntrl\cntrlDRS.dbf, E:\oracle\DRS/sapdata1/cntrl\cntrlDRS.dbf, E:\oracle\DRS\origlogA\/cntrl\cntrlDRS.dbf

db_block_buffers = 31296

db_block_size = 8192

compatible = 8.1.6

log_archive_start = TRUE

log_archive_dest = E:\oracle\DRS/oraarch/DRSarch

log_buffer = 1048576

log_checkpoint_interval = 300000

log_checkpoint_timeout = 0

db_files = 254

db_file_multiblock_read_count= 32

log_checkpoints_to_alert = TRUE

control_file_record_keep_time= 30

dml_locks = 2500

transactions_per_rollback_segment= 20

max_rollback_segments = 400

rollback_segments = PRS_0, PRS_1, PRS_10, PRS_11, PRS_12, PRS_13, PRS_14, PRS_15, PRS_16, PRS_17, PRS_18, PRS_19, PRS_2, PRS_3, PRS_4, PRS_5, PRS_6, PRS_7, PRS_8, PRS_9

transaction_auditing = FALSE

remote_os_authent = TRUE

sort_area_size = 2097152

sort_area_retained_size = 0

db_name = DRS

open_cursors = 800

optimizer_mode = choose

optimizer_index_cost_adj = 10

hash_join_enabled = FALSE

background_dump_dest = E:\oracle\DRS/saptrace/background

user_dump_dest = E:\oracle\DRS/saptrace/usertrace

core_dump_dest = E:\oracle\DRS/saptrace/background

PMON started with pid=2

DBW0 started with pid=3

LGWR started with pid=4

CKPT started with pid=5

SMON started with pid=6

RECO started with pid=7

Tue Sep 30 09:29:23 2008

ARCH: STARTING ARCH PROCESSES

ARC0 started with pid=8

ARC0: Archival started

Tue Sep 30 09:29:23 2008

ARCH: STARTING ARCH PROCESSES COMPLETE

Tue Sep 30 09:29:23 2008

ALTER DATABASE MOUNT

Tue Sep 30 09:29:28 2008

Successful mount of redo thread 1, with mount id 54045752.

Tue Sep 30 09:29:28 2008

Database mounted in Exclusive Mode.

Completed: ALTER DATABASE MOUNT

Tue Sep 30 09:29:28 2008

ALTER DATABASE OPEN

ARCH: Beginning to archive log# 3 seq# 1159

ARCH: Error 19504 creating archivelog file 'E:\ORACLE\DRS\ORAARCH\DRSARCHARC01159.001'

ARCH: Archiving not possible: error count exceeded

ARCH: Failed to archive log# 3 seq# 1159

ORA-16014 signalled during: ALTER DATABASE OPEN...

Tue Sep 30 09:37:10 2008

Shutting down instance (immediate)

License high water mark = 2

Tue Sep 30 09:37:10 2008

ALTER DATABASE CLOSE NORMAL

ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...

Tue Sep 30 09:37:10 2008

ALTER DATABASE DISMOUNT

Completed: ALTER DATABASE DISMOUNT

archiving is disabled

Tue Sep 30 09:37:14 2008

ARCH shutting down

ARC0: Archival stopped

Starting up ORACLE RDBMS Version: 8.1.7.0.0.

System parameters with non-default values:

processes = 80

sessions = 96

timed_statistics = TRUE

shared_pool_size = 170917888

shared_pool_reserved_size= 17091788

enqueue_resources = 8000

control_files = E:\oracle\DRS/saparch/cntrl\cntrlDRS.dbf, E:\oracle\DRS/sapdata1/cntrl\cntrlDRS.dbf, E:\oracle\DRS\origlogA\/cntrl\cntrlDRS.dbf

db_block_buffers = 31296

db_block_size = 8192

compatible = 8.1.6

log_archive_start = TRUE

log_archive_dest = E:\oracle\DRS/oraarch/DRSarch

log_buffer = 1048576

log_checkpoint_interval = 300000

log_checkpoint_timeout = 0

db_files = 254

db_file_multiblock_read_count= 32

log_checkpoints_to_alert = TRUE

control_file_record_keep_time= 30

dml_locks = 2500

transactions_per_rollback_segment= 20

max_rollback_segments = 400

rollback_segments = PRS_0, PRS_1, PRS_10, PRS_11, PRS_12, PRS_13, PRS_14, PRS_15, PRS_16, PRS_17, PRS_18, PRS_19, PRS_2, PRS_3, PRS_4, PRS_5, PRS_6, PRS_7, PRS_8, PRS_9

transaction_auditing = FALSE

remote_os_authent = TRUE

sort_area_size = 2097152

sort_area_retained_size = 0

db_name = DRS

open_cursors = 800

optimizer_mode = choose

optimizer_index_cost_adj = 10

hash_join_enabled = FALSE

background_dump_dest = E:\oracle\DRS/saptrace/background

user_dump_dest = E:\oracle\DRS/saptrace/usertrace

core_dump_dest = E:\oracle\DRS/saptrace/background

PMON started with pid=2

DBW0 started with pid=3

LGWR started with pid=4

CKPT started with pid=5

SMON started with pid=6

RECO started with pid=7

Tue Sep 30 09:37:26 2008

ARCH: STARTING ARCH PROCESSES

ARC0 started with pid=8

ARC0: Archival started

Tue Sep 30 09:37:27 2008

ARCH: STARTING ARCH PROCESSES COMPLETE

Tue Sep 30 09:37:27 2008

ALTER DATABASE MOUNT

Tue Sep 30 09:37:31 2008

Successful mount of redo thread 1, with mount id 54061595.

Tue Sep 30 09:37:31 2008

Database mounted in Exclusive Mode.

Completed: ALTER DATABASE MOUNT

Tue Sep 30 09:37:31 2008

ALTER DATABASE OPEN

ARCH: Beginning to archive log# 3 seq# 1159

ARCH: Error 19504 creating archivelog file 'E:\ORACLE\DRS\ORAARCH\DRSARCHARC01159.001'

ARCH: Archiving not possible: error count exceeded

ARCH: Failed to archive log# 3 seq# 1159

ORA-16014 signalled during: ALTER DATABASE OPEN...

Try to read Note 391 - Archiver stuck

Regards.

hai Khurshid Ahmed ,

thank u man.i followed the commands and now there is no error in sapmmc.now its working perfectly.

Answers (3)

thank u all.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

hai experts,

thank u all for supporting and helping me to solve the problem.

regards,

pugazh.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Raj,

paste dev_w0 here

Regards

Ashok

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

trc file: "dev_w0", trc level: 1, release: "620"

ACTIVE TRACE LEVEL 1
ACTIVE TRACE COMPONENTS all, M

B Fri Sep 26 12:37:49 2008

B create_con (con_name=R/3)

B Loading DB library 'E:\usr\sap\DRS\SYS\exe\run\dboraslib.dll' ...

B Library 'E:\usr\sap\DRS\SYS\exe\run\dboraslib.dll' loaded

B Version of 'E:\usr\sap\DRS\SYS\exe\run\dboraslib.dll' is "620.02", patchlevel (0.112)

B New connection 0 created

M systemid 560 (PC with Windows NT)

M relno 6200

M patchlevel 0

M patchno 251

M intno 20020600

M pid 2112

M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 2112) [dpxxdisp.c 1016]

I MtxInit: -2 0 0

X Fri Sep 26 12:37:58 2008

X EmInit: MmSetImplementation( 2 ).

X <ES> client 0 initializing ....

X Fri Sep 26 12:37:59 2008

X Using implementation std

M <EsNT> Memory Reset enabled as NT default

X ES initialized.

M Fri Sep 26 12:38:01 2008

M calling db_connect ...

C Got ORACLE_HOME=E:\oracle\ora81 from environment

C Client NLS settings: AMERICAN_AMERICA.WE8DEC

C Logon as OPS$-user to get SAPDRS's password

C Connecting as /@DRS on connection 0 ...

C Attaching to DB Server DRS (con_hdl=0,svchp=069EA5E8,svrhp=069EA3F4)

C Starting user session (con_hdl=0,svchp=069EA5E8,srvhp=069EA3F4,usrhp=06A2B71C)

C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1033

[dboci.c 3718]

C *** ERROR => CONNECT failed with sql error '1033'

[dboci.c 9536]

C Try to connect with default password

C Connecting as SAPDRS/<pwd>@DRS on connection 0 ...

C Starting user session (con_hdl=0,svchp=069EA5E8,srvhp=069EA3F4,usrhp=06A2B71C)

C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1033

[dboci.c 3718]

C *** ERROR => CONNECT failed with sql error '1033'

[dboci.c 9536]

B ***LOG BV3=> severe db error 1033 ; work process is stopped [dbsh#2 @ 957] [dbsh 0957 ]

B ***LOG BY2=> sql error 1033 performing CON [dblink#1 @ 419] [dblink 0419 ]

B ***LOG BY0=> ORA-01033: ORACLE initialization or shutdown in progress [dblink#1 @ 419] [dblink 0419 ]

M ***LOG R19=> tskh_init, db_connect ( DB-Connect 000256) [thxxhead.c 1098]

M in_ThErrHandle: 1

M *** ERROR => tskh_init: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 8277]

M Info for wp 0

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 * LOCATION SAP-Server erp_DRS_00 on host erp (wp 0)

M * ERROR tskh_init: db_connect

M *

M * TIME Fri Sep 26 12:38:01 2008

M * RELEASE 620

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 8408

M * COUNTER 1

M *

M *****************************************************************************

M Entering TH_CALLHOOKS

M ThCallHooks: call hook >SAP-Trace buffer write< for event BEFORE_DUMP

M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 672]

M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 235]

M Entering ThSetStatError

M Entering ThReadDetachMode

M call ThrShutDown (1)...

M ***LOG Q02=> wp_halt, WPStop (Workproc 0 2112) [dpnttool.c 345]

Hi Raj,

Check this note

Note 655240 - Composite SAP note: ORA-01033

Regards

Ashok

Hi,

Check out the SNote 34432 which depicts about the error " DB-Connect 000256 " during sapstart.

Note suggests to Increase the parameters 'processes'

and 'sessions' by 50% in the profile

/oracle/<SID>/dbs/init<SID>.ora. and restart the database.

Hope it help you out.

Rgds

Ashok

Ask a Question

Top Q&A Solution Author

User

Count

error in sapmmc

Accepted Solutions (1)

Accepted Solutions (1)

Answers (3)

Answers (3)

Re: Mass Update a Zfield in Std Table with Split &...

Re: Deploy failed. Detail: Request failed with sta...

Re: CAP Autentication error

Re: How to make a REST "PUT" call to a dynamic url...

Re: Allocation of multiple hierarchies from parent...