Logon Denied Dbd Error Ocisessionbegin
Business solution integration Software modernization (system migration) IT performance management (tuning) IT service management (ISO 20000 certified) IT training & knowledge transfer Business Intelligence Services Products dbi FlexService - Service Level Agreements (SLA's) Workshops & trainings (dbi InSite) Fixed Price Services Database Management Kit (DMK) References Customer references Testimonials Expertise Areas of expertise Database management (RDBMS & NoSQL) Enterprise Content Management (ECM) Application integration & middleware Operating systems Hardware & storage Business Intelligence Partnerships Oracle Platinum Partner Microsoft Gold Partner EMC Documentum Partner Dbvisit Partner EnterpriseDB Partner Severalnines Partner Orachrome Lighty Partner Arcentis Training Oracle workshops Microsoft workshops Open Source DB workshops Operating system workshops Newsroom Press releases Press images Events dbi services Press articles Newsletter About dbi Company profile dbi people Offices Corporate values & mission dbi xChange dbi InSite workshops Jobs & career Oracle Consultant (m/w) - Basel - Lausanne - Zug/Zürich SQL Server Consultant (m/w) - Basel - Zug/Zürich Imprint Blog Bloggers Categories Tags Contact Offering Services IT systems analysis & design (feasibility studies & audits) Software license management IT system & application implementation Business solution integration Software modernization (system migration) IT performance management (tuning) IT service management (ISO 20000 certified) IT training & knowledge transfer Business Intelligence Services Products dbi FlexService - Service Level Agreements (SLA's) Workshops & trainings (dbi InSite) Fixed Price Services Database Management Kit (DMK) References Customer references Testimonials Expertise Areas of expertise Database management (RDBMS & NoSQL) Enterprise Content Management (ECM) Application integration & middleware Operating systems Hardware & storage Business Intelligence Partnerships Oracle Platinum
Sign in Pricing Blog Support Search GitHub This repository Watch 29 Star 127 Fork 61 darold/ora2pg Code Issues 2 Pull requests 0 Projects 0 Pulse Graphs New issue Can't connect to Oracle db #136 Closed Jrsnow8921 opened this Issue Sep 22, 2015 · 2 comments Projects None yet Labels None yet Milestone No milestone Assignees No one assigned 2 participants Jrsnow8921 commented Sep 22, 2015 I am trying to connect to my Oracle db, but for some http://blog.dbi-services.com/how-to-connect-to-an-oracle-database-using-the-perl-dbi-module-and-dbdoracle-u201cas-sysdbau201d/ reason I am unable to do so. Any help would be # greatly appreciated!(I changed my sid, username, and password for security reasons to display my issue) Here is the error --> programmer@snowserver:~$ ora2pg -u interact DBI connect('host=172.16.1.139;sid=test;port=1521','interact',...) failed: ORA-01017: invalid username/password; logon denied (DBD ERROR: OCISessionBegin) at /usr/local/share/perl/5.18.2/Ora2Pg.pm line 1139. FATAL: 1017 ... ORA-01017: invalid username/password; logon https://github.com/darold/ora2pg/issues/136 denied (DBD ERROR: OCISessionBegin) Aborting export... I can however access my oracle db with the same credentials via sqlplus programmer@snowserver:/opt/oracle/instantclient_11_2$ ./sqlplus testuser/somepassword@test SQL*Plus: Release 11.2.0.4.0 Production on Tue Sep 22 10:07:48 2015 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> I'm using Xubuntu Oracle db is 11g Here is my bash--- export ORACLE_HOME=/opt/oracle/instantclient_11_2/ export ORACLE_SID=test export TNS_ADMIN=/opt/oracle/network/admin/tnsnames.ora Here is my tnsname.ora test = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.1.139)(PORT = 1521) ) (CONNECT_DATA = (SERVICE_NAME= test) ) ) And here is my ora2pg.conf ORACLE_HOME /opt/oracle/instantclient_11_2 ####TNS_ADMIN /opt/oracle/instantclient_11_2/network/admin/tnsnames.ora ORACLE_DSN dbi:Oracle:host=172.16.1.139;sid=test;port=1521 ORACLE_USER testuser ORACLE_PWD somepassword USER_GRANTS 1 DEBUG 0 ORA_INITIAL_COMMAND Owner darold commented Sep 22, 2015 Hi, Why are you using a tnsnames.ora? You don't need it when using instantclient and DBI. Everything is in the datasource. Try to reset TNS_ADMIN and let me know. Regards, Jrsnow8921 commented Sep 25, 2015 Okay that worked thank you! @darold Jrsnow8921
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 http://stackoverflow.com/questions/14476875/ora-01017-invalid-username-password-when-connecting-to-11g-database-from-9i-clie Learn more about Stack 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 https://scn.sap.com/thread/3209017 Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up ORA-01017 Invalid Username/Password when connecting to 11g database logon denied from 9i client up vote 31 down vote favorite 4 I'm trying to connect to a schema on 11g (v11.2.0.1.0) from a PC with 9i (v9.2.0.1) client. It seems to connect fine to some schemas, but not this one - it comes back with a ORA-01017 Invalid Username/Password error every time. The username and password are DEFINITELY correct - can anyone think of a reason why this wouldn't logon denied dbd work? Are there any fundamental incompatibilities between 9i and 11g? oracle oracle11g oracle9i share|improve this question edited Mar 13 at 17:31 Alex.K. 1,53171627 asked Jan 23 '13 at 9:59 user1578653 2,28683257 1 The password is all lower case. We are typing in the password in lower case when logging in. –user1578653 Jan 23 '13 at 10:16 add a comment| 11 Answers 11 active oldest votes up vote 24 down vote accepted The user and password are DEFINITELY incorrect. Oracle 11g credentials are case sensitive. Try ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = FALSE; and alter password. http://oracle-base.com/articles/11g/case-sensitive-passwords-11gr1.php share|improve this answer edited Sep 17 at 10:48 Am_I_Helpful 11.7k51745 answered Jan 23 '13 at 10:15 iddqd 5,36311323 This worked! So does the 9i client do something to your password after you've entered it like change it to uppercase? –user1578653 Jan 23 '13 at 10:34 3 @user1578653 oracle9i defaults to uppercase as it didn't cater for case sensitivity. instead of changing the database to insensitive, you can connect by pasting your password in double quotes eg `sqlplus youruser/"Password"@db to pass mixed case. –DazzaL Jan 23 '13 at 10:44 why after that alter, we should alter password? –IProblemFactory Sep 13
and SafetyAsset NetworkAsset Operations and MaintenanceCommerceOverviewSubscription Billing and Revenue ManagementMaster Data Management for CommerceOmnichannel CommerceFinanceOverviewAccounting and Financial CloseCollaborative Finance OperationsEnterprise Risk and ComplianceFinancial Planning and AnalysisTreasury and Financial Risk ManagementHuman ResourcesOverviewCore Human Resources and PayrollHuman Capital AnalyticsTalent ManagementTime and Attendance ManagementManufacturingOverviewManufacturing NetworkManufacturing OperationsResponsive ManufacturingMarketingOverviewMarket with Speed and AgilityUnique Customer ExperiencesReal-Time Customer InsightsR&D/EngineeringOverviewDesign NetworkDesign OrchestrationProject and Portfolio ManagementSalesOverviewCollaborative Quote to CashSales Force AutomationSales Performance ManagementSelling Through Contact CentersServiceOverviewEfficient Field Service ManagementOmnichannel Customer ServiceTransparent Service Process and OperationsSourcing and ProcurementOverviewContingent Workforce ManagementDirect ProcurementSelf-Service ProcurementServices ProcurementStrategic Sourcing and Supplier ManagementSupply ChainOverviewDemand ManagementDemand NetworkLogistics NetworkManufacturing Planning and SchedulingResponse NetworkResponse and Supply ManagementSales, Inventory, and Operations PlanningTransportation ManagementWarehouse ManagementSustainabilityOverviewEnvironment, Health, and SafetyProduct Safety and Stewardship NetworkBrowse by IndustryAerospace and DefenseAutomotiveBankingChemicalsConsumer ProductsDefense and SecurityEngineering, Construction, and OperationsHealthcareHigh TechHigher Education and ResearchIndustrial Machinery and ComponentsInsuranceLife SciencesMediaMill ProductsMiningOil and GasProfessional ServicesPublic SectorRetailSports and EntertainmentTelecommunicationsTravel and TransportationUtilitiesWholesale DistributionBrowse Platform and TechnologyAnalyticsOverviewBusiness IntelligencePredictive AnalyticsGovernance, Risk, and ComplianceEnterprise Performance ManagementApplication Platform and InfrastructureOverviewApplication PlatformContent and CollaborationInterface ManagementProcess Management and IntegrationData ManagementOverviewBig Data on HadoopData WarehousingDatabase ManagementEnterprise Information ManagementIT ManagementOverviewApplication Lifecycle ManagementIT Infrastructure ManagementSecurity SoftwareOverviewApplication and IT Infrastructure SecurityIdentity, Access and Authentication ManagementBrowse by ProductAnalyticsContent and CollaborationCustomer Relationship ManagementData ManagementEnterprise ManagementFinancial ManagementHuman Capital