Forms :: Get Client IP Address And Machine Name In Oracle 10g Without Webutil
Sep 26, 2013How can we get client ip address and machine name in oralce forms 10g without webutil.
View 3 Replies
ADVERTISEMENT
ODP.NET :: How To Get IP Address And Machine Name Of Client
Oct 15, 2012On cliente/server, I used to get the user IP address using SYS_CONTEXT and IP_ADDRESS, and the terminal name with SYS_CONTEXT and HOST.But in web environment, these functions returned Server IP and name.I have to build a trigger to obtain the information of user IP address and terminal name to save on audit table.
View 8 Replies View RelatedForms :: Using Webutil To Get IP Address On Form Load
Feb 12, 2008My requirement is to show the ip address of the client after he has logged in.
I tried putting the code in when-new-form-instance .. but it returns null. I think the webutil objects are not yet loaded in when the when-new-form-instance is fired. If I put the same code in a push button , I am able to get the IP address. Actually for test purpose I am displaying the IP in a message.
Message ('Client IP add '|| webutil_clientinfo.get_ip_address);
Forms :: Store Report Output In Client Machine Through Oracle 11g
Aug 24, 2011i am generating report from oracle forms using web.show_document .pdf output is coming in seperate url.entire piece of code is working fine.now i want to store this pdf out put in client machine whether path will be specified by user.
View 3 Replies View RelatedForms :: How To Get Client IP Address
Feb 15, 2010method to get the ip address of Client machine using oracle forms .
I am using Oracle forms 6i and application server 9i.
Forms :: Get Client IP Address Using 10g Rel.2?
May 2, 2011how i can get Client IP address using Forms 10g Rel.2 and if other useful information i can get, how is it possible? is there any other solution if not using WebUtils ?
View 2 Replies View RelatedOracle 11g Client / ORA-12533 Illegal ADDRESS Parameter
Jul 10, 2011I am working on a database application which works as a data access layer. The application uses OCI interface to connect and query to the Oracle Database. This application is certified on Oracle 9i and 10g client and works fine without any issue, but when I am certifying the application on Oracle 11g client, I am getting connection failed problem and following Oracle Error is displayed.
ORA-12533 illegal ADDRESS Parameter.
There is no change in the environment setting between Oracle 10g and Oracle 11g.
Following are the details of the environment
Version of Oracle 11g client is 11.1.0.6.0
Version of Oracle Database is 11.1.0.6.0.
Platform - Solaris 5.9 on sparc v9
On enabling client trace with support level also does not work. It shows TNS error TNS-12533 illegal ADDRESS Parameter.
what could be the possible reasons that the connection is failing with Oracle 11g client, while the same is working with Oracle 10g client. As I said there is no environmental difference when performing this test. The only change is ORACLE_HOME setting for the corresponding Oracle client version.
Forms :: Get Client IP Address When Initializing Forms
Jun 25, 2010How to get the client machine IP in Forms 10g without using webutil? I know the function Webutil_clientinfo.get_ip_address. But Webutil is not working in when new form instance. And I need get client ip address in trigger PRE-FORM.
sys_context('userenv', 'IP_ADDRESS') return address of server, not client.
OR
How to make the trigger WHEN-CUSTOM-ITEM-EVENT in Webutil starts before triggers "WHEN-NEW-FORM-INSTANCE" and "PRE-FORM" ?? To use webutil_ clientinfo.get_ip_address
Installation :: Oracle 10g Client Install Skips - Windows 7 Machine
Nov 15, 2013I have Oracle 11g database home in my 64 bit Windows 7 machine. However, now i would like to install Oracle 10.2.0 client as well. I tried giving a separate location.
But for some reason, whenever i start the Setup and run the Administrator Type, the installation just skips without giving any errors. It just creates the inventory folder in the specified path. It goes to the Product-Specific Prerequisite Checks and exits without giving any warnings or errors.
Forms :: Generate File From Database Into Server And Copy It To Client Machine
Feb 2, 2012I have a forms that generate a file from database into database server and copy it to client machine by the follow process:
IF webutil_file_transfer.Is_AS_readable(V_server_way || V_file_name) THEN
l_success := webutil_file_transfer.AS_to_Client
(clientFile => :V_screen_way
[code]...
But is showing the erro ora-105100 in one client machine
Forms :: Configured Webutil For OAS On Oracle EBS R12 Linux 64?
May 1, 2010I have configured and tested the webutil in Windows Operating System and worked perfect, Now i am trying to deploy customized form to EBS R12 that using webutil, and after making same configuration which has done before, i got compilation error.
Form is very simple(Just button with following pl/sql code)
show_webutil_information (TRUE);
Erro is: "FRM-40039: Cannot attach library WEBUTIL while opening form XXR12_DEMO.fmb"
webutil configuration steps on R12 or the error solution,
Client Tools :: Oracle / Crystal Reports On Windows 7 64Bit Machine?
Feb 1, 2011I recently got a new PC at work which is Windows 7 64 bit.
We run lots of crystal reports(1000's) that pull data from an oracle back end.
I have installed the Oracle Client 32 bit on this machine and have no problem connecting to the database and pulling back data.
However, when I use crystal to access the TNS Name it gives me the following error.
[URL]
My path variable on the PC has "C:oracleproduct10.2.0client_1BIN;".
I also tried to create and ODBC using the 32bit ODBC on the machine and that connects fine, but when you try to access the DSN from Crystal, I still get the 12154 error.
Client Tools :: How To Configure SQL DEVELOPER Via Virtual Machine Oracle Database
Mar 21, 2012i have oel installed on my parallel Virtual machine.
i have a problem with configuring sql developer to the oracle database which is located in my virtual machine.
my os is windows7 32 bit.
Best Way To Change Language Of Windows Oracle Client Machine Edit Registry
Jun 29, 2012We have installed oracle client on Windows machine and despite selecting language as English
when look in registry shows NLS_LANG as
AMERICAN_AMERICA.WE8MSWIN1252.
What is the best way to change language of Windows oracle client machine edit registry.
Forms :: How To Get Domain Name Using Webutil From 10g And Oracle Application Server Name
Apr 29, 2010How can i get my domain name using webutil. from forms 10g.
View 8 Replies View RelatedForms :: How To Use Static IP Address In Oracle 10g
Jun 4, 2011how to use static ip address in oracle 10g.
View 5 Replies View RelatedForms :: Install Oracle 5i On XP Machine
Oct 30, 2012I am getting below error when I try to install Oracle Form5i on XP machine.
"OS_ERROR while translating path from $"
SQL & PL/SQL :: Retrieve IP Address For Client Who Do The Transaction
Apr 19, 2011am using oracle 10g
and i want to retrieve IP address for client who do the transaction
and i try to using some selects like select terminal from v4session but it return the IP for application server
so i think to use commands ipconfig
how can i call windows commands by oracle
SQL & PL/SQL :: How To Grep Client IP Address When LOGON
Aug 4, 2011How to grep client's IP address when LOGON to database? I write a trigger , but when compile , it show Error , Here is code :
CREATE OR REPLACE TRIGGER On_Logon
AFTER LOGON ON The_user.Schema
DECLARE
v_addr VARCHAR2(11);
BEGIN
IF (ora_sysevent = 'LOGON') THEN
v_addr := ora_client_ip_address;
raise_application_error( '-20001', 'user IP: '||v_addr);
END IF;
END;
[code]....
PL/SQL :: How To Get Client Machine Name And Client User Name
Dec 25, 2012the trigger shown below is working fine.But i want to get client machine name and client osuser name in the output of the same trigger shown below,how can i achieve this in the same trigger?
trigger :
------------
CREATE TABLE logonaudit
(
user_id VARCHAR2(30),
sess_id NUMBER(10),
logon_time DATE,
host VARCHAR2(20));
[code]....
the output showing sessionid,date,db user name,host as local server machine name.but i want client machine name and client osuser names as u all know clients login to database from their machines.
Database Design For Storing Client Address Information For All Its Branches?
Jul 27, 2012I have to design a database so that the performance is optimum and joins are optimum between tables.
Requirement - I have several banks as clients globally, like HSBC, RBS, AMEX etc. Each bank operate globally, and are divided like the geographies, regions etc. For eg. HSBC is operating from US, UK, ASIA, AUSTRALIA. Each geoagraphy is further divided/childs, like, in ASIA has INDIA, PAKISTAN, SRI LANKA, CHINA. Further, it is divided, like in India, it has cities like DELHI, BOMBAY, CHENNAI etc., then further it has within Delhi - Lajpat Nagar, Rohini, Pashim Vihar etc.
As per the above scenario, I need to store addresses, phone numbers, of all the branches of all clients. Also, there is one more condition like in the above defined hierarchy, later on, a new hierarchy can be added, like In INDIA, it can further divided in States and then its local cities.
Not Able To Connect From Client Machine
Dec 23, 2010I have installed oracle 10g on Red Hat Linux and I am able to connect as well.The listener and DB is up and running and I am able to coonect as well from the server.
But I have installed the oracle client (TOAD) on some windows machine and from there I am not able to connect . I am directly connecting by giving IP and other details and using TNS as well but I am not able to connect from client machine. I am getting ORA 12170 - TNS timeout error.
[root@rhel1 admin]# sqlplus system/system@db102
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Dec 23 11:16:04 2010
Copyright © 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL>
SQL>
Client RMAN Backups From AIX Machine
Mar 7, 2010I have some client RMAN backups from an AIX machine, a set of .bkp files including the control file, that I have been asked to restore on a Windows 2003 server. My first question is if such a restore is possible?Also, the backups are from Oracle 10.2.0.3, and I need to restore them to 11g, will this cause any complications?
how to carry out such a restore procedure from scratch.
SQL & PL/SQL :: Read All Files In Directory On Client's Machine
May 30, 2012I want to read all the files present in a directory of client's machine.
However I have achieved this by creating java class in database but the problem is it accesses the directory of machine on which database is installed not the client's machine.
I have oracle client and I tried to access local directory of client's machine to read all the files in that directory but it didn't work.
However, I achieved this by creating one java class for ex. test.class and I run it locally through command prompt but I want to achieve it using Pl-sql.
Forms :: Configure Webutil For Use With 11g?
Jun 14, 2010have a link to install/configure webutil for use with Forms 11g?
View 2 Replies View RelatedForms :: Configure Webutil In 10g?
Aug 3, 2012how configure webutil in forms 10g. send me all the doc related to this.
View 2 Replies View RelatedForms :: Message From Webutil?
Apr 3, 2012I'm migrating some forms from 6i to 9i and one of them has to use the webutil library, but when I execute the form in the IE, a message appear and I don't know from where because I haven't made it. The message say: "Confirme el mensaje" This is a print of the message,
View 3 Replies View RelatedForms :: Progress Bar In Webutil
Mar 13, 2010I have challenge to do progress bar
i have simple form has one database block tabular used to upload files by webutil procedures
my question is there build_in progress bar that special for uploading could be used by webutil ?
Networking And Gateways :: Client And Database Server On Same Machine?
Mar 26, 2013I have client and database on same machine, when I will connect to the instance , it will use IPC, suppose If I will use connection string then which process will handle this request?
View 2 Replies View RelatedServer Utilities :: EXPORT And IMPORT From Client Machine?
Oct 8, 2012 Is it also possible to use the EXPORT and IMPORT utilities from a client machine? I want to give these utilities to one of my developers without allowing him to sit in front of my Oracle server.
i am using oracle 11.2.0.1 and windows7 OS