Error In Executing Triggers On Connect Internal
Web and Mobile SQL*Plus Data Warehousing Installation Networking Backup Recovery Security Tuning PLSQL Oracle Applications Scripts Administration ORA-HOWTO Web and Mobile SQL*Plus Data Warehousing Installation Networking Backup Recovery Security Tuning PLSQL Oracle Applications Papers Administration ORA-HOWTO Web and Mobile SQL*Plus Data Warehousing Installation Networking Backup Recovery Security Tuning PLSQL Oracle Applications Forum All threads Best last month Links Oracle official Oracle Technical Info Tools (free) Tools (commercial) Oracle FAQ Other DBA-sites Oracle development Not Oracle specific Oracle Blogs Imho Fqa Pirats | Start http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=37423&DestinationA=RSS a new thread | All threads | Best last month | No question at this time DBA Top 10 1 M. Cadot 38400 2 F. Diaz 33800 3 J. Schnackenberg 18000 4 A. Kavsek 16050 5 B. Vroman 15850 6 P. Wisse 14750 7 T. Boles 14000 8 M. Hidayathullah ... 11700 9 A. Hudspith 8600 10 A. Khan http://4dag.cronos.be/village/dvp_forum.OpenThread?ThreadIdA=24770 4400 About Advertise here Download PLATOThe free tool for auditing and tuning your databaseVersion 55 now available Sep 02, 2016 The DBA-Village forum as RSS feed Site StatisticsEver registered users47779Total active users2114Act. users last 24h23Act. users last hour3Registered user hits last week612Registered user hits last month6526 Go up trigger error Next thread: dbms_stats - 9iR2 Prev thread: Any distinction between star and star_transformation ? Message Score Author Date Hi friends, I ran this trigger as SYS to restri...... Hemant Patel Jul 17, 2006, 05:59 Hi, I think you tried your trigger with SYS but...... Michel Cadot Jul 17, 2006, 06:19 Hi Michel, Thanks for sharing information. Y...... Hemant Patel Jul 17, 2006, 06:40 Hi, (Sorry i don't see any result from your que...... Michel Cadot Jul 17, 2006, 06:47 Hi Michel, Actually I didn't printed any result...... Hemant Patel Jul 17, 2006, 07:23 Hi Hemant, Depending on your version, with SYS,...... Michel Cadot Jul 17, 2006, 08:02 Hi Michel, Let me find out more information mys...... Hemant Patel Jul 17, 2006, 08:50 Hi Mi
at "SYS.STANDARD" If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. http://www.dbasupport.com/forums/showthread.php?35211-ORA-06512-at-quot-SYS-STANDARD-quot To start viewing messages, select the forum that you want to visit from the http://www.orafaq.com/forum/t/50140/ selection below. Results 1 to 5 of 5 Thread: ORA-06512: at "SYS.STANDARD" Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 04-04-2003,09:14 AM #1 Giani View Profile View Forum Posts Oracle DBA Join Date Nov 2002 Location Dublin, Ireland Posts 133 ORA-06512: error in at "SYS.STANDARD" Hi DBAs, I am on Oracle8i Release 8.1.7.4.0. Currently I am having below problem on dev box. SQL>connect usert Enter password: ERROR: ORA-00604: error occurred at recursive SQL level 1 ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at "SYS.STANDARD", line 609 ORA-06512: at line 7 This is the first time I hit this problem - how do I do to solve this issue Thanks in advance. error in executing Regards, Giani Reply With Quote 04-04-2003,11:34 AM #2 marist89 View Profile View Forum Posts Visit Homepage Super-Genius Join Date Nov 2000 Location greenwich.ct.us Posts 9,092 Hmmm. Odds are your data dictionary is messed up. Jeff Hunter marist89@yahoo.com http://marist89.blogspot.com/ "I pledge to stop eating sharks fin soup and will not do so under any circumstances." Reply With Quote 04-04-2003,01:05 PM #3 Giani View Profile View Forum Posts Oracle DBA Join Date Nov 2002 Location Dublin, Ireland Posts 133 Hi Jeff, Thanks for the input. Here is what got from trace file when I connected as internal : ----------------- *** 2003-04-04 16:22:13.951 *** SESSION ID:(20.571) 2003-04-04 16:22:13.948 Error in executing triggers on connect internal *** 2003-04-04 16:22:13.951 ksedmp: internal or fatal error ----------------- Thanks to the above alert I was able to findout which SYS trigger was causing problem. so it was after logon trigger written a dev DBA. He said that it worked before and users were able to logon... SQL>sho user USER is "SYS" SQL>select 'Create or Replace trigger ',description,trigger_body 2 from user_triggers where trigger_name = 'RESTRICT_IP'; Create or Replace trigger restrict_ip after logon on database declare c_exclude varchar2(16) := ' '; c_exclude1 varchar2(16) := '19.40.60.58'; c_exclude2 varchar2(16) := '19.9.100.1'; c_exclude3 varchar2(16) := '19.9.100.2'; begin if ( sys_context('userenv','ip_address') = c_exclude1 ) then
errors [message #132059] Wed, 10 August 2005 11:22 vikramjogi Messages: 71Registered: June 2005 Location: Scranton Member Hello All, I have put an “after logon on trigger” on the database which is restricing a user to logon using SQLPLUS tool. The trigger works fine and is giving me the result I am expecting but it throws errors in the alert log file. Below is the trigger which works fine and is restricting the user to use SQLPLUS tool ******************Trigger*************************************** CREATE OR REPLACE TRIGGER block_eis AFTER LOGON ON DATABASE DECLARE v_prog sys.V_$SESSION.program%TYPE; v_prog1 sys.V_$SESSION.username%TYPE; v_prog2 sys.V_$SESSION.osuser%TYPE; BEGIN SELECT program,username,osuser INTO v_prog,v_prog1,v_prog2 FROM sys.V_$SESSION WHERE audsid = USERENV('SESSIONID') AND audsid != 0; -- Allow SYS Connections; IF UPPER(v_prog1) LIKE '%EIS%' AND UPPER(v_prog) LIKE '%SQLPLUS%' AND UPPER(v_prog2) NOT LIKE '%ZEKEPSRV%' THEN RAISE_APPLICATION_ERROR(-20001, 'Sorry! Batch only USER'); END IF; END; ****************************END TRIGGER ************************* The errors I get are: ORA-04088: error during execution of trigger 'ORACLE.BLOCK_EIS' ORA-01403: no data found ORA-06512: at line 6 Below is the trace file that is generated: Error in executing triggers on connect internal *** 2005-08-08 14:29:22.859 ksedmp: internal or fatal error ORA-04088: error during execution of trigger 'ORACLE.BLOCK_EIS' ORA-01403: no data found ORA-06512: at line 6 Please provide solution to this issue. Thanks in advance Vik Jogi Report message to a moderator Re: ORA-04088 ORA-01403 and ORA-06512 errors [message #132068 is a reply to message #132059] Wed, 10 August 2005 12:31 Art Metzer Messages: 2478Registered: December 2002 Senior Member Forget about your error; your so-called restriction is easy to circumvent. Do this:Go to $ORACLE_HOME/bin. Copy sqlplus.exe. Paste it into the same folder, renaming it, oh, "anythingiwant.exe". Double-click this copied executable to launch SQL*Plus. Run the following query from this copied executable, and you should see what I see:SQL> SELECT program FROM v$session WHERE audsid = USERENV('S