Forum New Posts Today's Posts FAQ Calendar Forum Actions Mark Forums Read Quick Links View Site Leaders dBforums Database Server Software Oracle frm-41214 report coud not run If this is your I guess you have already read this, but never mind:OracleREP-501: Unable to connect to the specified database. We are verifying if this bug solves the issue. REP-501 error when running reports Applies To Product(s): Exor Network Manager Version(s): 04.06.00.08 Environment: N/A Area: Reports Subarea: Original Author: Kristijonas Nalivaika, Bentley Technical Support Group weblink
HTH CJ DTSIGuy, Sep 22, 2014 #6 jagadekara Forum Guru Messages: 1,126 Likes Received: 145 Trophy Points: 1,805 Location: Pulivendula Re: REP-0501: Unable to connect to the specified database ORA-12154: Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... What is TNSAdmin Parameter? I am hoping to remove Oracle 8i soon so this situation is temporary.
There are my codes to call report : Declare rep_id REPORT_OBJECT; v_rep Varchar2(100); Rep_status Varchar2(20); Title Varchar2(255); Begin :Global.Server:='Hungdq'; :Global.Port:='8888'; :Global.Report_Server:='rep_srv'; rep_id := Find_Report_Object('REPORT6'); Set_Report_Object_Property(rep_id, REPORT_EXECUTION_MODE, RUNTIME); Set_Report_Object_Property(rep_id,REPORT_SERVER, :Global.Report_Server); Set_Report_Object_Property(rep_id, REPORT_DESFORMAT, Muhammad Usman replied May 30, 2007 Thank you so much Dave , you cant believe that i was really disappointed of searching the help for REP-501.Definitely i will try the url I get error: REP-501: Unable to connect to the specified database. Reply With Quote 01-12-04,03:03 #10 satish_ct View Profile View Forum Posts Visit Homepage Registered User Join Date Nov 2003 Location Bangalore, INDIA Posts 333 Hi, This problem occurs only when deploying
Could you send me all step (step by step) to config successfully. I did not make any configuration changes on the applications server. We had a similar issue after upgrading to 11g database, at the end, it was the database password's case sensitivity setting. Please update...
Re: REP-501: The specified database cannot be connected.. I am reading the patch set realease notes and the upgrade appears tricky withy lots of detail. Results 1 to 2 of 2 Thread: Reports Server gives error REP-501 Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid I had been successed in the past with DS but now I can't.
Did you restart WLS_REPORTS after the modification in rwnetwork.conf ? jagadekara, Sep 22, 2014 #1 DTSIGuy Forum Advisor Messages: 402 Likes Received: 58 Trophy Points: 410 Location: Texas Re: REP-0501: Unable to connect to the specified database ORA-12154: TNS: could not Then it's working. Orademak posted Jan 5, 2017 at 11:54 AM Oracle po ers invoice srihari1 posted Jan 4, 2017 at 5:32 AM Fusion hcm content Veerendrahrms posted Jan 4, 2017 at 1:55 AM
When I read trace file I see a problem. Can you help me! Rep-0501 Unable To Connect To The Specified Database Report Builder Running the report from form by directly using web.show_document 3. Rep-0501: Unable To Connect To The Specified Database Ora-12154: Tns: Could Not Resolve Service Name i have already made the connection & it works fine with my first page set up.i need to take an item from the drop down list which i populated from myfirst
We opened Bug 10100777: REPORTS ENGINE CRASH WITH REP-501 and got an oracle patch. Reply With Quote 01-13-04,02:09 #15 hungdq View Profile View Forum Posts Visit Homepage Registered User Join Date Sep 2003 Location Hanoi- Vietnam Posts 27 Thank for your replies. The resoultion is via LDAP. jagadekara Forum Guru Messages: 1,126 Likes Received: 145 Trophy Points: 1,805 Location: Pulivendula Hi All, When I am connecting report builder getting the following error. Rep-0177 The Specified Database Cannot Be Connected
Thanks a lot. Please login or register.Did you miss your activation email? 1 Hour 1 Day 1 Week 1 Month Forever Login with username, password and session length News: To still receiving newsletters If you're in Windows, the TNSAdmin parameter is a system environment variable directing ALL of the Homes to look HERE for the TNS file...it simplifies things. check over here Can I just copy all oracle datafiles from sol8 server to sol10 server and start db as normal filesystem and block size are the same on both servers except for OS
Now I have 1 scenario which I am not sure how to go about with. The final config files were the same as original (Before we experienced this issue). Home | Invite Peers | More Oracle Groups Your account is ready.
Package varaiables in 10g reports  (20Views) I have a report running on 10g application server. The tnsnames.ora file in located in the $OI/config location. - Case sensitivity parameter settings: If the SEC_CASE_SENSITIVE_LOGON=TRUE in the pile or spfile, Oracle will make the Reports log on credentials case REP-0501: The specified database cannot be connected still occures. Then grab your masters and put them there....
If you find an error or have a suggestion for improving our content, we would appreciate your feedback. This is a part of the trace file: [2004/0/13 11:16:2] Info 50132 (JobObject:reset): Get command line: report=D:\App\HRMS\Forms\Test_report.rdf Desformat=PDF server=cdit destype=cache authid=RWUser [email protected] SERVER_NAME="hungdq" SERVER_PORT=8888 SCRIPT_NAME="/rwservlet" SERVER_PROTOCOL="HTTP/1.1" REMOTE_ADDR="192.168.8.40" REMOTE_HOST="Hungdq.app.cdit.com.vn" ACCEPT_LANGUAGE="en-us" USER_AGENT="Mozilla/4.0 (compatible; Open reports.sh. 2. when i do the same that is drag & drop with a diferent database that is sqlserver 2000 i don't face any such problem.
TNS_ADMIN may be pointing to a directory where tnsnames.ora is missing or the values does not match the connecting database servicename. Running the same report from browser with all params including the connect string 2. would like to weather its not possible of generating a dataset for mysql database using the wizard.later i draged and droped a dataadapter from the tool box and then generated a Any other information I can provide ?
However, everytime I run them I get an error of "VNI-2015: Authentication error". Report message to a moderator Re: Oracle 10g Reports - REP-501 on access from form but browser access works fine [message #392665 is a reply to message #392639] Click here. You're now being signed in.
Sign-on to SQL*Plus and connect with the TNS name ("connect [email protected]_name") Within SQL*Plus, try a select from [email protected]_db_link Oracle Training from Don Burleson The best on site "Oracle But the problem occurs when i try to run a simple report through web browser url it gives me REP-501 Unable to connect to specified.The problem is only while calling reports I have edited the tnsnames.ora on both machines but still no luck. Search BC Oracle Sites HomeE-mail Us Oracle Articles New Oracle Articles Oracle TrainingOracle Tips Oracle ForumClass Catalog Remote DBAOracle TuningEmergency 911RAC SupportApps SupportAnalysisDesignImplementationOracle SupportSQL
Salai.jayavelu Aug 26, 2011 10:51 AM (in response to Denis Segard-Oracle) Hi, I am getting the same error, could you please let me know how did you resolved the issue..? What to set host to in listerner.ora for 2 servers sharing disks?  (19Views) when sharing disks between 2 servers, what do you set the host to in listener.ora for TCP connections This PL/SQL package variable is used in where conditions of the report parameter's list item's select queries. Eventhough new builder got same eerror.
I am interested in hearing more from other if they think my theory has any credence.. upgrade oracle application server upgrade  (14Views) I want to upgrade my application server from 10.1.2.0.2(base) to 10.1.2.3.0(latest) on windows server 32bit. Help me on this.... My problem is that the same forms is going to be used for both databases, and I therefore cannot replace run_report_object with an explicit web.show_document, especially since the former is working
The PL/SQL variable is declare in the package specification defined in the database. It's far better to create the TNS_ADMIN environment variable and point it to a single location and put your file there.