SQL & PL/SQL :: How To Grep Client IP Address When LOGON

Aug 4, 2011

How 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]....

View 13 Replies


ADVERTISEMENT

Client Tools :: Logon Trigger Creates 2 Records?

Aug 5, 2010

why my logon trigger always creates 2 records with different timestamp. Also is this the proper way of excepting records to insert?

Script.

CREATE OR REPLACE TRIGGER TR_LOGON_AUDIT
AFTER LOGON ON DATABASE
BEGIN
If user<> 'DBSNMP' then -- don't want to insert this
if user <> 'SYS' then -- don't want to insert this

[code]....

Result when select.

OS_USERNAME LOGON_TIMESTAMP
----------- ----------------
GAN 2010-08-05 14:27:52
GAN 2010-08-05 14:27:55

View 12 Replies View Related

Forms :: How To Get Client IP Address

Feb 15, 2010

method to get the ip address of Client machine using oracle forms .

I am using Oracle forms 6i and application server 9i.

View 9 Replies View Related

Forms :: Get Client IP Address Using 10g Rel.2?

May 2, 2011

how 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 Related

ODP.NET :: How To Get IP Address And Machine Name Of Client

Oct 15, 2012

On 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 Related

SQL & PL/SQL :: Retrieve IP Address For Client Who Do The Transaction

Apr 19, 2011

am 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

View 8 Replies View Related

Oracle 11g Client / ORA-12533 Illegal ADDRESS Parameter

Jul 10, 2011

I 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.

View 2 Replies View Related

Forms :: Get Client IP Address And Machine Name In Oracle 10g Without Webutil

Sep 26, 2013

How can we get client ip address and machine name in oralce forms 10g without webutil.

View 3 Replies View Related

Database Design For Storing Client Address Information For All Its Branches?

Jul 27, 2012

I 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.

View 3 Replies View Related

SQL & PL/SQL :: Display Office Address / House Address And Emp ID In Single Query?

Feb 23, 2013

I have two tables emp , emp address as below

emp table :
emp_id emp_name,
1 rajesh
2 suresh

emp address table :

emp id emp_addresstype emp address
1 O kukatpally
1 H Hitech
2 O Kolkata
2 H hydar nagar

I need the query to display the Office address & House address & emp id in single query

ex: 1,Kukatally,hitech
2,kolkata,hydarnagr

View 3 Replies View Related

Forms :: Get Client IP Address When Initializing Forms

Jun 25, 2010

How 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

View 30 Replies View Related

Logon Trigger Not Getting Updated

May 9, 2011

There is a xxxxx.sql file in the OS level which contains create or replace trigger script. I modified that file with the code below:

if(upper(USER)= 'U_USER') then

execute immediate 'alter session set current_schema=USER';

end if;

after that, I went to sqlplus
and logged in to U_USER like this
SQL>conn U_USER/U_USER;
connected.

SQL>@xxxxx

some numbers are getting generated if i press enter.

Then i press ctrl +c and get to sql prompt.

I issue

SQL>select SYS_CONTEXT('USERENV','CURRENT_SCHEMA') FROM DUAL;

I am getting the output as U_USER but I must get the output as USER and not as U_USER. Basically the trigger is not getting updated.

View 1 Replies View Related

SQL & PL/SQL :: QUERY - Host Name And Max Logon Day?

Oct 27, 2010

I want to host name and max logon day from the below query But host name not belongs to start with 'IRS%' and 'EMEAUKIMIV00023828'.

My question is How to handle the backslash in oracle 8i and also check the below query is ok or not,

select host, max(logon_day) from (
select host,logon_day from system.stats$user_log
where host not like 'IRS%'
AND not in ('EMEAUKIMIV00023828'))
group by host;

View 10 Replies View Related

Create After Logon Trigger

Jun 20, 2012

I'm looking to create an after logon trigger... my question is - can this trigger be created by any user (i.e. other than sys) and - if so - what's required to ensure it fires for EVERY other user that log's on to the database?

View 2 Replies View Related

Can't Connect To Oracle - Logon Denied

Mar 21, 2011

i installed Oracle 11.2.0 64bit & Oracle SQL developer 2.1.1.64 on Windows-7 64bit

i try to connect to database like this:

username: scott
password: tiger
role : sysdba
hostname: localhost
port : 1521
sid : ORCL

and i got this error: `ora-01017 invalid username/password; logon denied`

View 3 Replies View Related

Forms :: Logon / Logout Screen

Feb 3, 2012

I am developing menu.. in that menu having 5 different forms.. these forms are 3 one schema ( i.e X ) and remaining 2 forms are one schema ( i.e Y )..

i am calling x schema

form level trigger on_logoon :
onlogon('a','a@X');

a for Username and x database name and another form in form level trigger on_logon : coding

logout;
logon('b','b@Y');

b for Username and y database name

but the form is not executing and not saving the record's.

View 1 Replies View Related

SQL & PL/SQL :: Create A Trigger With After Logon Database?

Apr 28, 2011

i would like to trace some connexions on database, once compile the code , i have the issus following:

10/2 PL/SQL: SQL Statement ignored
11/20 PL/SQL: ORA-00942: table or view does not exist

this is the

DROP TABLE connect_user;
CREATE TABLE connect_user
(
nom_ora varchar2(15),
naom_os varchar2(15),
programme varchar2(20),
poste varchar2(20),

[code]...

View 3 Replies View Related

Security :: Logon / Off Audit Using Audit_Trail?

Jul 30, 2010

getting logon timestamp for our auditing process. In some website, it says to get the logon timestamp I have to select it from timestamp column of dba_audit_session but when I do this, some results has a logoff earlier than logon. Is timestamp column really the logon timestamp?

SELECT
returncode,
(logoff_time-timestamp) timeonline,
TO_CHAR(timestamp, 'DD-MON-YYYY HH24:MI:SS') LOGON_TIME,
TO_CHAR(logoff_time, 'DD-MON-YYYY HH24:MI:SS') LOGOFF_TIME,
action_name
FROM dba_audit_session;

[code]....

View 2 Replies View Related

Security :: Unable To Logon As Sysdba?

Mar 3, 2005

I am working on oracle 9.0.1 version on XP.

Here I am unable to log as sysdba

I am doing like this

d:sqlplus /nolog
sql>conn /as sysdba

not working,giving an error then i tried

sql>conn sys as sysdba
again same error :_ insufficent Priv..

where as sql> conn system/manager working

View 21 Replies View Related

Forms :: How To Logon With Externally Identified Password

Mar 11, 2004

I have a externally identified oracle id. In the logon screen I want to enter / and logon externally.

I have tried using ? with LOGON built in package but it doesn't work.

/@<servername> does not work ?

how to logon to oracle forms with a externally identified password?

View 1 Replies View Related

SQL & PL/SQL :: Which Privileges Required To Create A Trigger Like After Logon On Database

Mar 17, 2011

Which Privileges required to create a trigger like after logon on database. I have grant Create any trigger privilege to user but still not able to create and give me an error insufficient Privilege.

View 5 Replies View Related

Getting ORA-01017 Error Invalid Username / Pwd Logon Denied

Oct 19, 2010

i am getting ORA-01017 error frequently .

we have an application that is running from remote host to connect database using JDBC driver 10.2.0.2

but i am getting ORA-01017 error intermittently. we fetching stored username/pwd after every 5 min but for certain interval it's giving error and we get connection sucessful after some time with same username pwd.

the application monitor more number of databases but facing problem with only 1 instance.

View 1 Replies View Related

ORA-01017 - Invalid Username / Password - Logon Denied

Jun 26, 2012

Case 1,

-I have a Oracle Client 11.2.0.1 (*Administrator*) installed on a client machine on Redhat 6.
-I have a database 11.2.0.1 testdb installed on another machine.

I configured tnsnames.ora for the client machine to connect my database testdb.If I use sqlplus to connect to the testdb from client machine, it's successful.However, If I use one of the jdbc connection string from the client machine, it reports "ORA-01017: invalid username/password; logon denied"

Case 2,

-I have a Oracle Client 11.2.0.1 (*Runtime*) installed on a client machine on Redhat 6.
-I have a database 11.2.0.1 testdb installed on another machine.

I configured tnsnames.ora for the client machine to connect my database testdb.

-If I use sqlplus to connect to the testdb from client machine, it's successful.
-If I use one of the jdbc connection string from the client machine, it 's successful too.

For case 1 and case 2, the only difference is the Oracle client (one is Runtime, the other is administrator)The database I have is set to

SQL> show parameters case

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon boolean FALSE

why the administrator client report ORA-01017?

View 15 Replies View Related

XE :: Unable To Login With Logon As OPS$-user To Get SAPSR3 Password?

Jun 18, 2013

my listener getting started and database also up

but gives error

Connecting as SAPSR3/<pwd>@ECC on connection 0 (nls_hdl 0)

Logon as OPS$-user to get SAPSR3's password

If can share screen shots are some link so i can go aehad

what is the default password for SYSTEM

View 1 Replies View Related

Security :: ORA-01017 / Invalid Username / Password - Logon Denied

Jul 2, 2011

I am not able to login in the database with sys user. when i am trying with sqlplus "/as sysdba" it is showing

ERROR: ORA-01031: insufficient privileges.

& when i am trying with sqlplus sys as sysdba it is showing

ERROR:ORA-01017: invalid username/password; logon denied.

I login with system user and changed the password of sys nd then tried login with sys but same result.

remote_login_passwordfile is set to NONE nd i am login through that user only by which i was always able to login.

View 23 Replies View Related

SQL & PL/SQL :: Obtaining REMOTE ADDR Using Owa_util Package In After Logon Trigger

Nov 16, 2011

I am working in the company which is using PL/SQL to create web interface. Of course we are using mod_plsql. I was using OWA_UTIL get_cgi_env ('REMOTE_ADDR') in the packages and it was always properly returning the IP address of the client. But Now I want to use it in after logon on schema trigger and it is never initialized.

Maybe some other way to obtain the IP of the client machine just before calling the package which is showing the interface?

Here is the simplified code of the trigger:

CREATE OR REPLACE TRIGGER dev_debug_trg AFTER LOGON ON SCHEMA
DECLARE
l_ip VARCHAR2(200);
BEGIN

[Code].....

View 3 Replies View Related

Forms :: Login As SYSDBA In Oracle From Normal Logon Procedure?

Apr 24, 2012

is it possible to login as SYSDBA in oracle forms from normal logon procedure?

logon(sys_acc, sys_pwd||'@'||:GLOBAL.db_conn);

The reason behind this is to make a form which will alter user's password. But all the users are in SYS account and it is necessary to login as SYSDBA in forms to execute alter statement.

View 4 Replies View Related

Security :: ORA-01017 - Invalid Username / Password - Logon Denied?

Sep 24, 2013

I have a log-in problem. I created the new database and when I try to log-in with system user, its giving ORA-01017: invalid username/password; log-in denied, and when I try to log-in with "/ as sysdba" its successfully logged in.

When I try to change SYSTEM user password, I successful change and connecting and after few seconds when I try to connect its again giving same error "ORA-01017: invalid username/password; log-in denied

And I disable the case sensitive password also:

sec_case_sensitive_logon boolean FALSE

OS: windows
Oracle Versions: 11.2.0.1.0

View 6 Replies View Related

Create A Query That Displays Number Of Unique Logon For Each User Per Day?

Feb 23, 2010

I have a table that has three columns.
UserId - DateStamp - Action

An action contains user activities such as "logon". A user may logon multiple times in a day.I'm trying to create a query that displays the number of unique logons for each user per day.

By doing the following:

select userid, to_char(creationtimestamp,'YYYY-MM-DD'), count(*)
from useraction
where action = 'logon'
group by to_char(creationtimestamp,'YYYY-MM-DD'), userid
order by to_char(creationtimestamp,'YYYY-MM-DD') desc;

I can get the following results
userid - date - count
1 - 2/21/2010 - 8
1 - 2/22/2010 - 3
2 - 2/22/2010 - 2
1 - 2/23/2010 - 1
4 - 2/23/2010 - 6
6 - 2/23/2010 - 1

What I'm trying to get is
2/21/2010 - 1
2/22/2010 - 2
2/22/2010 - 3

View 2 Replies View Related

Server Administration :: Get Details Of SYS / SYSTEM Users Logon And Logoff Time

Aug 13, 2012

I want to get the details of the SYS/SYSTEM users logon and Logoff's time.

Steps 1:
=======
SQL> SHOW PARAMETER AUDIT

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest string C:ORACLEPRODUCT10.2.0ADMIN
DB10GADUMP
audit_sys_operations boolean FALSE
audit_trail string NONE
SQL>

Step 2:
=======
Set the Necessary parameters:
-----------------------------
alter system set audit_trail=db scope=spfile;

Step 3:
=======
Shutdown the DB

Step 4:
=======
Restart the DB

Step 5:
=======
For auditing the Session. Fire the below command.

AUDIT CREATE SESSION;

Step 6:
=======
select DISTINCT USERNAME,os_username,timestamp,logoff_time
from DBA_audit_session;

When I fire the above query, I couldn't get the SYS user's LOGOFF time. But for rest of the users, I am getting.

View 12 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved