Reports & Discoverer :: Connect To Remote Database
Jul 24, 2011
I am using Report Builder 10.1.2.0.2. There is a table in a remote database with synonyms/links defined. I am getting error trying to access those tables. DBA says links/synonyms are correct and I am also able to access that table from SQLTool without error.
I can do a select statement on those tables from 'SQL Query statement' in data model.
Error is generated only if I try to use those tables in 'Formula' or in function/procedure.
I don't know if this is a bug or something else.
View 28 Replies
ADVERTISEMENT
Jun 29, 2012
I could not connect the reports builder to the database. Im trying to connect it to the XE database. I checked the tns names and the hosts. Everything seems to be fine. But still when i try to connect the report it throws an error "ORA 12541- tns no listner"..
View 11 Replies
View Related
Apr 20, 2011
i want to know how can i run my report using report server which exist on remote machine ?
is it possible to set parameters then report would use the report server of remote location ?
View 4 Replies
View Related
Sep 3, 2009
I installed oracle 10g and developed simple software using forms 6i. Its working well as a stand alone system.
I want to share it in network. 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 password , it comes ORA-12203 Unable to connect to destination. I checked LSNRCTL in the database machine, it is listening.
View 11 Replies
View Related
Jan 16, 2013
I'm currently having this kind of issue whenever I click the 'Finish Enrolling' that dialog box appears. what kind of error is this and what was the cause of this error.
View 1 Replies
View Related
Jul 19, 2013
I am trying to connect to a database located at my work from at home. I am running into the following issue (see command and error below):
ansichart@ansivm:~/src/perl$ sqlplus aspxdba/********@aspxp2 SQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 18 21:15:09 2013 Copyright (c) 1982, 2011, Oracle.
All rights reserved. ERROR:ORA-12545: Connect failed because target host or object does not exist-- Here is my tnsnames.ora file (I have the service_name censored out for privacy reasons):-
ansichart@ansivm:~/src/perl$ cat $ORACLE_HOME/network/admin/tnsnames.oraaspxp2 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = orarac9-scan)(PORT = 1521)) ) (CONNECT_DATA =(SERVICE_NAME = *****************)(UR=A) ) )-
I have verified that I can establish a TCP connection to this DB server on the port specified, using the same info from the TNSnames.ora file (see below):-
---ansichart@ansivm:~/src/perl$ nmap -sT -p 1521 orarac9-scan Starting Nmap 5.21 (URL.... ) at 2013-07-18 20:53 CDTNmap scan report for orarac9-scan (10.1.13.115)Host is up (0.0088s latency).PORT STATE SERVICE1521/tcp open oracle Nmap done: 1 IP address (1 host up) scanned in 0.09 secondsansichart@ansivm:~/src/perl$--
I have another terminal opened up to a server at work and I can connect to the DB with sqlplus just fine. I verified that the record for this database on the tnsnames.ora file is the same as it is at work. In conclusion, I can connect to the Database at work, but I cannot at home, even though I am using the same connection information and verified that port 1521 is accessible on this Database server from at home. So why can't I establish a DB connection?
View 6 Replies
View Related
Apr 5, 2010
i need to connect to a remote database located on a different server using sqlplus without using database name in connect string.
e.g. if mydb1 (located on another database server on network)
sqlplus username/password
i am able to do this on local database but not on the remote database
View 7 Replies
View Related
May 22, 2013
I have created a function for knowing the status of link which connect me with remote database.function is as follows
---------------------------------------------------------------------------------------------
CREATE OR REPLACE FUNCTION get_status_db_link (p_db_link_in VARCHAR2)
RETURN NUMBER AS
rows NUMBER;
v_code NUMBER;
v_errm VARCHAR2(64);
[code]....
Now functin should returns 1 when link is up and it should return 0 when link down but sometime when link is down it continues showing executing it hang my pc.
View 1 Replies
View Related
Feb 22, 2011
i need the crystal report application to try to get some reporys from the database .
and i am new to crystal reports and want to know how to connect to oracle database 11g .
wher to get CR 8 and step by step how to connect it to my database
View 1 Replies
View Related
Feb 27, 2012
I have installed Windows7 64bit on my laptop and then installed Reports10G. I am not able to connect to DB from Reports10g, Its gives below error -
REP-0501: Unable to connect to the specified database
ORA-02248: Invalid Option for ALTER SESSION
Same Reports10g is able to connect to DB on Windows XP machine. Database version is 11g which is remote.
View 5 Replies
View Related
Feb 27, 2011
I am getting the error FRM-41213: Unable to connect to the report server error when trying to run report by calling from form.
Im not able to access even
with the urls.....rwservlet/showjobs
and /reports/conf/showjobs.
Is there any configuration need to be made in order to run report from form.
I use my report server name as rep_dpaoscit211 .
I havent added any line to any config file for reporting....
View 1 Replies
View Related
Aug 8, 2013
My user would like to have a way to attach files to database records. For simplicity, we'll say that each employee in the database could have 0-many file attachments associated with them. I know how to make this part work using Oracle Forms.
So that's the easy part for me. The tough part is that they want to be able to run an Oracle Report on our application server (displays as a PDF, also downloadable as a PDF) and have links on this report to the attachments that they uploaded using the forms process above.
For the idea of storing the files on a folder somewhere, I simply created a text object on the report that had it's hyperlink property pointing to the file location. Done.. opens fine.
However, I want to be able to have the option of storing these files in the database instead, just in case we can't go with the shared folder idea. I'm not sure how to make this work. I can store a blob in the database.. but how do I link to that blob on the report for them to be able to download it? Is this even possible?
how to create a download link on the Oracle Report that let's them download a file out of the database.
View 5 Replies
View Related
Jul 19, 2010
When I try to remotely connect to an Oracle schema using SQLplus, I consistantly get this error:
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Yet I can connect to the same machine, from my own machine just fine using SQLDeveloper.Here are the details I have collected so far
- I am using the instantclient for OS X
- export DYLD_LIBRARY_PATH=/Users/jeff/instantclient
- export ORACLE_HOME=/Users/jeff/instantclient
- export TNS_ADMIN=/Users/jeff/instantclient/tns
The command line i ran : ./sqlplus seam_classoft/seam_classoft@//oracle11gtest.terida.net:1521/orcl
Its behind a VPN, so I'm not worried about posting my info.
My /Users/jeff/instantclient/tns/tnsnames.ora that I copied directly from the server looks like this:
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle11gtest.terida.net)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.terida.net)
)
)
I've tried changing SERVICE_NAME to SID = orcl, no change inbehavior. My original guess was that the database wasn't registered with the listener, but that would mean sqlDeveloper should fail as well, but it works.Here is out put of lsnctrl status:
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 07-JUN-2010 09:16:40
Uptime 42 days 0 hr. 58 min. 59 sec
Trace Level off
[code]....
View 4 Replies
View Related
Jul 2, 2010
I have a database up and running (including listener) on machine A. From that machine, everything seems fine. However, when I try to connect to it from another machine (say, machine B) on the network, the connection cannot be established (exact message: connection to database failed: The Network adapter cannot establish the connection).
I can successfully ping machine A from machine B. The machine A db is a default install (ORCL).
Is it possible the DB listener is not configured properly to connect to remote clients? On machine B, I have oracle tools such as SQLPLUS, Oracle Net Manager, and Net Configuration Assistant.
View 31 Replies
View Related
Dec 24, 2007
We installed Oracle 10g on one of our servers and configured the listener to host=localhost. Here's our listener.ora file:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
[code]...
After restarting the listener, we could connect using the connect identifier from the local server. However, when trying to connect from a remote client we received the error of "no listener". In the remote client the identifier is defined with host=ip_address. TNSping from the client to the host was successful.
When we changed listener.ora to host=up_address we could connect ONLY from the remote computer. Only after changing the host in tnsnames.ora file to the IP as well - we could connect from both the local server and the remote client.
I usually use host=localhost in the listener file (and the local tnsnames file) and never had this problem before.
View 1 Replies
View Related
Sep 17, 2013
I have a strange problem of connecting Oracle Forms6i from our Remote site.actually we change our IP address of lease line, we connect to it.but when we connect locally,forms are running without any problem,but when we connect globally or from other sites it can't able to connect,even sql prompt and toad also connect from remote site,but when we try to connect forms(forms runtime) it gives error message(ORA-12203: TNS:unable to connect to destination).when we connect this application from local application(Forms) it can connect well but from globally it can't able to connect.
View 1 Replies
View Related
Jul 23, 2012
I have sample windows C# application to connect remote Oracle DB(Enterprise edition SQ L plus).
Want to connect remotely without installing oracle client on local system.
View 13 Replies
View Related
Sep 9, 2010
I am trying to add fields from an SQL server database to the EUL. We have a lot of Oracle tables and fields in the existinging EUL, and we have created a database link from the Oracle database to the SQL database. But how can I find til SQL database tables and fields in Discoverer admin?
View 1 Replies
View Related
Jun 8, 2011
I have a business area rfprod and i the folders in it were imported by me from an oracle 10g database. Usually i right click and import from databse, when i get the box instead of the default database i used to select the database and import the folders, but now the database has been moved to 11g and i cannot access the databse as i have to alter the database link.
View 2 Replies
View Related
Aug 5, 2013
In my table I have a column for storing image path how can I display the image in my report.I added a file link and specified the image source and the image is displayed when running report.
is it possible to make the source dynamic, based on the primary key entered by the user??
View 1 Replies
View Related
Nov 4, 2010
I'm developing a script and i need to select the worksheet identifier in the database, but i don't know the name of the table that stay this information.
View 3 Replies
View Related
Aug 25, 2011
Is it possible to save a report directly in a table instead of the typically destination? (file, cache,...)
View 4 Replies
View Related
May 28, 2011
i am facing another problem with 11g database. i am using 6i forms and reports and recently shifted database to 11g 64 bit version. as its 6i forms so i use run_product to call reports. suppose my code for runproduct is in a button, once i press the button to get the print i am getting the logon_screen. if i enter login data again its giving the report.
View 1 Replies
View Related
Feb 15, 2011
I want to change database login in report at runtime.
For Example. I have created and run a menu by using database login "ABC/xxx" and want to run a report through this menu directly (Without using form) by different data base login i.e "xyz/ddd".
what is the sol. except passing user id at report call i.e rwrun60 parameter.
View 1 Replies
View Related
Jul 5, 2010
how to Run a Discoverer Reports in a Forms Menu.
View 2 Replies
View Related
Jun 29, 2013
I'm trying to connect a oracle client application on the client machine to a remote oracle server on the server machine but i get a connection fail.
On the server machine I configured oracle server in the following way:
Installed oracle server. Created a database "DB_Test" with the database configuration assistant Created a LISTNER with the Oracle NET Manager with the following parameter:
Protocol: TCP/IP HOST: server pc hostname (ENZOVAIO) or server machine address ip (192.168.0.71) in the network lan Port Number: 1521 Created "dbtest" service with the Oracle NET Manager with with the following parameter:
Service Name: "dbtest" Protocol: TCP/IP HOST: server pc hostname (ENZOVAIO) or server machine address ip (192.168.0.71) in the network lan Port Number: 1521
All services on the server machine are running and I opened port number (1521) in the router. On the client machine I installed SQL PLUS and SQL Developer.
With SQL Plus as by the official documentation I have entered the following command:
CONNECT username/password@[//]host[:port][/service_name]. In my case is:
CONNECT SYSTEM/oracledb@//ENZOVAIO:1521/testdb.
With SQL Developer I have entered the same parameter.
But with both SQLPlus and SQL Developer the connection fails.
View 14 Replies
View Related
Aug 10, 2010
we have oracle server. we have to connect 500+ client machine to oracle server.
is it i need to install client version to all 500+ or any other shortcut way?
View 6 Replies
View Related
Oct 6, 2010
I have the following computer/setup:
Acer laptop, Intel Processor w/ Windows 7 Professional (64-bit)
Delphi 2010 Professional
Oracle XE (+ the Oracle XE client that comes with it)
I cannot can't to the Oracle database from Delphi. 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. Create an ODBC connection to my Oracle database
- run C:WindowsSysWOW64odbcad32.exe to open the ODBC administrator.
- Data source name: bt_user
- TNS Server Name: localhost/xe
- user bt_user
- Clicked "test connection" -- Success.
2. Open Delphi and drop a TDatabase component on my main form.
- Set the Alias Name property to "bt_user" (the alias I set up in ODBC)
- Set database name to "bt_user".
- Checked "connected".
Alternatively, I tried using the Delphi ADO components (the dbGo components).
- Drop TADOConnection component on my form.
- Select "connection string" and open the dialog.
- Click "build string".
- Select "Microsoft OLE DB Provider for ODBC Drivers" from the selection.
- In "use data source", select "bt_user" from the drop-down list (my ODBC connection from #1)
- Click "test connection".
Again the same error.
My questions are:
1. Can Delphi work with Oracle XE (Express Edition)?
2. If so, then do I need to install the "Instant Client"?
3. Will the instant client for Oracle 10g work with Oracle 10g XE?
4. Do I need to install any additional ODBC driver(s)?
5. Why was I successful in creating the ODBC connection in Windows, but it failed in Delphi?
6. Will Visual Studio.NET (C#) work with Oracle XE, and what are the steps for setting that up?
View 2 Replies
View Related
Dec 6, 2011
Is it possible to link to Discoverer Viewer from Forms without requiring the user to log in again. If so, can I then link to a specific Workbook within Discoverer?
View 2 Replies
View Related
Mar 19, 2012
When running my query in sql developer, I have to execute the command apps.fnd_global.apps_initialize(user_id, resp_id, resp_appl_id) in order to show the result of my query. Without this, the query returns nothing. The problem is I am using this query as a custom query for my Discoverer report and my report does not show any record.
View 3 Replies
View Related
