Ora 12154 Error In Oracle Forms
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not ora 12154 oracle 11g post a blank message. Please type your message and try again. More discussions ora 12154 tns could not resolve service name in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived 1 2 3 4 5 6 Previous Next 84 Replies Latest reply on Aug 4, 2010 1:51 PM by rajeysh Go to original post This content has been marked as final. Show 84 replies 60. Re: ORA-12154: TNS:could not resolve the connect identifier specified 609487 Nov 20, 2007 10:40 AM (in response to 604134) hi guyz i have this problem with my oracle 10gi. i am able to connect to SCOTT using my pass and able to perform every function, but when i go to form builder and try to run the data block wizard, and when i try to connect from there i give it the same details it just give me the error ora-12154. any help would be really appreciated. thanks Like Show 0 Likes(0) Actions 61. Re: ORA-12154: TNS:could not resolve the connect identifier specified Eduardo Legatti Nov 20, 2007 1:01 PM (in response to 609487) Hi, >>but when i go to form builder What forms version are you talking about ? How many ORACLE_HOME's do you have in your machine ? Cheers Like Show 0 Likes(0) Actions 62. Re: ORA-12154: TNS:could not resolve the connect identifier specified 616322 Jan 7, 2008 2:50 PM (in response to 381046) I checked my windows services. There is no service related to TNS. Only db service I can see is OracleMTSRecoveryService which is started and Automatic. Neither do I have a listener.ora file. Where do I get the oracle_sid?? Can anybody help. Thanks. Like Show 0 Likes(0) Actions 63. Re: ORA-12154: TNS:could not resolve the connect identifier specified 618457 Jan 18, 2008 2:12 PM (in response to 429733) 1. For linux platform the following files should be in the ORACLE_HOME: lasses12.jar glogin.sql libclntsh.so.10.1 libnnz10.so libocci.so.10.1 libociei.so libocijdbc10.so libsqlplus.so ojdbc14.jar README_IC.htm sqlnet.ora sqlplus tnsnames.ora 2. Set the tnsname.ora to the right database, protocol
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 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 of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Oracle Forms - Just another ORA-12154 error up vote 0 down vote favorite ---The problem is solved, the Oracle Forms has its https://community.oracle.com/thread/269600?start=60&tstart=0 own otnsnames.ora file, located in NET80\ADMIN--- I have Oracle and Oracle Forms Runbtime installed on mi PC (windows). THe whole stuff connects to another machine where the database is set. At Oracle Forms Runtime lauching, I have an ORA-12154 error. Here are the things I checked (and I really don't know what to check more, that's why I'm asking here) -Checking my Oracles configuration files : #tnsnames.ora BOL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS http://stackoverflow.com/questions/18278157/oracle-forms-just-another-ora-12154-error = (PROTOCOL = TCP)(HOST = sajama)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = BOL) ) ) #sqlnet.ora SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME) The host "sajama" is declared in hosts file. -Checking the connexion with the database. I'm able to connect with tnsping to BOL, and i can connect to the database via Sqlplus with the same identifiers and SID that I enter in Oracle Forms. I didn't found any information about a specific Oracle Forms configuration file, nor information about this specific problem on the net... I actually already have another machine connecting to the same database, and their tnsmanes.ora and sqlnet.ora are exactly the sames. Moreover, the Oracle Forms scripts are installed on the Oracle database machine, it's then the same file that is lauched from the two computers. And, it works on the secund one. Does someone have a clue? Thanks for your help! oracle oracle10g tnsnames share|improve this question edited Aug 6 '14 at 16:22 Mat 136k21235274 asked Aug 16 '13 at 16:35 user2690104 11 Is Forms picking up the same tnsnames.ora file as SQL*Plus etc.? I seem to recall it has its own, possibly under its own config directory, and that would be a sample by default. But I'm not sure... –Alex Poole Aug 16 '13 at 17:21 Yes they do have,
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies http://stackoverflow.com/questions/16770817/forms-and-reports-ora-12154 of this site About Us Learn more about Stack Overflow the company https://www.youtube.com/watch?v=sym5xYV5LEo 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 of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: ora 12154 Sign up Forms and Reports ora - 12154 up vote 1 down vote favorite First things first : I have installed oracle 11g database and 10g developers suite(need to use forms builder).Are those 2 compatible ?Can i make forms using 10g Form builder on a 11g database ?There isn't a download available on Oracle for 10g database. If yes ^^ then: I ora 12154 error made a new database called genericName and i am trying to connect to it using sys/myPasswordChoice/genericName to it from Form builder and i am getting the following error: ORA-12154: TNS could not resolve the connection identifier specified I searched the internet for a solution and it seems to me that i need to simply modify something in one of the .ora files.Dunno if this is the solution buti have a hunch Can anyone please help me fix this so i cand use Form Builder 10g Thank you forms oracle builder share|improve this question asked May 27 '13 at 10:07 user1840302 4029 add a comment| 2 Answers 2 active oldest votes up vote 0 down vote Yes even Oracle 6i can connect to 11g!!! check $oracle_home/network/admin/tnsnames.ora. ($oracle_home is where developer suite is installed) Add the entry manualy or use net configuration assistant gui tool. The next lines: apex2 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.53.2.55)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = uni11g) ) ) describes the tns name apex2 (the one you use in forms to connect), that
10g TNS Configuration Ravi shankar kumar SubscribeSubscribedUnsubscribe2929 Loading... Loading... Working... Add to Want to watch this again later? Sign in to add this video to a playlist. Sign in Share More Report Need to report the video? Sign in to report inappropriate content. Sign in Statistics 5,000 views 5 Like this video? Sign in to make your opinion count. Sign in 6 1 Don't like this video? Sign in to make your opinion count. Sign in 2 Loading... Loading... Loading... Rating is available when the video has been rented. This feature is not available right now. Please try again later. Published on Oct 1, 2013Oracle Forms 10g Category People & Blogs License Standard YouTube License Show more Show less Loading... Autoplay When autoplay is enabled, a suggested video will automatically play next. Up next Oracle Apps Training - Complete Bank Accounts setup - Duration: 57:48. ERPWebTutor 9,407 views 57:48 Oracle Forms 12c and Beyond New Feature Sneak Peak - Duration: 59:09. Auraplayer Admin 7,975 views 59:09 How to Fix ORACLE 6i Error "ORA-12154: TNS:could not resolve the connect identifier specified". - Duration: 4:02. SYED AIZAD RAZA KAZMI 3,522 views 4:02 Oracle Forms 6i setup and TNS configuaration (SEFAT) - Duration: 13:37. sefat ullah 6,044 views 13:37 how to setup Oracle (forms developer) - Duration: 19:11. touch oracle 330 views 19:11 Oracle forms developing part 1.avi - Duration: 21:57. Abdul Nawaz 35,745 views 21:57 Oracle ASM - Part 1 - Duration: 55:30. Prasad Mynumpati / DBA Technologies 29,727 views 55:30 解决 Oracle ora-12514错误 - Duration: 33:45. Maclean Liu 1,025 views 33:45 Oracle - Understanding the tnsnames.ora and listener.ora files - Duration: 12:46. Chris Ostrowski 91,272 views 12:46 How to solve TNS: protocol adaptor error in oracle - Duration: 4:41. Tsega Zeab 5,520 views 4:41 Oracle Database Backup and Recovery Session 1 - Duration: 2:38:11. ORACLEGENESIS 63,492 views 2:38:11 How to install Oracle Developer Suite 10g on Windows - Duration: 22:09. Subhroneel Ganguly 7,115 views 22:09 009 How to Connect Forms Builder to Oracle Database 11g.mp4 - Duration: 4:50. Goran Husamalddin 4,975 views 4:50 Oracle 10