RE: dbms_support on 8i
Jared I have dbmssupp.sql in rdbms/admin of my HP11 8.1.7.4 t -Original Message- Sent: Wednesday, 3 December 2003 6:20 am To: Multiple recipients of list ORACLE-L Does anyone know which patch level of 8i includes the dbmssupp.sql and .plb files? I have databases here that are at 8.1.7.4, but the files are not there. 9i has them, but none of the 8i databases. Thanks, Jared PS. Metalink was no help for this. Neither was google. Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. -- 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).
Oracle Financials 10SC on HP-UX rev 11
Hi Has anyone converted Oracle Financials from HP_UX rev 10.20 (DB v7.3.4.4) to run on HP-UX rev 11? The only rev 10.20 host we have left is running our Oracle Financials 10SC. We are looking at converting to HP-UX rev 11 purely for disaster recovery reasons. It will be most useful to communicate with someone who has already been through the pain in order to get some idea about whether the move is justifiable. Upgrading to Financials 11i is not an option. Issues include: Should we go for 7.3.4.4 or 8.1.7.4 DB? Do we/can we match financials patch levels between the binary-incompatible rev10.20 11 versions of Financials? How are customizations best identified, duplicated and re-installed? Thanks trevor Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. -- 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).
RE: find on unix
but find . ! -newer ... will find the older ones -Original Message- Sent: Wednesday, 26 March 2003 3:50 am To: Multiple recipients of list ORACLE-L Ignore that.. It will find newer files, not older files.. I misread the question. Sorry.. - Kirti -Original Message- Sent: Tuesday, March 25, 2003 1:39 PM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Create a 'flag' file with the 'particular' date as its last modified date: touch -t 200303201330.40 oldfile The timestamp is of the format: MMDDHHMM.SS Then use find command to find files newer (later) than oldfile. find . -newer oldfile -print HTH, - Kirti -Original Message- Sent: Tuesday, March 25, 2003 10:39 AM To: Multiple recipients of list ORACLE-L How to use find command on unix to find files older then (created ) a particular date . Any idea -ak -- 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).
RE: Comparing between two tables
David You might want to look at select * from t1 minus select * from t2 / t -Original Message- Sent: Thursday, 16 January 2003 9:04 am To: Multiple recipients of list ORACLE-L Is it a way to compare two tables to see the differences? We have problem with our database, someone input new data into database that causes problem, we want to find and remove those entries from that table. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nguyen, David M 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). Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. -- 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).
RE: Unix Q: Substring-ing an output.
Ross ps -ef | grep ora_smon | grep -v grep | awk 'FS=smon_ {print $2}' works fine for me on HP-UX trevor -Original Message- Sent: Tuesday, 29 October 2002 7:24 am To: Multiple recipients of list ORACLE-L Very clever! But unfortunately, -F accepts only 1 character. I tried that though... Ross -Original Message- From: Henry Poras [mailto:hporas;etal.URI.EDU] Sent: Tuesday, 29 October 2002 3:43 To: Multiple recipients of list ORACLE-L Subject: RE: Unix Q: Substring-ing an output. Quick thought. What about just setting awk -F_ to awk -Fpmon_ ??? Henry -Original Message- Bobak Sent: Sunday, October 27, 2002 11:49 PM To: Multiple recipients of list ORACLE-L Hmm...good point. You know, I use this technique in various places. I never noticed that bug before, cause it will only appear if the database has been up less than 1 day. Guess it's time to do a bit of script auditing. Ok, try this instead: ps -ef|grep pmon|grep -v grep|cut -c49- |awk -F_ '{ 'print $3 }' I replaced the first awk w/ cut. the -c option says to cut that output from position 49 to the end of the line. You may have to adjust the value from 49 to something else. That ought to work for you. -Mark On Sun, 2002-10-27 at 22:53, Ross Collado wrote: Thanks Mark. Yes that helps, in a way. I could use good ol' awk to parse the last field! However, a slight problem in the ps -ef output. If I do what you have suggested on my 'ps -ef' output below, I would only get RMAN as it is the only one in field #8. All the rest are in field #9. All I need now is figure out how to cut the last field then pipe it to your awk command. Ok I'm getting somewhere! Rgds, Ross -Original Message- From: Mark J. Bobak [mailto:mark;bobak.net] Sent: Monday, 28 October 2002 13:54 To: Multiple recipients of list ORACLE-L Subject: Re: Unix Q: Substring-ing an output. As is often the case, there are a million ways to do this. Given the output listed, I'd do something like: ps -ef|grep pmon|grep -v grep|awk '{ print $8 }'|awk -F_ '{ print $3 }' ps -ef -- get the programs that are running grep pmon -- get only those lines that have 'pmon' in them grep -v grep -- drop out the line that has 'grep pmon' awk '{ print $8 }' -- get the eighth column, the program name awk -F_ '{ print $3 }' -- parse the program name on the '_' and return the third field, the database name. Hope that helps, -Mark On Sun, 2002-10-27 at 20:43, Ross Collado wrote: Hi All, I want to feed my shell script with the names of currently running databases. I thought of using ps -ef|grep [p]mon. What I got was the following: oracle 20113 1 0 Oct 25 ?0:01 ora_pmon_TLDEV oracle 898 1 0 Jul 22 ?0:06 ora_pmon_TLQA oracle 944 1 0 Jul 22 ?0:07 ora_pmon_TLQAVAR oracle 19588 1 0 Oct 25 ?0:00 ora_pmon_DBMON oracle 13509 1 0 12:16:13 ?0:00 ora_pmon_RMAN oracle 20450 1 0 Oct 25 ?0:00 ora_pmon_PRDINF oracle 13026 1 0 Oct 26 ?0:00 ora_pmon_TLDVVAR What I wanted is get only the db name part eg. TLDEV, RMAN, DBMON,etc. I don't want to rely on oratab file. I was thinking of using 'cut' to cut out the last field and do some ${X##} (variable pattern substitution) to get to the dbname bit. The trouble is the number of fields in a ps -ef output is not consistent. As you can see I've just restarted RMAN and now it only has 8 fields as compared to 9 for the others. Any suggestions? Or another way of doing it? Using KSH on Solaris 8. Thanks. Ross -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well. -- Rene Descartes -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark J. Bobak 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). -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well. -- Rene Descartes -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:
admin_restrictions_listener
hi all I have my listener.ora owned by the oracle owner with 600 permissions and admin_restrictions_listener set. On a machine in the DMZ. Is there any point in having a password as well? thanks trevor Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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).
RE: admin_restrictions_listener
I understood that admin_restrictions_listener=on meant that you had to be physically logged on to the machine containing the listener.ora file to be able to stop/start/change. Is this not correct? If correct, then 600 permissions would mean that you also had to be logged on as the oracle owner: and if you are the oracle owner logged on to the same machine as the listener then you'd not need to use lsnrctl to create havoc. What am i missing here? -Original Message- Sent: Friday, 18 October 2002 4:11 am To: Multiple recipients of list ORACLE-L Not true. I'm talking about accessing the TNS Listener process from a lsnrctl executable on another machine entirely (i.e. my laptop, for example). Changing the file permissions on the tnslsnr executable on the server won't prevent commands (like STOP) received over the network... Passwording the TNS Listener is the only protection for that... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 17, 2002 12:29 PM Although if you set the lsnrctl to 700 that problem goes away (that's what we did). I'm still amazed that it's world executable. Jay Miller -Original Message- Sent: Thursday, October 17, 2002 10:35 AM To: Multiple recipients of list ORACLE-L yup. i can run lsnrctl from my laptop somewhere on your network and stop the listener otherwise... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 17, 2002 3:38 AM hi all I have my listener.ora owned by the oracle owner with 600 permissions and admin_restrictions_listener set. On a machine in the DMZ. Is there any point in having a password as well? thanks trevor Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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.com -- 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 '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: Miller, Jay 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.com -- 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 '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