Home > Error Code > Error(code12505)(emfi4)



asked 5 years ago viewed 24970 times active 2 years ago Upcoming Events 2016 Community Moderator Election ends in 2 days Get the weekly newsletter! But not necessarily so. You use the sid globldb3 which may be undefined on the 10.x instance. I don't normally connect to a single host. weblink

As you mentioned, in log files of oracle 9i said that 08-FEB-2006 10:39:01 * (CONNECT_DATA=(SID=biosyscom)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST= * establish * biosyscom * 12505 TNS-12505: TNS:listener could not resolve SID given in Learn more MATLAB and Simulink resources for Arduino, LEGO, and Raspberry Pi Learn more Discover what MATLAB® can do for your career. The DATABASE function expects the 'databasename' parameter to be the same as the SID parameter at the end of the 'databaseurl'. So I would make sure that you're at least using an Oracle 10g JDBC driver.

Error Code 12505 In Oracle

using JDBC thin drivers. 1) does Oracle 9i RAC support JDBC thin drivers ? 2) if App. FAQs Search RecentTopics FlaggedTopics HotTopics Best Topics Register / Login Post Reply Bookmark Topic Watch Topic New Topic programming forums Java Java JSRs Mobile Certification Databases Caching Books Engineering Languages Frameworks The error is not consistant.

Post Reply Bookmark Topic Watch Topic New Topic Similar Threads Oracle Connectivity error who can help me about jdbc to solaris oracle9i? You can also select a location from the following list: Americas Canada (English) United States (English) Europe Belgium (English) Denmark (English) Deutschland (Deutsch) España (Español) Finland (English) France (Français) Ireland (English) If the listener.ora file is minimal, it will mediate between the database instance that registers and the clients that connect to port 1521 (or whatever). Connection Refused(description=(err=1153)(vsnnum=0)(error_stack=(error=(code=1153)(emfi=4) Hence I feel this is an inappropriate forum for your question, and it's not my area of expertise, so I can't really help you.

share|improve this answer answered Oct 23 '12 at 18:43 user1697575 2,13211425 1 The correct format is : not / –Lisandro Dec 13 '12 at 20:52 1 Well it works Vsnnum=186647552 Apply Today MATLAB Academy New to MATLAB? Action: Check to make sure that the SID specified is correct. Join the conversation Activate your FREE membership today|Log-in Java SOA TEST/QA Today On TSS Discussions Topics White Papers Multimedia RSS Java management Java Web services RESTful Web services ESB products Agile

in my cas, i find out that database url (ex ) the database port number was wrong After correcting the port number,all worked fine. Io Exception: Invalid Connection String Format, A Valid Format Is: "host:port:sid" The answer lies in the server configuration. More discussions in Java - JDBC Archive All PlacesOracle CommunityArchived ForumsJava - JDBC Archive This discussion is archived 1 2 Previous Next 22 Replies Latest reply on Jun 7, 2011 3:04 Hot Network Questions PPCG Jeopardy: Cops How to increase the height of a single row in table?


The Java program accepts four command line arguments: user, password, hostname, and database. Re: Oracle 10g JDBC connection refused error Avi Abrami Feb 9, 2006 4:25 AM (in response to 201187) shine99, It appears that your problem is more to do with installing and Error Code 12505 In Oracle Opportunities for recent engineering grads. Oracle Err=1153 Based on your location, we recommend that you select: .

select value from v$parameter where name='db_name'; Try using that value instead of ‘'. The SIDs that are currently registered with the listener can be obtained by typing supported can be obtained by typing "LSNRCTL SERVICES listener_name". I realized that I was pointing to the 9i JDBC JAR file. globldb3 is the sid of the 9.1 instance, your new oracle instance has (a) different sid(s). Error Code 305 Emfi 1

con = DriverManager.getConnection(dbServer, username, password); I tested the above on another sid on another boxe and it worked fine. For instance: url="jdbc:oracle:thin:@(DESCRIPTION= (LOAD_BALANCE=on) (ADDRESS=(PROTOCOL=TCP)(HOST=host1) (PORT=1521)) (ADDRESS=(PROTOCOL=TCP)(HOST=host2)(PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=service_name)))" or url="jdbc:oracle:thin:@(DESCRIPTION= (ADDRESS=(PROTOCOL=TCP)(HOST=cluster_alias) (PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=service_name)))" Like Show 0 Likes(0) Actions 14. You can leave a response, or trackback from your own site. Reply Bernhard Kern says: Tuesday, June 19, 2007 at 10:20 am i tried the following value and now it works select value from v$parameter where name = ‘instance_name' Reply Chandan Kumar

Thanks! Ora-28040: No Matching Authentication Protocol I think there is a problem with the TNS listener. java jdbc java-ee share|improve this question edited Jun 28 '11 at 8:53 asked Jun 28 '11 at 7:37 Adnan 1,58893048 error 12505 is wrong SID.

In the log file of 10g is like that 08-FEB-2006 10:38:50 * (CONNECT_DATA=(SID=biosyscom)(CID=(PROGRAM=G:\oracle\product\10.2.0\db_2\perl\5.8.3\bin\MSWin32-x86-multi-thread\perl.exe)(HOST=austvagoy)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST= * establish * biosysco * 0 08-FEB-2006 10:40:18 * service_update * biosysco * 0.

Thanks! From what I've read, I'm guessing the next step would be to try running the 'lsnrctl services' on your Oracle server to figure out if the SID that you are specifying The connect descriptor received by the listener specified a SID for an instance (usually a database instance) that either has not yet dynamically registered with the listener or has not been Java.sql.sqlexception: Io Exception: The Network Adapter Could Not Establish The Connection Regards, Like Show 0 Likes(0) Actions 11.

Action: Check to make sure that the SID specified is correct. Re: Oracle 10g JDBC connection refused error 558844 Jan 29, 2007 7:49 PM (in response to 201187) The problem here is an incompatibility which for all I know Oracle has introduced. Not the answer you're looking for? source code snippet: public Connection getConnection() throws SQLException, ClassNotFoundException { Class.forName("oracle.jdbc.driver.OracleDriver"); Connection con = DriverManager.getConnection("jdbc:oracle:thin:@oracle8i_installed_server_ipaddress:1521:servicename" , "msudev", "msudev"); System.out.println("Con: " + con); return con; } Exception stack trace: java.sql.SQLException: Io exception:

© Copyright 2017 All rights reserved.