I'm having trouble with my forms builder. I can't connect to my reports server.
DECLARE
REP_ID REPORT_OBJECT;
REP_J_ID VARCHAR2(25);
SERVER_LENGTH NUMBER;
REP_STATUS VARCHAR2(25);
[code]...
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....
I'm trying to catch the FRM-41213 ERROR (Unable to connect to the report server), so I can switch the generation to another report server. At runtime the message FRM-41213 appers but I'm unable to catch it using 'exception' or 'error_code'.
Here's my
begin
v_rep := run_report_object (repid, pl_id);
if err_type = 'FRM' and (err_code = '41213' or err_code = '41214') then
message('ss error catch');
end if;
exception
when others then
message('ss error to handle');
end;
"FRM- 41213: Unable to connect to the report server error"
View 17 Replies View RelatedI 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 RelatedIs it possible to connect SQL Server 2000 with Forms6i?
View 1 Replies View RelatedI just want to know whether Oracle forms 11g supports other databases like DB2, SQL Server etc.
Also does Oracle forms 11g supports Oracle database 9i or 10g apart from 11g?
I have a pb went i can access on my forms server:
FRM-92050: Failed to connect to the Server: ://127.0.0.1/servlet/oracle.form...enerServlet:-1
java.net.ConnectException: Connection refused
We are unable to connect to Oracle 11.1.0.7.0 from Oracle Forms 4.5..However we are able to connect using Oracle forms 6i
Now Forms 4.5 is old and not supported, however apart from Tests I will need prove it to the higher ups...Do we have any link, document which will cover such compatibility issue?
i am using client-server environment without using a domain.On One computer i have installed Oracle 8.0.5 and developer 2000. and on client side i have installed form 6i. 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 connect to destination
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
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.
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.
How can we run forms & Reports from server through internet. I mean that i want to install forms, reports and database on server and not interested to install runtime on client computers so is it possible if yes then what can i do for this?
View 1 Replies View RelatedCan I install Forms 10g on WIN 2003 64 bit server? From ORACLE site, I downloaded forms 10g, but it is not sepcified that it s for 32 bit or 64 bit.
View 1 Replies View RelatedAfter I moved my servers (application and db) into a VPN network I am facing this error "REP-51002: Bind to Reports Server failed".
Product-Oracle Forms and Reports 11g
Servers(app and db)- Windows 2008
While accessing the reports i am getting the following error
Rep - 51002 : Bind to Reports Server rep_wwubh01ap45 failed.
I have checked the file $ORACLE_HOME/reports/conf rwservelet.properties. The parameter SERVER=rep_wwubh01ap45 was present in that file.
We have a reports proces which we want to produce a report where the browser windows doest not display, or if it does, quickly closes after the report is completed.We are using Forms Version 10.1.2.0.2, Oracle Database 10g Release 10.2.0.4.0, OS is Windows XP Pro SP3
We have tried the below, but the primary application window closes, not the report server window.
- http - removed due to form message:You cannot use links until you have posted more than 5 messages.
WEB.SHOW_DOCUMENT(://'|| :global.Report_Server_Name ||
'/reports/rwservlet?cmdkey=ky10i&report='||v_rep_object||'.rdf' ||
'¶mform=no&desformat=pdf&destype=file&desname='||v_file_dir||
'&P_VOU_ID='||'883100000000000005565047129970'||
[code]...
We have modified the forms trigger to produce the report as shown below, but get the error:
FRM-41213: Unable to connect to the Report Server
Current theory is the connection to the database is lacking the user id and password since the cmdkey is not specified. How can we specify the cmdkey when using the run_report_object?
= = = = = = = = = = = = = = = = = = = = = =
DECLARE
v_rep_tx VARCHAR2(100);
v_RepStatus VARCHAR2(2000) := '';
v_rep_idREPORT_OBJECT;
v_repVARCHAR2(100);
[code]...
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.
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?
I am getting this error ( ORA-12516: TNS:listener could not find available handler with matching protocol stack ) When I am trying to connect to the server through my application in which I am using SOAP
View 1 Replies View RelatedI do not know how to create a connection between oracle to SQL server using topology manager on my application. I understand that I must create a logical and physical architecture to create the connection and the logical and physical architecture is running under topology manager.
View 1 Replies View RelatedWhen we tried to query a data from the sql server we are getting the below generic error message i
SQL> select * from all_users@testing
2 /
select * from all_users@testlink1
*
ERROR at line 1:
ORA-28545: error diagnosed by Net8 when connecting to an agent
Unable to retrieve text of NETWORK/NCR message 65535
ORA-02063: preceding 2 lines from TESTLINK1
below are the details setup / configuration done by us:
os :windows 2008 server.
database "oracle standard edition
Command Line input /output:
C:\Users\aorenstein>C:\oracle\product\11.2.0\db_1\bin\dg4odbc
Oracle Corporation --- WEDNESDAY JUN 20 2012 10:20:54.308
Heterogeneous Agent Release 11.2.0.1.0 - 64bit Production Built with
Oracle Database Gateway for ODBC
[code]....
OS: RHEL 5.7 64 bit
DB: 11.2.0.2 SE 64 bit
We have a scenairo in which we have two servers one is a Oracle server and the other is SQL server and we need to enable automated Emails from the oracle DB server. As the Oracle server is not whitelisted and we have a SQL server which is already whitelisted so is it possible to connect from Oracle server to Sql server so that the automated emails will be generated from the sql server (as it is whitelisted) and we do not want to whitelist the oracle server.
Is it possible to connect to 10g oracle server from 9i client?
View 1 Replies View RelatedWeb Server(port80) and SSH Server(port 212) and Oracle client with sqlplus (192.168.137.2)
||
||
SSH client (192.168.137.1/128.21.31.111)
||
||
Oracle Server (port 1521) (128.21.31.112)
my php program have to access the db on oracle server, and then i do this on my SSH client
ssh -p 212 user@192.168.137.2 -R 1521:128.21.31.112:1521
I have Tow Virtual Servers (Connect As Cluster) in the Same Computer The Files In the Drive C Different (of the Tow Servers) And Others Like (e,f,q) The Same Files
And There is Database of both Servers That Have Same Name Let say orcl and both database Have same Schema let Say sch
How I can Share The Data when i am insert to table. in the schema sch in the server A i can see Same Data That I have Inserted In the Schema sch in the server B.
1-How much memory is needed to use the Oracle 11g Enterprise Manager? (Probabely other parts need less memory than EM)
2-When i try to connect to Oracle 11g , get the following error?
can connect a 64 bit Oracle 11g Release 2 on a Windows 7 client with a 32 bit Oracle 11g Release 2 on a Windows 2008 server?
View 5 Replies View Relatedhow to connect to sql server databases via toad. I have used toad to connect to oracle databases, but never to a sql server database. To connect to an oracle database, we first install the client and then add the tnsentry of the database to the tnsnames.ora file and then we can directly connect to the oracle database right?So I was wondering if there are any steps like that to be followed to connect to the sql server databases.
View 2 Replies View Related