wah pak indra dah senior nih mo nanya ah....
pak, kok kalo saya manualin service oracle di XP
pasti aja lama2 error ga mo jalan sama sekali,
service-nya yang paling atas deh pokoknya, bukan iSQLPlus, bukan listener,
pokoknya yang paling atas, dengan kondisi yang terinstal hanya Oracle Database
10G
pesan error bukan "timely fashion", kalo ga salah katanya ga sesuai sama
Microsoft Version gitu...
Sedangkan Kalo di Automatic, jelas lambat banget notebooknya pas startup...
kadang harus nunggu lebih dari 10 menit...
Mohon Bantuannya ya Pak Indra dan Rekan2 yang lainnya
Indra Armansyah <[EMAIL PROTECTED]> wrote:
Salah satu contoh untuk membuat triggernya:
1. Connect sebagai SYSTEM:
CREATE OR REPLACE TRIGGER LOGON_TRIGGER
AFTER LOGON ON DATABASE
DECLARE
v_user_identifier varchar2(64);
BEGIN
SELECT SYS_CONTEXT('USERENV', 'OS_USER')
||':'||
SYS_CONTEXT('USERENV', 'IP_ADDRESS')
INTO v_user_identifier
FROM dual;
DBMS_SESSION.SET_IDENTIFIER(v_user_identifier);
END;
/
2. Connect sebagai SCOTT, untuk mencoba apakah trigger yang telah dibuat
berhasil dieksekusi.
3. Connect sebagai SYSTEM:
SELECT username, client_identifier, module FROM V$SESSION;
USERNAME CLIENT_IDENTIFIER MODULE
------------------------------ ------------------------------- --------------
SYSTEM indra:10.10.10.27 SQL*Plus
SCOTT indra:10.10.10.27 SQL*Plus
Selanjutnya bisa dimodifikasi sendiri sesuai dengan kebutuhan.
Semoga membantu.
Salam,
Indra Armansyah
[EMAIL PROTECTED]
----- Original Message -----
From: Oscar Wilyanto
To: [email protected]
Sent: Friday, March 16, 2007 7:55 AM
Subject: [indo-oracle] Dapetin IP address client di isqlplus
Dear Masters,
Saya ingin membuat trigger yang mencatat semua ip address yang melakukan
loggin ke database, terutama yang melalui isqlplus..
Bagaimana caranya? apakah ada paket khusus untuk ini?
Thanks in Advance
Oscar
----------------------------------------------------------
This message contains confidential information and is intended only for the
individual named. If you are not the named addressee you should not
disseminate, distribute or copy this e-mail. Please notify the sender
immediately by e-mail if you have received this e-mail by mistake and delete
this e-mail from your system. E-mail transmission cannot be guaranteed to be
secure or error-free as information could be intercepted, corrupted, lost,
destroyed, arrive late or incomplete, or contain viruses. MKD Group therefore
does not accept liability for any errors or omissions in the contents of this
message, which arise as a result of e-mail transmission. If verification is
required please request a hard-copy version.
MKD Group, www.mkdgroup.com
----------------------------------------------------------
[Non-text portions of this message have been removed]
----------------------------------------------------------
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.11/722 - Release Date: 3/14/2007
3:38 PM
[Non-text portions of this message have been removed]
---------------------------------
Get your own web address.
Have a HUGE year through Yahoo! Small Business.
[Non-text portions of this message have been removed]
