Ocisessionbegin Error
Contents |
#528923] Thu, 27 October 2011 12:06 dba_7722 failed to connect to database instance ora 28001 the password has expired dbd error ocisessionbegin Messages: 197Registered: August 2010 Location: Delhi Senior
Ora-28000: The Account Is Locked (dbd Error: Ocisessionbegin)
Member Hi, I'm new to OEM. When login i'm getting error : ora-28001 the password has expired (dbd error ocisessionbegin) oracle 11g Details Failed to connect to database instance: ORA-28000: the account is locked (DBD ERROR: OCISessionBegin). I have checked DBCONSOLE
Ociserverattach
& AGENT are running properly. Please suggest. litening:/opt/oracle/product/11.2.0/bin>export ORACLE_SID=infoddp litening:/opt/oracle/product/11.2.0/bin>export ORACLE_HOME=/opt/oracle/product/11.2.0 litening:/opt/oracle/product/11.2.0/bin>export ORACLE_HOSTNAME=liteningv litening:/opt/oracle/product/11.2.0/bin>emctl status dbconsole Oracle Enterprise Manager 11g Database Control Release 11.2.0.2.0 Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved. http://liteningv:4300/em/console/aboutApplication Oracle Enterprise Manager 11g is enterprise manager is not able to connect to the database instance 11g running. ------------------------------------------------------------------ Logs are generated in directory /opt/oracle/product/11.2.0/liteningv_infoddp/sysman/log litening:/opt/oracle/product/11.2.0/bin>emctl status agent Oracle Enterprise Manager 11g Database Control Release 11.2.0.2.0 Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved. --------------------------------------------------------------- Agent Version : 10.2.0.4.3 OMS Version : 10.2.0.4.3 Protocol Version : 10.2.0.4.3 Agent Home : /opt/oracle/product/11.2.0/liteningv_infoddp Agent binaries : /opt/oracle/product/11.2.0 Agent Process ID : 4566 Parent Process ID : 4557 Agent URL : http://liteningv:4900/emd/main Repository URL : http://liteningv:4300/em/upload/ Started at : 2011-10-25 06:03:08 Started by user : oracle Last Reload : 2011-10-25 06:17:09 Last successful upload : 2011-10-27 13:01:21 Total Megabytes of XML files uploaded so far : 27.35 Number of XML files pending upload : 0 Size of XML files pending upload(MB) :
relating to ORACLE DATABASE Oracle Application Express 3.2 Oracle VirtualBox Oracle10gR2 Admin Admin Scripts Clone or Duplicate Data Guard and DR DATABASE
Ora-01017
AUDIT Datapump10g FLASHBACK Password RMAN10G Upgrade and Patching Oracle11gR2 Clone11g DB
Dbsnmp
or Duplicate Database Admin Database11g Install and Configure OCM for Oracle 11GR2 Oracle Utilities Oracle11gR2 Tuning RMAN11G oracle unlock user Oracle11gR2 GRID INFRA and ASM Oracle9i SQL SERVER DATABASE SQL SERVER 2008 R2 Welcome Archives July 2013 September 2012 June 2012 February 2012 January 2012 December 2011 November http://www.orafaq.com/forum/t/175976/ 2011 September 2011 August 2011 June 2011 May 2011 April 2011 March 2011 February 2011 January 2011 December 2010 October 2010 August 2010 July 2010 June 2010 May 2010 January 2010 APEX Apex from Oracle APEX OBE Inside Oracle Apex Blogroll WordPress.com WordPress.org Christian Amazing Facts Andrew Wommack Bill Johnson Insights of God JGLM JGLM Forum Joshua https://hendrydasan.wordpress.com/2010/06/23/failed-to-connect-to-database-instance-ora-28001-the-password-has-expired-dbd-error-ocisessionbegin/ Mills KOJ KOJ BLOG KOJ YOUTUBE Mark Hankins Online Parallel Bible Sid Roth XPMEDIA GENERAL Bankwest Centrelink Citibank Australia Dept of Immigration and Citizenship E-wire usage E-wire webmail GOOGLE Google Maps Mercer Wealth Soultions - Super oziCall Paypal Pennytel - Voip Transperth Vero Insurance NEWS ABC News Australian Australian-IT BOM - Weather Reuters SMH Business Oracle Websites My Oracle Support Online Demos Oracle 12c Oracle Downloads Oracle E-Delivery Oracle Technology Network oracle-database-11g-top-features Oracle10g Online Doc Oracle11g OBE Oracle11g Online Doc Oracle10g from Oracle RMAN10g Commands Oracle11g from Oracle Oracle11g ASM SQL SERVER Websites MSSQL Tips Meta Register Log in Subscribe Entries (RSS) Comments (RSS) « Application Client Failover and DRTest Change Admin password inApex » Failed to connect to database instance: ORA-28001: the password has expired (DBD ERROR: OCISessionBegin). Posted by Hendry chinnapparaj on June 23, 2010 Oracle Enterprise Manager 10g Grid Control Alert MessageFailed to connect to database instance: ORA-28001: the password has expired (DBD ERROR: OCISessionBegin). SQL> select username, account_status from dba_users where username='DBSNMP'; USERNAME ACCOUNT_STATUS -------------------
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack http://stackoverflow.com/questions/19663821/sqlstatehy000-ocisessionbegin-ora-21561-oid-generation-failed Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community https://support.software.dell.com/shareplex/kb/15071 of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up SQLSTATE[HY000]: OCISessionBegin: ORA-21561: OID generation failed up vote 7 down vote favorite I'm receiving the following error dbd error when trying to do a PDO OCI SQL query on one of my web servers: SQLSTATE[HY000]: OCISessionBegin: ORA-21561: OID generation failed I've confirmed that the Oracle server is accessible from the machine and network configuration looks fine. Google returns very few, and not very helpful results. Has anyone else run into this, or have any suggestions on how to resolve? php oracle pdo oci share|improve this question asked Oct 29 '13 to connect to at 16:21 Camden S. 1,10111021 1 could you show PDO constructor params and tnsnames.ora (check if hostnames are same in both places) –ziollek Oct 29 '13 at 16:41 I actually just thought to bypass PDO altogether and just use OCI, and received a more helpful error message which led to a quick solution -- sorry for the trouble. I'll post my findings as answer in case it helps anyone else. –Camden S. Oct 29 '13 at 16:46 add a comment| 2 Answers 2 active oldest votes up vote 10 down vote I was facing the same issue. I was trying to connect to database on my localhost. This is how I solved it. Get the hostname > hostname localhost.idc.company.com Add this name to /etc/hosts file 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 localhost.idc.company.com share|improve this answer edited May 2 at 8:27 kiamlaluno 15.3k124876 answered Jan 24 '14 at 11:56 Mustafa Hussain 334411 Adding the hostname to the /etc/hosts file for localhost also worked for me, even though I was connecting to a remote Oracle server. So even if you've got a remote server, try this fix. –Tim Holt May 25 at 17:24 add a comment| up vote 1 down vote accepted I decided to forego the use of PDO an