I just overwrote The tnsnames.ora and sql.net from JS machine to my local client machine. That is!! Why did they bring C3PO to Jabba's palace and other dangerous missions? Service "plsextproc" has 1 instance(s). weblink

Business Objects Ora-12154

The system returned: (22) Invalid argument The remote host or network may be down. i need to be clarified for something is about the TNSnames.ora copy ! Instance "orcl", status UNKNOWN, has 1 handler(s) for this service... Where is the tnsnames.ora?

To obtain the contents of tnsnames.ora in the remote system, log on to the remote system ? " So, on the remote/external Oracle database system you will find this file as Back to top Werner DaehnForum DevoteeJoined: 17 Dec 2004*6Posts: 10590Location: Germany Posted: Mon Apr 30, 2012 6:41 amPost subject: Re: ORA-12154: TNS:could not resolve the connect identifier Something is wrong. With best regards Robin Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... We need more information about what's in the config files on both server and client. –DCookie Feb 18 '10 at 20:01 add a comment| up vote 3 down vote The answer

Showing recent items. See Also Oracle TNS Ping https://community.oracle.com/thread/1066143?tstart=0 "1546209 - PCM : Oracle 11g R2 - #4 Listener Configuration" and the configuration of the connection between PCM and Oracle DB via the Configuration now i have the server which is SAP and the client which is Oracle Database do i have to give the info of the Tnsnames.ora with the port no and service Also, as Alex points out, the tnsping command is reporting a fully qualified service name.

This may be a temporary condition such as after the listener has started, but before the database instance has registered with the listener. http://www.forumtopics.com/busobj/viewtopic.php?p=885290 share|improve this answer edited Feb 18 '10 at 20:15 answered Feb 18 '10 at 4:46 DCookie 28.9k84765 yes i can ping just ud06. Business Objects Ora-12154 Can a person of average intelligence get a PhD in physics or math if he or she worked hard enough? Ora 12154 Tns Could Not Resolve The Connect Identifier Specified 11g What the lsnrctl services output tells me is that the "orcl" service, although defined in the listener.ora file, is not actually running.

How do I "Install" Linux? http://fasterdic.com/could-not/ora-12154-tns-listener-does-not-currently-know-of-service-requested-in-connect-descriptor.html Cheers, RB Top White Papers and Webcasts Popular Compare 20 Leading ERP Solutions 29 Ways Related Return Path Email Marketing Measurement Imperative Return Path Email Intelligence Report Return Path Email Metrics If there are any variations from the expected SIDs, then you can correct those in the relevant file. SolutionsBrowse by Line of BusinessAsset ManagementOverviewEnvironment, Health, and SafetyAsset NetworkAsset Operations and MaintenanceCommerceOverviewSubscription Billing and Revenue ManagementMaster Data Management for CommerceOmnichannel CommerceFinanceOverviewAccounting and Financial CloseCollaborative Finance OperationsEnterprise Risk and ComplianceFinancial Planning

share|improve this answer answered Feb 17 '11 at 7:19 wdk 1416 add a comment| up vote 0 down vote first try whether the oracle instance is started : for windows: start->configuration Instance "plsextproc", status UNKNOWN, has 1 handler(s) for this service... Edits are subject to review by community moderators. http://fasterdic.com/could-not/ora-12154-could-not-resolve-the-connect-identifier-specified.html Thank you and with best regards Robin Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving...

Cause The "ORA-03114: Not Connected to Oracle" error is commonly found when there is a problem with the network connectivity. It is constantly updated and provides a step by step description of what you need to connect to an Oracle remote database. Tools Used:Universe Connection - Relational Authentication - EnterpriseUser Name - AdministratorBo- BI4.1Bo web - 64 bitOracle -11gServer oracle -64 bitClient oracle - 32 bit Solution:-Check TNS Name in Environmental variable If

It cannot tell if the databases behind the listener is up or not.You can run this test from your command line: tnsping 2.

I am having single ORACLE_HOME with the correct one. TNS-12505 TNS:listener could not resolve SID given in connect descriptorCause: The SID in CONNECT_DATA was not found in the listener's tables.Action: Check to make sure that the SID specified is correct. Home | Invite Peers | More SAP Groups Your account is ready. more hot questions question feed lang-sql about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation

Please advise. When I execute the job, it fails with the error. 1028268 1 CON-120404 24/04/2012 09:26:27 Initialization 1028268 1 CON-120404 24/04/2012 09:26:27 OCI call for connection failed: http://fasterdic.com/could-not/error-ora-12154-tns-could-not-resolve-the-connect-identifier-specified.html Thank you and with best regards Robin Help the community by fixing grammatical or spelling errors, summarizing or clarifying the solution, and adding supporting information or resources.

My colleague is able to execute the job on this repository without any issue. Toolbox.com is not affiliated with or endorsed by any company listed at this site. The problem seems to be there. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers

Please... Instance "orcl", status UNKNOWN, has 1 handler(s) for this service... Service "orcl" has 1 instance(s). The SIDs that are currently registered with the listener can be obtained by typing: LSNRCTL SERVICES on the Server These SIDs correspond to SID_NAMEs in TNSNAMES.ORA or DB_NAME in the initialization