BASIS GURU

CONCEPTS | BASICS | HOWTO

  • Home
  • SAP
    • SAP BASIS
    • SAP SOLMAN
    • SAP SECURITY
  • DATABASE
    • ORACLE
    • SAP HANA
    • SAP ASE
    • MSSQL
  • OPERATING SYSTEM
    • WINDOWS
    • LINUX-UNIX
  • SAP ON CLOUD

2EETW169 no connect possible: “DBMS = ORACLE— dbs_ora_tnsname

admin DATABASE, ORACLE 0

www.basisguru.com

Today we will discuss about the issue during the oracle database startup.

Symptoms For Error 2EETW169 no connect possible:

Oracle doesn’t start & R3trans -d throws error as

“No connect possible

2EETW169 no connect possible: “DBMS = ORACLE— dbs_ora_tnsname = ‘DEV'”

Solution:

We analyzed many logs and few of the steps we performed to rectify the issue are as below:

  • We have checked listener which was working fine
  • Checked if the database is in open state.
  • Finally, when we checked the dev_W* logs which is showing the below that it is due to locking of user account SAPDEV:
CONNECT failed with sql error ‘28000’
ORA-28000 account is locked
  • We checked if any database user was locked using the query:
Select username,ACCOUNT_STATUS from dba_users;
Account locked

Here SAPDEV user was locked, oracle unlock account should be performed to solve the issue using the command:

SQL> alter user <USER> account unlock;
<USER>=SAPDEV in our case

Reason and Prerequisites for 2EETW169 no connect possible:

what is ORA-28000 and when it occurs?

There are two situations when your account could be locked and to get ORA-28000 error.

  • Failed Login Attempts:

Default profile in oracle Database Management Software has 10 failed login attempts and after that it locks the user account. So, need to unlock this.

SQL> select * from dba_profiles where resource_name like 'FAILED_LOGIN_ATTEMPTS%';

Results:

PROFILERESOURCE_NAMERESOURCELIMIT
DEFAULTFAILED_LOGIN_ATTEMPTSPASSWORD10
MONITORING_PROFILEFAILED_LOGIN_ATTEMPTSPASSWORDUNLIMITED
  • New Database Creation:

When you create a new database all default accounts are “EXPIRED & LOCKED” except SYS and SYSTEM. So, you need to unlock and change password to use them.

SQL> select username,account_status from dba_users;

USERNAME                       ACCOUNT_STATUS
------------------------------ --------------------------------
SYS                              OPEN
SYSTEM                           OPEN
SAPDEV                           EXPIRED & LOCKED
OUTLN                            EXPIRED & LOCKED

Related posts:

  1. ORACLE Central Inventory Is Corrupted
  2. RMAN – Check Oracle Database Consistency
  3. SAP Web dispatcher does not work on Linux operating system
  4. Using SAP BRTOOLS Add Datafile To Oracle Database
  5. Oracle Index Rebuilding Using BRtools
  6. How To Set NLS_DATE_FORMAT Parameter In Oracle
  7. How To Find SCN From Timestamp in Oracle
  8. How To Set a New Password For SA Account In SAP ASE
  9. Unlock SAP User At Database Level
  • ora 28000 account is locked
  • oracle unlock account
  • oracle unlock user
www.basisguru.comPrevious

LZPL driver does not support SAPscript

LINUX_www.basisguru.comNext

SAP Web dispatcher does not work on Linux operating system

Recent Posts

  • CVE-2021-21465 Multiple vulnerabilities in SAP Business Warehouse (Database Interface)
  • SAP Security Updates For The Browser Control Google Chromium
  • SAP HANA Upgrade
  • LDAPRC 004 Error Maximum Number Of Find Results Exceeded
Quick Links
  • About Us
  • Contact Us
  • Privacy Policy
  • Disclaimer
Recent Posts
  • CVE-2021-21465 Multiple vulnerabilities in SAP Business Warehouse (Database Interface)
  • SAP Security Updates For The Browser Control Google Chromium
  • SAP HANA Upgrade
  • LDAPRC 004 Error Maximum Number Of Find Results Exceeded

Copyright © 2021 | WordPress Theme by MH Themes