Oracle-L: RE: ORA-2083 DATABASE name has illegal character '-'

From: <Rick_Cale_at_teamhealth.com>
Date: Tue, 03 Dec 2002 13:09:14 -0800
Message-ID: <F001.00511553.20021203130914@fatcity.com>

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 s,v$instance i
WHERE s.username = user
AND s.logon_time = (SELECT MAX(x.logon_time)

                      FROM v$session x
                      WHERE x.username = user);

BEGIN
FOR rec IN temp_rec LOOP
INSERT INTO login_history_at_utilities_itport02_dblink (user_name,

  os_user_name,
  machine_name,
  session_id,

  serial_no,
  logon_time,
  ip_address,
  program_name,
  instance_name,
  host_name,
  version)
VALUES (rec.user_name,

  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);

END LOOP;
EXCEPTION
WHEN OTHERS THEN
NULL;
END;
/
ALTER TRIGGER login_capture ENABLE;

--

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

--

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