RE: initjvm.sql
rmjvm.sql doesnot remove all the components properly. If your resources sizes are ok, then try following. If for any reason the installation fails then $ORACLE_HOME/javavm/install/rmjvm.sql has to be run. Unfortunately it does not remove all the components. Following workaround has to be used to get over the bugs. 1. Restart the database. 2. Start a different session other than the one that started the database. 3. Run initjvmaux.sql 4. Run rmjvm.sql 5. Run following SQL queries, LOG on as SYS. --The minimum action to remove JIS trigger is running the following sql. drop trigger JIS$ROLE_TRIGGER$; delete from ducs$ where owner='SYS' and pack='JIS$INTERCEPTOR$' and proc='USER_DROPPED'; delete from aurora$startup$classes$ where classname='oracle.aurora.mts.http.admin.RegisterService'; delete from aurora$dyn$reg; Regards, sunil s. -Original Message-From: Saravana Kumar [mailto:[EMAIL PROTECTED]]Sent: Monday, November 12, 2001 12:55 PMTo: Multiple recipients of list ORACLE-LSubject: initjvm.sql Hi friends, I have problem during execution of initjvm.sql The step's which i have followed. 1)Increased system tablespace 200 mb 2)increased the shared pool size 50mb 3)increased the java pool size to 50mb 4)ran rmjvm.sql 5)initjvm.sql While runnig initjvm.sql the script hangs while i get the statement create or replace java system; What could be the reason. Please reply as soon as possible Thanks in advance Saravana.
MAIL on insertion/updation of a record.
hi, I have a requirement as per which i have to send a mail on insertion/updation of a record. How this can be done using PL/SQL (i.e. triggers). Does mail server i.e. Lotus or Exchange server matters in this case. regards sunil s. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SUNILSHIVAPPA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: MAIL on insertion/updation of a record.
It will be great... -Original Message- Sent: Wednesday, October 03, 2001 7:10 PM To: Multiple recipients of list ORACLE-L I've actually got a piece of code that will allow you to use the unix mail facility, I think it was Rachel that passed this on to me and I kindof tweaked it a bit. If you want me to post it I can do. K. hit any user to continue __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com http://www.calanais.com/ -Original Message- Sent: 03 October 2001 13:25 To: Multiple recipients of list ORACLE-L I'm redirecting you to http://asktom.oracle.com/pls/ask/f?p=4950:8:162284::NO::F4950_P8_DISPLAY ID,F 4950_P8_CRITERIA:319216860351,%7Bsend%7D%20and%20%7Bmail%7D http://asktom.oracle.com/pls/ask/f?p=4950:8:162284::NO::F4950_P8_DISPLA YID, F4950_P8_CRITERIA:319216860351,%7Bsend%7D%20and%20%7Bmail%7D This link explains how to send email through developer2000 forms. Hope that using utl_smtp package, you can send mails through pl/sql triggers. Rgds, Nirmal. -Original Message- Sent: Wednesday, October 03, 2001 1:10 PM To: Multiple recipients of list ORACLE-L hi, I have a requirement as per which i have to send a mail on insertion/updation of a record. How this can be done using PL/SQL (i.e. triggers). Does mail server i.e. Lotus or Exchange server matters in this case. regards sunil s. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: SUNILSHIVAPPA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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: SUNILSHIVAPPA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: MAIL on insertion/updation of a record.
hi kevin, Some doubts : your mail mentions three files : mailserver_startup.sh mailserver.csh and mail_server.sql. What i see in mail is only two attachments. mailhost.csh mail_server.sql. mail_server.sql looks ok to me. but mailhost.csh contains the statement like command := 'sprintf(SCmdLine,'' -s%s -e%s -t%s'',sub,dst,msg)'; This gives the statement like sprintf(SCmdLine,' -s%s -e%s -t%s',sub,dst,msg) on command prompt to execute. Don't we use anything like sendmail. please clarify. How it works and where are mailserver.csh and mailserver_startup.sh files. regards sunil s. -Original Message- Sent: Wednesday, October 03, 2001 9:15 PM To: Multiple recipients of list ORACLE-L Here we go folksthis was originally sent to Christopher Spence... Hi Chrisopher, It's based around the fact that I don't have access to the UTL_SMTP package. Some of our DBs are still 7.3.4.2.0 and I'm not sure if we have access to this utility. I don't want to bother the DBAs with it..grin. It's basically comprised of three elements. A pl/sql package called mail_server. A unix shell script called mailserver_startup.sh and a unix c shell script called mailserver.csh. I've attached them for you. Basically run the package into your database. Place the two shell scripts into a directory and run the mailserver_startup.sh like so: $ksh mailserver_startup.sh If you then do a: $ ps -ef | grep mailserver You should find that the mailserver.csh process is sitting in the backgound running away as normal. To send mail from within pl/sql, issue the command: SQL exec v_mail_server.send_mail('[EMAIL PROTECTED]','Subject matter','Message'); And that is that..any probs give me a shout. Kev. hit any user to continue __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 03 October 2001 15:25 To: Multiple recipients of list ORACLE-L It will be great... -Original Message- Sent: Wednesday, October 03, 2001 7:10 PM To: Multiple recipients of list ORACLE-L I've actually got a piece of code that will allow you to use the unix mail facility, I think it was Rachel that passed this on to me and I kindof tweaked it a bit. If you want me to post it I can do. K. hit any user to continue __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com http://www.calanais.com/ -Original Message- Sent: 03 October 2001 13:25 To: Multiple recipients of list ORACLE-L I'm redirecting you to http://asktom.oracle.com/pls/ask/f?p=4950:8:162284::NO::F4950_P8_DISPLAY ID,F 4950_P8_CRITERIA:319216860351,%7Bsend%7D%20and%20%7Bmail%7D http://asktom.oracle.com/pls/ask/f?p=4950:8:162284::NO::F4950_P8_DISPLA YID, F4950_P8_CRITERIA:319216860351,%7Bsend%7D%20and%20%7Bmail%7D This link explains how to send email through developer2000 forms. Hope that using utl_smtp package, you can send mails through pl/sql triggers. Rgds, Nirmal. -Original Message- Sent: Wednesday, October 03, 2001 1:10 PM To: Multiple recipients of list ORACLE-L hi, I have a requirement as per which i have to send a mail on insertion/updation of a record. How this can be done using PL/SQL (i.e. triggers). Does mail server i.e. Lotus or Exchange server matters in this case. regards sunil s. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: SUNILSHIVAPPA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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
RE: Oracle - SQL Server
Generic connectivity works fine, I have tried this. You can query MS SQL server tables, but if you want to execute packages/procedures of SQL server then you have to use Transparent Gateway for MS SQL server. This is a separate product by oracle. (you can get more details about this at www.oracle.com/gateways As for as using HSODBC(heterogeneneous ODBC or Generic connectivity) if your database in ORACLE, then ODBC driver for SQL server has to be used on UNIX. MERANT is one such provider (www.merant.com). regards sunil s. -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 03, 2001 6:45 AM To: Multiple recipients of list ORACLE-L Christopher, What OS is your Oracle DB on? If on NT and your version = 816 then you can use the heterogeneous services - for some more information see Metalink / doco: I found note 114820.1 helpful - QUICK START GUIDE: WIN NT - Generic Connectivity using ODBC Also note 109730.1 - How to setup generic connectivity (Heterogeneous Services) for Windows NT If your Oracle is on Unix then you could also use Heterogeneous services, provided you can get a SQL Server ODBC driver for Unix. Regards, Bruce Reardon -Original Message- Sent: Wednesday, 3 October 2001 7:25 I was thinking that same thing as the easiest way as I know transparent isn't cheap and there probably isn't an easy way. I was going to use Perl/Java to make something if there isn't any other way like the OPENQUERY option in SQL Server to look at oracle tables. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Tuesday, October 02, 2001 4:14 PM Cc: [EMAIL PROTECTED] Oh geez, here I go again. This is trivial with Perl, DBD::Oracle and DBD::ODBC. Whether it is useful to you depends on a number of things. * can you use an Oracl copy of the SQL server data? * does the data always need to be fresh? * how fresh? * how big is it? Since it's temporary, this may work for you. Jared --- I know there is a way in SQL server to query oracle tables, is there a way to do the reverse? I am looking at trying to create access from an Oracle DB to SQL Server data until we convert the SQL server database. Anyone have any ideas on this, I searched technet (ms/oracle) and metalink, as well as some search engines without luck. Christopher R. Spence -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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: SUNILSHIVAPPA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
privileges on packages
hi, HOW to find out the whether a particular user has a execute permission on package or not. Regards, sunil s. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SUNILSHIVAPPA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).