Oracle Dbd Error Ocisessionbegin
Contents |
friend Failed to connect to database instance (DBD ERROR: OCISessionBegin) [message #276898] Fri, 26 October 2007 12:42 masoodnt10 Messages: 5Registered: October 2007 Junior Member I'm trying to connect to remote database from oracle enterprise manager ; the connection is going fine perl dbi oracle service name but when i try to connect to a database xyz it's giving error like ora-01017: invalid username/password; logon denied (dbd error: ocisessionbegin) shown below... Failed to connect to database instance: ORA-28000: the account is locked (DBD ERROR: OCISessionBegin)... Report message to a moderator
Perl Oracle Connection Example
Re: Failed to connect to database instance (DBD ERROR: OCISessionBegin) [message #276899 is a reply to message #276898] Fri, 26 October 2007 12:47 BlackSwan Messages: 24958Registered: January 2009 Location: SoCal Senior Member Alternatively
Perl Connect To Oracle Database Example
you could use a schema that is not locked. Report message to a moderator Re: Failed to connect to database instance (DBD ERROR: OCISessionBegin) [message #276900 is a reply to message #276898] Fri, 26 October 2007 12:51 masoodnt10 Messages: 5Registered: October 2007 Junior Member Can you please write a bit detail how can i use a schema alternatively. On one of my server there is a database xyz, I perl dbd oracle want to backup that database from oracle enterprise manager, I've tried system/manager but getting the above mentioned error... it would be nice if you can write detail, how to solve this issue. Report message to a moderator Re: Failed to connect to database instance (DBD ERROR: OCISessionBegin) [message #276929 is a reply to message #276900] Sat, 27 October 2007 01:08 Mohammad Taj Messages: 2412Registered: September 2006 Location: Dubai, UAE Senior Member Please check...sysman or dbsnmp user schema is locked or not ??? if it is locked then please unlock first alter user SYSMAN account unlock; alter user DBSNMP account unlock; Please Keep in mind don't change SYSMAN password directly.otherwise you have to reconfigure OEM respository. If you want to change SYSMAN password then use below procedure. http://dbataj.blogspot.com/2007/07/change-sysman-password.html Regards Taj [Updated on: Sat, 27 October 2007 01:08]Report message to a moderator Previous Topic: Enterprise Manager 10gR2: exit codes and dependencies Next Topic: Oracle 10g Installation on Windows XP Goto Forum: - SQL & PL/SQLSQL & PL/SQLClient Tools- RDBMS ServerServer AdministrationBackup & RecoveryPerformance TuningSecurityNetworking and GatewaysEnterprise ManagerServer Utilities- Server OptionsRAC & FailsafeData GuardReplicationStreams & AQSpatialText & interMedia- Developer & ProgrammerApplication Express, ORDS & MOD_PLSQLFormsReports & DiscovererDesignerJDeveloper, Java & XMLWarehouse BuilderPrecompilers, OCI & OCCI- Fusion Middleware & Colab Su
CoolUsesForPerl PerlNews Q&A Tutorials Poetry RecentThreads NewestNodes Donate What'sNew on Aug 05, 2009 at 09:28UTC ( #786017=perlquestion: print w/replies, xml ) Need Help?? laminee has asked for the wisdom of the Perl Monks concerning the following question: Hi Monks, I am trying to replicate the sqlplus '/as sysdba' connection using DBI and DBD::Oracle by following the guidelines from http://search.cpan.org/~pythian/DBD-Oracle-1.23/Oracle.pm#Connect_Attributes. My tnsnames.ora is like this: #Generated tnsnames.ora by gen_tnsnames.sh script #Localnode service connectivity ABCD12.COMPANYDOMAIN.COM = (DESCRIPTION = http://www.orafaq.com/forum/t/91610/ (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = testserver24.companydomain.co +m )(PORT = 30710)) ) (CONNECT_DATA = (INSTANCE_NAME = ABCD12) (SERVICE_NAME = ABCD12.COMPANYDOMAIN.COM) ) ) [download] and I have no problem connecting with the usual sqlplus '/as sysdba'. I am doing the following in my script: use DBI; use DBD::Oracle qw(:ora_session_modes); my http://www.perlmonks.org/?node_id=786017 $dsn = "dbi:Oracle:"; #$ENV{ORACLE_SID} = "ABCD12"; $ENV{ORACLE_SID} = "ABCD12.COMPANYDOMAIN.COM"; delete $ENV{TWO_TASK}; my $dbh = DBI->connect($dsn, "", "", { ora_session_mode => ORA_SYSDBA +}); [download] and getting the error: DBI connect('','',...) failed: ORA-12545: Connect failed because targe +t host or object does not exist (DBD ERROR: OCIServerAttach) [download] Specifying ORACLE_SID with/without the domain name doesn't change the error message. I have checked that $TNS_ADMIN is defined and the host name is present in /etc/hosts. What am I doing wrong here? Thanks, AniComment on Connecting 'as sysdba' using DBD::OracleSelect or Download Code Replies are listed 'Best First'. Re: Connecting 'as sysdba' using DBD::Oracle by tweetiepooh (Friar) on Aug 05, 2009 at 11:08UTC Try $dsn = "dbi:Oracle:ABCD12"; [download] and make sure that sqlnet.ora has NAMES.DEFAULT_DOMAIN = COMPANYDOMAIN.COM [download] [reply][d/l][select] Re^2: Connecting 'as sysdba' using DBD::Oracle by laminee (Novice) on Aug 05, 2009 at 11:38UTC With $dsn = "dbi:Oracle:DS8CC2"; [download] or $dsn = "dbi:Oracle:DS8CC2.ORACLEOUTSOURCING.COM"; [download]
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don http://www.dba-oracle.com/sf_ora_28000_the_account_is_locked.htm Burleson Blog
ORA-28000: the account is locked tips Oracle Error Tips by Burleson Question: I am getting the ORA-28000 error on my database: Answer: The Oracle oerr utility notes this about the ORA-28000 error: ORA-28000: the account is locked. Cause: The user has entered wrong password consequently dbd error for maximum number of times specified by the user"s profile parameter FAILED_LOGIN_ATTEMPTS, or the DBA has locked the account Action: Wait for PASSWORD_LOCK_TIME or contact DBA "The DBSNMP Account Becomes Locked And Database Shows A Status Of Down With A Metric Collection Error Of 'Ora-28000' " occurring in Enterprise Manager Grid Control 10.1-10.2. ORA-28000 in DBSNMP is shown when DBSNMP is locked oracle dbd error when trying to navigate to Database Monitoring Configuration page with the error: error java.sql.SQLException: ORA-28000: the account is locked This can also be shown when as the console is running, yet the database shows a down status with this error: ORA-28000: the account is locked (DBD ERROR: OCISessionBegin). Sporadic at first, if the password is reset, the DBSNMP is locked daily. Stored in the targets.xml file, if the dbsnmp password is not in sync with the reset DBSNMP password, ORA-28000 will be thrown. If this happens, the Agent account will be locked because it has attempted to logon to the database incorrectly a certain amount of times, and ORA-28000 will become a problem. ORA-28000 can also occur if there is a service such as 9i Intelligent Agent trying to connect as DBSNMP with an invalid password, even if the DB target monitoring credentials are valid. In trying to resolve ORA-28000, keep in mind that FAILED_LOGIN_ATTEMPTS is maxed at 10 because DBSNMP has a default profile, after the 10 have been maxed, the account will lock. Resolving ORA-28000 consists of a few steps,