| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-2083 DATABASE name has illegal character '-'
Rick - Can you do that insert in SQL*Plus (outside the trigger)? I'm sure
you have, just my logical completeness tendency.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Tuesday, December 03, 2002 3:09 PM
To: Multiple recipients of list ORACLE-L
Yes I have taken the insert statement out of the logon trigger and it works fine. I think there may be a possible bug with logon trigger using database links.
DENNIS WILLIAMS
<DWILLIAMS_at_life To: Multiple recipients of
list ORACLE-L <ORACLE-L_at_fatcity.com>
touch.com> cc:
Sent by: Subject: RE: ORA-2083 DATABASE
name has illegal character '-'
root_at_fatcity.co
m
12/03/2002
03:14 PM
Please respond
to ORACLE-L
Rick - Have you tested the link itself?
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Tuesday, December 03, 2002 1:10 PM
To: Multiple recipients of list ORACLE-L
Hi,
Oracle 8.1.6.0.0 NT 4.0
I have the following logon trigger. It works fine as long I insert into local table. If I try to insert into a table across a database link the record get inserted but upon exiting the app whether it is sqlplus,forms,etc I get ora-2083. I think it is probably a bug since I have exact same environment and it works Ok. It fails on 3 other identical environments. Anyone heard of any possible bugs using database link in logon trigger? I search metalink and google but no such reported error.
DROP PUBLIC DATABASE LINK utilities_a12345_dblink; CREATE PUBLIC DATABASE LINK utilities_a12345_dblink CONNECT TO utilities IDENTIFIED BY 123x456x USING 'a123456';
GRANT SELECT ON v_$session TO PUBLIC;
GRANT SELECT ON v_$instance TO PUBLIC;
DROP TRIGGER login_capture;
CREATE OR REPLACE TRIGGER login_capture AFTER LOGON ON DATABASE
DECLARE
CURSOR temp_rec IS
SELECT user AS user_name,
NVL(UPPER(SUBSTR(osuser,1,30)),'SERVER') AS os_user_name,
RTRIM(NVL(SUBSTR(machine,instr(machine,'\') +1,12),'SERVER'),CHR(0))
AS machine_name,
sid AS session_id,
serial# AS serial_no,
SYSDATE AS logon_time,
SYS_CONTEXT('userenv','ip_address') AS ip_address,
NVL(SUBSTR(program,1,64),'INTERNAL') AS program_name,
i.instance_name AS instance_name,
i.host_name AS host_name,
i.version AS version
FROM v$session x
WHERE x.username = user);
BEGIN
os_user_name, machine_name, session_id,
rec.os_user_name, rec.machine_name, rec.session_id, rec.serial_no, rec.logon_time, rec.ip_address, rec.program_name, rec.instance_name, rec.host_name, rec.version);
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: Rick_Cale_at_teamhealth.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Tue Dec 03 2002 - 16:09:15 CST
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: DWILLIAMS_at_LIFETOUCH.COM Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: Rick_Cale_at_teamhealth.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: DWILLIAMS_at_LIFETOUCH.COM Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
 |
 |