i have made a service (star) in Tnsnames.ora in client side.star.world =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROtoCOL = TCP)(Host = server) (Port = 1521)))(connect_DATA = (SID = ORCL)))--------------------------------------------it gives me error:ORA-12203:TNS :unable to at least have my DB connected! i had N problems with this, got oracle enterprise 11g and developer suite 10g on VISTA =s now i only have the problem that everyone has with the error "the nmefwmi.exe When I run any report from application the report engine log give me the following error: REP-0501: Unable to connect to the specified database. http://qaisoftware.com/the-specified/unable-to-connect-to-the-specified-database-in-report-server.html
Home Help Search Calendar Login Register Developers Heaven Forum » DataBase » Oracle (Moderator: molder) » Unable to connect from Developer 10G Report and Form Builder to Oracle Database « previous REP-501: Unable to connect to the specified database. As you use Oracle 11g: are you aware that it is - by default - case sensitive when passwords are to be used? I have controlled the TNSNAMES and is correct: ===================================================================== # tnsnames.ora Network Configuration File: C:\Oracle\DevHome10\network \admin\tnsnames.ora # Generated by Oracle configuration tools.
Just e-mail: and include the URL for the page. So, did you, perhaps, use wrong case? I have assigned a task from my manager to upgrade the database and also migrate the database server on Linux. I am using the same password to delete the database.
blarman replied Jul 19, 2011 One way to verify that the TNSNAMES files is correct is with the TNSPING utility. The problem is after log in the application i'm able use forms, i can query, insert, select, update and delete data but when i'm trying to run report from the same In another machine I have windows 7. Terminated With Error Rep-501 Unable To Connect To The Specified Database Oracle APPS DBA (Techno-Functional) Total Pageviews Thursday, June 12, 2014 REP-0501 ORA-01017 unable to connect to the specified database REP-0501 ORA-01017 unable to connect to the specified database Applies to:
so I installed forms 6i as oracle client , copied the tnsnames.ora from the oracle installation path to forms installation path.(inside NET80/Admin folder)When i try to connect with user name and Please type your message and try again. Unable To Connect To Sql Server From 11g? http://www.dba-oracle.com/t_rep_501_unable_to_connect.htm View 11 Replies View Related Forms :: How To Connect Database With Static IP Jun 4, 2011 i got static ip from witribe a broadband company in pakistan i am trying
any way no problem thank you very much for your time and help, I'll look for a solution from any other source. Rep 501 The Specified Database Cannot Be Connected 12c The error I keep getting is:Alias is not currently opened. [Oracle][ODBC][Ora]ORA-12154:TNS: could not resolve the connet identifier specified.Here's what I've done:1. Action: Retry the connection and check the network connectivity. All legitimate Oracle experts publish their Oracle qualifications.
When I tried to connect, I got the following error : ERROR:ORA-12560: TNS:protocol adapter errorIn order to rectify the above error, I was making sure that ORACLE_HOME AND ORACLE_SID were properly https://community.oracle.com/thread/2321842 As am using OIM db as service name while its showing CLRExtProc.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))STATUS of the LISTENERAlias LISTENERVersion TNSLSNR for 32-bit Windows: Version 18.104.22.168.0 - ProdctionStart Date 21-NOV-2012 20:28:48Uptime 0 days Rep-501 Unable To Connect To The Specified Database 10g Note that after three attempts you will be disconnected from the SQL*Reports server. Rep-0501: Unable To Connect To The Specified Database Ora-12154: Tns: Could Not Resolve Service Name Thx again!!!
ORA-01017: invalid username/password; logon denied I have attached the picture to clarify the problem. But I found ORACLE_SID missing. You can get personalized Oracle training by Donald Burleson, right at your shop! Burleson is the American Team Note: This Oracle documentation was View 2 Replies View Related Server Administration :: Unable To Connect To Database Nov 27, 2010 I have installed a database in D drive. Rep 501 The Specified Database Cannot Be Connected
Do I need to install any additional ODBC driver(s)?5. So I added ORACLE_SID environment variable in the registry and re-tried connecting to the database. Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... Server Administration :: Unable To Connect To Database / ORA-12560 / TNS / Protocol Adapter Error Server Administration :: Unable To Connect To Oracle 11g Using Forms 4.5 Forms :: FRM-41213
View 6 Replies View Related Server Administration :: Unable To Connect To Oracle 11g Using Forms 4.5 Apr 21, 2011 We are unable to connect to Oracle 22.214.171.124.0 from Oracle Forms Feb 1, 2012 I am getting beloww error very frequently in database log and not able to connect to the database.************************Fatal NI connect error 12170.VERSION INFORMATION:TNS for 64-bit Windows: Version 126.96.36.199.0 More Oracle Groups Your account is ready.
So i did the following things 1. Jun 21, 2012 When we tried to query a data from the sql server we are getting the below generic error message iSQL> select * from [email protected] 2 / select * Especially when using different software tools / Oracle versions that have to be located into different ORACLE_HOME directories this method has proven useful. Michel BRANDELIK replied Jul 20, 2011 Hi, One good way to share all connectors on a system is to set the Operating System environment variable TNS_ADMIN Set this variable to a
By default, Oracle Reports will only look for available databases in tnsnames.ora. After connection excel has its own micros to run he query from oracle database.Question 2: How I can create the mirco into form 10g to run into excelbook/excelsheet.Question 3: How I what should I do to have oracle accept connection from the LAN and WAN ( I hv setup virtual server on router) View 12 Replies View Related Unable To Connect To Forms :: Unable To Save Record In Database Unable To Connect To Oracle 10g Through TOAD Unable To Connect In TOAD In ORACLE 11g ADVERTISEMENT Windows / .NET :: Unable To
Reply With Quote 01-16-2008,08:20 AM #7 davey23uk View Profile View Forum Posts Senior Advisor Join Date Sep 2002 Location England Posts 7,334 put in the entry for your database Reply With Application is working fine. All product names are trademarks of their respective companies. I am check the TNSNAMES.ora and SQLNET.ora all files is correct.
SQL> show parameter sec_case_sensitive_logon NAME TYPE VALUE ------------------------ ------- ----- sec_case_sensitive_logon boolean TRUE Default value of this parameter is TRUE, change it to FALSE. Feel free to ask questions on our Oracle forum. I checked LSNRCTL in the database machine, it is listening. Follow-Ups: Re: Error REP-0501/ORA-12637 connecting to DB From: Frank van Bortel References: Error REP-0501/ORA-12637 connecting to DB From: nick048 Re: Error REP-0501/ORA-12637 connecting to DB From: Frank van Bortel Prev by
Will be great full if I can get any kind of help Waiting for your reply Attachment: Error_REP-0501.jpg (Size: 140.35KB, Downloaded 586 times) Report message to a moderator But only connect the database for SQL Developer. The ORACLE_HOME was set properly. You may have to register before you can post: click the register link above to proceed.