SAP & Database not starting

[Former Member]

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_member227283 · Accepted solution]

Hi imran,

Pls paste the enviroment varibale which is set to user devadm.

Also check DBA role is set on OS level for user devadm

Thanks

Anil

Edited by: Anil Bhandary on Oct 13, 2009 11:00 AM

[Former Member · Accepted solution]

enviroment variable are

DBMS_TYPE = ora

dbs_ora_schema = sapSR3

dbs_ora_tnsname=DEV

JAVA_HOME = C:\j2sdk1.4.2_09

ORACLE_HOME = E:\oracle\DEV\102

ORACLE_SID = DEV

PATH = G:\usr\sap\DEV\SYS\exe\uc\NTAMD64

SAPDATA_HOME = G:\oracle\DEV

SAPEXE=G:\usr\sap\DEV\SYS\exe\uc\NTAMD64

SAPLOCALHOST=devsap

TNS_ADMIN = G:\usr\sap\DEV\SYS\profile\oracle

devadm is member of

administrators

backup operator

ora_dba

ora_dev_dba

ora_dev_oper

sap_dev_globaladmin

sap_dev_localadmin

sap_localadmin

users

regards

Imran

[anindya_bose · Accepted solution]

Imran

Go to your ORACLE_HOME/NETWORK/ADMIN directory.. Check the file SQLNET.ORA

Does it contain a entry like below

SQLNET.EXPIRE_TIME = 0

SQLNET.AUTHENTICATION_SERVICES = (NTS)

TCP.NODELAY=YES

IF not, then please take a backup of the sqlnet.ora and change the entry as above. Try to login with SIDADM again

[Former Member · Accepted solution]

tns ping results

Microsoft Windows [Version 5.2.3790]

(C) Copyright 1985-2003 Microsoft Corp.

C:\Documents and Settings\Administrator>tnsping DEV

TNS Ping Utility for 64-bit Windows: Version 10.2.0.2.0 - Production on 13-OCT-2009 15:58:15

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

Used parameter files:

G:\usr\sap\DEV\SYS\profile\oracle\sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP.WORLD)(PROTOCOL = TCP)(HOST = devsap)(PORT = 1527))) (CONNECT_DATA = (SID = DEV) (GLOBAL_NAME = DEV.WORLD)))

OK (40 msec)

C:\Documents and Settings\Administrator>

also set parameter as said but error is same

[Former Member · Accepted solution]

thanks

database has been started wrongly edit G:\usr\sap\DEV\SYS\profile\oracle\tnsname.ora

but still sap not starting in syslog

SAP-Basis System: Initialization DB-Connect Failed, Return Code 000256

Communications data: SAP gateway was closed

SAP-Basis System: Stop Workproc 3, PID 1724

Database: > ORA-28000: the account is locked

plz guide

[anindya_bose · Accepted solution]

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

[Former Member · Accepted solution]

Refer to Note 951167 - ORA-28000: the account is locked

[former_member227283]

Hi Imran,

Nice to see your that problem resolved.

For SAP start problem.

Solution :- Goto sqlplus with sysdba & unlock the scheme user

sqlplus "/as sysdba"

sqlplus > alter user SAPSR3 account unlock.

Thanks

Anil

[former_member524429]

Dear Imran,

Please refer

[ Note 480266 - Problems with the SYSDBA/SYSOPER/INTERNAL connect|https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=480266]

[Note 441518 - ORA-12560 composite SAP Note|https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=441518]

[Note 175636 - cannot startup Oracle (with no/meaningless error(s))|https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=175636]

When you connect as sysdba with Database, the system checks whether the calling operating system user belongs to ORA_<sid>_DBA operating system group. If so, the user logs on with comprehensive SYSDBA privileges. If not, the system prompts the user to enter a password and then issues ORA-01017 or ORA-01031.

Make sure that ora_<SID>_dba & ora_<SID>_oper groups are created. and user <SID>adm is a member of both groups and user sapservice<SID> is included in the group ora_<SID>_oper.

Have you tired to restart the tnslistner service manually ? Is it starting normally ?

Regards,

Bhavik G. Shroff

[markus_doehr2]

What happened prior to this error? was the system working before? Did you do some changes to the system?

Markus

[former_member227283]

Hi Imram,

Did you made any changes in system, where after you are getting error ???

Pls add the parameter as mention my BOSE earlier .

in file sqlnet.ora which is present in 2 location

<drive:\ >oracle\DEV\102\NETWORK\ADMIN\sqlnet.ora

&

G:\usr\sap\DEV\SYS\profile\oracle\sqlnet.ora

Both location sqlnet.ora should be in sync

after syncing both try again.

Thanks

Anil

Edited by: Anil Bhandary on Oct 13, 2009 12:16 PM

[former_member227283]

Hi Imran,

Login on OS with user devadm & run following command.

tnsping DEV

Pls paste the log in form.

Thanks

Anil

[former_member227283]

Hi imaran,

You get all this error because you doing all the activity through administrator user id

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

Try all the activities through sap user SIDADM i.e in your scenario , you have to login in OS with user devadm and carry on the activity ... it should work.

Thanks

Anil

[Former Member]

hi,

i login with SIDadm , it is just showing administrator , actually this is SID adm user

there is some diff. problem that generating the errors

Best Regards

Khan