Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SAP & Database not starting

hii all,

when i start as sysdba oracle it generate error

<SQL*Plus: Release 10.2.0.2.0 - Production on Tue Oct 13 11:49:32 2009>

<Copyright (c) 1982, 2005, Oracle. All Rights Reserved.>

<ERROR:>

<ORA-01031: insufficient privileges>

<Enter user-name:>

and when start or stop lestner it say that

<c:\Documents and Settings\Administrator>lsnrctl start>

<LSNRCTL for 64-bit Windows: Version 10.2.0.2.0 - Production on 13-OCT-2009 11:38:21>

<Copyright (c) 1991, 2005, Oracle. All rights reserved.

Starting tnslsnr: please wait...

Service OracleDEV102TNSListener already running.

TNS-12560: TNS:protocol adapter error>

<C:\Documents and Settings\Administrator>lsnrctl stop

LSNRCTL for 64-bit Windows: Version 10.2.0.2.0 - Production on 13-OCT-2009 11:52:49

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=devsap)(PORT=1521)))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

64-bit Windows Error: 61: Unknown error>

C:\Documents and Settings\Administrator>

plz guide

regards

Imran

Former Member
replied

run SQL command

select username, account_status from dba_users;

it will show which are the users locked now.

then run

alter user <username> account unlock;

after you unlock , try restart SAP. SAP should start now

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question