AW: making me crazy
Title: RE: making me crazy Hi Paula ! You have 2 options : 1) provide symlink to your "listener.ora" file. 2) In case you start the listener process via sth like thata "BASH_PROMPT> lsnrctl start " you can "fake" the shell with the command " TNS_ADMIN=/tmp lsnrctl start" ( no export of TNS_ADMIN varaible ! ). thus the variable TNS_ADMIN will be used ONLY for the invocation of the current command (in this case lsnrctl start) . Here is a small proof of the concept ( under RHAS 2.1, Orac 9.2.0):) - 11338 access("/tmp/ldap.ora", F_OK) = -1 ENOENT (No such file or directory)11338 access("/oracle/o1/oracle/product/9.2.0/network/admin/ldap.ora", F_OK) = -1 ENOENT (No such file or directory)11338 access("/tmp/listener.ora", F_OK) = 011338 open("/tmp/listener.ora", O_RDONLY) = 311338 fcntl64(0x3, 0x2, 0x1, 0x2) = 011338 brk(0x81c2000) = 0x81c200011338 fstat64(3, {st_mode=S_IFREG|0644, st_size=713, ...}) = 011338 old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x40abc00011338 read(3, "# LISTENER.ORA Network Configura"..., 4096) = 713 . . 11340 rt_sigaction(SIGRT_2, {SIG_DFL}, NULL, 8) = 011340 execve("/oracle/o1/oracle/product/9.2.0/bin/tnslsnr", ["/oracle/o1/oracle/product/9.2.0/"...,"LISTENER", "-inherit"], [/* 36 vars */]) = 011340 uname({sys="Linux", node="as1", ...}) = 0 - HTH. Milen -Ursprüngliche Nachricht-Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Gesendet: Mittwoch, 10. September 2003 16:45An: Multiple recipients of list ORACLE-LBetreff: RE: making me crazy Dealing with 2 Oracle Homes - one if which I need to run the listener from and one in which I need to use the tnsnames.ora definitions from and no I can't just copy the tnsnames.ora to the 1st Oracle Home. Even when I set the oracle home from which to run lsnrctl it tries to use the listener.ora from the TNS_ADMIN home. How can I make sure to explicitly start the correct listener.ora? Thanks, Paula
AW: Oracle and Perl
Hi, Ron my $ORA_SID = $ENV{'ORACLE_SID'} my ORAC_HOME = $ENV{'ORACLE_HOME'} should siffice ;) HTH. Milen -Ursprüngliche Nachricht- Von: Smith, Ron L. [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 9. September 2003 15:39 An: Multiple recipients of list ORACLE-L Betreff: Oracle and Perl Can anyone tell me how to pick up the $ORACLE_SID or $ORACLE_HOME from within a Perl script? Thanks! Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] 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: [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.net -- Author: Kulev, Milen INET: [EMAIL PROTECTED] 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: [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).
AW: Oracle 9i Rel. 2 on Red Hat Advanced Server 2.1
Hi Helmut , I think the papers below should give you "fast start" about what is so special in RHAS 2.1. http://otn.oracle.com/tech/linux/pdf/1_linuxVM_v2_accepted.pdf http://otn.oracle.com/tech/linux/pdf/9iR2-on-Linux-Tech-WP-Final.PDF HTH. Milen -Ursprüngliche Nachricht- Von: Jack van Zanen [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 4. September 2003 10:19 An: Multiple recipients of list ORACLE-L Betreff: RE: Oracle 9i Rel. 2 on Red Hat Advanced Server 2.1 I have been led to believe that AS2.1 has been optimized on for instance I/O and is therefore a lot faster on the I/O side (I believe it is async I/O that was worked on) Probably some other issues as well but this one stuck. I have no experience with it though. -Original Message- Sent: Thursday, September 04, 2003 10:04 AM To: Multiple recipients of list ORACLE-L Hi! Is anybody using Oracle 9i on Red Hat Advanced Server? I just installed RAS 2.1 and did not notice much difference to a regular Red Hat Installation... What is the beig difference between Advanced Server and "regular" Red Har Linux? Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen INET: [EMAIL PROTECTED] 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: [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.net -- Author: Kulev, Milen INET: [EMAIL PROTECTED] 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: [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).
AW: Partitions in RH AS 2.1
Title: Partitions in RH AS 2.1 Hi Tanel & Ramon, It is better to use ext3 on Linux /"fsck" time at startup of OS is much, much shorter; ) / .There is no mke3fs on Linux, which I am aware of. Instead, use mke2fs with "-j" option /"-j" stands for journaling/' For more details about "-j" option , see "man mke2fs". Be sure that "ext3" module for ext3 filesystem ist loaded (type "lsmod") /on RHAS 2.1 normally it is /. If not -> "insmod ext3" .Then try to mount to partitions with "mount - t ext3 /dev/device /mntpount". HTH. Milen -Ursprüngliche Nachricht-Von: Tanel Poder [mailto:[EMAIL PROTECTED]Gesendet: Samstag, 23. August 2003 13:14An: Multiple recipients of list ORACLE-LBetreff: Re: Partitions in RH AS 2.1 Hi! IIRC, the command for formatting was mke2fs for making ext2 fs (is there an mke3fs as well?). mount -t ext2 /dev/device /mnt/directory mounts ext2 type device named "device" to given directory Tanel. - Original Message - From: Ramon E. Estevez To: Multiple recipients of list ORACLE-L Sent: Friday, August 22, 2003 6:14 PM Subject: Partitions in RH AS 2.1 Hi list, New in linux. I configured a RAID 0 in a Dell Server and installed RH AS 2.1. Now as a result I have a /dev/sda4 of 200 GB. I used fdisk and made 3 partitions that became /dev/sda9, /dev/sda10, /dev/sda11. Now I want to make the file systems and mount the partitions and haven't been able to do it. Any help would be appreciated. TIA Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994
AW: RH not-so-Advanced 2.1 and new hardware
Hi Rich ! Most of the NICs are NE2000 compatible. This means that you could run your NIC by using the module 'ne2k-pci.o' in '/lib/modules/$KERNEL_VERSION/kernel/drivers/net'. (on RH9 or RG AS2.1) I am using this module at home to run my RT8139 NIC under RHAS 2.1 HTH. Milen -Ursprüngliche Nachricht- Von: Jesse, Rich [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 21. August 2003 18:35 An: Multiple recipients of list ORACLE-L Betreff: RH not-so-Advanced 2.1 and new hardware We're trying to test/prove 9iRAC on a cheap setup. Has anyone used newer hardware when trying to install RH not-so-AS 2.1? I've got an Intel D845GERG2 motherboard and the old 2.4-9 kernel doesn't have a module for the onboard ethernet. Also, intel.com has a few Linux drivers for this MB, but they require 2.4-11+. I'm going to try and run -- -- up2date, but I thought I'd ask here, too, since I can't be the first to put up with this horse hockey. TIA, Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [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.net -- Author: Kulev, Milen INET: [EMAIL PROTECTED] 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: [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).
AW: Question about cursors
Hello Roland, Supposing that you want to select from table A and insert into B /or any ather table/. here is a samll example : DECLARE TYPE id_type IS TABLE OF A.id%TYPE; t_id id_type; BEGIN SELECT id BULK COLLECT INTO t_id FROM A where id > 10 ; FORAll id IN t_id.FIRST .. t_id.LAST insert into B(id) values(t_id(id)); commit ; END; / HTH. Milen -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 15. August 2003 13:39 An: Multiple recipients of list ORACLE-L Betreff: Question about cursors Hallo, I would like to get a goood example on how to do this in a pl/sql block, maybe this is too simple but I cant get it work. I would like to do a select from table A, like this select id from A where id > 10 This sql statement gives me about 10 rows. I want those rows(the id) to be inserted in a table called A. I woul dlike to use variables to store al the id's that the sql gets me. so the values to be inserted in the table should be for instance 11 12 13 14 15 16 17 18 19 20 How can I do this, using a cutsor I guess. Please give me an example. Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] 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: [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.net -- Author: Kulev, Milen INET: [EMAIL PROTECTED] 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: [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).
AW: RedHat AS Dev edition still available today THANK YOU Ron !
To Ron: Ron, your last link works !!! RH AS Dev Edition is already by me. Thank you very, VERY much for the help! BTW, according to one of the official RedHat resellers in Germany, Dev Edition was not avialable anymore (?! I haven't posted them the link yet;) ), because there were too many requests for updates ...NO comment. Best Regards Milen Kulev -Ursprüngliche Nachricht- Von: Ron Rogers [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 17. Juni 2003 14:30 An: Multiple recipients of list ORACLE-L Betreff: Re: RedHat AS Dev edition still available today Milen, The offer is still available at https://rhn.redhat.com/network/sales/index.pxt you must have a RedHat network login, Easy to get on line. Ron >>> [EMAIL PROTECTED] 06/16/03 06:39PM >>> Thanks for the answer Ron, the problem is that I don't see Dev Edition listed anymore ;(. I dont't know whether RH will repeat this great offer- I didn't expected this offer to be pulled so quickly ;( That is why I am searching a way to get this software. Best Regards Milen Kulev -Ursprüngliche Nachricht- Von: Ron Rogers [mailto:[EMAIL PROTECTED] Gesendet: Montag, 16. Juni 2003 18:20 An: Multiple recipients of list ORACLE-L Betreff: Re: RedHat AS Dev edition Melin, Talking to the REdHat support people and the Dev edition was pulled last week some time. If on the "buy it" page you see the RedHat AS Developers edition you can still purchase it and download the ISO's with a login and password. Ron >>> [EMAIL PROTECTED] 06/13/03 05:09PM >>> Hallo list, I would like to play a little bit with RAC and decided to download RedHat AdvacedServer Dev Edition (in February there was a thread about this topic in the list ). The problem is that the link http://www.redhat.com/software/advancedserver/developer/ doesn't offer this "promotion" (60 USD)anymore. Is this offer really gone or am I missing sth ? Where could I find RH AS Dev Edition ? Any help will be appreciated. Milen Kulev -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] 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: [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.net -- Author: Kulev, Milen INET: [EMAIL PROTECTED] 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: [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.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] 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: [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.net -- Author: Kulev, Milen INET: [EMAIL PROTECTED] 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: [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).
WG: RedHat AS Dev edition
-Ursprüngliche Nachricht- Von: Kulev, Milen Gesendet: Dienstag, 17. Juni 2003 00:39 An: Multiple recipients of list ORACLE-L Betreff: AW: RedHat AS Dev edition Thanks for the answer Ron, the problem is that I don't see Dev Edition listed anymore ;(. I dont't know whether RH will repeat this great offer- I didn't expected this offer to be pulled so quickly ;( That is why I am searching a way to get this software. Best Regards Milen Kulev -Ursprüngliche Nachricht- Von: Ron Rogers [mailto:[EMAIL PROTECTED] Gesendet: Montag, 16. Juni 2003 18:20 An: Multiple recipients of list ORACLE-L Betreff: Re: RedHat AS Dev edition Melin, Talking to the REdHat support people and the Dev edition was pulled last week some time. If on the "buy it" page you see the RedHat AS Developers edition you can still purchase it and download the ISO's with a login and password. Ron >>> [EMAIL PROTECTED] 06/13/03 05:09PM >>> Hallo list, I would like to play a little bit with RAC and decided to download RedHat AdvacedServer Dev Edition (in February there was a thread about this topic in the list ). The problem is that the link http://www.redhat.com/software/advancedserver/developer/ doesn't offer this "promotion" (60 USD)anymore. Is this offer really gone or am I missing sth ? Where could I find RH AS Dev Edition ? Any help will be appreciated. Milen Kulev -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] 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: [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.net -- Author: Kulev, Milen INET: [EMAIL PROTECTED] 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: [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.net -- Author: Kulev, Milen INET: [EMAIL PROTECTED] 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: [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).
AW: RedHat AS Dev edition
Thanks for the answer Ron, the problem is that I don't see Dev Edition listed anymore ;(. I dont't know whether RH will repeat this great offer- I didn't expected this offer to be pulled so quickly ;( That is why I am searching a way to get this software. Best Regards Milen Kulev -Ursprüngliche Nachricht- Von: Ron Rogers [mailto:[EMAIL PROTECTED] Gesendet: Montag, 16. Juni 2003 18:20 An: Multiple recipients of list ORACLE-L Betreff: Re: RedHat AS Dev edition Melin, Talking to the REdHat support people and the Dev edition was pulled last week some time. If on the "buy it" page you see the RedHat AS Developers edition you can still purchase it and download the ISO's with a login and password. Ron >>> [EMAIL PROTECTED] 06/13/03 05:09PM >>> Hallo list, I would like to play a little bit with RAC and decided to download RedHat AdvacedServer Dev Edition (in February there was a thread about this topic in the list ). The problem is that the link http://www.redhat.com/software/advancedserver/developer/ doesn't offer this "promotion" (60 USD)anymore. Is this offer really gone or am I missing sth ? Where could I find RH AS Dev Edition ? Any help will be appreciated. Milen Kulev -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] 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: [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.net -- Author: Kulev, Milen INET: [EMAIL PROTECTED] 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: [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).
RedHat AS Dev edition
Title: RE: db file sequential read [WAS:wait event puzzler] Hallo list, I would like to play a little bit with RAC and decided to download RedHat AdvacedServer Dev Edition (in February there was a thread about this topic in the list ). The problem is that the link http://www.redhat.com/software/advancedserver/developer/ doesn't offer this "promotion" (60 USD)anymore. Is this offer really gone or am I missing sth ? Where could I find RH AS Dev Edition ? Any help will be appreciated. Milen Kulev
RH AS Dev edition
The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. <>
AW: How to run sql*plus and its command in Windows as batch job?
Install Cygwun (http://www.cygwin.com/). Then there wouldn't be a need for format change and you could use (almost)all your UNIX scripts . Best Regards MILEN -Ursprüngliche Nachricht- Von: Chuan Zhang [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 20. März 2003 04:19 An: Multiple recipients of list ORACLE-L Betreff: How to run sql*plus and its command in Windows as batch job? Hi, All, In unix, we can put following commands in a file and run that file. For example: $ORACLE_HOME/bin/sqlplus /nolog << EOF connect test/test alter sesion set sql_trace=true select count(*) from product_temp p, invoice_temp i where p.invpsid=i.invoiceid; disconnect exit EOF What's the corresponding format on windows? Your input is precious, TIA Chuan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chuan Zhang INET: [EMAIL PROTECTED] 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: [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.net -- Author: Kulev, Milen INET: [EMAIL PROTECTED] 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: [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).
AW: Problem with netasst & dbastudio
Hi Milen. I had the same problemson my Linux box. On the console type "ps -ef | grep jre ". Normally I see a lot of zombie jre's [defunc]. Kill them all wich "killall -9 jre" (I hope that no other application using JRE is running at that time ;) ). Then try to start netasst or dbastudio again. It worked for me. HTH. Another Milen ;) -Ursprüngliche Nachricht- Von: Milen Pankov [mailto:[EMAIL PROTECTED] Gesendet: Montag, 17. März 2003 08:49 An: Multiple recipients of list ORACLE-L Betreff: Problem with netasst & dbastudio recently i posted mail here about problem installing oracle 8.1.7 on mandrake 9.0. well i managed to install it - it was a mising file when installing the glibs patch. now i have created a database, created listener, configured naming methods and everything. finally i imported a entire database from another server. the db is mounted and works fine. the problem now is i can't start netasst or dbastudio. everything else works - the dbaasst, workheet, netca etc. when i write in the console 'oemapp dbastudio' or 'netasst' it just holds on and nothing till i press Ctrl+C. i think there may be some problem with the JRE. i didn't manage to run the installer in the begining of the installation and i downloaded a JRE from IBM - it was theonly way it worked. may be now the problem is with the ibm's jre - i don't know. any sugestions?? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Milen Pankov INET: [EMAIL PROTECTED] 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: [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.net -- Author: Kulev, Milen INET: [EMAIL PROTECTED] 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: [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).
AW: Backup Strategy
John, teh scripts are still there (with a small correction) :) http://www.oracle-dba.com/rman/ Milen -Ursprüngliche Nachricht- Von: Hallas, John, Tech Dev [mailto:[EMAIL PROTECTED] Gesendet: Montag, 17. März 2003 11:29 An: Multiple recipients of list ORACLE-L Betreff: RE: Backup Strategy So what are you doing this afternoon after you have mastered the SQL Server gui this morning? -Original Message- Sent: 15 March 2003 09:44 To: Multiple recipients of list ORACLE-L I put them on http://www.vanzanen.com/rman.zip They are oracle 8.0 (if memory serves me right) so they won't work with 9i. I'll see if I can find the time to do the same for 9i one of these days (have to learn SQL Server first) Jack -Original Message- Sent: vrijdag 14 maart 2003 20:24 To: Multiple recipients of list ORACLE-L I have found Joe Testa's site has a good set of RMAN scripts (I think they came from Jack van Zanen off this list), quite simple but they give the syntax for most of the commands you will want The link was http://www.oracle-dba.com but that is no longer working Where have you put them Joe?? John -Original Message- Sent: 14 March 2003 16:34 To: Multiple recipients of list ORACLE-L Jay If you want a good book to get up to speed on RMAN, buy Oracle9i RMAN Backup & Recovery by Robert Freeman and Matthew Hart If you want to compare the steps for various recovery scenarios between RMAN and user-managed recovery, get Oracle Backup & Recovery 101 by Smith and Haisley. It has you create a small test database and then run various backup and recovery steps for various types of failures and recoveries. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, March 14, 2003 2:54 AM To: Multiple recipients of list ORACLE-L Dear All, Iam entitled the responsibility to come out with a plan for Backup (using RMAN) for our forthcoming data centre operations. Could someone help me on this? I would also like to know the steps for Recovery in the case of a Redo Log member failure, using RMAN and the traditional Recovery commands from SQLPLUS. TIA . Best Regards Jai -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [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.net -- Author: Hallas, John, Tech Dev INET: [EMAIL PROTECTED] 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: [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.net -- Author: Jack van Zanen INET: [EMAIL PROTECTED] 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: [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.net -- Author: Hallas, John, Tech Dev INET: [EMAIL PROTECTED] 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: [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.net -- Author: Kulev, Milen INET:
AW: can't create database
Title: RE: LMT monitoring Hi Milen, 1) Have you relinked the executables during installation phase(applying stubs patch supplied by Oracle ) ? 2) Create DB creating scripts with dbassist. Then perform each step written in *.SQL & *.sh files separately, while watching ALERT.LOG. This approach can help you localize at which step the problem appears. Best wishes Milen Kulev -Ursprüngliche Nachricht-Von: Milen Pankov [mailto:[EMAIL PROTECTED]Gesendet: Dienstag, 11. März 2003 18:00An: Multiple recipients of list ORACLE-LBetreff: can't create database can't create a database with oracle 8.1.7. the installation went fine, but when i start dbassist on the 2% of the database creation it tels me: "not connected to oracle". any ideas?
AW: How to start with Oracle Financial?
Mike, could you provide a link on Oracle site, where I can "purchase" OraApps (not only updates -> see http://oraclestore.oracle.com/OA_HTML/ibeCCtpSctDspRte.jsp?section=11536). Further on http://oraclestore.oracle.com/OA_HTML/ibeCCtpSctDspRte.jsp?section=10391 what I am reading is: "Trial licenses allow you to evaluate Oracle's software programs* for 30 days from the delivery date; the programs may not be used for production purposes. If you wish to continue using the programs after the 30 day evaluation period then you will need to purchase licenses from us. Oracle does not provide technical support or warranties for trial programs. For full details, please refer to the Oracle License & Services Agreement. * We do not offer trial licenses for our E-Business Suite Applications. ". So, my question is: If I don't want to play Ebay lottery (it's really lottery, at the end:)), and I want to play a little bit with OraApps, how can I do it ?! Because a friend of mine & me played the lottery and "won" 50CDs (full OraApps, documentation to OraApps, Oracle docs, performance & tunning packs for 8i & etc..). Best wishes Milen -Ursprüngliche Nachricht- Von: Hately, Mike (NESL-IT) [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 28. Februar 2003 14:19 An: Multiple recipients of list ORACLE-L Betreff: RE: How to start with Oracle Financial? Alternatively, rather than playing the E-Bay lottery you can go to the Oracle store and buy the same for 39.95 USD. Theoretically you should also order a trial license but these are free so what's the point. Anyone? Am I missing something here? Cheers, Mike -Original Message- Sent: 28 February 2003 12:49 To: Multiple recipients of list ORACLE-L Alex, from time to time offers for OraApps are appearing for sale on www.ebay.com For 90-100USD you can buy 50 CDs with a lot a (OraApps & more )stuff there... These CDs are for educational pusposes only and are not time-constrant (at least the sellers state so ;)) HTH. Milen -Ursprüngliche Nachricht- Von: Hately, Mike (NESL-IT) [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 28. Februar 2003 12:49 An: Multiple recipients of list ORACLE-L Betreff: RE: How to start with Oracle Financial? To be honest if you can't download manuals, books or software you don't leave yourself many options. It's not clear whether you've been unable to download manuals or won't. The manuals are all available at http://download-uk.oracle.com/docs/cd/A99488_01/html/erpdoc.html. You can't download Oracle Financials but you can order Oracle Financials from the Oracle Store? It's pretty cheap (look under "CD Packs"). Cheers, Mike -Original Message- Sent: 28 February 2003 10:29 To: Multiple recipients of list ORACLE-L Hello List, Have the one question from subj please. I'd like to get some initial experience with Oracle Financial. What is the best way to do so? I couldn't download this package or manuals/books from OTN for practise... But I need to have some knowledge of it to get new job. Thank you for your help. -- Best regards, Alex ** The information contained in this e-mail is confidential and intended only for the use of the addressee. If the reader of this message is not the addressee, you are hereby notified that you have received this e-mail in error and you must not copy, disseminate, distribute, use or take any action as a result of the information contained in it. If you have received this e-mail in error, please notify [EMAIL PROTECTED] (UK 01384 275454) and delete it immediately from your system. Neither Npower nor any of the other companies in the Innogy group from whom this e-mail originates accept any responsibility for losses or damage as a result of any viruses and it is your responsibility to check attachments (if any) for viruses. Npower Limited Registered office: Windmill Hill Business Park, Whitehill Way, Swindon SN5 6PB. Registered in England and Wales: number 3653277. This e-mail may be sent on behalf of a member of the Innogy group of companies. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] 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: [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 subscribi
AW: How to start with Oracle Financial?
Alex, from time to time offers for OraApps are appearing for sale on www.ebay.com For 90-100USD you can buy 50 CDs with a lot a (OraApps & more )stuff there... These CDs are for educational pusposes only and are not time-constrant (at least the sellers state so ;)) HTH. Milen -Ursprüngliche Nachricht- Von: Hately, Mike (NESL-IT) [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 28. Februar 2003 12:49 An: Multiple recipients of list ORACLE-L Betreff: RE: How to start with Oracle Financial? To be honest if you can't download manuals, books or software you don't leave yourself many options. It's not clear whether you've been unable to download manuals or won't. The manuals are all available at http://download-uk.oracle.com/docs/cd/A99488_01/html/erpdoc.html. You can't download Oracle Financials but you can order Oracle Financials from the Oracle Store? It's pretty cheap (look under "CD Packs"). Cheers, Mike -Original Message- Sent: 28 February 2003 10:29 To: Multiple recipients of list ORACLE-L Hello List, Have the one question from subj please. I'd like to get some initial experience with Oracle Financial. What is the best way to do so? I couldn't download this package or manuals/books from OTN for practise... But I need to have some knowledge of it to get new job. Thank you for your help. -- Best regards, Alex ** The information contained in this e-mail is confidential and intended only for the use of the addressee. If the reader of this message is not the addressee, you are hereby notified that you have received this e-mail in error and you must not copy, disseminate, distribute, use or take any action as a result of the information contained in it. If you have received this e-mail in error, please notify [EMAIL PROTECTED] (UK 01384 275454) and delete it immediately from your system. Neither Npower nor any of the other companies in the Innogy group from whom this e-mail originates accept any responsibility for losses or damage as a result of any viruses and it is your responsibility to check attachments (if any) for viruses. Npower Limited Registered office: Windmill Hill Business Park, Whitehill Way, Swindon SN5 6PB. Registered in England and Wales: number 3653277. This e-mail may be sent on behalf of a member of the Innogy group of companies. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] 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: [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.net -- Author: Kulev, Milen INET: [EMAIL PROTECTED] 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: [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).
AW: Unix variable question
Answer1: ROOT # man bash Answer2(copy& paste form answer1) ${parameter} The value of parameter is substituted. The braces are required when parameter is a positional parameter with more than one digit, or when parameter is followed by a character which is not to be interpreted as part of its name. If the first character of parameter is an exclamation point, a level of variable indirection is intro duced. Bash uses the value of the variable formed from the rest of parameter as the name of the variable; this variable is then expanded and that value is used in the rest of the substitution, rather than the value of parameter itself. This is known as indirect expansion. The exception to this is the expansion of ${!prefix*} described below. In each of the cases below, word is subject to tilde expansion, parameter expansion, command substitution, and arithmetic expansion. When not performing substring expansion, bash tests for a parameter that is unset or null; omitting the colon results in a test only for a parameter that is unset. ${parameter:-word} Use Default Values. If parameter is unset or null, the expansion of word is substituted. Other wise, the value of parameter is substituted. ${parameter:=word} Assign Default Values. If parameter is unset or null, the expansion of word is assigned to parame ter. The value of parameter is then substituted. Positional parameters and special parameters may not be assigned to in this way. Milen -Ursprüngliche Nachricht- Von: Sinardy Xing [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 25. Februar 2003 10:29 An: Multiple recipients of list ORACLE-L Betreff: Unix variable question Hi all, Can someone help me understand this... ROOT # TEST=${2:-.} ROOT # echo $TEST ROOT #. what is 2:-. another similar code ROOT # TEST=${1:-0} ROOT # echo $TEST ROOT # 0 they looks like emoticon for me Thank you Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing INET: [EMAIL PROTECTED] 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: [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.net -- Author: Kulev, Milen INET: [EMAIL PROTECTED] 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: [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).
AW: Oracle connection through firewall
-Ursprüngliche Nachricht- Von: Stefan Jahnke [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 12. Februar 2003 13:14 An: Multiple recipients of list ORACLE-L Betreff: Oracle connection through firewall Hi everybody Since I'm a networking dummy, here's a question that might be easy to answer: I have to setup client access (Oracle Net) to an Oracle Database through a firewall. So far, I only know that the listener listens on a dedicated port (like 1521). After a client requested a connection, a dedicated server process is started (this is not an MTS environment) and the listener is informed about the port the server process wants to use to communicate with the client. The listener sends this information to the client and from thereon, the client can communicate with the server through this port. Now, I'm wondering about what ports do I have to keep open on the firewall between client and Oracle server ? &&>>>yes, you have to do this. 1521 is probably not enough, since this let's the client only reach the listener itself. What happens then ? Can I restrict Oracle Net to a range of ports for the server processes to be used (didn't find that in the fine manual) ? &&>> As far as I know OracleNet can not do this for you- this is an operating system issue. This means you should configure your OS regarding the acceptable range of local ports, but this range will be for all servers on this host, not only for Oracle. For more info, you can follow this link "http://en.tldp.org/LDP/solrhe/Securing-Optimizing-Linux-RH-Edition-v1.3/cha p6sec70.html" (Linux specific, although the other OSes should have similar parameters). Then you should configure your firewall to accept from outside the configured range of ports. But would make the existence of the firewall pointless. If so, how is this done ? Or do I have to go with Oracle connection manager ? &&&&>>> Definitely. Best regards. Milen Kulev Regards, Stefan Jahnke Consultant BOV Aktiengesellschaft Voice: +49 201 - 4513-298 Fax: +49 201 - 4513-149 mailto: [EMAIL PROTECTED] Please remove nospam to contact me via email. visit our website: http://www.bov.de subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen! Weitere Informationen unter +49 201/45 13-240 oder E-Mail an mailto:[EMAIL PROTECTED]. Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] 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: [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.net -- Author: Kulev, Milen INET: [EMAIL PROTECTED] 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: [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).
AW: OAUGNet & OAUGNet-DBA list servers from OAUG.COM
You should re-register yourself to the lists. I had the same problem, but after re-registering mail delivery is OK. Milen -Ursprüngliche Nachricht- Von: Bob Robert [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 6. Februar 2003 16:45 An: Multiple recipients of list ORACLE-L Betreff: OAUGNet & OAUGNet-DBA list servers from OAUG.COM Hi, Is any one getting emails from OAUGNet & OAUGNet-DBA list servers (WWW.OAUG.COM)? For some reason, I am not getting emails for the last one week. Thanks Bob __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Robert INET: [EMAIL PROTECTED] 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: [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.net -- Author: Kulev, Milen INET: [EMAIL PROTECTED] 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: [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).
AW: Oracle Financials - Help!
Yes Ron, there is. For ORACLE FINANCIALS go to http://www.rchath.com/mail_list.htm or http://www.oaug.org/public/oaugnet/oaugnet.html and follow the instructions. For other Oracle Products: http://www.odtug.com/subscrib.htm http://www.doug.org/list.server.html HTH. Milen -Ursprüngliche Nachricht- Von: Smith, Ron L. [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 22. Januar 2003 15:44 An: Multiple recipients of list ORACLE-L Betreff: Oracle Financials - Help! Is there a forum for Oracle Financials questions? I am doing backup support on Oracle Financials and I don't know anything about the product. The /tmp file on Unix has filled with a couple of very large temp files. I need a way to tie the files back to a process and hopefully a client. Can anyone help? Thanks! R.Smith If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] 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: [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.net -- Author: Kulev, Milen INET: [EMAIL PROTECTED] 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: [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).
AW: Help with procedure
Wasn't the Syntax for nested IFs IF THEN ... ELSIF THEN ... ELSIF THEN ... END IF; instead of else if upper(x.level_) in ('PAYROLL') then > v_security_group := 2; -Ursprüngliche Nachricht- Von: Tim Gorman [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 20. Januar 2003 22:47 An: Multiple recipients of list ORACLE-L Betreff: Re: Help with procedure Could you relate exactly what error you are seeing? Just seeing the code doesn't help much... To get the error messages, you can execute the following from SQL*Plus: SHOW ERRORS PROCEDURE PROCEDURE CONVERT_AA_ADMIN while connected as the account EMPLOYEE_ACTIVITY... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, January 20, 2003 2:15 PM > Hi List, I'm hoping someone can help me. I'm trying to compile a procedure, > which calls another procedure and I keep getting an error on the first end; > can't figure out what's wrong. Perhaps someone that hasn't seen this > procedure for hours can tell me what's wrong. > The user has all the right privileges. > > Here's the code: > > > > CREATE OR REPLACE PROCEDURE EMPLOYEE_ACTIVITY.convert_AA_admin > AS > -- > -- > -- Purpose: Convert Agent_Activity.Admin table to Employee_Activity > -- User_Info and User_Security_Group. > -- > -- MODIFICATION HISTORY > -- Person Date Comments > -- - -- --- > -- psurring 1/20/03 Initial implementation > -- > > err_num NUMBER; > err_msg VARCHAR2 (100); > V_SECURITY_GROUPUSER_SECURITY_GROUP.SECURITY_GROUP_ID%TYPE; > V_BRANCHUSER_INFO.BRANCH%TYPE; > > CURSOR get_admin > IS > Select username, >password, >level_, >center, >first_name, >last_name > From AGENT_ACTIVITY.ADMIN > Where upper(level_) in ('CENTER','TEAM','GROUP','PAYROLL'); > > BEGIN > >FOR x IN get_workgroups >LOOP > begin > if upper(x.level_) in ('CENTER','TEAM','GROUP') then > v_security_group := 4; > else if upper(x.level_) in ('PAYROLL') then > v_security_group := 2; > end if; > if x.center = 'TX' then > v_branch := '7'; > else > v_branch := 'G'; > end if; > EMPLOYEE_ACTIVITY.ADD_USER(x.username, > x.first_name, > x.last_name, > x.password, > v_branch, > null, > 'SYSTEM', > v_security_group); > > EXCEPTION > WHEN OTHERS > THEN > err_num := SQLCODE; > err_msg := SUBSTR (SQLERRM, 1, 100); > ROLLBACK; > insert into Application_error (USER_NAME, > ERROR_DATE, > PROCEDURE_NAME, > SQL_ERROR_NUM, > SQL_ERR_MSG, > PARAMETER) > values > (v_LAST_UPDATED_BY,sysdate,'EMPLOYEE_ACTIVITY.ADD_USER',v_err_num,v_err_msg, > 'v_USER_NAME='||v_USER_NAME|| > 'v_FIRST_NAME='||v_FIRST_NAME|| > 'v_LAST_NAME='||v_LAST_NAME|| > 'v_PASSWORD='||v_PASSWORD|| > 'v_DEFAULT_BRANCH='||v_DEFAULT_BRANCH|| > 'v_DEFAULT_WORKGROUP_ID='||v_DEFAULT_WORKGROUP_ID|| > 'v_LAST_UPDATED_BY='||v_LAST_UPDATED_BY|| > 'v_SECURITY_GROUP_ID='||v_SECURITY_GROUP_ID); > COMMIT; > RAISE; > >END; >END LOOP; > end; > / -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'Lis
AW: Cognos-unix???
Yes, We runnung it On Solaris 8. HTH. -Ursprüngliche Nachricht- Von: karthikeyan S [mailto:[EMAIL PROTECTED]] Gesendet: Freitag, 16. August 2002 16:39 An: Multiple recipients of list ORACLE-L Betreff: Cognos-unix??? Hi, Is it possible to install Cognos (Version 7) in an UNIX environment (HP, SCO or whatever) ? Thanks in advance... regards, Karthik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: karthikeyan S 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: Kulev, Milen 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).
AW: OT : informix and/or sybase
Go to http://www.sybase.com/detail?id=1010661, download and install Technical Library Installer (http://www.sybase.com/detail?id=1010663) with collections useful to you(http://sybooks.sybase.com/collectionslist.html). HTH Milen Kulev -Urspr?ngliche Nachricht- Von: Andrey Bronfin [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 26. Juni 2002 18:24 An: Multiple recipients of list ORACLE-L Betreff: OT : informix and/or sybase Dear gurus ! There is a chance that i'll have to administer informix and/or sybase databases in addition to the Oracle ones. I have no idea whatsoever about these products. i would like to ask those of us who have any experience with these products to point me to any papers / URLs etc. , as a place to start. I know , that i can start with www.sybase.com and/or www.informix.com , and i will definetly do , but i thought may be anyone knows of some better way , may be a paper like "Sybase for Oracle DBAs" or "Informix for Oracle DBAs" . Anyway , i'll be extermely glad to have any inputs . Please send them either directly to me or to the list , and i promise to summarize everything i get and post the summary. Thanks a lot ! DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin 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: Kulev, Milen 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).
just test. Igonore it !
test - Ignore it !
Title: Message
9i new features, the saga continues?
There were very interesting collection of articles. It would be nice if you continue writing them. -Ursprüngliche Nachricht-Von: Mark Leith [mailto:[EMAIL PROTECTED]]Gesendet: Donnerstag, 25. April 2002 16:34An: Multiple recipients of list ORACLE-LBetreff: RE: 9i new features, the saga continues? Keep 'em coming Joe! -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of JOE TESTASent: 25 April 2002 14:14To: Multiple recipients of list ORACLE-LSubject: 9i new features, the saga continues? Ok life has slowed down some and i've got some free time to potentially pickup the 9i new features saga i did about 6 months ago. Anyone still interested? The next on the list was 9i data guard. joe