Very high memory usage per user process
Hi All, A while ago somebody posted a question what the reason could be for very high memory usage per session. We had the same problem and tracked it back to bug 762114 yesterday. SO if that person reads this maybe you have the same problem. Jack = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
OID in application..
Hello All.. I am using Oracle Internet Directory in our e-Commerce application based on Oracle Technologies. How is it possible in my pl/sql application to have some mechanism to find that if any of the LDAP server is being used for certain data or not? I want to know in starting of my application that, if any LDAP or directory server is being used for user entries then access from directory server else access from my application database. How is it possible? I am very new to OID concepts.. You comments will be great help to me Thanks Regards Vinay Sharma -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: resize in 7.3.4 urgent
Bonjour Theorically it's possible. The condition is that there is a free space at the end of the datafile. Best Regards, Kamel Benlatreche -Message d'origine- De : Djaroud Salim [mailto:[EMAIL PROTECTED]] Envoyé : mardi 17 juillet 2001 17:05 À : Multiple recipients of list ORACLE-L Objet : resize in 7.3.4 urgent hi, i want if any body try to resize a datafile to a lower value. i'm on oracle 7.3.4 on hpunix 10.0 thanks in advance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Djaroud Salim 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: GL2Z/ INF DBA BENLATRECHE 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).
offtopic-wishing to learn Solaris/Unix from scratch
Title: offtopic-wishing to learn Solaris/Unix from scratch hi list, if some one is willing to start learning Solaris/Unix from scratchscratch means scratch, then which link/artical/book will be serving the purpose. and that some one wants to get through Solaris certification after getting himself drowned in Solaris, Not to mention docs.sun.com has all the solaris related material, but remember the word SCRATCH thanks in advance Arslan
Re: private/public rollbacks (Out of the Office 7/17 - 7/20)
I will be in a training class 7/17 - 7/20. I will respond to this e-mail when I return. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHRIS FARMER 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).
Certification
Oh dear, it looks like the time has arrived whereby I am to be certified. I will be booked on all of the Oracle 8i courses (some are superfluous to my needs but they are block booked at a discount - a nice little jolly away from the office if nothing else !!) and then take the exams as I do them. So, those who have been through this - what are the best study guides to use ? Any recommendation would be welcome. Regards Lee (who promises not include Oracle 8i OCP in his sig if I pass !!) The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system.
RE: resize in 7.3.4 urgent
see this note from Oracle but be careful . Doc ID: Note:1029252.6 Type: BULLETIN Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 03-APR-1997 Last Revision Date: 27-APR-2001 PURPOSE This bulletin covers a method for resizing datafiles with the ALTER DATABASE DATAFILE RESIZE command. SCOPE APPLICATION Instructional. How to Resize a Datafile: = Datafile management has two sides to it: not enough room for existing datafiles, or not enough room IN existing datafiles. Typical solutions are to drop and recreate the tablespace with different sized datafiles, or to add more datafiles to a tablespace. To make solving these issues easier, Oracle has come up with a way to resize the datafiles for the database. Starting with RDBMS 7.2, you can use the new command for datafiles, called RESIZE. This option allows you to change the physical size of a datafile from what was specified during its creation. I. Increase Datafile Size II. Decrease Datafile Size III. Cautions and Warnings Attempting to use the RESIZE command on versions prior to 7.2 will receive the following error: ORA-00923: FROM keyword not found where expected I. INCREASE DATAFILE SIZE To increase the size of a datafile, you would use the command: ALTER DATABASE DATAFILE 'full_path_name' RESIZE integer [K|M]; where the size specified is larger than the existing file size. Check V$DATAFILE for current settings. The BYTES column shows the current size of the datafile, and the CREATE_BYTES column shows what the size was specified when the file was created. The size of the datafile will also be changed at the operating system level. For example: FILE# STATUS ENABLEDCHECKPOINT BYTES CREATE_BYT NAME -- --- -- -- -- -- 5 ONLINE READ WRITE 7450 2097152102400 /databases/oracle/test.dbf As you can see, the file was created with a size of 100K (CREATE_BYTES) and was increased to a size of 2MB (BYTES) with the RESIZE command. II. DECREASE DATAFILE SIZE To decrease the size of a datafile, you use the same command, but specify a size smaller than the existing datafile. For example, we could reduce the file above back to 1MB with the command: ALTER DATABASE DATAFILE '/databases/oracle/test.dbf' RESIZE 1MB; Downsizing a datafile is more complicated than increasing the size of a datafile. You cannot deallocate space from a datafile that is currently being used by database objects. To remove space from a datafile, you have to have contiguous space at the END of the datafile.Check the view DBA_FREE_SPACE to see how much space is not being used in a datafile. For the above file we get: SELECT * FROM DBA_FREE_SPACE WHERE TABLESPACE_NAME=TEMP ORDER BY BLOCK_ID; TABLESPACE_NAMEFILE_IDBLOCK_ID BYTES BLOCKS -- -- -- -- -- TEMP4 2 102400 50 TEMP4 55 96256 47 TEMP41021890304923 As you can see, there are two large extents at the high end of the datafile (BLOCK_ID = 55 and contains 47 blocks, BLOCK_ID=102 and contains 923 blocks). This means there are 1986560 unused bytes at the end of our datafile, almost 2MB. We want to leave some room for growth in our datafile, and depending on how the objects in that datafile allocate new extents, we could remove easily up to 1.89MB of disk space from the datafile without damaging any objects in the tablespace. If you have a large extent in the middle of a datafile, and some object taking up room at the end of the datafile, you can use the query FINDEXT.SQL to find this object. If you export this object, then drop it, you should then free up contiguous space at the end of your datafile so you will be able to resize it smaller. Make sure you leave enough room in the datafile for importing the object back into the tablespace. III. CAUTIONS AND WARNINGS For safety reasons, you should take a backup of your database whenever you change its structure, which includes altering the size of datafiles. If you try to resize a datafile to a size smaller than is needed to contain all the database objects in that datafile, you will get an error: ORA-03297: file contains number blocks of data beyond requested RESIZE value The resize operation will fail at this point. If you try to resize a datafile larger than can be created, you will also get an error. For instance, in trying to create a file of 2GIG, without 2GIG of available disk space you will get something similar to: ORA-01237: cannot extend datafile number ORA-01110:
Re: security problem with 8i
Listers: My client has asked me to look into this issue and determine if they should be concerned about it or not. Since they don't have any db's directly accessible from the Internet and since their LAN is very secure anyway, I'm inclined to not apply any patches based on the premise that if it isn't a necessary patch, don't apply it in fear of breaking something else. What do you think? -- Jon Walthour, OCDBA Oracle DBA Computer Horizons Cincinnati, Ohio - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 09, 2001 1:26 PM Hi All, i am not sure if this has already been posted or not, but.. --29 June 2001 Oracle8i Database Buffer Overflow Vulnerability Security experts found and disclosed a pair of vulnerabilities in the standard and enterprise editions of Oracle8i database. The Transport Network Substrate (TNS) Listener has a buffer overflow vulnerability; a flaw in the SQL Net protocol leaves the system vulnerable to denial-of- service attacks. Patches are available. http://www.computerworld.com/storyba/0,4125,NAV47_STO61802,00.html -bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Conner 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: Jon Walthour 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: send email through pl/sql ???
Hi Janet :
Try to use this code.
It works only in 8.1 above version of database.
create or replace PROCEDURE send_mail (senderIN VARCHAR2,
recipient IN VARCHAR2,
message IN VARCHAR2)
IS
mailhost VARCHAR2(30) := 'internet';
smtp_error EXCEPTION;
mail_conn utl_tcp.connection;
PROCEDURE smtp_command(command IN VARCHAR2,
ok IN VARCHAR2 DEFAULT '250')
IS
response varchar2(3);
lixo pls_integer;
BEGIN
lixo := utl_tcp.write_line(mail_conn, command);
response := substr(utl_tcp.get_line(mail_conn), 1, 3);
IF (response ok) THEN
RAISE smtp_error;
END IF;
END;
BEGIN
mail_conn := utl_tcp.open_connection(mailhost, 25);
smtp_command('HELO ' || mailhost);
smtp_command('MAIL FROM: ' || sender);
smtp_command('RCPT TO: ' || recipient);
smtp_command('DATA', '354');
smtp_command(message);
smtp_command('QUIT', '221');
utl_tcp.close_connection(mail_conn);
EXCEPTION
WHEN OTHERS THEN
null;
END;
create or replace PROCEDURE PR_ENVIA_EMAIL
(senderIN VARCHAR2,
recipient IN VARCHAR2,
subj IN VARCHAR2,
body IN VARCHAR2)
as
crlf VARCHAR2(2):= CHR( 13 ) || CHR( 10 );
mesg VARCHAR2(32000);
mail_conn UTL_SMTP.CONNECTION;
cc_recipient VARCHAR2(50) default 'email';
bcc_recipient VARCHAR2(50) default 'email';
BEGIN
mail_conn := utl_smtp.open_connection('servidor email', 25);
utl_smtp.helo(mail_conn, 'mailhost');
utl_smtp.mail(mail_conn, sender);
utl_smtp.rcpt(mail_conn, recipient);
utl_smtp.rcpt(mail_conn, cc_recipient);
utl_smtp.rcpt(mail_conn, bcc_recipient);
mesg:= 'Date: ' || TO_CHAR( SYSDATE, 'dd Mon yy hh24:mi:ss' ) || crlf ||
'From: ' || sender || crlf ||
'To: ' || recipient || crlf ||
'Cc: ' || cc_recipient || crlf ||
'Bcc: ' || bcc_recipient || crlf ||
'Reply-to: 'email, email' || crlf ||
'X-Sent-by: Widesoft Widelog - 1 ' || crlf ||
'X-Event: Deu pau no procedimento W_supxxx1 ' || crlf ||
'Subject: ' || subj || crlf;
mesg:= mesg || '' || crlf || body;
utl_smtp.data(mail_conn, mesg);
utl_smtp.quit(mail_conn);
EXCEPTION
WHEN OTHERS THEN
dbms_output.put_line(sqlerrm);
END;
exec PR_ENVIA_EMAIL ('email','email','Test Message - ','Dear friend :
' || chr(13) || chr(10) || 'It is a very good resource' );
Eriovaldo
[EMAIL PROTECTED]
Brazil
From: Janet Linsy [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: send email through pl/sql ???
Date: Tue, 17 Jul 2001 20:45:23 -0800
Hi all,
Does anybody know how to send email through pl/sql?
thank you.
Janet
__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Janet Linsy
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).
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Eca Eca
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).
how to configure utl_smtp
hi can any one help me to configure UTL_SMTP PACKAGE AFTER INSTALLING THE UTL_SMTP.sql what steps need to be taken at the NT level (any things to be configured) the documentation gives the procedures how to use the package but i could not find how to configure the UTL_SMTP with the database on NT Thanks in advance shyam Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad 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).
RE: Certification
Lee, Try my web site www.hcresources.co.uk which has a page about my OCP exploits. It is not much of a site but the OCP info may be helpful John -Original Message-From: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED]]Sent: 18 July 01 12:30To: Multiple recipients of list ORACLE-LSubject: Certification Oh dear, it looks like the time has arrived whereby I am to be certified. I will be booked on all of the Oracle 8i courses (some are superfluous to my needs but they are block booked at a discount - a nice little jolly away from the office if nothing else !!) and then take the exams as I do them. So, those who have been through this - what are the best study guides to use ? Any recommendation would be welcome. Regards Lee (who promises not include Oracle 8i OCP in his sig if I pass !!) The information contained in this communication isconfidential, is intended only for the use of the recipientnamed above, and may be legally privileged. If the reader of this message is not the intended recipient, you arehereby notified that any dissemination, distribution orcopying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computersystem. ** This email and any attachments may be confidential and the subject of legal professional privilege. Any disclosure, use, storage or copying of this email without the consent of the sender is strictly prohibited. Please notify the sender immediately if you are not the intended recipient and then delete the email from your inbox and do not disclose the contents to another person, use, copy or store the information in any medium. **
Re: offtopic-wishing to learn Solaris/Unix from scratch
I would like to recommend to read some book about the very concepts, I don't think there are many changes from these times in process management, memory management, file system management and i/o management for example A.Silbuschatz, J.Peterson, P.Galvin Operating Systems Concepts Addison Wesley publishing company,1991, ISBN 0-201-51379-X or William A. Shay, Introduction to operating systems, harper collins college publishers 1993 ISBN 0-673-38-122-6 Of course these two books are not the only one source, maybe not the best source but you understand my direction Gints Plivna Arslan Dar arslandar@skTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] m.org.pkcc: Sent by: Subject: offtopic-wishing to learn Solaris/Unix from scratch root@fatcity. com 2001.07.18 11:45 Please respond to ORACLE-L hi list, if some one is willing to start learning Solaris/Unix from scratchscratch means scratch, then which link/artical/book will be serving the purpose. and that some one wants to get through Solaris certification after getting himself drowned in Solaris, Not to mention docs.sun.com has all the solaris related material, but remember the word SCRATCH thanks in advance Arslan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
Oracle internet directory example.
Hello Oracle Gurus. This time i tried to run the EMP trigger example given in Oracle Internet Directory Application guide with LDAP/PLSQL API. I created the trigger with the script trigger.sql under ORA_HOME/LDAP/DEMO directory. when i run the script empdata.sql toinsert data in EMP table encountered following error. LDAP Host: vinay LDAP Port: 389 Ldap session : 38AA2309(returned from init) simple_bind_s Returns: 0 Adding Entry for DN : [cn=Natt Ball, o=acme,dc=com] Error code: -31202 Error Message : ORA-31202: DBMS_LDAP: LDAP client/server error: No such object Exception encountered .. exiting I am using Oracle 8.1.7 database on Windows 2000. the oid monitor and directory server instance has been started successfully using oidmon, oidctl commands. If some one has tried this example then please let me know where i am doing wrong.. Thanks Vinay -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: security problem with 8i
On Wed, Jul 18, 2001 at 03:45:57AM -0800, Jon Walthour wrote: Listers: My client has asked me to look into this issue and determine if they should be concerned about it or not. Since they don't have any db's directly accessible from the Internet and since their LAN is very secure anyway, I'm inclined to not apply any patches based on the premise that if it isn't a necessary patch, don't apply it in fear of breaking something else. What do you think? -- two words, disgruntled employee === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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: security problem with 8i
Jon, I would tend to agree with you. As long as their data is not externally available, the risk of this type of attack is very low. Most employees are not foolhardy enough to initiate DOS attacks from their internal LAN's. However if they ever intend to move their system to the internet, VPN, etc. then they need to keep this info and patch as part of their migration plan. Rodd Original Message On 7/18/01, 6:45:57 AM, Jon Walthour [EMAIL PROTECTED] wrote regarding Re: security problem with 8i: Listers: My client has asked me to look into this issue and determine if they should be concerned about it or not. Since they don't have any db's directly accessible from the Internet and since their LAN is very secure anyway, I'm inclined to not apply any patches based on the premise that if it isn't a necessary patch, don't apply it in fear of breaking something else. What do you think? -- Jon Walthour, OCDBA Oracle DBA Computer Horizons Cincinnati, Ohio - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 09, 2001 1:26 PM Hi All, i am not sure if this has already been posted or not, but.. --29 June 2001 Oracle8i Database Buffer Overflow Vulnerability Security experts found and disclosed a pair of vulnerabilities in the standard and enterprise editions of Oracle8i database. The Transport Network Substrate (TNS) Listener has a buffer overflow vulnerability; a flaw in the SQL Net protocol leaves the system vulnerable to denial-of- service attacks. Patches are available. http://www.computerworld.com/storyba/0,4125,NAV47_STO61802,00.html -bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Conner 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: Jon Walthour 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: Rodd Holman 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: [Re: UNIX mailx]
I would like to thank all of you who send a reply. I got it to work emailing one file, working on multi files in one email. Thanks again Yigal - Original Message - From: Yigal Ran [EMAIL PROTECTED] To: LazyDBA.com Discussion [EMAIL PROTECTED] Sent: Monday, July 16, 2001 1:45 PM Subject: UNIX mailx Does any one know if it is possible to attach a file when using mailx to send an email? TIA Yigal Get free email and a permanent address at http://www.amexmail.com/?A=1 Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html Get free email and a permanent address at http://www.amexmail.com/?A=1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yigal Ran 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: Certification
Very interesting reading John. Not from the North East of England are you ?? Interv8 are in North Shields and I got a couple of calls from them over the Christmas Holiday period. Lee -Original Message-From: Hallas John [mailto:[EMAIL PROTECTED]]Sent: 18 July 2001 13:35To: Multiple recipients of list ORACLE-LSubject: RE: Certification Lee, Try my web site www.hcresources.co.uk which has a page about my OCP exploits. It is not much of a site but the OCP info may be helpful John -Original Message-From: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED]]Sent: 18 July 01 12:30To: Multiple recipients of list ORACLE-LSubject: Certification Oh dear, it looks like the time has arrived whereby I am to be certified. I will be booked on all of the Oracle 8i courses (some are superfluous to my needs but they are block booked at a discount - a nice little jolly away from the office if nothing else !!) and then take the exams as I do them. So, those who have been through this - what are the best study guides to use ? Any recommendation would be welcome. Regards Lee (who promises not include Oracle 8i OCP in his sig if I pass !!) The information contained in this communication isconfidential, is intended only for the use of the recipientnamed above, and may be legally privileged. If the reader of this message is not the intended recipient, you arehereby notified that any dissemination, distribution orcopying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computersystem.**This email and any attachments may be confidential and the subject of legal professional privilege. Any disclosure, use, storage or copying of this email without the consent of the sender is strictly prohibited.Please notify the sender immediately if you are not the intended recipient and then delete the email from your inbox and do not disclose the contents to another person, use, copy or store the information in any medium. **
Re: Further question: Oracle 32bit / 64bit
Last time that I installed Oracle 8.1.6 on a Sun 64 bit OS I installed the 64 bit version. If you pressed me real hard as to why I did that, the best that I could say is that it seemed like a good idea at the time. Some vague idea that the 64 bit version would work better (more optimally) with the 64 bit OS. I haven't seen anything to make me think that the 32 bit version would have been a better choice. On the other hand, it was a new installation, not a migration of an existing database. I don't know if there are any problems with migrating a 32 bit version database to 64 bit. Finally, the Oracle installation manual seems to assume the 32 bit version. As I remember we had to tweak the kernel parameters to get the database to mount and open. Don't remember which. Fortunately, you don't have to reboot to get the changes to take effect. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
9ias for sun intel
list, One of the developers is looking for the download of 9iAS for SUN INTEL. He would like to use the developer portion as a study aid for his college course. Does anyone know the location? OTN only has the linux intel available. It can be purchased from the Oracle store for $40 but he doesn't want to spend the $. Thanks, ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers 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: Certification
On Wednesday 18 July 2001 04:30, Robertson Lee - lerobe wrote: Lee (who promises not include Oracle 8i OCP in his sig if I pass !!) If you got it, flaunt it! Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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[2]: security problem with 8i
Although there has been so much publicity of security holes in Oracle, in particular the listener, the one hole that really causes me concern is the default passwords for sys and system and/or using the username as a password. Over the past 2 years I've been to a few sites, like 4, at a friends request and/or on an interview where the manager said show me and each time I've been able to log onto the DB with any of the following: sys/change_on_install sys/sys system/system system/manager Now come on, this was an old V6 thing that we were suppose to do, and we're still not!! Dick Goulet Reply Separator Author: Ray Stell [EMAIL PROTECTED] Date: 7/18/2001 5:15 AM On Wed, Jul 18, 2001 at 03:45:57AM -0800, Jon Walthour wrote: Listers: My client has asked me to look into this issue and determine if they should be concerned about it or not. Since they don't have any db's directly accessible from the Internet and since their LAN is very secure anyway, I'm inclined to not apply any patches based on the premise that if it isn't a necessary patch, don't apply it in fear of breaking something else. What do you think? -- two words, disgruntled employee === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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: 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).
OFF-TOPIC : remsh from a WIN workstation to a UNIX
Title: OFF-TOPIC : remsh from a WIN workstation to a UNIX Dear list ! Is there a way to run a command from a WIN NT workstation on a remote UNIX server (i.e. something like remsh) . Thanks a lot in advance !
RE: Certification
Thanks everyone. I thinkl I have enough to be going on with. Lee -Original Message- Sent: 18 July 2001 14:54 To: [EMAIL PROTECTED] The tests come directly out of the in class study guides. All you need to do is study the guides and take a few practice test to get a feel for the types of questions and the tests themselves. There are a lot of 'tests' on the web: http://cramsession.brainbuzz.com/cramsession/oracle/ http://braindumps.com/it/o/temp1.htm http://www.geocities.com/SiliconValley/Hub/9578/oracle/index.htm http://ora.dbasupport.com/oracle/cert/train.shtml http://www.certprep.com/starthere.asp http://www.examsonline.com/ Good Luck. Todd Carlson Oracle 8i Certified DBA Bunge North America Robertson To: Multiple recipients of list ORACLE-L Lee - lerobe [EMAIL PROTECTED] lerobe@acxiocc: m.co.uk Subject: Certification Sent by: root@fatcity. com 07/18/2001 06:30 AM Please respond to ORACLE-L Oh dear, it looks like the time has arrived whereby I am to be certified. I will be booked on all of the Oracle 8i courses (some are superfluous to my needs but they are block booked at a discount - a nice little jolly away from the office if nothing else !!) and then take the exams as I do them. So, those who have been through this - what are the best study guides to use ? Any recommendation would be welcome. Regards Lee (who promises not include Oracle 8i OCP in his sig if I pass !!) The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Oh dear, it looks like the time has arrived whereby I am to be certified. I will be booked on all of the Oracle 8i courses (some are superfluous to my needs but they are block booked at a discount - a nice little jolly away from the office if nothing else !!) and then take the exams as I do them. So, those who have been through this - what are the best study guides to use ? Any recommendation would be welcome. Regards Lee (who promises not include Oracle 8i OCP in his sig if I pass !!) The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe 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: Multiple Listeners
It is my understanding that you don't need the; SID_LIST_LISTENERDB2 = (SID_LIST = (SID_DESC = (SID_NAME = DBAME2) (ORACLE_HOME = /path/to/oracle/home) ) ) section if you define the service_names entry in your init.ora files. You should do one or the other. Please correct if I'm wrong, but this is how it works on my 8.1.6 instances. -Original Message- Aschenbrenner Sent: Monday, July 16, 2001 6:27 PM To: Multiple recipients of list ORACLE-L Edward, Yes, you can setup multiple listeners. Here is an example: LISTENERDB1 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = hostname.com)(PORT = 1521)) ) ) ) LISTENERDB2 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = hostname.com)(PORT = 1522)) ) ) ) SID_LIST_LISTENERDB1 = (SID_LIST = (SID_DESC = (SID_NAME = DBAME1) (ORACLE_HOME = /path/to/oracle/home) ) ) SID_LIST_LISTENERDB2 = (SID_LIST = (SID_DESC = (SID_NAME = DBAME2) (ORACLE_HOME = /path/to/oracle/home) ) ) After you have set this up, you can start the listeners individually: lsnrctl start listenerdb1 lsnrctl start listenerdb2 Hope that helps... Alan Alan Aschenbrenner Oracle DBA IHS Group [EMAIL PROTECTED] (303)-858-6394 -Original Message- Carr Sent: Monday, July 16, 2001 3:42 PM To: Multiple recipients of list ORACLE-L Hello All, I am currently running Oracle 816 64bit on a Solaris 8 box. I have three databases on the system with one LISTENER for all of them. Is it possible to configure multiple listeners, one for each database? We have tried in the past with no success... If there is a document on the web somebody could point me to, that would be great! I have searched for one but must not be searching correctly. TIA, -- Edward W. Carr UNIX Systems Administrator Qwest Communications Broadband Services Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alan Aschenbrenner 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: Glenn Travis 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).
OT RE: Re[2]: security problem with 8i
there's also the ALL POWERFUL scott/tiger account to consider! -Original Message- Sent: Wednesday, July 18, 2001 11:07 AM To: Multiple recipients of list ORACLE-L Although there has been so much publicity of security holes in Oracle, in particular the listener, the one hole that really causes me concern is the default passwords for sys and system and/or using the username as a password. Over the past 2 years I've been to a few sites, like 4, at a friends request and/or on an interview where the manager said show me and each time I've been able to log onto the DB with any of the following: sys/change_on_install sys/sys system/system system/manager Now come on, this was an old V6 thing that we were suppose to do, and we're still not!! Dick Goulet Reply Separator Author: Ray Stell [EMAIL PROTECTED] Date: 7/18/2001 5:15 AM On Wed, Jul 18, 2001 at 03:45:57AM -0800, Jon Walthour wrote: Listers: My client has asked me to look into this issue and determine if they should be concerned about it or not. Since they don't have any db's directly accessible from the Internet and since their LAN is very secure anyway, I'm inclined to not apply any patches based on the premise that if it isn't a necessary patch, don't apply it in fear of breaking something else. What do you think? -- two words, disgruntled employee === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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: 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: Mohan, Ross 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: resize in 7.3.4 urgent
If you want to see a more visual representation of what's in a tablespace
(including free space) use the mapper.sql from the old DBA Handbook (don't
have it right here in front of me so I don't know the author's name). This
is for Oracle 7.3.4.
--
rem
rem file: mapper.sql
rem parameters: the tablespace name being mapped
rem
rem Sample invocation:
rem @mapper SYSTEM
rem
rem This script generates a mapping of the space usage
rem (free space vs used) in a tablespace. It graphically
rem shows segment and free space fragmentation.
rem
set pagesize 66 linesize 132 verify off
ttitle 'Map of Tablespace ' 1 right datevar skip 1
column substr(file_id,1,4) heading File|Id
column bytes format 999,999,999,999
column today noprint new_value datevar
SELECT
to_char(sysdate, 'MM/DD/YY') today,
'free space' owner, /*owner of free space*/
' ' object, /*blank object name*/
substr(file_id,1,4), /*file ID for the extent header*/
block_id, /*block ID for the extent header*/
blocks, /*lengthof the extent in blocks*/
bytes /*length of the extent in bytes*/
FROM sys.dba_free_space
WHERE tablespace_name = upper('1')
UNION
SELECT
to_char(sysdate, 'MM/DD/YY') today,
substr(owner,1,10), /*owner name (first 20 chars)*/
substr(segment_name,1,27), /*segment name (first 26 chars)*/
substr(file_id,1,4), /*file ID for extent header*/
block_id, /*block ID for block header*/
blocks, /*length of the extent in blocks*/
bytes /*length of the extent in bytes*/
FROM sys.dba_extents
WHERE tablespace_name = upper('1')
ORDER BY 4,5
/
undefine 1
--
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
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: Re[2]: security problem with 8i
Are you joking ? --- [EMAIL PROTECTED] a écrit : Although there has been so much publicity of security holes in Oracle, in particular the listener, the one hole that really causes me concern is the default passwords for sys and system and/or using the username as a password. Over the past 2 years I've been to a few sites, like 4, at a friends request and/or on an interview where the manager said show me and each time I've been able to log onto the DB with any of the following: sys/change_on_install sys/sys system/system system/manager Now come on, this was an old V6 thing that we were suppose to do, and we're still not!! Dick Goulet Reply Separator Author: Ray Stell [EMAIL PROTECTED] Date: 7/18/2001 5:15 AM On Wed, Jul 18, 2001 at 03:45:57AM -0800, Jon Walthour wrote: Listers: My client has asked me to look into this issue and determine if they should be concerned about it or not. Since they don't have any db's directly accessible from the Internet and since their LAN is very secure anyway, I'm inclined to not apply any patches based on the premise that if it isn't a necessary patch, don't apply it in fear of breaking something else. What do you think? -- two words, disgruntled employee === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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: 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Vos albums photos en ligne, Yahoo! Photos : http://fr.photos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= 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: Oracle db missing
Have you included this database in the tnsnames.ora file on the machine where OEM is running? Also use the suggestion about the Agent. HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 17, 2001 11:45 PM I just install a preconfigure - Oracle 8i into my win2k machinese becoz of the testing requirement , I have configure another small 'test' db , I can see the tnsname already include the new small baby 'test', but when I goto DB studio ,the OEM did't show me my new db ? why ? I can run sqlplus scot/tiger@test ,why the OEM can't detect it -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond Lee Meng Hong 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: Ruth Gramolini 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: OFF-TOPIC : remsh from a WIN workstation to a UNIX
Title: OFF-TOPIC : remsh from a WIN workstation to a UNIX MKS toolkit? http://www.mkssoftware.com/products/tk/ds_tksa.asp -Original Message-From: Andrey Bronfin [mailto:[EMAIL PROTECTED]]Sent: Wednesday, July 18, 2001 10:42 AMTo: Multiple recipients of list ORACLE-LSubject: OFF-TOPIC : remsh from a WIN workstation to a UNIX Dear list ! Is there a way to run a command from a WIN NT workstation on a remote UNIX server (i.e. something like "remsh") . Thanks a lot in advance !
Re: OFF-TOPIC : remsh from a WIN workstation to a UNIX
Use ssh, it's a secure replacement for remsh. Available as part of cygwin at http://sources.redhat.com/cygwin/ Jared On Wednesday 18 July 2001 07:41, Andrey Bronfin wrote: Dear list ! Is there a way to run a command from a WIN NT workstation on a remote UNIX server (i.e. something like remsh) . Thanks a lot in advance ! Content-Type: text/html; charset=windows-1255; name=Attachment: 1 Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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).
Licensing
I am just curious if anyone knows anything about concurrent user licensing. My question is: am I limited to the number of instances or just to concurrent users? Any help is greatly appreciated. Thanks, -- Alan Carbutt Applications Programmer Adams State College 719-587-7096 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alan Carbutt 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[2]: Certification
Jared, Why amongst one's peers? I appreciate and flaunt it in other places that provide more bang for the buck (like on the resume). Dick Goulet Reply Separator Author: Jared Still [EMAIL PROTECTED] Date: 7/18/2001 7:01 AM On Wednesday 18 July 2001 04:30, Robertson Lee - lerobe wrote: Lee (who promises not include Oracle 8i OCP in his sig if I pass !!) If you got it, flaunt it! Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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: 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: New Listener Question
I disagree. Mine only registers itself if I have the service_names entry in the init.ora file. Comment this line out and see what happens... -Original Message- Smith Sent: Tuesday, July 17, 2001 1:31 PM To: Multiple recipients of list ORACLE-L In Oracle 8i a database will self register with the default listener even if you do not have it defined. There are parameters that you can put in your init.ora to prevent this. -Original Message- Sent: Tuesday, July 17, 2001 9:35 AM To: Multiple recipients of list ORACLE-L First Off, I would like to thank everyone who replied yesterday, your answers were most helpful! Today, I am facing a new puzzle. I am currently running 3 databases on a server, but only two of them are listed in the listener.ora (bdw and rcvr). If I do a 'lsnrctl status' it shows a listener for all three databases (bdw rcvr and webprod). How is this possible? I have included my current listener.ora and output from 'lsnrctl status' ... Also, people who access these databases go through VIRTUAL ip's, i.e. the box itself has IP address xxx.xxx.xxx.11 the bdw ip is xxx.xxx.xxx.31 and the webprod ip is xxx.xxx.xxx.30 The reason for the virt ip's is for the fail over we have in place, so people do not have to reconfigure their machines when we move the databases around. So by all rights I do not see how anyone can connect, but they are?!?!?!? WTH??? Thanks again guys ... # LISTENER.ORA Configuration File:/apps/oracle/product/816/network/admin/listener.ora # Generated by Oracle configuration tools. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = bdw1)(PORT = 1521)) ) ) (DESCRIPTION = (PROTOCOL_STACK = (PRESENTATION = GIOP) (SESSION = RAW) ) (ADDRESS = (PROTOCOL = TCP)(HOST = bdw1)(PORT = 2481)) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /apps/oracle/product/816) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = bdw) (ORACLE_HOME = /apps/oracle/product/816) (SID_NAME = bdw) ) (SID_DESC = (GLOBAL_DBNAME = rcvr) (ORACLE_HOME = /apps/oracle/product/816) (SID_NAME = rcvr) ) ) oracle@bdw1 SID: bdw /apps/oracle/product/816/network/admin lsnrctl status LSNRCTL for Solaris: Version 8.1.6.0.0 - Production on 17-JUL-2001 09:24:30 (c) Copyright 1998, 1999, Oracle Corporation. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC))) STATUS of the LISTENER Alias LISTENER Version TNSLSNR for Solaris: Version 8.1.6.0.0 - Production Start Date10-JUL-2001 15:14:01 Uptime6 days 18 hr. 10 min. 30 sec Trace Level off Security OFF SNMP OFF Listener Parameter File /apps/oracle/product/816/network/admin/listener.ora Listener Log File /apps/oracle/product/816/network/log/listener.log Services Summary... PLSExtProchas 1 service handler(s) WEBPROD has 2 service handler(s) bdw has 1 service handler(s) bdw has 1 service handler(s) rcvr has 1 service handler(s) The command completed successfully -- Edward W. Carr UNIX Systems Administrator Qwest Communications Broadband Services Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith 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: Glenn Travis 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).
Oracle 9i on AIX with RAC
Hi, Anyone has any updates on 9i with RAC on AIX platform availability? Any dates? Dates without RAC ?? Thanks in advance Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra 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: OT RE: Re[2]: security problem with 8i
Ross, You can get into all of my databases that way, including the enterprise SAP database. Wonderful huh? Changing passwords around is on my todo list, but it's often not as simple as just changing it. There may be other ramifications, like it's a FailSafe database for instance. Or a 3rd party duhveloper installed the software and set everyone up to run as SYSTEM. Brilliant. Jared On Wednesday 18 July 2001 08:20, Mohan, Ross wrote: Although there has been so much publicity of security holes in Oracle, in particular the listener, the one hole that really causes me concern is the default passwords for sys and system and/or using the username as a password. Over the past 2 years I've been to a few sites, like 4, at a friends request and/or on an interview where the manager said show me and each time I've been able to log onto the DB with any of the following: sys/change_on_install sys/sys system/system system/manager Now come on, this was an old V6 thing that we were suppose to do, and we're still not!! Dick Goulet Reply Separator Author: Ray Stell [EMAIL PROTECTED] Date: 7/18/2001 5:15 AM On Wed, Jul 18, 2001 at 03:45:57AM -0800, Jon Walthour wrote: Listers: My client has asked me to look into this issue and determine if they should be concerned about it or not. Since they don't have any db's directly accessible from the Internet and since their LAN is very secure anyway, I'm inclined to not apply any patches based on the premise that if it isn't a necessary patch, don't apply it in fear of breaking something else. What do you think? -- two words, disgruntled employee === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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: 9i RAC's
I thought RAC was a major improvement of OPS, but it was still OPS by another name. I don't believe you gang together machines of any ilk to make a cluster, but you need to use architectures expressedly designed to be loosely-coupled. CERN, the physics lab in Geneva, is presently considering Oracle to store event data from the Large Hadronic Collider. The last I heard, which was a few years ago, the requirement was to have a petabyte of data available through online and nearline storage. RAC's are one of the reasons Oracle is being considered. One way to do this would be to build one huge cluster, but that would wed you to a single vendor. One could make several clusters, but then how does one determine which cluster the data is on. There is also some doubt whether 64,000 partitions will be enough, though I haven't heard how the data is to be partitioned. There is much skepticism, a healthy majority, about Oracle's ability to handle such a system. I'm in the skeptic camp as well. I have no influence nor input on Cern's decision. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Tuesday, July 17, 2001 9:35 AM To: Multiple recipients of list ORACLE-L I'm a little late to respond, but... RAC is most certainly a significant upgrade to and renaming of OPS. There is absolutely no doubt about it. At Oracle Open World 2000, all the Oracle OPS people doing presentations found out about the name change only a few weeks before the conference and scrambled madly to change all occurrences of Oracle Parallel Server to Real Application Clusters in their 9i (nee 8.2) presentations. The handouts still said OPS (and sometimes 8.2 ), but the otherwise identical overheads (usually) said RAC and 9i. The marketing denial of this is simply because OPS got such a bad reputation - which was, in my opinion, largely undeserved. The people who actually write the code for OPS/RAC suffer no such delusions. Granted OPS/RAC is/was more complex, but the bad rep was mostly due to people trying to use OPS inappropriately - for poorly-suited applications and systems (i.e. the majority). RAC is somewhat simpler to set up and administer than OPS and performs much better, but it is still OPS with a new name. While Oracle finally admitted that OPS was a specialty product, they seem now to be saying that RAC is for anything. I wouldn't swallow all of that particular Kool-Aid just yet! -Don Granaman [certifiable Orasaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 13, 2001 2:20 PM No it is not the upgrade of OPS as I understand. They even put OPS down themselves saying that it was sparsely used, and far to complicated to set up. What RAC does, is essentially link every machine together in to a cluster, then each physical machine can touch the same database concurrently (probably on a central storage unit). There is no actual standby when this is in use, as all machines connected to the cluster work together - but if one of the machines has a hardware failure, the load is simply spread between the remaining machines.. It looks *really* cool stuff, and by *Oracles* stats, beats any other clustered databases in real world situations. If only I could blag the boss for a ?1,000,000 budget for a bunch of compaq servers :-) Mark -Original Message- Greenfield Sent: Friday, July 13, 2001 03:51 To: Multiple recipients of list ORACLE-L Mark, isn't RAC just the upgrade for OPS? Then that would make it a 'standby' for the instance, but not a standby for the database, no? Am I misunderstanding something? y Mark Leith wrote: I attended the Oracle 9i opening yesterday at Oracle HQ in the UK, and one of the main points they discussed about 9i, was the use of Real Application Clusters (RAC). Of course you have to be running on Compaq hardware at the moment, but it takes the need for a standby away, as you essentially just plug the standby in to the cluster, and make use of it's computing power, instead of having the standby just stood waiting for a failure.. Just a thought.. Mark -Original Message- Turner Sent: Thursday, July 12, 2001 08:26 To: Multiple recipients of list ORACLE-L Anyone know if the standby in 9i can be in readonly mode while the logs are being applied? I've heard about this as being the case and also that this isn't the case. Thanks, Dave Turner -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
long to clob scripts?
Title: OFF-TOPIC : remsh from a WIN workstation to a UNIX We are finally getting around to replacing all our long data types with clobs and blobs - anybody already have a script that does this?
SQL*Net Connection limits
hi gurus, Does SQL*net has a limit on concurrent simulataneous access/connection to the the database. I simulated 600 web user accesing the oracle DB thru a PHP script which connects to the data base,fetches the data, and disconnects. From the listener.log, connections is about 7/8 conncetions/sec. How can I increase the connections#/sec. I noticed that a client program takes longer to connect when the test is being run. A vmstat shows that CPU utilization : users % = 50%,sys 27#,idle 23%. The platform is Compaq Digital AS 400 with 2 CPUs,512 MB Memory, Digital Unix ver4.0d, 8.1.5 RDBMS. Any pointers Thanks --azhar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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[2]: Re[2]: security problem with 8i
I wish I was. Reply Separator Author: =?iso-8859-1?q?paquette=20stephane?= [EMAIL PROTECTED] Date: 7/18/2001 7:25 AM Are you joking ? --- [EMAIL PROTECTED] a écrit : Although there has been so much publicity of security holes in Oracle, in particular the listener, the one hole that really causes me concern is the default passwords for sys and system and/or using the username as a password. Over the past 2 years I've been to a few sites, like 4, at a friends request and/or on an interview where the manager said show me and each time I've been able to log onto the DB with any of the following: sys/change_on_install sys/sys system/system system/manager Now come on, this was an old V6 thing that we were suppose to do, and we're still not!! Dick Goulet Reply Separator Author: Ray Stell [EMAIL PROTECTED] Date: 7/18/2001 5:15 AM On Wed, Jul 18, 2001 at 03:45:57AM -0800, Jon Walthour wrote: Listers: My client has asked me to look into this issue and determine if they should be concerned about it or not. Since they don't have any db's directly accessible from the Internet and since their LAN is very secure anyway, I'm inclined to not apply any patches based on the premise that if it isn't a necessary patch, don't apply it in fear of breaking something else. What do you think? -- two words, disgruntled employee === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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: 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Vos albums photos en ligne, Yahoo! Photos : http://fr.photos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= 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: 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: Re[2]: security problem with 8i
I would doubt he's joking. I've had simular experiences transferred to another department within the same company. Get a call from my old boss our dba is out sick, we HAVE to have this done today, this is a highly secured system you have to help and make the changes from this pc I go there, cannot log into the database with the username and password he gives me. We call the dba (who was really sick), apologize and ask for the username and password -- same as what I had. Still does not work. I stop, think and say let me try something and log in as system/manager I do what they ask me to, then take my old boss aside and explain (gently) that he has a security hole in his highly secured system that I could drive a truck through. From: paquette stephane [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Re[2]: security problem with 8i Date: Wed, 18 Jul 2001 07:25:48 -0800 Are you joking ? --- [EMAIL PROTECTED] a écrit : Although there has been so much publicity of security holes in Oracle, in particular the listener, the one hole that really causes me concern is the default passwords for sys and system and/or using the username as a password. Over the past 2 years I've been to a few sites, like 4, at a friends request and/or on an interview where the manager said show me and each time I've been able to log onto the DB with any of the following: sys/change_on_install sys/sys system/system system/manager Now come on, this was an old V6 thing that we were suppose to do, and we're still not!! Dick Goulet Reply Separator Author: Ray Stell [EMAIL PROTECTED] Date: 7/18/2001 5:15 AM On Wed, Jul 18, 2001 at 03:45:57AM -0800, Jon Walthour wrote: Listers: My client has asked me to look into this issue and determine if they should be concerned about it or not. Since they don't have any db's directly accessible from the Internet and since their LAN is very secure anyway, I'm inclined to not apply any patches based on the premise that if it isn't a necessary patch, don't apply it in fear of breaking something else. What do you think? -- two words, disgruntled employee === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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: 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Vos albums photos en ligne, Yahoo! Photos : http://fr.photos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel
RE: resize in 7.3.4 urgent
DBA Handbook is by Kevin Loney. as is Oracle8 DBA Handbook and Oracle8i DBA
Handbook (this last with Marlene Theriault as co-author). and the
to-be-published (no, I don't have a date, they have just started working on
it!) Oracle9i DBA Handbook
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: resize in 7.3.4 urgent
Date: Wed, 18 Jul 2001 07:01:36 -0800
If you want to see a more visual representation of what's in a tablespace
(including free space) use the mapper.sql from the old DBA Handbook (don't
have it right here in front of me so I don't know the author's name). This
is for Oracle 7.3.4.
--
rem
rem file: mapper.sql
rem parameters: the tablespace name being mapped
rem
rem Sample invocation:
rem @mapper SYSTEM
rem
rem This script generates a mapping of the space usage
rem (free space vs used) in a tablespace. It graphically
rem shows segment and free space fragmentation.
rem
set pagesize 66 linesize 132 verify off
ttitle 'Map of Tablespace ' 1 right datevar skip 1
column substr(file_id,1,4) heading File|Id
column bytes format 999,999,999,999
column today noprint new_value datevar
SELECT
to_char(sysdate, 'MM/DD/YY') today,
'free space' owner, /*owner of free space*/
' ' object, /*blank object name*/
substr(file_id,1,4), /*file ID for the extent header*/
block_id, /*block ID for the extent header*/
blocks, /*lengthof the extent in blocks*/
bytes /*length of the extent in bytes*/
FROM sys.dba_free_space
WHERE tablespace_name = upper('1')
UNION
SELECT
to_char(sysdate, 'MM/DD/YY') today,
substr(owner,1,10), /*owner name (first 20 chars)*/
substr(segment_name,1,27), /*segment name (first 26 chars)*/
substr(file_id,1,4), /*file ID for extent header*/
block_id, /*block ID for block header*/
blocks, /*length of the extent in blocks*/
bytes /*length of the extent in bytes*/
FROM sys.dba_extents
WHERE tablespace_name = upper('1')
ORDER BY 4,5
/
undefine 1
--
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
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).
_
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
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).
I still can't install Oracle on Linux - help
Hi, I have the following environment: Suse 7.1, Oracle 8.1.6, 256 Mb Ram, KDE, Java runtime (I hope I installed it correctly). When I run the Installer from Kde, it makes nothing, but if I run from terminal window I get a very long list ended by an OK. I'm going to paste below the whole message, I hope somebody will help : oracle@linux:~ cd /cdrecorder oracle@linux:/cdrecorder ./runInstaller oracle@linux:/cdrecorder Initializing Java Virtual Machine from ../stage/Components/oracle.swd.jre/1.1.8/1/DataFiles/Expanded/linux/bin/jre. Please wait... SIGSEGV received at bfffd994 in /cdrecorder/stage/Components/oracle.swd.jre/1.1.8/1/DataFiles/Expanded/linux/lib/linux/native_threads/libjava.so. Processing terminated Wed Jul 18 17:06:53 2001 jre full version JDK 1.1.8 IBM build l118-2429 (JIT enabled: jitc) Operating Environment - Host : linux. OS Level : 2.2.18.#1 Mon Feb 5 17:56:44 GMT 2001 glibc Version : 2.2 No. of Procs : 1 Memory Info: total: used: free: shared: buffers: cached: Mem: 268017664 239714304 28303360 0 126836736 39231488 Swap: 115109888 0 115109888 MemTotal: 261736 kB MemFree: 27640 kB MemShared: 0 kB Buffers: 123864 kB Cached: 38312 kB BigTotal: 0 kB BigFree: 0 kB SwapTotal: 112412 kB SwapFree: 112412 kB User Limits (in bytes except for NOFILE and NPROC) - RLIMIT_FSIZE : infinity RLIMIT_DATA : infinity RLIMIT_STACK : 2093056 RLIMIT_CORE : 0 RLIMIT_NOFILE : 1024 RLIMIT_NPROC : 1024 Application Environment --- Signal Handlers - SIGQUIT : ignored SIGILL : sysThreadIDump (libjava.so) SIGABRT : sysThreadIDump (libjava.so) SIGFPE : sysThreadIDump (libjava.so) SIGBUS : sysThreadIDump (libjava.so) SIGSEGV : sysThreadIDump (libjava.so) SIGPIPE : ignored SIGUSR1 : doSuspendLoop (libjava.so) Environment Variables - PWD=/cdrecorder/install LTDL_LIBRARY_PATH=/home/oracle/.kde2/lib:/opt/kde2/lib konq_sm_file=/opt/kde2/share/config/SuSE/config/konqueror:1054d0ebe29756685240014220002 PAGER=less GLX_NO_DIRECT=t HOSTNAME=linux LD_LIBRARY_PATH=/cdrecorder/stage/Components/oracle.swd.jre/1.1.8/1/DataFiles/Expanded/linux/lib/linux/native_threads:/lib:/usr/lib:/opt/kde/lib:/home/oracle/.kde2/lib:/opt/kde2/lib LS_OPTIONS=-N --color=tty -T 0 ignoreeof=0 KDEDIRS=/etc/opt/kde2:/opt/kde2 KDEHOME=/home/oracle/.kde2 POVRAYOPT=-l/usr/lib/povray/include SUSE_DOC_HOST=localhost QTDIR=/usr/lib/qt OPENWINHOME=/usr/openwin D=32 CLASSPATH=/tmp/OraInstall0:../stage/Components/oracle.swd.oui/1.7.0.18.0A/1/DataFiles/Expanded/lib/OraInstaller.jar:../stage/Components/oracle.swd.oui/1.7.0.18.0A/1/DataFiles/Expanded/lib/InstImages.jar:../stage/Components/oracle.swd.oui/1.7.0.18.0A/1/DataFiles/Expanded/lib/InstHelp.jar:../stage/Components/oracle.swd.oui/1.7.0.18.0A/1/DataFiles/Expanded/lib/oracleice.jar:../stage/Components/oracle.swd.oui/1.7.0.18.0A/1/DataFiles/Expanded/lib/help.jar:../stage/Components/oracle.swd.oui/1.7.0.18.0A/1/DataFiles/Expanded/lib/ewt.jar:../stage/Components/oracle.swd.oui/1.7.0.18.0A/1/DataFiles/Expanded/lib/xmlparser.jar:../stage/Components/oracle.swd.oui/1.7.0.18.0A/1/DataFiles/Expanded/lib/swingaccess.jar:/cdrecorder/stage/Components/oracle.swd.jre/1.1.8/1/DataFiles/Expanded/linux/lib/rt.jar:/cdrecorder/stage/Components/oracle.swd.jre/1.1.8/1/DataFiles/Expanded/linux/lib/i18n.jar:/cdrecorder/stage/Components/oracle.swd.jre/1.1.8/1/DataFiles/Expanded/linux/lib/math.jar:/cdrecorder/stage/Components/oracle.swd.jre/1.1.8/1/DataFiles/Expanded/linux/lib/classes.zip LESSKEY=/etc/lesskey.bin LESSOPEN=|lesspipe.sh %s MANPATH=/usr/local/man:/usr/share/man:/usr/man:/usr/X11R6/man:/usr/openwin/man LANGUAGE=hungarian NNTPSERVER=news KDEDIR=/opt/kde LESS=-M -S -I USER=oracle LS_COLORS= HISTCONTROL=ignoredups XSESSION_IS_UP=yes THREADS_TYPE=native_threads MACHTYPE=i386-suse-linux XKEYSYMDB=/usr/X11R6/lib/X11/XKeysymDB THREADS_FLAG=native LANG=hu_HU GNOMEDIR=/opt/gnome JAVA_HOME=/cdrecorder/stage/Components/oracle.swd.jre/1.1.8/1/DataFiles/Expanded/linux COLORTERM=1 X=1024 INFOPATH=/usr/local/info:/usr/share/info:/usr/info Y=768 DISPLAY=:0 LOGNAME=oracle SHLVL=3 TEXINPUTS=~/.TeX:/usr/share/doc/.TeX:/usr/doc/.TeX:~/.TeX:/usr/share/doc/.TeX:/usr/doc/.TeX:~/.TeX:/usr/share/doc/.TeX:/usr/doc/.TeX:~/.TeX:/usr/share/doc/.TeX:/usr/doc/.TeX MINICOM=-c on INFODIR=/usr/local/info:/usr/share/info:/usr/info SESSION_MANAGER=local/linux:/tmp/.ICE-unix/667 KDE_INITIAL_DESKTOP=1 SHELL=/bin/bash PRINTER=lp HOSTTYPE=i386 QT_XFT=Y OSTYPE=linux WINDOWMANAGER=/usr/X11R6/bin/kde HOME=/home/oracle TERM=kvt XNLSPATH=/usr/X11R6/lib/X11/nls no_proxy=localhost PATH=/bin:/usr/bin:/usr/local/bin:/usr/bin:/usr/X11R6/bin:/bin:/home/zsolti/kylix/bin:/home/zsolti/kylix/lib:/usr/lib/java/bin:/usr/games/bin:/usr/games:/opt/gnome/bin:/opt/kde2/bin:/opt/kde/bin:. LESSCHARSET=latin1 FROM_HEADER=YAST_ASK LC_COLLATE=POSIX
RE: OT RE: Re[2]: security problem with 8i
JS, I think DG did this and mail got crossed. HTH, RM -Original Message- Sent: Wednesday, July 18, 2001 11:51 AM To: Multiple recipients of list ORACLE-L Ross, You can get into all of my databases that way, including the enterprise SAP database. Wonderful huh? Changing passwords around is on my todo list, but it's often not as simple as just changing it. There may be other ramifications, like it's a FailSafe database for instance. Or a 3rd party duhveloper installed the software and set everyone up to run as SYSTEM. Brilliant. Jared On Wednesday 18 July 2001 08:20, Mohan, Ross wrote: Although there has been so much publicity of security holes in Oracle, in particular the listener, the one hole that really causes me concern is the default passwords for sys and system and/or using the username as a password. Over the past 2 years I've been to a few sites, like 4, at a friends request and/or on an interview where the manager said show me and each time I've been able to log onto the DB with any of the following: sys/change_on_install sys/sys system/system system/manager Now come on, this was an old V6 thing that we were suppose to do, and we're still not!! Dick Goulet Reply Separator Author: Ray Stell [EMAIL PROTECTED] Date: 7/18/2001 5:15 AM On Wed, Jul 18, 2001 at 03:45:57AM -0800, Jon Walthour wrote: Listers: My client has asked me to look into this issue and determine if they should be concerned about it or not. Since they don't have any db's directly accessible from the Internet and since their LAN is very secure anyway, I'm inclined to not apply any patches based on the premise that if it isn't a necessary patch, don't apply it in fear of breaking something else. What do you think? -- two words, disgruntled employee === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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: Mohan, Ross 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: 9i RAC's
Early publicity for RACs specifically said that it was an OPS upgrade and made great play of cache fusion which was already available in 8.1.7. I agree with the previous point that OPS was often thrown at applications that were badly suited and so customers perceived it as a poor technology. RAC seeks to improve over OPS by giving it the capability to scale any application, whether or not it's specifically designed to run in a parallel environment. Whether they've succeeded yet is still to be discovered. Regards, Mike Hately -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: security problem with 8i
Ah, War stories... Reminds me (somewhat) of a company that I consulted, that had been suddently abandoned by its DBA in November, 1999 - anyone remember the Y2K panic?? They couldn't explan the CPU slowdown and lack of IO throughput. So I went on site, and their DBA with 5 years of experience had exactly 3 tablespaces in the system: TEMP, RBS, and SYSTEM. System was 2GB and was composed of about 25 datafiles. Anyone care to guess where all of the db objects lived??? It was a production system, BTW. It's nice to feel like a miracle-worker sometimes. : ) Brian Rachel Carmichael wrote: I would doubt he's joking. I've had simular experiences transferred to another department within the same company. Get a call from my old boss our dba is out sick, we HAVE to have this done today, this is a highly secured system you have to help and make the changes from this pc I go there, cannot log into the database with the username and password he gives me. We call the dba (who was really sick), apologize and ask for the username and password -- same as what I had. Still does not work. I stop, think and say let me try something and log in as system/manager I do what they ask me to, then take my old boss aside and explain (gently) that he has a security hole in his highly secured system that I could drive a truck through. From: paquette stephane [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Re[2]: security problem with 8i Date: Wed, 18 Jul 2001 07:25:48 -0800 Are you joking ? --- [EMAIL PROTECTED] a écrit : Although there has been so much publicity of security holes in Oracle, in particular the listener, the one hole that really causes me concern is the default passwords for sys and system and/or using the username as a password. Over the past 2 years I've been to a few sites, like 4, at a friends request and/or on an interview where the manager said show me and each time I've been able to log onto the DB with any of the following: sys/change_on_install sys/sys system/system system/manager Now come on, this was an old V6 thing that we were suppose to do, and we're still not!! Dick Goulet Reply Separator Author: Ray Stell [EMAIL PROTECTED] Date: 7/18/2001 5:15 AM On Wed, Jul 18, 2001 at 03:45:57AM -0800, Jon Walthour wrote: Listers: My client has asked me to look into this issue and determine if they should be concerned about it or not. Since they don't have any db's directly accessible from the Internet and since their LAN is very secure anyway, I'm inclined to not apply any patches based on the premise that if it isn't a necessary patch, don't apply it in fear of breaking something else. What do you think? -- two words, disgruntled employee === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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: 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Vos albums photos en ligne, Yahoo! Photos : http://fr.photos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services
Re: security problem with 8i
Rachel Carmichael wrote: and log in as system/manager I do what they ask me to, then take my old boss aside and explain (gently) that he has a security hole in his highly secured system that I could drive a truck through. you, my dear goddess, are way to kind.;-) -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ If a program is useful, it must be changed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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: Re[2]: security problem with 8i
This is the way my current employers shop was. After I started here as a SQL Server DBA I was told they want me to become the Oracle DBA for a new third party app they were getting. They already had two other apps using Oracle. These other apps were up and running for a couple of years. Within the first couple of months of learning Oracle I was able to access the other Oracle databases with the standard SYS and SYSTEM logins. These were systems that at the time, I did not have access to. Well the next day, I told damagement and now I have three Oracle systems. :) Dave -Original Message- Sent: Wednesday, July 18, 2001 11:13 AM To: Multiple recipients of list ORACLE-L I would doubt he's joking. I've had simular experiences transferred to another department within the same company. Get a call from my old boss our dba is out sick, we HAVE to have this done today, this is a highly secured system you have to help and make the changes from this pc I go there, cannot log into the database with the username and password he gives me. We call the dba (who was really sick), apologize and ask for the username and password -- same as what I had. Still does not work. I stop, think and say let me try something and log in as system/manager I do what they ask me to, then take my old boss aside and explain (gently) that he has a security hole in his highly secured system that I could drive a truck through. From: paquette stephane [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Re[2]: security problem with 8i Date: Wed, 18 Jul 2001 07:25:48 -0800 Are you joking ? --- [EMAIL PROTECTED] a écrit : Although there has been so much publicity of security holes in Oracle, in particular the listener, the one hole that really causes me concern is the default passwords for sys and system and/or using the username as a password. Over the past 2 years I've been to a few sites, like 4, at a friends request and/or on an interview where the manager said show me and each time I've been able to log onto the DB with any of the following: sys/change_on_install sys/sys system/system system/manager Now come on, this was an old V6 thing that we were suppose to do, and we're still not!! Dick Goulet Reply Separator Author: Ray Stell [EMAIL PROTECTED] Date: 7/18/2001 5:15 AM On Wed, Jul 18, 2001 at 03:45:57AM -0800, Jon Walthour wrote: Listers: My client has asked me to look into this issue and determine if they should be concerned about it or not. Since they don't have any db's directly accessible from the Internet and since their LAN is very secure anyway, I'm inclined to not apply any patches based on the premise that if it isn't a necessary patch, don't apply it in fear of breaking something else. What do you think? -- two words, disgruntled employee === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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: 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Vos albums photos en ligne, Yahoo! Photos : http://fr.photos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)
SORT_SEGMENT_REQUEST Timeouts 100%
I logged a tar last night and have not gotten much help, here is the problem: AIX 4.3 Oracle 8.1.7 * Any operation requiring use of a temp segment takes forever to complete. Also attempting to drop TEMP tablespace is taking forever to complete. V$LOCK shows very long times on a TT and IS lock. The tablespace being dropped is only 500 MB and offline. V$SESSION_EVENT shows a constant enqueue wait. V$SYSTEM_EVENT has shown in past 100% timeouts on sort_segment_request event. This looks very much like bug# 1131535 but it says that it is fixed in 8.1.7? * Furthur analysis showed that the sort segment never got used then all of a sudden last night it started working and I have not been able to figure out why. I dropped the TEMP tablespace (eventually) and recreated a new LMT temporary tablespace and the trouble still occurred. Not occuring now so having problems diagnosing it. I did an event 10046 level 8 and the trace file was pretty useless to me, I could not make heads or tails of it. It showed a call to DBMS_APPLICATION_INFO which I assume is normal and it did not show the SQL I was running. Would this imply perhaps a problem with lib cache latch since it wasn't even in the trace file...? Any thoughts would be greatly appreciated. Thanks, Ethan -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan 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: Re[2]: security problem with 8i
Oh yeah! I've got one even better! When I joined a previous company, their *Web-accessible* application's administration username/password was admin/admin! Their production Oracle DB - accessed via the admin/admin protected app - had system/manager and mps/mps (mps stands for Main Production Schema), plus all the usual default schemas like ctxsys/ctxsys... Needless to say, I closed those holes pretty quickly! Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Carmichael Sent: Wednesday, July 18, 2001 11:13 AM To: Multiple recipients of list ORACLE-L I would doubt he's joking. I've had simular experiences transferred to another department within the same company. Get a call from my old boss our dba is out sick, we HAVE to have this done today, this is a highly secured system you have to help and make the changes from this pc I go there, cannot log into the database with the username and password he gives me. We call the dba (who was really sick), apologize and ask for the username and password -- same as what I had. Still does not work. I stop, think and say let me try something and log in as system/manager I do what they ask me to, then take my old boss aside and explain (gently) that he has a security hole in his highly secured system that I could drive a truck through. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite 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).
Snapshot shows as INVALID in DBA_OBJECTs
Hi All, The subject says it all, 8.1.7 on Solaris 2.8 The snapshot is accessable and correct. Anyone know a (supported) way to clean up the data dictionary? TIA Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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[2]: security problem with 8i
Brian, Humm, let me guess, SYSTEM right??? Some old concepts die so hard. Oracle 5 and earlier did not understand the idea of tablespaces, but had partitions with the system partition being the original and prime one. Now one could create other partitions, but that was 'risky' at best whereas Oracle provided a canned way to add a datafile to the system partition!!! Dick Goulet Reply Separator Author: Brian McGraw [EMAIL PROTECTED] Date: 7/18/2001 8:56 AM Ah, War stories... Reminds me (somewhat) of a company that I consulted, that had been suddently abandoned by its DBA in November, 1999 - anyone remember the Y2K panic?? They couldn't explan the CPU slowdown and lack of IO throughput. So I went on site, and their DBA with 5 years of experience had exactly 3 tablespaces in the system: TEMP, RBS, and SYSTEM. System was 2GB and was composed of about 25 datafiles. Anyone care to guess where all of the db objects lived??? It was a production system, BTW. It's nice to feel like a miracle-worker sometimes. : ) Brian Rachel Carmichael wrote: I would doubt he's joking. I've had simular experiences transferred to another department within the same company. Get a call from my old boss our dba is out sick, we HAVE to have this done today, this is a highly secured system you have to help and make the changes from this pc I go there, cannot log into the database with the username and password he gives me. We call the dba (who was really sick), apologize and ask for the username and password -- same as what I had. Still does not work. I stop, think and say let me try something and log in as system/manager I do what they ask me to, then take my old boss aside and explain (gently) that he has a security hole in his highly secured system that I could drive a truck through. From: paquette stephane [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Re[2]: security problem with 8i Date: Wed, 18 Jul 2001 07:25:48 -0800 Are you joking ? --- [EMAIL PROTECTED] a écrit : Although there has been so much publicity of security holes in Oracle, in particular the listener, the one hole that really causes me concern is the default passwords for sys and system and/or using the username as a password. Over the past 2 years I've been to a few sites, like 4, at a friends request and/or on an interview where the manager said show me and each time I've been able to log onto the DB with any of the following: sys/change_on_install sys/sys system/system system/manager Now come on, this was an old V6 thing that we were suppose to do, and we're still not!! Dick Goulet Reply Separator Author: Ray Stell [EMAIL PROTECTED] Date: 7/18/2001 5:15 AM On Wed, Jul 18, 2001 at 03:45:57AM -0800, Jon Walthour wrote: Listers: My client has asked me to look into this issue and determine if they should be concerned about it or not. Since they don't have any db's directly accessible from the Internet and since their LAN is very secure anyway, I'm inclined to not apply any patches based on the premise that if it isn't a necessary patch, don't apply it in fear of breaking something else. What do you think? -- two words, disgruntled employee === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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: 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
Procedure Builder - Seeing variables
Hi all, Does anyone know what can I do for to see the variables in Procedure Builder. I know to start the procedure and i don´t get to see the variables in debbug option. Where must I click for it ? Regards Eriovaldo [EMAIL PROTECTED] Brazil _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eca Eca 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: security problem with 8i
Farnsworth, Dave wrote: This is the way my current employers shop was. After I started here as a SQL Server DBA I was told they want me to become the Oracle DBA for a new third party app they were getting. They already had two other apps using Oracle. These other apps were up and running for a couple of years. Within the first couple of months of learning Oracle I was able to access the other Oracle databases with the standard SYS and SYSTEM logins. These were systems that at the time, I did not have access to. Well the next day, I told damagement and now I have three Oracle systems. :) Dave some days it doesn't pay to open your mouth.;-) -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ If a program is useful, it must be changed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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: security problem with 8i
nah, I LIKED this boss :) From: Thater, William [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: security problem with 8i Date: Wed, 18 Jul 2001 09:02:52 -0800 Rachel Carmichael wrote: and log in as system/manager I do what they ask me to, then take my old boss aside and explain (gently) that he has a security hole in his highly secured system that I could drive a truck through. you, my dear goddess, are way to kind.;-) -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ If a program is useful, it must be changed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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).
connecting to sqlplus within a shell script
I use a lot of shell scripts (korn mainly) which use connections to sqlplus and always seem to get this error message when the script logs into sqlplus: stty: standard input: Inappropriate ioctl for device Here is my connection procedure within the script: sqlplus -s sitemon/sitemon END To my knowledge it does not appear to cause any problems with my shell script or output but would really like to know why I am getting it and if there is any recommendations for fixing the problem. OS: Red Hat Linux 6.2 ORACLE: 8.1.7 standard edition shell: korn Any help would be appreciated thanks Reed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kempf, Reed 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: Re[2]: security problem with 8i
Not at all. Just last week I had a vendor who came in to install a package. They were very upset because SYS didn't have the standard password and their install script wouldn't work. I questioned their use of the SYS schema for the installation but powers wiser than me had me change the SYS password to the standard value and leave the room. Hey, it's a job. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
OT: Certifications
Well I have to say the IBM WebSphere Cert and Sun Java Programmer Cert are infinitely easier than the Oracle OCP. I have received them both in the mail recently and never taken any of the tests! This is strange, I think someone has stolen my identity and is doing a better job at living my life than me! - Ethan -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan 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: resize in 7.3.4 urgent
Yep. That's the one. First book on my Oracle bookshelf.
Rachel
Carmichael To: Multiple recipients of list ORACLE-L
carmichr@hot[EMAIL PROTECTED]
mail.comcc:
Sent by: Subject: RE: resize in 7.3.4 urgent
root@fatcity.
com
07/18/2001
12:17 PM
Please
respond to
ORACLE-L
DBA Handbook is by Kevin Loney. as is Oracle8 DBA Handbook and Oracle8i DBA
Handbook (this last with Marlene Theriault as co-author). and the
to-be-published (no, I don't have a date, they have just started working on
it!) Oracle9i DBA Handbook
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: resize in 7.3.4 urgent
Date: Wed, 18 Jul 2001 07:01:36 -0800
If you want to see a more visual representation of what's in a tablespace
(including free space) use the mapper.sql from the old DBA Handbook (don't
have it right here in front of me so I don't know the author's name).
This
is for Oracle 7.3.4.
--
rem
rem file: mapper.sql
rem parameters: the tablespace name being mapped
rem
rem Sample invocation:
rem @mapper SYSTEM
rem
rem This script generates a mapping of the space usage
rem (free space vs used) in a tablespace. It graphically
rem shows segment and free space fragmentation.
rem
set pagesize 66 linesize 132 verify off
ttitle 'Map of Tablespace ' 1 right datevar skip 1
column substr(file_id,1,4) heading File|Id
column bytes format 999,999,999,999
column today noprint new_value datevar
SELECT
to_char(sysdate, 'MM/DD/YY') today,
'free space' owner, /*owner of free space*/
' ' object, /*blank object name*/
substr(file_id,1,4), /*file ID for the extent header*/
block_id, /*block ID for the extent header*/
blocks, /*lengthof the extent in blocks*/
bytes /*length of the extent in bytes*/
FROM sys.dba_free_space
WHERE tablespace_name = upper('1')
UNION
SELECT
to_char(sysdate, 'MM/DD/YY') today,
substr(owner,1,10), /*owner name (first 20 chars)*/
substr(segment_name,1,27), /*segment name (first 26 chars)*/
substr(file_id,1,4), /*file ID for extent header*/
block_id, /*block ID for block header*/
blocks, /*length of the extent in blocks*/
bytes /*length of the extent in bytes*/
FROM sys.dba_extents
WHERE tablespace_name = upper('1')
ORDER BY 4,5
/
undefine 1
--
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
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).
_
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
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
Re: security problem with 8i
Rachel Carmichael wrote: nah, I LIKED this boss :) never had one of those.;-) -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ If a program is useful, it must be changed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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: New Listener Question
On Wed, 18 Jul 2001, Glenn Travis wrote: I disagree. Mine only registers itself if I have the service_names entry in the init.ora file. Comment this line out and see what happens... Actually, the parameter that controls instance registration with listeners for dedicated server is LOCAL_LISTENER. The default value for this parameter is (ADDRESS = (PROTOCOL=TCP)(HOST=)(PORT=1521)). That means that even if you don't set LOCAL_LISTENER, any instance will try to register with any listener running on port 1521 on the localhost. SERVICE_NAMES allows you to specify multiple differently named databases as a single 'service' for clients, but does not change which listeners the instance registers with. This information can be found in TFM, at the following URLs: http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76961/ch176.htm http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/network.817/a76933/concepts.htm#1036732 From the Net8 Administrator's Guide, Release 8.1.6: By default, PMON registers with the local listener on server at the default local address of TCP/IP, port 1521. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -Original Message- Smith In Oracle 8i a database will self register with the default listener even if you do not have it defined. There are parameters that you can put in your init.ora to prevent this. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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: connecting to sqlplus within a shell script
SQL*Plus is probably performing terminal specific ioctl settings; e.g., setting it in something other than line mode so it can update the screen more efficiently, etc. For scripting SQL, I'd recommend making a move to Perl/DBI. It rocks! Steve Sapovits Global Sports Interactive Work Email: [EMAIL PROTECTED] Home Email: [EMAIL PROTECTED] Work Phone: 610-491-7087 Cell: 610-574-7706 Pager: 877-239-4003 -Original Message- From: Kempf, Reed [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, July 18, 2001 1:41 PM To: Multiple recipients of list ORACLE-L Subject: connecting to sqlplus within a shell script I use a lot of shell scripts (korn mainly) which use connections to sqlplus and always seem to get this error message when the script logs into sqlplus: stty: standard input: Inappropriate ioctl for device Here is my connection procedure within the script: sqlplus -s sitemon/sitemon END To my knowledge it does not appear to cause any problems with my shell script or output but would really like to know why I am getting it and if there is any recommendations for fixing the problem. OS: Red Hat Linux 6.2 ORACLE: 8.1.7 standard edition shell: korn Any help would be appreciated thanks Reed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kempf, Reed 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: Steve Sapovits 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[2]: Re[2]: security problem with 8i
In my book, it was a job. Reply Separator Author: [EMAIL PROTECTED] Date: 7/18/2001 9:48 AM Not at all. Just last week I had a vendor who came in to install a package. They were very upset because SYS didn't have the standard password and their install script wouldn't work. I questioned their use of the SYS schema for the installation but powers wiser than me had me change the SYS password to the standard value and leave the room. Hey, it's a job. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: 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: Re[2]: security problem with 8i
My old job had never changed any of the default passwords. And the reason why standard passwords are kept is because it is 'easy to remember'. Go figure... -Original Message- Sent: Wednesday, July 18, 2001 1:48 PM To: Multiple recipients of list ORACLE-L Not at all. Just last week I had a vendor who came in to install a package. They were very upset because SYS didn't have the standard password and their install script wouldn't work. I questioned their use of the SYS schema for the installation but powers wiser than me had me change the SYS password to the standard value and leave the room. Hey, it's a job. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: 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: connecting to sqlplus within a shell script
Are you doing an su before running SQL plus? I have run into problems in my .profile script when su-ing before running SQLPlus in a script. In my case, I was trying to run STTY to change my erase key in the .profile. Just a thought. Erik -Original Message- From: Steve Sapovits [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, July 18, 2001 1:52 PM To: Multiple recipients of list ORACLE-L Subject: RE: connecting to sqlplus within a shell script SQL*Plus is probably performing terminal specific ioctl settings; e.g., setting it in something other than line mode so it can update the screen more efficiently, etc. For scripting SQL, I'd recommend making a move to Perl/DBI. It rocks! Steve Sapovits Global Sports Interactive Work Email: [EMAIL PROTECTED] Home Email: [EMAIL PROTECTED] Work Phone: 610-491-7087 Cell: 610-574-7706 Pager: 877-239-4003 -Original Message- From: Kempf, Reed [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, July 18, 2001 1:41 PM To: Multiple recipients of list ORACLE-L Subject:connecting to sqlplus within a shell script I use a lot of shell scripts (korn mainly) which use connections to sqlplus and always seem to get this error message when the script logs into sqlplus: stty: standard input: Inappropriate ioctl for device Here is my connection procedure within the script: sqlplus -s sitemon/sitemon END To my knowledge it does not appear to cause any problems with my shell script or output but would really like to know why I am getting it and if there is any recommendations for fixing the problem. OS: Red Hat Linux 6.2 ORACLE: 8.1.7 standard edition shell: korn Any help would be appreciated thanks Reed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kempf, Reed 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: Steve Sapovits 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: Erik Williams 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).
OEM help ???
Hi all, I installed OEM816 on NT40, database server is 815 on Sun 5.6. The OEM doesn't run since OMS NT service cannot be started for some reason. I tried to deinstalled OEM using installer, the deinstalling only runs for 2% and jumpped out. So I manually removed all the OEM files, and tried to install again. Now the installer told me that you cannot install this since it's already in oem home directory. and the Installed Products still shows all the OEM products, even though I already got rid off the whole oem home. Are there anything log in the registry or some other places that I should clean out? And does OEM816 works well with 815 database?? Thanks. Andrea __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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: RE: New Listener Question
Actually, it's called dynamic service registration and you need both the INSTANCE_NAME parameter and the SERVICE_NAMES parameter defined in the init.ora. Then, when the instance starts up, it will register the services it supports with the listener(s). Jon Walthour --- Original Message --- From: Glenn Travis [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 7/18/01 12:21:24 PM I disagree. Mine only registers itself if I have the service_names entry in the init.ora file. Comment this line out and see what happens... -Original Message- Smith Sent: Tuesday, July 17, 2001 1:31 PM To: Multiple recipients of list ORACLE-L In Oracle 8i a database will self register with the default listener even if you do not have it defined. There are parameters that you can put in your init.ora to prevent this. -Original Message- Sent: Tuesday, July 17, 2001 9:35 AM To: Multiple recipients of list ORACLE-L First Off, I would like to thank everyone who replied yesterday, your answers were most helpful! Today, I am facing a new puzzle. I am currently running 3 databases on a server, but only two of them are listed in the listener.ora (bdw and rcvr). If I do a 'lsnrctl status' it shows a listener for all three databases (bdw rcvr and webprod). How is this possible? I have included my current listener.ora and output from 'lsnrctl status' ... Also, people who access these databases go through VIRTUAL ip's, i.e. the box itself has IP address xxx.xxx.xxx.11 the bdw ip is xxx.xxx.xxx.31 and the webprod ip is xxx.xxx.xxx.30 The reason for the virt ip's is for the fail over we have in place, so people do not have to reconfigure their machines when we move the databases around. So by all rights I do not see how anyone can connect, but they are?!?!?!? WTH??? Thanks again guys ... # LISTENER.ORA Configuration File:/apps/oracle/product/816/network/admin/listener.ora # Generated by Oracle configuration tools. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = bdw1)(PORT = 1521)) ) ) (DESCRIPTION = (PROTOCOL_STACK = (PRESENTATION = GIOP) (SESSION = RAW) ) (ADDRESS = (PROTOCOL = TCP)(HOST = bdw1)(PORT = 2481)) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /apps/oracle/product/816) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = bdw) (ORACLE_HOME = /apps/oracle/product/816) (SID_NAME = bdw) ) (SID_DESC = (GLOBAL_DBNAME = rcvr) (ORACLE_HOME = /apps/oracle/product/816) (SID_NAME = rcvr) ) ) oracle@bdw1 SID: bdw /apps/oracle/product/816/network/admin lsnrctl status LSNRCTL for Solaris: Version 8.1.6.0.0 - Production on 17-JUL-2001 09:24:30 (c) Copyright 1998, 1999, Oracle Corporation. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC))) STATUS of the LISTENER Alias LISTENER Version TNSLSNR for Solaris: Version 8.1.6.0.0 - Production Start Date10-JUL-2001 15:14:01 Uptime6 days 18 hr. 10 min. 30 sec Trace Level off Security OFF SNMP OFF Listener Parameter File /apps/oracle/product/816/network/admin/listener.ora Listener Log File /apps/oracle/product/816/network/log/listener.log Services Summary... PLSExtProchas 1 service handler(s) WEBPROD has 2 service handler(s) bdw has 1 service handler(s) bdw has 1 service handler(s) rcvr has 1 service handler(s) The command completed successfully -- Edward W. Carr UNIX Systems Administrator Qwest Communications Broadband Services Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith 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: Glenn Travis 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
Re: Procedure Builder - Seeing variables
Eriovaldo, Check on the object navigator and expand the node with the 'Stack' and you should see your variables there. Also, from the menu you can select 'View''Navigator Pane' and this will show the object navigator in the center of the PL/SQL Interpreter. Regards, Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: New Listener Question
You are right, sir! I stand corrected. and thanks! -Original Message- Wilton Sent: Wednesday, July 18, 2001 1:48 PM To: Multiple recipients of list ORACLE-L On Wed, 18 Jul 2001, Glenn Travis wrote: I disagree. Mine only registers itself if I have the service_names entry in the init.ora file. Comment this line out and see what happens... Actually, the parameter that controls instance registration with listeners for dedicated server is LOCAL_LISTENER. The default value for this parameter is (ADDRESS = (PROTOCOL=TCP)(HOST=)(PORT=1521)). That means that even if you don't set LOCAL_LISTENER, any instance will try to register with any listener running on port 1521 on the localhost. SERVICE_NAMES allows you to specify multiple differently named databases as a single 'service' for clients, but does not change which listeners the instance registers with. This information can be found in TFM, at the following URLs: http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/ a76961/ch176.htm http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/network.817 /a76933/concepts.htm#1036732 From the Net8 Administrator's Guide, Release 8.1.6: By default, PMON registers with the local listener on server at the default local address of TCP/IP, port 1521. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -Original Message- Smith In Oracle 8i a database will self register with the default listener even if you do not have it defined. There are parameters that you can put in your init.ora to prevent this. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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: Glenn Travis 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: Certifications
Now that's disconcerting! Chuck Speaks Database Administrator Lithonia Lighting 770-861-3450 http://www.lithonia.com -Original Message- Sent: Wednesday, July 18, 2001 1:32 PM To: Multiple recipients of list ORACLE-L Well I have to say the IBM WebSphere Cert and Sun Java Programmer Cert are infinitely easier than the Oracle OCP. I have received them both in the mail recently and never taken any of the tests! This is strange, I think someone has stolen my identity and is doing a better job at living my life than me! - Ethan -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan 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: Speaks, Chuck W. 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: connecting to sqlplus within a shell script
If you code the stty command like the following - [ -t 1 ] stty erase It works both interactively via cron jobs. HTH YMMV! Erik Williams wrote: Are you doing an su before running SQL plus? I have run into problems in my .profile script when su-ing before running SQLPlus in a script. In my case, I was trying to run STTY to change my erase key in the .profile. Just a thought. Erik -Original Message- From: Steve Sapovits [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, July 18, 2001 1:52 PM To: Multiple recipients of list ORACLE-L Subject: RE: connecting to sqlplus within a shell script SQL*Plus is probably performing terminal specific ioctl settings; e.g., setting it in something other than line mode so it can update the screen more efficiently, etc. For scripting SQL, I'd recommend making a move to Perl/DBI. It rocks! Steve Sapovits Global Sports Interactive Work Email: [EMAIL PROTECTED] Home Email: [EMAIL PROTECTED] Work Phone: 610-491-7087 Cell: 610-574-7706 Pager: 877-239-4003 -Original Message- From: Kempf, Reed [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, July 18, 2001 1:41 PM To: Multiple recipients of list ORACLE-L Subject:connecting to sqlplus within a shell script I use a lot of shell scripts (korn mainly) which use connections to sqlplus and always seem to get this error message when the script logs into sqlplus: stty: standard input: Inappropriate ioctl for device Here is my connection procedure within the script: sqlplus -s sitemon/sitemon END To my knowledge it does not appear to cause any problems with my shell script or output but would really like to know why I am getting it and if there is any recommendations for fixing the problem. OS: Red Hat Linux 6.2 ORACLE: 8.1.7 standard edition shell: korn Any help would be appreciated thanks Reed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kempf, Reed 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: Steve Sapovits 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: Erik Williams 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: Charlie Mengler 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: connecting to sqlplus within a shell script
For scripting SQL, I'd recommend making a move to Perl/DBI. It rocks! Gather all ye faithful down by the river, and ye shall be baptized into the kingdom of Perl and DBI, and never more shall ye want or toil in vain! Jared ( part time perl evangelist :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: OEM help ???
Hi Andrea, Look for the oraInventory file. The installer reads this file for information on installed products. Find the file then delete the OEM entries. There are probably some registry entries that need to be removed so search the registry for references to OEM. HTH, -Rocky --- Andrea Oracle [EMAIL PROTECTED] wrote: Hi all, I installed OEM816 on NT40, database server is 815 on Sun 5.6. The OEM doesn't run since OMS NT service cannot be started for some reason. I tried to deinstalled OEM using installer, the deinstalling only runs for 2% and jumpped out. So I manually removed all the OEM files, and tried to install again. Now the installer told me that you cannot install this since it's already in oem home directory. and the Installed Products still shows all the OEM products, even though I already got rid off the whole oem home. Are there anything log in the registry or some other places that I should clean out? And does OEM816 works well with 815 database?? Thanks. Andrea __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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). __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rocky Welch 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: connecting to sqlplus within a shell script
[EMAIL PROTECTED] wrote: For scripting SQL, I'd recommend making a move to Perl/DBI. It rocks! Gather all ye faithful down by the river, and ye shall be baptized into the kingdom of Perl and DBI, and never more shall ye want or toil in vain! Jared ( part time perl evangelist :) can you preach to my SAs to install it and let me have access to it? they tell me perl is an SA tool and i don't need it.:-( -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ If a program is useful, it must be changed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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: RE: New Listener Question
instance_name has default value ORACLE_SID and service_name has default value db_name.db_domain - so you do not need to define these parameters for dynamic service registration. Alex Hillman -Original Message- Sent: Wednesday, July 18, 2001 2:25 PM To: Multiple recipients of list ORACLE-L Actually, it's called dynamic service registration and you need both the INSTANCE_NAME parameter and the SERVICE_NAMES parameter defined in the init.ora. Then, when the instance starts up, it will register the services it supports with the listener(s). Jon Walthour --- Original Message --- From: Glenn Travis [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 7/18/01 12:21:24 PM I disagree. Mine only registers itself if I have the service_names entry in the init.ora file. Comment this line out and see what happens... -Original Message- Smith Sent: Tuesday, July 17, 2001 1:31 PM To: Multiple recipients of list ORACLE-L In Oracle 8i a database will self register with the default listener even if you do not have it defined. There are parameters that you can put in your init.ora to prevent this. -Original Message- Sent: Tuesday, July 17, 2001 9:35 AM To: Multiple recipients of list ORACLE-L First Off, I would like to thank everyone who replied yesterday, your answers were most helpful! Today, I am facing a new puzzle. I am currently running 3 databases on a server, but only two of them are listed in the listener.ora (bdw and rcvr). If I do a 'lsnrctl status' it shows a listener for all three databases (bdw rcvr and webprod). How is this possible? I have included my current listener.ora and output from 'lsnrctl status' ... Also, people who access these databases go through VIRTUAL ip's, i.e. the box itself has IP address xxx.xxx.xxx.11 the bdw ip is xxx.xxx.xxx.31 and the webprod ip is xxx.xxx.xxx.30 The reason for the virt ip's is for the fail over we have in place, so people do not have to reconfigure their machines when we move the databases around. So by all rights I do not see how anyone can connect, but they are?!?!?!? WTH??? Thanks again guys ... # LISTENER.ORA Configuration File:/apps/oracle/product/816/network/admin/listener.ora # Generated by Oracle configuration tools. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = bdw1)(PORT = 1521)) ) ) (DESCRIPTION = (PROTOCOL_STACK = (PRESENTATION = GIOP) (SESSION = RAW) ) (ADDRESS = (PROTOCOL = TCP)(HOST = bdw1)(PORT = 2481)) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /apps/oracle/product/816) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = bdw) (ORACLE_HOME = /apps/oracle/product/816) (SID_NAME = bdw) ) (SID_DESC = (GLOBAL_DBNAME = rcvr) (ORACLE_HOME = /apps/oracle/product/816) (SID_NAME = rcvr) ) ) oracle@bdw1 SID: bdw /apps/oracle/product/816/network/admin lsnrctl status LSNRCTL for Solaris: Version 8.1.6.0.0 - Production on 17-JUL-2001 09:24:30 (c) Copyright 1998, 1999, Oracle Corporation. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC))) STATUS of the LISTENER Alias LISTENER Version TNSLSNR for Solaris: Version 8.1.6.0.0 - Production Start Date10-JUL-2001 15:14:01 Uptime6 days 18 hr. 10 min. 30 sec Trace Level off Security OFF SNMP OFF Listener Parameter File /apps/oracle/product/816/network/admin/listener.ora Listener Log File /apps/oracle/product/816/network/log/listener.log Services Summary... PLSExtProchas 1 service handler(s) WEBPROD has 2 service handler(s) bdw has 1 service handler(s) bdw has 1 service handler(s) rcvr has 1 service handler(s) The command completed successfully -- Edward W. Carr UNIX Systems Administrator Qwest Communications Broadband Services Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith 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:
Re: OT: Certifications
Post, Ethan wrote: Well I have to say the IBM WebSphere Cert and Sun Java Programmer Cert are infinitely easier than the Oracle OCP. I have received them both in the mail recently and never taken any of the tests! This is strange, I think someone has stolen my identity and is doing a better job at living my life than me! - Ethan Some are born gurus, some achieve certification, and some have certification thrust upon them :). -- Regards, Stephane Faroult Oriole Corporation Voice: +44 (0) 7050-696-269 Fax:+44 (0) 7050-696-449 Performance Tools Free Scripts -- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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).
* Oracle Financials DBA Needed in Houston..
Major Houston company needs a Sr. Level Oracle Financials DBA to join its' I.T. staff. Requirements: -Must have 3+ yrs Oracle Financials DBA experience. -Looking for someone who has at least 18 months Fin. Apps. installations experience -U.S. citizenship or permanent residency. This company offers: -Competitive Salary with full benefits -Company will pay relocation NO sub contracting positions available. PLEASE do not send your resume if you are not in the United States. For immediate consideration, please send your resume as an attachment to: OraStaff, Inc. Ph: 1-800-549-8502-Please do not call if you need sponsorship Email: [EMAIL PROTECTED] Please use job code: One/Fin DBA/Houston/Pottle/Sanders Note: This is only one of the many opportunities that we have available across the U.S. for candidates with Oracle skills who are U.S. citizens or permanent residents. So if this one is not a match for you, we invite you to send us your resume- as we quite possibly have the opportunity that you are seeking. We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for you. Thanks, Bill Law -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff 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).
OEM nmi.log file growing
We have shutdown one of our databases for extended maintenance. The nmi.log is growing about 1k per minute with the following messages. Short of removing the database from the listener, which I do not really want to do since the database will eventually be brought back up, how can I stop the messages. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
Re: connecting to sqlplus within a shell script
Everytime I have seen this message it was because there was a . $HOME/.profile to ensure that the environment was correct and because the script was run from a cron. By the way, there was stty erase ^H in .profile. . $HOME/.profile 2/dev/null fudged the problem. HTH, Stephane Faroult Oriole Corporation Voice: +44 (0) 7050-696-269 Fax:+44 (0) 7050-696-449 Performance Tools Free Scripts -- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -- Steve Sapovits wrote: SQL*Plus is probably performing terminal specific ioctl settings; e.g., setting it in something other than line mode so it can update the screen more efficiently, etc. For scripting SQL, I'd recommend making a move to Perl/DBI. It rocks! Steve Sapovits Global Sports Interactive Work Email: [EMAIL PROTECTED] Home Email: [EMAIL PROTECTED] Work Phone: 610-491-7087 Cell: 610-574-7706 Pager: 877-239-4003 -Original Message- From: Kempf, Reed [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, July 18, 2001 1:41 PM To: Multiple recipients of list ORACLE-L Subject: connecting to sqlplus within a shell script I use a lot of shell scripts (korn mainly) which use connections to sqlplus and always seem to get this error message when the script logs into sqlplus: stty: standard input: Inappropriate ioctl for device Here is my connection procedure within the script: sqlplus -s sitemon/sitemon END To my knowledge it does not appear to cause any problems with my shell script or output but would really like to know why I am getting it and if there is any recommendations for fixing the problem. OS: Red Hat Linux 6.2 ORACLE: 8.1.7 standard edition shell: korn Any help would be appreciated thanks Reed -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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: OEM help ???
Andrea Remove the oracle home from the registry regedit or reg32 HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE --- Andrea Oracle [EMAIL PROTECTED] wrote: Hi all, I installed OEM816 on NT40, database server is 815 on Sun 5.6. The OEM doesn't run since OMS NT service cannot be started for some reason. I tried to deinstalled OEM using installer, the deinstalling only runs for 2% and jumpped out. So I manually removed all the OEM files, and tried to install again. Now the installer told me that you cannot install this since it's already in oem home directory. and the Installed Products still shows all the OEM products, even though I already got rid off the whole oem home. Are there anything log in the registry or some other places that I should clean out? And does OEM816 works well with 815 database?? Thanks. Andrea __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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). __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: k johnson 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).
Another programming standard falls
Microsoft dropping Java code from Windows XP In the wake of a January legal settlement with Java owner Sun Microsystems, Microsoft plans to ship its Windows XP operating system without the code needed to run Java applications. http://computerworld.com/nlt/1%2C3590%2CNAV47_STO62358_NLTAM%2C00.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: connecting to sqlplus within a shell script
On Wed, Jul 18, 2001 at 10:37:48AM -0800, [EMAIL PROTECTED] wrote: For scripting SQL, I'd recommend making a move to Perl/DBI. It rocks! Gather all ye faithful down by the river, and ye shall be baptized into the kingdom of Perl and DBI, and never more shall ye want or toil in vain! Jared ( part time perl evangelist :) -- OraTcl is much better ;- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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: connecting to sqlplus within a shell script
You could add logic to .profile to execute stty only if the session is
attached to a terminal.
# set env based on terminal or non-terminal
if [ -t 0 ]
then
# if executing from terminal process
stty istrip
stty erase ^h kill ^u intr ^c
PATH=${PATH}:/${HOME}/tools/bin ; export PATH
. ${HOME}/bin/sid # set Oracle env
THISHOST=`uname -n` ; export THISHOST
PS1='${THISHOST}-${LOGNAME}:${ORACLE_SID}:${PWD} '
SQLPATH=${HOME}/tools/sql ; export SQLPATH
EDITOR=vi ; export EDITOR
PATH=${PATH}:${ORACLE_HOME}/bin:/usr/local/bin:/usr/local/ssh/bin ;
export PATH
else
# if executing from non-terminal process, eg., cron
ORACLE_HOME=/opt/app/oracle/product/8.1.7 ; export ORACLE_HOME
PATH=${PATH}:${ORACLE_HOME}/bin ; export PATH
fi
Erik Williams wrote:
Are you doing an su before running SQL plus? I have run into problems in my
.profile script when su-ing before running SQLPlus in a script. In my case,
I was trying to run STTY to change my erase key in the .profile. Just a
thought.
Erik
-Original Message-
From: Steve Sapovits [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, July 18, 2001 1:52 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: connecting to sqlplus within a shell script
SQL*Plus is probably performing terminal specific ioctl settings;
e.g., setting it in something other than line mode so it can update
the screen more efficiently, etc.
For scripting SQL, I'd recommend making a move to Perl/DBI. It rocks!
Steve Sapovits
Global Sports Interactive
Work Email: [EMAIL PROTECTED]
Home Email: [EMAIL PROTECTED]
Work Phone: 610-491-7087
Cell: 610-574-7706
Pager: 877-239-4003
-Original Message-
From: Kempf, Reed [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, July 18, 2001 1:41 PM
To: Multiple recipients of list ORACLE-L
Subject:connecting to sqlplus within a shell script
I use a lot of shell scripts (korn mainly) which use connections to
sqlplus
and always seem to get this error message when the script logs into
sqlplus:
stty: standard input: Inappropriate ioctl for device
Here is my connection procedure within the script: sqlplus -s
sitemon/sitemon END
To my knowledge it does not appear to cause any problems with my shell
script or output but would really like to know why I am getting it and
if
there is any recommendations for fixing the problem.
OS: Red Hat Linux 6.2
ORACLE: 8.1.7 standard edition
shell: korn
Any help would be appreciated
thanks
Reed
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kempf, Reed
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: Steve Sapovits
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: Erik Williams
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: Suzy Vordos
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
MTS on Linux
Dears First I would like to thank you all for replies about tracing - it helped me very much Now I have a different problem - I have Linux (suse 7.0) with oracle 8.1.7EE and with 2 IP addresses and I want to have MTS server running. The server allways connects to the listener as a dedicated server and not as dispatcher (lsnrctl services). I have opened TAR but they are not able to help me (TAR opened since 18.6). I have tried a lot of things in initSID.ora and listener.ora files but it didnt help. Is there somebody who has the same configuration and whith MTS running? If yes, would you be so kind and send me your configuration files (or part with MTS config), please? Thank you in advance Ivo this is my MTS part of init.ora file #mts_max_dispatchers=10 #mts_max_servers=10 #mts_servers=3 #mts_listener_address=(ADDRESS=(PROTOCOL=TCP)(HOST=10.17.150.5)(PORT=1521)) #large_pool_size = 1000 #MTS_DISPATCHERS=(ADDRESS=(PARTIAL=TRUE)(PROTOCOL=TCP)\ #(HOST=10.17.150.5)(PORT=12345))(DISPATCHERS=2) mts_servers=3 mts_dispatchers=(PRO=TCP)(DISP=3)(LIS=awms) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Libal, Ivo 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).
Command History in SQL*PLUS
Sometime ago there was a post on how to get the last commands executed in SQL*Plus. It is very similar to doing escape from the UNIX command line Do you know how to scroll down the last 10-20 commands executed in SQL*Plus ? I am not talking about / which would get the last command. Rama -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rama Malladi 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: New Listener Question
According to the doc, the default value for service_names is db_name.db_domain. Shouldn't the default value be sufficient? (I haven't actually tried it yet). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike J Kurth 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: RE: New Listener Question
Alex, you are correct. And that's how it worked in 8.1.6. But due to some unknown 'feature' one has to explicitly set the service_names and instance_name in the init .ora file as a workaround to be able to use auto-register feature in 8.1.7. Again, only if using the default listener name with default listener port#.. I have not yet tested this stuff in 9.0.1 but will do in the very near future. Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Hillman, Alex [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, July 18, 2001 1:52 PM To: Multiple recipients of list ORACLE-L Subject: RE: RE: New Listener Question instance_name has default value ORACLE_SID and service_name has default value db_name.db_domain - so you do not need to define these parameters for dynamic service registration. Alex Hillman -Original Message- Sent: Wednesday, July 18, 2001 2:25 PM To: Multiple recipients of list ORACLE-L Actually, it's called dynamic service registration and you need both the INSTANCE_NAME parameter and the SERVICE_NAMES parameter defined in the init.ora. Then, when the instance starts up, it will register the services it supports with the listener(s). Jon Walthour -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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: Command History in SQL*PLUS
On HP-UX use 'ied' command to launch sql*plus or svrmgrl session (% ied sqlplus) . Esc-K will recall previous SQL commands (just like setting 'set -o vi' in a KSH) Check out a script #10 at http://www.orafaq.com/faqscrpt.htm#UNIX. It is wrapper for sqlplus and svrmgrl to do similar things. On NT, I guess use your arrow keys... (Not sure of that, though).. HTH, Regards. - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Rama Malladi [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, July 18, 2001 2:36 PM To: Multiple recipients of list ORACLE-L Subject: Command History in SQL*PLUS Sometime ago there was a post on how to get the last commands executed in SQL*Plus. It is very similar to doing escape from the UNIX command line Do you know how to scroll down the last 10-20 commands executed in SQL*Plus ? I am not talking about / which would get the last command. Rama -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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: Command History in SQL*PLUS
Deshpande, Kirti wrote: On NT, I guess use your arrow keys... (Not sure of that, though).. nope, at least not with the 8.1.7 client. -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ If a program is useful, it must be changed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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: connecting to sqlplus within a shell script
I have an stty erase ^H in my login.sql file which may be causing the problem... h thanks for all of your responses Reed -Original Message- Sent: Wednesday, July 18, 2001 1:08 PM To: Multiple recipients of list ORACLE-L Everytime I have seen this message it was because there was a . $HOME/.profile to ensure that the environment was correct and because the script was run from a cron. By the way, there was stty erase ^H in .profile. . $HOME/.profile 2/dev/null fudged the problem. HTH, Stephane Faroult Oriole Corporation Voice: +44 (0) 7050-696-269 Fax:+44 (0) 7050-696-449 Performance Tools Free Scripts -- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -- Steve Sapovits wrote: SQL*Plus is probably performing terminal specific ioctl settings; e.g., setting it in something other than line mode so it can update the screen more efficiently, etc. For scripting SQL, I'd recommend making a move to Perl/DBI. It rocks! Steve Sapovits Global Sports Interactive Work Email: [EMAIL PROTECTED] Home Email: [EMAIL PROTECTED] Work Phone: 610-491-7087 Cell: 610-574-7706 Pager: 877-239-4003 -Original Message- From: Kempf, Reed [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, July 18, 2001 1:41 PM To: Multiple recipients of list ORACLE-L Subject: connecting to sqlplus within a shell script I use a lot of shell scripts (korn mainly) which use connections to sqlplus and always seem to get this error message when the script logs into sqlplus: stty: standard input: Inappropriate ioctl for device Here is my connection procedure within the script: sqlplus -s sitemon/sitemon END To my knowledge it does not appear to cause any problems with my shell script or output but would really like to know why I am getting it and if there is any recommendations for fixing the problem. OS: Red Hat Linux 6.2 ORACLE: 8.1.7 standard edition shell: korn Any help would be appreciated thanks Reed -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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: Kempf, Reed 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: Command History in SQL*PLUS
There is a SQL command history, actually, there is more then one. SQL command history can be found in v$sql,v$sqlarea and v$sqltext. -Original Message- From: Thater, William [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 18, 2001 4:26 PM To: Multiple recipients of list ORACLE-L Subject: Re: Command History in SQL*PLUS Deshpande, Kirti wrote: On NT, I guess use your arrow keys... (Not sure of that, though).. nope, at least not with the 8.1.7 client. -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ If a program is useful, it must be changed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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: Gogala, Mladen 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).
OT: Quest Software Product Query
Hi All. We just had some folks here from Quest software showing us their 'Live Reorg' product. Does anybody out there use...or not...this product? If you have experience or recommendations or horror stories I'd like to hear them. Please e-mail me privately ; this traffic doesn't need to clog up the list. My address is [EMAIL PROTECTED] Thanks, Mike --- === Michael P. Vergara | I've got a PBS mind in an MTV world Oracle DBA | Guidant Corporation | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) 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: OEM help ???
You don't want to remove the entire Oracle home from the registry UNLESS you are willing to remove all remnants of Oracle, files and registry entries for 8.1.5 and anything else you may have installed and then reinstall the components you need. OEM 816 (release 2.1?) will work with other versions of databases for administrative purposes, but you must have an 8.1.6 database for the OEM repository. Defry - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 18, 2001 3:15 PM Andrea Remove the oracle home from the registry regedit or reg32 HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE --- Andrea Oracle [EMAIL PROTECTED] wrote: Hi all, I installed OEM816 on NT40, database server is 815 on Sun 5.6. The OEM doesn't run since OMS NT service cannot be started for some reason. I tried to deinstalled OEM using installer, the deinstalling only runs for 2% and jumpped out. So I manually removed all the OEM files, and tried to install again. Now the installer told me that you cannot install this since it's already in oem home directory. and the Installed Products still shows all the OEM products, even though I already got rid off the whole oem home. Are there anything log in the registry or some other places that I should clean out? And does OEM816 works well with 815 database?? Thanks. Andrea __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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). __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: k johnson 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: Mustafa 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: Oracle high availability
I would check out the Veritas suite of products. We have several 24x7 high availability OLTP databases and are using Veritas Database Edition HA (High Availability), which includes several Veritas products bundled together that are well integrated with Oracle to provide continuous services and database failover and restoral in the event of hardware or software failure. You may also want to look into Oracle Parallel Server (8i, 8 and 7), or 9i Real Application Clusters if you're deploying with 9i. Defry - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 16, 2001 8:25 PM I'm new to the list and was recently assigned working on Oracle high availability for NT and HP-UX platforms. We have Oracle 8 currently running in production but my research should show all options including 9i. Any research, urls, white papers, recommendations or implementations are greatly appreciated. Jessie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Mustafa 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).
sort segments
Are there any circumstances when temporary tablespace can contain more than 1 sort segment? Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex 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).
Oracle Apps customization help working with consultants
First some background We are running on Unix 8.1.6 with 11i Apps. I know very little about Oracle Apps and I am the first DBA hired in house who has walked into several projects mid streams that consultants are working on and they continue to exclude me from design meeting and I get little or no information about the project. A consulting group is customizing 11i Apps. Part of this involves an EDI application that will take in files load them into staging tables that then will be loaded into the appropriate 11i App table. There are various Oracle and Crystal Reports that will be extracting information from these tables as well. Why use both... go figure... they are using Crystal for some reports and Oracle Reports for others. Just like some of the screens are being done in Forms and some done in ASP. These custom EDI app tables have 10 attribute columns defined as varchar2(100) in the middle of the table. These are extra columns to that may be used in the future for what ever reason. I have asked these be removed and real column names and data types be added as needed. They refuse saying they will have to redesign the forms they have created to use with these tables. Isn't is reasonable that the Forms should also reflect real column names not Attribute 1...10? Isn't it better to add columns to tables as I need them with an appropriate name and data type? At the very least I asked that they put these columns at the end of the table. They have agreed to this. They are also using a lot of sequences for Primary Keys instead of using columns from the table that would make an intelligent primary key and would be unique. They also have many columns as NUMBER that could be defined as NUMBER(3) or NUMBER(4). Is there any pros or cons to using NUMBER without defining a data length? That is besides the obvious that NUMBER you don't have to worry about losing precision data precision. Also they use a lot of char(1) in defining what they think will only be one character fields. I was under the impression that it was better to use varchar2(1)? Any comments... This is probably a trivial issue but I would like to know people's opinions. I am just a bit brain dead from arguing with them anyway about using a consistence naming convention, including me on the database design, etc. Even with renaming a column I get We are on a tight schedule and this would put us behind. Or this is how Oracle Apps works. My point is that Oracle Apps as a generic product and this EDI application shouldn't be made generic but specific to our company needs. That is not putting in this Attribute fields into all the EDI tables, using intelligent keys not sequence numbers, defining the data length of the NUMBER Fields. I am really worried about performance since I will have to maintain this in January after they are long gone. Any help or suggestions would be appreciated. Any good books to get me quickly up to speed on how to tune Oracle Apps? Thanks very much. Kathy Confidential This e-mail and any files transmitted with it are the property of Belkin Components and/or its affiliates, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipients or otherwise have reason to believe that you have received this e-mail in error, please notify the sender and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kathy Duret 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).
Oracle listener security patch -
Just installed p1859778_8162_Solaris patch for listener security problems. Before I installed it - everything was hunky-dory. Afterwards the listener wouldn't start any 'services'. Haven't tried metallink yet. Anybody had this problem? (Using 8.1.6.2 on Sun Solaris) TIA - john f. lewis -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Lewis 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).
Dump V$ to Excel and Upload to Web for Analysis...or not.
MS haters please ignore this I wrote a little app in Access 97 that will allow you to dump any table to Excel via ODBC. It also generates an index page in HTML format so you can FTP all the files to a web server for others to see. I think this will be useful for people that ask questions like my database is slow please help. They can put a bunch of V$ and DBA table info in oneplace so we can actually get an idea of where the problem might be, of course we could just ignore them too but that wouldn't be nice. I'm sure there are many other applications for this. Enjoy. Thanks, Ethan http://www.geocities.com/epost1/excel_dump.htm -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan 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: Command History in SQL*PLUS
Under NT with sqlplus.exe you can use the arrow keys (that is the character version of sqlplus). I do not know how to do this with sqlplusw.exe - if anyone does it would be VERY appreciated. Regards, Bruce Reardon -Original Message- Sent: Thursday, 19 July 2001 6:26 Deshpande, Kirti wrote: On NT, I guess use your arrow keys... (Not sure of that, though).. nope, at least not with the 8.1.7 client. -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] -- 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).
Re: Command History in SQL*PLUS
Bill, I'm on NT and the up and down arrows work peachy! That's one of the few things I don't miss about Unix. I didn't think there was anything additional running on my pc to allow the arrows to work, but they do for me. Hmm... Unless you're referring to the windows client. (I just thought of this right before clicking 'send.') I use the DOS client in a cmd window just for this reason. The Windows client doesn't use the arrow keys, the DOS version does. Is that what you meant? Yosi Thater, William wrote: Deshpande, Kirti wrote: On NT, I guess use your arrow keys... (Not sure of that, though).. nope, at least not with the 8.1.7 client. -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ If a program is useful, it must be changed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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). -- Thanks, Yosi - Yosi Greenfield Oracle Certified DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield 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: Oracle Apps customization help working with consultants
The attribute1 - 10 columns are standard Oracle Applications infrastructure. They are used to hold context sensitive information about the record. I also would worry about the use of serrogate keys (sequences) as a primary key. This is standard fare in most ER designs. What I would be concerned about is there lack of trying to keep you involved in the project as it is you who will have to support it in the future. Be kind, understanding, but very demanding about this one put. BTW, what shop is doing the implementation? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] I'm too sexy for my code. - Awk Sed Fred KathyD@belkin .com To: [EMAIL PROTECTED] Sent by: cc: root@fatcity.Subject: Oracle Apps customization help working with consultants com 07/18/01 04:01 PM Please respond to ORACLE-L First some background We are running on Unix 8.1.6 with 11i Apps. I know very little about Oracle Apps and I am the first DBA hired in house who has walked into several projects mid streams that consultants are working on and they continue to exclude me from design meeting and I get little or no information about the project. A consulting group is customizing 11i Apps. Part of this involves an EDI application that will take in files load them into staging tables that then will be loaded into the appropriate 11i App table. There are various Oracle and Crystal Reports that will be extracting information from these tables as well. Why use both... go figure... they are using Crystal for some reports and Oracle Reports for others. Just like some of the screens are being done in Forms and some done in ASP. These custom EDI app tables have 10 attribute columns defined as varchar2(100) in the middle of the table. These are extra columns to that may be used in the future for what ever reason. I have asked these be removed and real column names and data types be added as needed. They refuse saying they will have to redesign the forms they have created to use with these tables. Isn't is reasonable that the Forms should also reflect real column names not Attribute 1...10? Isn't it better to add columns to tables as I need them with an appropriate name and data type? At the very least I asked that they put these columns at the end of the table. They have agreed to this. They are also using a lot of sequences for Primary Keys instead of using columns from the table that would make an intelligent primary key and would be unique. They also have many columns as NUMBER that could be defined as NUMBER(3) or NUMBER(4). Is there any pros or cons to using NUMBER without defining a data length? That is besides the obvious that NUMBER you don't have to worry about losing precision data precision. Also they use a lot of char(1) in defining what they think will only be one character fields. I was under the impression that it was better to use varchar2(1)? Any comments... This is probably a trivial issue but I would like to know people's opinions. I am just a bit brain dead from arguing with them anyway about using a consistence naming convention, including me on the database design, etc. Even with renaming a column I get We are on a tight schedule and this would put us behind. Or this is how Oracle Apps works. My point is that Oracle Apps as a generic product and this EDI application shouldn't be made generic but specific to our company needs. That is not putting in this Attribute fields into all the
