Re: OC4J
thanks a lot Charlie Mengler wrote: AFAIK, OC4J is NOT dependent upon other 9iAS components. P I P O wrote: i am just curious if OC4J could be used alone with out installing the other components of the Application Server? I mean does the OC4J has dependencies on the Appication Server other components? -- 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). -- Wilfredo Sellado, AbtikBoys Software Design Engineer NEC Telecom Software Phils., Inc. Asiatown I.T. Park Apas, Cebu City 6000, Philippines Office : +63(32)233-9142 [local 311] Residence: +63(32)412-8350 Mobile : +63(917)546-5867 Email: [EMAIL PROTECTED] I love you without knowing how, or when, or from where I love you simply without problems or pride I love you in this way because I don't know any other way of loving -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: P I P O 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: protocol.ora
Hi I only have one database running on this machine.. I have read somewhere that you can use sqlnet.ora instead of protocol.ora ? Regards Saj Iqbal On Mon, 15 Apr 2002, Xiaohong Yang (Sharon) wrote: Sajid, I used protocol.ora to restrict connection based on ip on oracle 8.1.6.3.0 and now 8.1.7.2.0 (Solaris 8). I don't have problem. However, when I had two sets of databases running on the same ORACLE_HOME and using two listeners for these two sets of databases, I had complications. The behavior was that the listener that had the protocol.ora in the directory had to be started after the other one (somehow the restriction stayed in the memory). If you failed to start the restricted-listener last, or restarted the open-connection listener after the restricted-listener is running, then the open-set of databases don't have open connections. Hope this helps. Sharon --- Xiaohong Yang (Sharon) certified Oracle DBA Center for Bioinformatics CB#7100 UNC-CH, Chapel Hill, NC 27599 (919)843-6106 (office) (919)966-6821 (fax) Date: Mon, 15 Apr 2002 08:59:01 +0100 (BST) Subject: Re: protocol.ora Hi I tried this however I get the same result as in it doesn't allow any connections at all..even IP addresses which are included in the .protocol.ora file. Regards Saj Iqbal On Fri, 12 Apr 2002, Jeremiah Wilton wrote: If you trace the listener you will see that it is looking for .protocol.ora with a leading period. This is a documented bug. Just copy protocol.ora to .protocol.ora. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Fri, 12 Apr 2002, Sajid Iqbal wrote: We used to use the protocol.ora file to restrict access to the database, on oracle 8.0.5 However since moving to Oracle 8.1.6.3 this doesn't work. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Xiaohong Yang (Sharon) 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). -- Sajid Iqbal Database Team Leader VIA NET.WORKS 620 Birchwood Boulevard Birchwood Warrington WA3 7QZ DDI: +44 (0) 1925 484485 Fax: +44 (0) 1925 484466 Email: [EMAIL PROTECTED] Website: http://www.vianetworks.co.uk local touch global reach -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sajid Iqbal 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: User_product_profile and sqlplusw
I haven't tried it for a long time either, but I remember a couple of things
that might help:
You can check the name of the program the users are connecting with using SELECT
PROGRAM FROM V$SESSION;
The 'security' is built into sqlplus, not into Oracle itself, so any curious
user can circumvent it very easily.
It's only usefull if you trust all your users not to mess with their desktops -
if you're serious about security, you might want to look at using
password-protected roles to enable access. I have got it to work with
sqlplusw.exe, but it was a long time ago.
Hope this helps.
Simon Anderson
Please respond to [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc: Simon Anderson/SSplc)
I haven't tried this for a while, but I think it's case sensitive. try
'sqlplusw.exe'
-Original Message-
Sent: Monday, April 15, 2002 4:13 PM
To: Multiple recipients of list ORACLE-L
Hi,
I have successfully restricted insert,update,delete using
product_user_profile if the user users sqlplus at the command prompt.
However I cannot
get it to work if they use sqlplusw.exe. Any ideas what entry I have to
use to enforce this.
This is what I used to restrict product access with sqlplus.exe
This works for command prompt sqlplus
insert into
SYSTEM.PRODUCT_USER_PROFILE(PRODUCT,USERID,ATTRIBUTE,CHAR_VALUE)
values ('SQLPlus','USER_ID','INSERT','DISABLED') ;
This does not work for windows sqlplus
insert into
SYSTEM.PRODUCT_USER_PROFILE(PRODUCT,USERID,ATTRIBUTE,CHAR_VALUE)
values ('SQLPlusw','USER_ID','INSERT','DISABLED') ;
Thanks
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).
Oracle DBA with Solaris Large DB experience- Los Angeles
Los Angeles area (Pasadena) California company needs a Sr. Oracle DBA to join its' I.T. team. They need a true production, large scale DBA on Unix (Solaris) PLEASE DO NOT send your resume for this position UNLESS you already live in the Greater Los Angeles area and have the skills outlined below for this position. DO NOT send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. If you are employed by a consulting company you must have a long term project history. This is a full time staff position so no sub-contractors or third parties please. . Responsibilities: Database configuration Back-up and recovery Performance tuning. Support global implementation and ongoing maintenance of large-scale Oracle databases. Support installation and configuration of Oracle Databases, Applications and tools. Maintain production and supporting instances of Oracle Databases, performing databases as well as systems administration duties. Pro-actively monitor and tune databases and troubleshoot problems. Apply patches and create additional database objects as needed. Create, test and execute reliable backup, recovery and high availability strategies. Ability to Document system configurations, database standards and procedures. Support data conversions and testing activities. Use third party tools and technologies to support and monitor systems. Skills/ experience: 5+ years solid Oracle DBA experience in a UNIX (Solaris) environment (NOT Windows) required. 4+ years of PL/SQL, SQL, and shell scripting experience.required 4+ years experience working with multiple large scale (terabyte) databases is required Strong client interpersonal skills required Excellent oral and written communication skills required BS in Computer Science or a related degree is required; Master's degree is preferred In depth knowledge of Oracle Database (RDBMS 8.0, 8i and above), database administration and system administration required. Experience with multilingual database environments a plus. Strong business and customer satisfaction orientation with ability to work in a fast changing, high demand environment. Working experience in using tools such as: OEM, DB Artisan, SQL Plus and server manager. SUN/Unix system administration experience a plus. Oracle certification a plus This company offers an excellent benefits package that starts your first day on the job. This includes: a 401K Plan, Medical (HMO PPM), Dental Vision benefits, 2 weeks paid vacation, 3 weeks after 2 years, 8 sick days, Short Long Term Disability Insurance, Life Insurance, Flexible Spending Account, Employee Assistance Program, Stock Option Plan and Employee Stock Purchase Plan. Employees enjoy a casual dress and fun team environment. -Will also need to be a U.S. citizen or permanent resident. The base salary range is 80-110K..depends on experience. For immediate consideration, please send your resume as a Word attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please use job code: One/Pasadena/Oracle DBA/Sean (*Los Angeles area candidates only- no relocation) ph: 1-800 -549-8502 All Submissions are handled in confidence. *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 your skills. 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).
Rman issue with oracle patch
Hi list The setting : A NT server upgraded to Oracle 81732 with the target database installed on it. A NT server with Oracle 81730 and the RMAN catalog installed. i did the following after applying the 81732 patch After creating/installing new oracle and rman executable user should do the following sqlplus '/ as sysdba'; %ORACLE_HOME%\rdbms\admin\dbmsrman.sql %ORACLE_HOME%\rdbms\admin\prvtrmns.plb If using catalog, then they should upgrade the catalog rman catalog user/passwd@alias upgrade catalog; upgrade catalog; this was executed with the new rman executable just installed. After that the hotbackup fails with the following error messages : RMAN-03022: compiling command: backup RMAN-03026: error recovery releasing channel resources RMAN-08031: released channel: t1 RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03002: failure during compilation of command RMAN-03013: command type: backup RMAN-03014: implicit resync of recovery catalog failed RMAN-06004: ORACLE error from recovery catalog database: ORA-06550: line 1, column 21: PLS-00302: component 'LOCKFORCKPT' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored RMAN-06097: text of failing SQL statement: begin dbms_rcvcat . lockForckpt ; end ; RMAN-06099: error occurred in source file: krmk.pc, line: 2121 anyone with a clue what happened ? thanks g.g. kor rdw ict the netherlands -- 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).
Security Hole
This just in from comp.databases.oracle.server. See metalink bug 2121935. Using ANSI syntax joins (CROSS JOIN, LEFT OUTER etc) allows you to view data from tables on which you have no privilege. For example, try this COMPLETE script: connect / as sysdba create user us1 identified by us1; grant create session to us1; connect us1/us1 select userid, password from sys.link$ cross join dual ; Worse still, if you have the privilege to create views then this loophole allows you to seek and destroy ANY DATA in the database that you might want to. The bug is fixed in 9iR2. I didn't see any note about a backport, or a security alert on OTN. Conclusion: 9.0.1 should not be in use on production system until Oracle supplies a fix. Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan 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).
Re: Please ignore: Internet DBA'ng
Nice! Good work, Suji! A lesson for us all. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 16, 2002 3:43 AM Salesmanship. They told the customer that they can't allow this, and instead of outsourcing DBA'ng to another company, why don't they just pay us for administration. -Original Message- Sent: Tuesday, 16 April 2002 5:13 PM To: Multiple recipients of list ORACLE-L How? -Original Message- Sent: 04 ÕÝÑ, 1423 09:08 AM To: Multiple recipients of list ORACLE-L Solved this issue. -Original Message- From: Sujatha Madan Sent: Tuesday, 16 April 2002 2:55 PM To: Multiple recipients of list ORACLE-L (E-mail) Subject: Internet DBA'ng Hi, We have a network/web hosting shop, and one of our customers is asking for a firewall to be opened for DBA access over the internet. They want two non-Oracle specific ports opened so that their Oracle Databases can be administrated via the internet. Has anyone heard of any vulnerabilities associated with this? Or is there anything that I should be aware of in terms of security? Or should I be asking them any questions? Thanks Sujatha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Sujatha Madan 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).
Ora-12500 Error
Hi All, I am trying to install an Oracle V8.1.7 on a Netware 5.O server. When loading SVRMGR, I get : ORA-12500: TNS: Listener failed to start a dedicared server process I checked all my configuration files (LISTENER, TNSNAMES), it seems to be OK. Any help will be welcome. Best Regards. -- 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).
Oracle versions for W2K
Anyone out there sucessfully running Oracle 7.3.3 and/or 8.0.5 on W2K?. - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean 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 Hole
Is this on 9i databases or is 8 involved? Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 16, 2002 7:33 AM This just in from comp.databases.oracle.server. See metalink bug 2121935. Using ANSI syntax joins (CROSS JOIN, LEFT OUTER etc) allows you to view data from tables on which you have no privilege. For example, try this COMPLETE script: connect / as sysdba create user us1 identified by us1; grant create session to us1; connect us1/us1 select userid, password from sys.link$ cross join dual ; Worse still, if you have the privilege to create views then this loophole allows you to seek and destroy ANY DATA in the database that you might want to. The bug is fixed in 9iR2. I didn't see any note about a backport, or a security alert on OTN. Conclusion: 9.0.1 should not be in use on production system until Oracle supplies a fix. Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan 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). -- 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).
Unix - need some help
Hallo, I have this unix script, please tell me how to change it so it also does the following: (See attached file: laddabilbo.sh) counts the time between start time and end time of the process(I mean time difference between Jobb startat(Job started) and Job Klart(Job Finished). IThis log file is also sent by mail to people. I would like this log file only to be sent if there is anything wrong with the script(for instance if the database is down) So if the script goes fine, then no email will be sent. The log file looks like this: Jobb startat :Sun Apr 14 18:06:23 MEST 2002 -- ehbgrupp status Total logical records skipped: 0 Total logical records read: 400 Total logical records rejected: 0 Total logical records discarded:0 Run began on Sun Apr 14 18:06:23 2002 Run ended on Sun Apr 14 18:11:51 2002 Elapsed time was: 00:05:28.15 CPU time was: 00:00:00.07 (Ma -- -- kampanj status Total logical records skipped: 0 Total logical records read:13 Total logical records rejected: 0 Total logical records discarded:0 Run began on Sun Apr 14 18:11:51 2002 Run ended on Sun Apr 14 18:12:44 2002 Elapsed time was: 00:00:52.52 CPU time was: 00:00:00.04 (Ma -- -- mxurval status Total logical records skipped: 0 Total logical records read: 4829 Total logical records rejected: 0 Total logical records discarded:0 Run began on Sun Apr 14 18:12:44 2002 Run ended on Sun Apr 14 18:12:50 2002 Elapsed time was: 00:00:05.90 CPU time was: 00:00:00.18 (Ma -- -- load_arg status Total logical records skipped: 0 Total logical records read:151613 Total logical records rejected: 0 Total logical records discarded:0 Run began on Sun Apr 14 18:12:50 2002 Run ended on Sun Apr 14 18:28:11 2002 Elapsed time was: 00:15:20.92 CPU time was: 00:00:25.07 (Ma -- -- laddabsg status Total logical records skipped: 0 Total logical records read: 92326 Total logical records rejected: 0 Total logical records discarded:0 Run began on Sun Apr 14 18:28:11 2002 Run ended on Sun Apr 14 18:40:15 2002 Elapsed time was: 00:12:03.95 CPU time was: 00:00:32.17 (Ma -- Jobb klart! :Sun Apr 14 18:49:23 MEST 2002 I would really appreciate help. Thanks in advance Roland laddabilbo.sh Description: Binary data
Simple Query
Hi All, I have a specific problem in retrieving rows from a table. I am listing down the some sample data in a table. TC_ID TC_TRANSCRIPTID TC_COLLECTDATETIME TC_ACTIONID TC_LINECOUNT ---1 10104/02/2002 12:30:00 1060 10 2 101 04/02/2002 01:00:00 1080 8 3 10204/02/2002 02:00:00 1060 25 410204/02/2002 03:00:00 1080 27- 5 103 04/02/2002 04:00:00 1060 40-- I need a query which will retrieve the COUNT(TC_ID) and SUM(TC_LINECOUNT) and the Conditions are 1) COUNT(TC_ID) should only be retrieved for the maximum of TC_ACTIONID. ( I mean for all those TC_TRANSCRIPTID which has got more than one entries in the table the maximum of TC_ACTIONID should be retrieved. 2) SUM(TC_LINECOUNT) should only be retrieved for the maximum of TC_ACTIONID I mean each and every TC_TRANSCRIPTID can have 'n' number of records in the table and when the query is executed it should retrieve the MAXIMUM of TC_ACTIONID that a TC_TRANSCRIPTID is having and the same goes with the File Count also. In the example sited above the query should retrieve COUNT(TC_ID) as 3 and the SUM(TC_LINECOUNT) as 75. COUNT(TC_ID) SUM(TC_LINECOUNT) 375 Thanks in advance. Regards, Shibu. Acusis - Bangalore
RE: User_product_profile and sqlplusw
Thanks but that does not work either.
Rick
Shaw
John-P55297 To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
P55297@motorcc:
ola.com Subject: RE: User_product_profile and
sqlplusw
Sent by:
root@fatcity.
com
04/15/2002
05:58 PM
Please
respond to
ORACLE-L
I haven't tried this for a while, but I think it's case sensitive. try
'sqlplusw.exe'
-Original Message-
Sent: Monday, April 15, 2002 4:13 PM
To: Multiple recipients of list ORACLE-L
Hi,
I have successfully restricted insert,update,delete using
product_user_profile if the user users sqlplus at the command prompt.
However I cannot
get it to work if they use sqlplusw.exe. Any ideas what entry I have to
use to enforce this.
This is what I used to restrict product access with sqlplus.exe
This works for command prompt sqlplus
insert into
SYSTEM.PRODUCT_USER_PROFILE(PRODUCT,USERID,ATTRIBUTE,CHAR_VALUE)
values ('SQLPlus','USER_ID','INSERT','DISABLED') ;
This does not work for windows sqlplus
insert into
SYSTEM.PRODUCT_USER_PROFILE(PRODUCT,USERID,ATTRIBUTE,CHAR_VALUE)
values ('SQLPlusw','USER_ID','INSERT','DISABLED') ;
Thanks
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Shaw John-P55297
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: Oracle versions for W2K
Hi Sean, Not anymore, Upgraded my W2K PC's to Oracle 8i/9i in the past months (production/test is All UNIX anyway so it's just my playground) But 8.0.5 used to run fine, No problemo. 7.3 (huh?) dunno Jack O'Neill, Sean Sean.ONeill@orgaTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] non.ie cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: Oracle versions for W2K [EMAIL PROTECTED] 16-04-2002 14:53 Please respond to ORACLE-L Anyone out there sucessfully running Oracle 7.3.3 and/or 8.0.5 on W2K?. - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean 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). == 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
Unix help
I have this unix script, please tell me how to change it so it also does the following: counts the time between start time and end time of the process(I mean time difference between Jobb startat(Job started) and Job Klart(Job Finished). loadbilbo.sh: #!/bin/sh . /usr/bin/orasetup.sh . /d31/appl/konto/bat/movefiles.sh echo Jobb startat :\c /d31/appl/konto/log/laddabilbo.txt date /d31/appl/konto/log/laddabilbo.txt sqlldr userid=konto/icakort control=/d31/appl/konto/bat/ehbgrupp.ctl log=/d31/appl/konto/log/ehbgrupp.log sqlldr userid=konto/icakort control=/d31/appl/konto/bat/kampanj.ctl log=/d31/appl/konto/log/kampanj.log sqlldr userid=konto/icakort control=/d31/appl/konto/bat/mxurval.ctl log=/d31/appl/konto/log/mxurval.log sqlldr userid=konto/icakort control=/d31/appl/konto/bat/load_arg.ctl log=/d31/appl/konto/log/load_arg.log sqlldr userid=konto/icakort control=/d31/appl/konto/bat/laddabsg.ctl log=/d31/appl/konto/log/laddabsg.log sqlplus -s konto/icakort ! set heading off set verify off set feedback off set termout off set pages 0 begin konto.fillbilbotables.anrop; END; / EXIT ! echo -- /d31/appl/konto/log/laddabilbo.txt echo ehbgrupp status /d31/appl/konto/log/laddabilbo.txt tail -11 /d31/appl/konto/log/ehbgrupp.log /d31/appl/konto/log/laddabilbo.txt echo -- /d31/appl/konto/log/laddabilbo.txt echo -- /d31/appl/konto/log/laddabilbo.txt echo kampanj status /d31/appl/konto/log/laddabilbo.txt tail -11 /d31/appl/konto/log/kampanj.log /d31/appl/konto/log/laddabilbo.txt echo -- /d31/appl/konto/log/laddabilbo.txt echo -- /d31/appl/konto/log/laddabilbo.txt echo mxurval status /d31/appl/konto/log/laddabilbo.txt tail -11 /d31/appl/konto/log/mxurval.log /d31/appl/konto/log/laddabilbo.txt echo -- /d31/appl/konto/log/laddabilbo.txt echo -- /d31/appl/konto/log/laddabilbo.txt echo load_arg status /d31/appl/konto/log/laddabilbo.txt tail -11 /d31/appl/konto/log/load_arg.log /d31/appl/konto/log/laddabilbo.txt echo -- /d31/appl/konto/log/laddabilbo.txt echo -- /d31/appl/konto/log/laddabilbo.txt echo laddabsg status /d31/appl/konto/log/laddabilbo.txt tail -11 /d31/appl/konto/log/laddabsg.log /d31/appl/konto/log/laddabilbo.txt echo -- /d31/appl/konto/log/laddabilbo.txt echo Jobb klart! :\c /d31/appl/konto/log/laddabilbo.txt date /d31/appl/konto/log/laddabilbo.txt cat /d31/appl/konto/log/laddabilbo.txt | mailx -s Konto - Statusrapport [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] IThis log file is also sent by mail to people. I would like this log file only to be sent if there is anything wrong with the script(for instance if the database is down) So if the script goes fine, then no email will be sent. The log file looks like this: Jobb startat :Sun Apr 14 18:06:23 MEST 2002 -- ehbgrupp status Total logical records skipped: 0 Total logical records read: 400 Total logical records rejected: 0 Total logical records discarded:0 Run began on Sun Apr 14 18:06:23 2002 Run ended on Sun Apr 14 18:11:51 2002 Elapsed time was: 00:05:28.15 CPU time was: 00:00:00.07 (Ma -- -- kampanj status Total logical records skipped: 0 Total logical records read:13 Total logical records rejected: 0 Total logical records discarded:0 Run began on Sun Apr 14 18:11:51 2002 Run ended on Sun Apr 14 18:12:44 2002 Elapsed time was: 00:00:52.52 CPU time was: 00:00:00.04 (Ma -- -- mxurval status Total logical records skipped: 0 Total logical records read: 4829 Total logical records rejected: 0 Total logical records discarded:0 Run began on Sun Apr 14 18:12:44 2002 Run ended on Sun Apr 14 18:12:50 2002 Elapsed time was: 00:00:05.90 CPU time was: 00:00:00.18 (Ma -- -- load_arg status Total logical records skipped: 0 Total logical records read:151613 Total logical records rejected: 0 Total logical records discarded:0 Run began on Sun Apr 14 18:12:50 2002 Run ended on Sun Apr 14 18:28:11 2002 Elapsed time was: 00:15:20.92 CPU time was:
Oracle DBA Needed in Hartford, CT
Position: Oracle DBA Location: Hartford, Connecticut Salary Range: 60-75K-depends on experience PLEASE DO NOT send your resume for this position UNLESS you already live in the Greater Hartford, CT area and have the skills outlined below for this position. DO NOT send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. If you are employed by a consulting company you must have a long term project history. This is a full time staff position so no sub-contractors or third parties please. Requirements: Client Company seeks 3+ years exp'd oracle dba with SQL background. Additional pluses are healthcare, peoplesoft, MS SQL Server, Himalayan Non-stop. For immediate consideration, please send your resume as a Word attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please use job code: One/Hartford/Oracle DBA/Stan D. (*Hartford area candidates only- no relocation) ph: 1-800 -549-8502 All Submissions are handled in confidence. *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 your skills. 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).
RE: Unix help
Yawn... -Original Message- Sent: Tuesday, April 16, 2002 10:08 AM To: Multiple recipients of list ORACLE-L I have this unix script, please tell me how to change it so it also does the following: counts the time between start time and end time of the process(I mean time difference between Jobb startat(Job started) and Job Klart(Job Finished). loadbilbo.sh: #!/bin/sh . /usr/bin/orasetup.sh . /d31/appl/konto/bat/movefiles.sh echo Jobb startat :\c /d31/appl/konto/log/laddabilbo.txt date /d31/appl/konto/log/laddabilbo.txt sqlldr userid=konto/icakort control=/d31/appl/konto/bat/ehbgrupp.ctl log=/d31/appl/konto/log/ehbgrupp.log sqlldr userid=konto/icakort control=/d31/appl/konto/bat/kampanj.ctl log=/d31/appl/konto/log/kampanj.log sqlldr userid=konto/icakort control=/d31/appl/konto/bat/mxurval.ctl log=/d31/appl/konto/log/mxurval.log sqlldr userid=konto/icakort control=/d31/appl/konto/bat/load_arg.ctl log=/d31/appl/konto/log/load_arg.log sqlldr userid=konto/icakort control=/d31/appl/konto/bat/laddabsg.ctl log=/d31/appl/konto/log/laddabsg.log sqlplus -s konto/icakort ! set heading off set verify off set feedback off set termout off set pages 0 begin konto.fillbilbotables.anrop; END; / EXIT ! echo -- /d31/appl/konto/log/laddabilbo.txt echo ehbgrupp status /d31/appl/konto/log/laddabilbo.txt tail -11 /d31/appl/konto/log/ehbgrupp.log /d31/appl/konto/log/laddabilbo.txt echo -- /d31/appl/konto/log/laddabilbo.txt echo -- /d31/appl/konto/log/laddabilbo.txt echo kampanj status /d31/appl/konto/log/laddabilbo.txt tail -11 /d31/appl/konto/log/kampanj.log /d31/appl/konto/log/laddabilbo.txt echo -- /d31/appl/konto/log/laddabilbo.txt echo -- /d31/appl/konto/log/laddabilbo.txt echo mxurval status /d31/appl/konto/log/laddabilbo.txt tail -11 /d31/appl/konto/log/mxurval.log /d31/appl/konto/log/laddabilbo.txt echo -- /d31/appl/konto/log/laddabilbo.txt echo -- /d31/appl/konto/log/laddabilbo.txt echo load_arg status /d31/appl/konto/log/laddabilbo.txt tail -11 /d31/appl/konto/log/load_arg.log /d31/appl/konto/log/laddabilbo.txt echo -- /d31/appl/konto/log/laddabilbo.txt echo -- /d31/appl/konto/log/laddabilbo.txt echo laddabsg status /d31/appl/konto/log/laddabilbo.txt tail -11 /d31/appl/konto/log/laddabsg.log /d31/appl/konto/log/laddabilbo.txt echo -- /d31/appl/konto/log/laddabilbo.txt echo Jobb klart! :\c /d31/appl/konto/log/laddabilbo.txt date /d31/appl/konto/log/laddabilbo.txt cat /d31/appl/konto/log/laddabilbo.txt | mailx -s Konto - Statusrapport [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] IThis log file is also sent by mail to people. I would like this log file only to be sent if there is anything wrong with the script(for instance if the database is down) So if the script goes fine, then no email will be sent. The log file looks like this: Jobb startat :Sun Apr 14 18:06:23 MEST 2002 -- ehbgrupp status Total logical records skipped: 0 Total logical records read: 400 Total logical records rejected: 0 Total logical records discarded:0 Run began on Sun Apr 14 18:06:23 2002 Run ended on Sun Apr 14 18:11:51 2002 Elapsed time was: 00:05:28.15 CPU time was: 00:00:00.07 (Ma -- -- kampanj status Total logical records skipped: 0 Total logical records read:13 Total logical records rejected: 0 Total logical records discarded:0 Run began on Sun Apr 14 18:11:51 2002 Run ended on Sun Apr 14 18:12:44 2002 Elapsed time was: 00:00:52.52 CPU time was: 00:00:00.04 (Ma -- -- mxurval status Total logical records skipped: 0 Total logical records read: 4829 Total logical records rejected: 0 Total logical records discarded:0 Run began on Sun Apr 14 18:12:44 2002 Run ended on Sun Apr 14 18:12:50 2002 Elapsed time was: 00:00:05.90 CPU time was: 00:00:00.18 (Ma -- -- load_arg status Total logical records skipped: 0 Total logical records read:151613 Total logical records rejected: 0 Total logical records discarded:0 Run began on Sun Apr 14 18:12:50 2002
RE: Security Hole
9i - Can't break it, can't break in! ?!?!? ;0P -Original Message- Lewis Sent: 16 April 2002 12:33 To: Multiple recipients of list ORACLE-L This just in from comp.databases.oracle.server. See metalink bug 2121935. Using ANSI syntax joins (CROSS JOIN, LEFT OUTER etc) allows you to view data from tables on which you have no privilege. For example, try this COMPLETE script: connect / as sysdba create user us1 identified by us1; grant create session to us1; connect us1/us1 select userid, password from sys.link$ cross join dual ; Worse still, if you have the privilege to create views then this loophole allows you to seek and destroy ANY DATA in the database that you might want to. The bug is fixed in 9iR2. I didn't see any note about a backport, or a security alert on OTN. Conclusion: 9.0.1 should not be in use on production system until Oracle supplies a fix. Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith 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 Hole
It appeared in 9i and is fixed in 9.2. 8i is not affected as it does not have cross joins. From Metalink Note 137286.1; Oracle9i introduces the following SQL:1999-compliant joins: 1.1 CROSS Join 1.2 NATURAL Join 1.3 OUTER Join 1.3.1 LEFT OUTER Join 1.3.2 RIGHT OUTER Join 1.3.3 FULL OUTER Join 1.1 CROSS Join -- A CROSS join is the cross-product of two tables. It is the equivalent of a Cartesian product. --- I tried the query with a cartesian product in 8i and it didn't work. select userid,password from sys.link$, dual * ERROR at line 1: ORA-00942: table or view does not exist -Original Message- From: Ruth Gramolini [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 16, 2002 8:38 AM To: Multiple recipients of list ORACLE-L Subject: Re: Security Hole Is this on 9i databases or is 8 involved? Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 16, 2002 7:33 AM This just in from comp.databases.oracle.server. See metalink bug 2121935. Using ANSI syntax joins (CROSS JOIN, LEFT OUTER etc) allows you to view data from tables on which you have no privilege. For example, try this COMPLETE script: connect / as sysdba create user us1 identified by us1; grant create session to us1; connect us1/us1 select userid, password from sys.link$ cross join dual ; Worse still, if you have the privilege to create views then this loophole allows you to seek and destroy ANY DATA in the database that you might want to. The bug is fixed in 9iR2. I didn't see any note about a backport, or a security alert on OTN. Conclusion: 9.0.1 should not be in use on production system until Oracle supplies a fix. Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan 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). -- 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). -- 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: sql isql
9i provides iSQL*Plus browser based tool. Don't know if it is similar to these. Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 16, 2002 9:18 AM Mks - isql is a Sybase and MS SQL tool, not Oracle. The following excerpt may clarify this. The equivalent in Oracle is probably SQL*Plus. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] A word about the isql tool The database access tool provided with Microsoft SQL Server is Microsoft isql. You must use Microsoft isql (or a compatible tool) to access the Microsoft SQL Server database to execute some of the test scripts documented in this Appendix. Although the name of the Microsoft isql tool is the same as the Sybase tool called isql, the Sybase and Microsoft tools are not compatible. For example, you cannot use the Sybase isql tool to access the Microsoft SQL Server data server and you cannot use the Microsoft isql tool to access the Replication Agent administration port. If you have both Sybase and Microsoft isql tools loaded on the same computer, you may need to change an environment variable (possibly the path variable) to avoid problems when you invoke one of the isql tools. -Original Message- Sent: Tuesday, April 16, 2002 1:18 AM To: Multiple recipients of list ORACLE-L Dear Gurus, Where can I get the difference between 'sql' and 'isql' in Oracle. I shall be grateful if anyone please mention some differences. mks -- 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: DENNIS 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: KENNETH JANUSZ 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 Hole
I forwarded it to SANS. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Tuesday, April 16, 2002 8:33 AM To: Multiple recipients of list ORACLE-L Subject:Security Hole This just in from comp.databases.oracle.server. See metalink bug 2121935. Using ANSI syntax joins (CROSS JOIN, LEFT OUTER etc) allows you to view data from tables on which you have no privilege. For example, try this COMPLETE script: connect / as sysdba create user us1 identified by us1; grant create session to us1; connect us1/us1 select userid, password from sys.link$ cross join dual ; Worse still, if you have the privilege to create views then this loophole allows you to seek and destroy ANY DATA in the database that you might want to. The bug is fixed in 9iR2. I didn't see any note about a backport, or a security alert on OTN. Conclusion: 9.0.1 should not be in use on production system until Oracle supplies a fix. Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J 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: interview questions
It really depends on what the job entails. On Mon, 15 Apr 2002, Maria Aurora VT de la Vega wrote: Hello Gurus. I would like to ask anyone who were at one point worked as Oracle Developers... or anyone who can give their opinion... I will be interviewing applicants for Oracle Developer position. Since I'm the only Oracle person in this shop, I was tasked to handle this interview. I have 0 experience with the use of any Oracle Development tools... And for me, as long as they know how to SQL and PLSQL...and respects their DBA... they're OK. I am not sure if there are other things I should ask.. Inputs Please! thanks. -- Maria Aurora VT de la Vega (OCP) Database Specialist Philippine Stock Exchange, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega 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: 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).
RE: interview questions
Maria - Oracle has quite a panoply of development tools, are you looking for someone who is expert in all of them, or can you narrow it down a bit. An old memory may be in order here. Remember the days of time-sharing? If not, look it up. Anyway I worked for a company that offered CDC and Cray services, and decided to get offer IBM services. So they leased a group of IBM computers and interviewed for some experts. The problem is it is really hard to tell an expert from a wannabe if you don't know the area. We got a bunch of wannabes, near as I could tell. For good interview questions, search Google for Oracle Developer Certification. A link I found is: http://www.whizlabs.com/ocp/ocp-1Z0-121-tips.html Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, April 15, 2002 10:43 PM To: Multiple recipients of list ORACLE-L Hello Gurus. I would like to ask anyone who were at one point worked as Oracle Developers... or anyone who can give their opinion... I will be interviewing applicants for Oracle Developer position. Since I'm the only Oracle person in this shop, I was tasked to handle this interview. I have 0 experience with the use of any Oracle Development tools... And for me, as long as they know how to SQL and PLSQL...and respects their DBA... they're OK. I am not sure if there are other things I should ask.. Inputs Please! thanks. -- Maria Aurora VT de la Vega (OCP) Database Specialist Philippine Stock Exchange, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega 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: DENNIS 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).
Re: sql isql
Hi all, Mks is probably referring to the iSQL*Plus tool available in Oracle9i. This is basically a web form that allows the user to type sql or sqlplus commands in the top window and see the results in the bottom window. It is clusser to sql*plus worksheet than the conventional sql*plus command line or gui. John [EMAIL PROTECTED] wrote: Mks - isql is a Sybase and MS SQL tool, not Oracle. The following excerpt may clarify this. The equivalent in Oracle is probably SQL*Plus. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] A word about the isql tool The database access tool provided with Microsoft SQL Server is Microsoft isql. You must use Microsoft isql (or a compatible tool) to access the Microsoft SQL Server database to execute some of the test scripts documented in this Appendix. Although the name of the Microsoft isql tool is the same as the Sybase tool called isql, the Sybase and Microsoft tools are not compatible. For example, you cannot use the Sybase isql tool to access the Microsoft SQL Server data server and you cannot use the Microsoft isql tool to access the Replication Agent administration port. If you have both Sybase and Microsoft isql tools loaded on the same computer, you may need to change an environment variable (possibly the path variable) to avoid problems when you invoke one of the isql tools. -Original Message- Sent: Tuesday, April 16, 2002 1:18 AM To: Multiple recipients of list ORACLE-L Dear Gurus, Where can I get the difference between 'sql' and 'isql' in Oracle. I shall be grateful if anyone please mention some differences. mks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA 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 Hole
Thanks! RBG - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 16, 2002 10:13 AM Oracle 9 only. Oracle 8 does not support ANSI join syntax. Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 16 April 2002 13:47 |Is this on 9i databases or is 8 involved? Ruth |- Original Message - |To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] |Sent: Tuesday, April 16, 2002 7:33 AM | | | This just in from comp.databases.oracle.server. | | See metalink bug 2121935. | | Using ANSI syntax joins (CROSS JOIN, LEFT OUTER etc) | allows you to view data from tables on which you have no | privilege. For example, try this COMPLETE script: | | connect / as sysdba | create user us1 identified by us1; | grant create session to us1; | | connect us1/us1 | | select userid, password | from | sys.link$ cross join dual | ; | | | | Worse still, if you have the privilege to create views | then this loophole allows you to seek and destroy | ANY DATA in the database that you might want to. | | The bug is fixed in 9iR2. I didn't see any note | about a backport, or a security alert on OTN. | | Conclusion: | | 9.0.1 should not be in use on production system | until Oracle supplies a fix. | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan 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). -- 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: interview questions
How familiar are they with using trace, tkprof, and tuning the SQL they write? Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Maria Aurora VT de la Vega [SMTP:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 10:43 PM To: Multiple recipients of list ORACLE-L Subject: interview questions Hello Gurus. I would like to ask anyone who were at one point worked as Oracle Developers... or anyone who can give their opinion... I will be interviewing applicants for Oracle Developer position. Since I'm the only Oracle person in this shop, I was tasked to handle this interview. I have 0 experience with the use of any Oracle Development tools... And for me, as long as they know how to SQL and PLSQL...and respects their DBA... they're OK. I am not sure if there are other things I should ask.. Inputs Please! thanks. -- Maria Aurora VT de la Vega (OCP) Database Specialist -- 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: Please ignore: Internet DBA'ng
thanks for posting your solution On Mon, 15 Apr 2002, Sujatha Madan wrote: Solved this issue. -Original Message- From: Sujatha Madan Sent: Tuesday, 16 April 2002 2:55 PM To: Multiple recipients of list ORACLE-L (E-mail) Subject:Internet DBA'ng Hi, We have a network/web hosting shop, and one of our customers is asking for a firewall to be opened for DBA access over the internet. They want two non-Oracle specific ports opened so that their Oracle Databases can be administrated via the internet. Has anyone heard of any vulnerabilities associated with this? Or is there anything that I should be aware of in terms of security? Or should I be asking them any questions? Thanks Sujatha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sujatha Madan 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: 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).
RE: Security Hole
Glenn, did the user have access to LINK$. It's common practice to restrict access to that table. Cheers, Mike -Original Message- Sent: Tuesday, April 16, 2002 3:39 PM To: Multiple recipients of list ORACLE-L It appeared in 9i and is fixed in 9.2. 8i is not affected as it does not have cross joins. From Metalink Note 137286.1; Oracle9i introduces the following SQL:1999-compliant joins: 1.1 CROSS Join 1.2 NATURAL Join 1.3 OUTER Join 1.3.1 LEFT OUTER Join 1.3.2 RIGHT OUTER Join 1.3.3 FULL OUTER Join 1.1 CROSS Join -- A CROSS join is the cross-product of two tables. It is the equivalent of a Cartesian product. --- I tried the query with a cartesian product in 8i and it didn't work. select userid,password from sys.link$, dual * ERROR at line 1: ORA-00942: table or view does not exist -Original Message- From: Ruth Gramolini [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 16, 2002 8:38 AM To: Multiple recipients of list ORACLE-L Subject: Re: Security Hole Is this on 9i databases or is 8 involved? Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 16, 2002 7:33 AM This just in from comp.databases.oracle.server. See metalink bug 2121935. Using ANSI syntax joins (CROSS JOIN, LEFT OUTER etc) allows you to view data from tables on which you have no privilege. For example, try this COMPLETE script: connect / as sysdba create user us1 identified by us1; grant create session to us1; connect us1/us1 select userid, password from sys.link$ cross join dual ; Worse still, if you have the privilege to create views then this loophole allows you to seek and destroy ANY DATA in the database that you might want to. The bug is fixed in 9iR2. I didn't see any note about a backport, or a security alert on OTN. Conclusion: 9.0.1 should not be in use on production system until Oracle supplies a fix. Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan 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). -- 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). -- 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). This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of
8.0.5 to 8.1.7 - export/import
Hi - I believe I can do this, but I would like some confirmation and or warnings, etc. We are migrating an application from 8.0.5 on NT to 8.1.7 on Unix (Solaris 2.6). I would like to do this by creating the 8.1.7 instance and then importing the data. Is it possible to export from the NT database (using the 8.0.5 exp command) and then import into the 8.1.7 database on Unix (using the 8.1.7 imp command)? Thank you- Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: YTTRI Lisa 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 Hole
Mike, that is the beauty of this bug, you don't need access to link$ for this to work. 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! -Original Message- Sent: Tuesday, April 16, 2002 11:39 AM To: Multiple recipients of list ORACLE-L Glenn, did the user have access to LINK$. It's common practice to restrict access to that table. Cheers, Mike *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
SHARED_POOL_RESERVED_SIZE pool question
Dear Gurus, SHARED_POOL_RESERVED_SIZE is for big database objects (procedure,function,package) as far as I know. I want to configure my database for pinning codes greater than 500K to reserved pool , smallers to shared pool . How Can I do that ? Thank you Bunyamin K. Karadeniz Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312 2873565 / 1217Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA.
Re: Security Hole
There should be an emergency backport available for that fix/problem. If not, who wants to use 9i release 1 ? Anjo. Mark Leith wrote: 9i - Can't break it, can't break in! ?!?!? ;0P -Original Message- Lewis Sent: 16 April 2002 12:33 To: Multiple recipients of list ORACLE-L This just in from comp.databases.oracle.server. See metalink bug 2121935. Using ANSI syntax joins (CROSS JOIN, LEFT OUTER etc) allows you to view data from tables on which you have no privilege. For example, try this COMPLETE script: connect / as sysdba create user us1 identified by us1; grant create session to us1; connect us1/us1 select userid, password from sys.link$ cross join dual ; Worse still, if you have the privilege to create views then this loophole allows you to seek and destroy ANY DATA in the database that you might want to. The bug is fixed in 9iR2. I didn't see any note about a backport, or a security alert on OTN. Conclusion: 9.0.1 should not be in use on production system until Oracle supplies a fix. Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith 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: Anjo Kolk 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: EMC Storage Array Issue
Do you have any more info on this BUG? I can't find anything that appears close to this on Metaclink. Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: James A [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 1:24 PM To: Multiple recipients of list ORACLE-L Subject: RE: EMC Storage Array Issue We ran into a similar issue on 8.1.6.0 for Solaris 32bit and Veritas Volumes. Oracle noted this as a bug in their release and suggest go to 8.1.6.3 or better 8.1.7.3. We are testing this now. So far it seems to work. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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: Database shutdown
What kind of shutdown are you doing (immediate or normal). If the former, there may be a lot of transactions to rollback, how often/ when was your last log switch? If the latter, somebody hasn't logged off. Normal waits for all transaction to complete. -Original Message- Sent: Tuesday, April 16, 2002 12:04 PM To: Multiple recipients of list ORACLE-L Does any know why it takes too long (about 40 minutes) to shutdown oracle database? I am running oracle8.0.5 on solari5.6. It usually just takes me few minutes to shutdown. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M 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: John Weatherman 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).
Using two TNSNAMES.ORA or some other solution.
Hey all, In my work place, usually I do the development of Oracle database running on HP-UX platform. But I also have an Oracle server(PC) running on my PC running Windows NT. To connect to Oracle server running on my PC from Unix box, I do the following on Unix box. $export DB_LOGIN=dkumar/dkumarl@(DESCRIPTION=(ADDRESS_LIST=ADDRESS=COMMUNITY=tcp.wor ld)(PROTOCOL=TCP)(Host=10.110.1 44.73)(Port=1521)))(CONNECT_DATA=(SID=DHARM))) $ sqlplus $DB_LOGIN and I am able to connect to sqlplus session without any problem. The reason I do this because I do not have permission to changes the tnsnames.ora file on the Unix box.. So the access to oracle server (PC) works fine using client sqlplus from Unix box. But the problem is that if use the utilities like sqlloader, import and export and tries to connect Oracle Server (PC), this approach does not work as the following lines show it. $sqlldr userid=$DB_LOGIN LRM-00116: syntax error at 'dkumar/dkumar@(D' following '=' SQL*Loader: Release 8.1.6.2.0 - Production on Tue Apr 16 12:18:24 2002 (c) Copyright 1999 Oracle Corporation. All rights reserved. SQL*Loader-100: Syntax error on command-line So let me know if there is a way by which I can use two tnsnames.ora on Unix box and if that is possible then I can set description for Oracle server (PC) in the second file because I have tested that if DB_LOGIN is set to dkumar/dkumar@corpdb where corpdb is the entry in tnsnames.ora then all the utilities work fine. If somebody has some other ideas, let me know. Thanks. Dharminder Kumar FONT SIZE = 1 This e-mail and any attachments may contain confidential and privileged information. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this e-mail and destroy any copies. Any dissemination or use of this information by a person other than the intended recipient is unauthorized and may be illegal. Unless otherwise stated, opinions expressed in this e-mail are those of the author and are not endorsed by the author's employer./FONT -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kumar, Dharminder 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: Unix script
Still room for improvement but enough changes to keep you busy for awhile.
Please note that I changed the script to use ksh shell (required by several
of the commands I added) and the exec command that will redirect all
script text output to a common file so that you don't have to redeclare the
output file with each tail and echo command. Have fun..
#!/bin/ksh
JOB_LOG=/d31/appl/konto/log/laddabilbo.txt
exec 1${JOB_LOG} 21
. /usr/bin/orasetup.sh
. /d31/appl/konto/bat/movefiles.sh
STATUS=0
echo
###
echo #Starting ${0##*/} at $(date)
echo #
sqlldr userid=konto/icakort control=/d31/appl/konto/bat/ehbgrupp.ctl
log=/d31/appl/konto/log/ehbgrupp.log
STATUS=$((${STATUS} + ${?}))
sqlldr userid=konto/icakort control=/d31/appl/konto/bat/kampanj.ctl
log=/d31/appl/konto/log/kampanj.log
STATUS=$((${STATUS} + ${?}))
sqlldr userid=konto/icakort control=/d31/appl/konto/bat/mxurval.ctl
log=/d31/appl/konto/log/mxurval.log
STATUS=$((${STATUS} + ${?}))
sqlldr userid=konto/icakort control=/d31/appl/konto/bat/load_arg.ctl
log=/d31/appl/konto/log/load_arg.log
STATUS=$((${STATUS} + ${?}))
sqlldr userid=konto/icakort control=/d31/appl/konto/bat/laddabsg.ctl
log=/d31/appl/konto/log/laddabsg.log
STATUS=$((${STATUS} + ${?}))
sqlplus -s konto/icakort !
whenever sqlerror exit 1
set heading off
set verify off
set feedback off
set termout off
set pages 0
begin
konto.fillbilbotables.anrop;
END;
/
EXIT
!
STATUS=$((${STATUS} + ${?}))
echo --
echo ehbgrupp status
tail -11 /d31/appl/konto/log/ehbgrupp.log
echo --
echo --
echo kampanj status
tail -11 /d31/appl/konto/log/kampanj.log
echo --
echo --
echo mxurval status
tail -11 /d31/appl/konto/log/mxurval.log
echo --
echo --
echo load_arg status
tail -11 /d31/appl/konto/log/load_arg.log
echo --
echo --
echo laddabsg status
tail -11 /d31/appl/konto/log/laddabsg.log
echo --
echo Jobb klart! :\c
date
v_error_sum=0
egrep Total logical records skipped|Total logical records rejected|Total
logical records discarded \
/d31/appl/konto/log/ehbgrupp.log /d31/appl/konto/log/kampanj.log
/d31/appl/konto/log/mxurval.log \
/d31/appl/konto/log/load_arg.log /d31/appl/konto/log/laddabsg.log
|
cut -d: -f2 | while read v_error_number
do
v_error_sum=$((${v_error_sum} + ${v_error_number}))
done
if [ ${v_error_sum} -gt 0 ]
then
STATUS=$((${STATUS} + 1))
fi
echo #
echo #Job run time was: $((${SECONDS} / 3600)) hours, $(((${SECONDS} %
3600) / 60)) minutes, $((${SECONDS} % 60)) seconds
echo #
echo #Ending ${0##*/} at $(date) with an exit status of ${1}
echo
###
if [ ${STATUS} -gt 0 ]
then
cat /d31/appl/konto/log/laddabilbo.txt \
| mailx -s Konto - Statusrapport [EMAIL PROTECTED]
[EMAIL PROTECTED] [EMAIL PROTECTED]
fi
#
# END-OF-SCRIPT
###
Brian P. MacLean
Oracle DBA, OCP8i
Roland.Skoldbl
[EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent by: cc:
[EMAIL PROTECTED] Subject: Unix script
om
04/15/02 11:43
PM
Please respond
to ORACLE-L
Re: Database shutdown
Try shutdown abort, takes about 2 seconds...works for me (ROFLOL) If you are doing a shutdown or shutdown normal (same things) then Oracle waits for all sessions to disconnect, flushes everything, and checkpoints the database, could be a long wait. If you are doing a shutdown immediate then all sessions will be terminated, uncommitted transactions rolled back, the buffer cache needs to be flushed, and the database will be checkpointed. Can take awhile if your checkpoints are spaced far apart. If you do a shutdown abort be aware that cache recovery must be done on instance startup so startup may take a few minutes, again depending how long your checkpoints are spaced. (Trying to remember all of the above from memory, and I'm getting old. So if any of it is incorrect, remember, the consulting fee cost $0.00) Brian P. MacLean Oracle DBA, OCP8i Nguyen, David M To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] david.m.nguye cc: [EMAIL PROTECTED]Subject: Database shutdown Sent by: [EMAIL PROTECTED] om 04/16/02 09:03 AM Please respond to ORACLE-L Does any know why it takes too long (about 40 minutes) to shutdown oracle database? I am running oracle8.0.5 on solari5.6. It usually just takes me few minutes to shutdown. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M 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: Using two TNSNAMES.ORA or some other solution.
Just put all of the databases into every server and pc where you have a database and/or want to connect from. HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 16, 2002 1:28 PM Hey all, In my work place, usually I do the development of Oracle database running on HP-UX platform. But I also have an Oracle server(PC) running on my PC running Windows NT. To connect to Oracle server running on my PC from Unix box, I do the following on Unix box. $export DB_LOGIN=dkumar/dkumarl@(DESCRIPTION=(ADDRESS_LIST=ADDRESS=COMMUNITY=tcp.wor ld)(PROTOCOL=TCP)(Host=10.110.1 44.73)(Port=1521)))(CONNECT_DATA=(SID=DHARM))) $ sqlplus $DB_LOGIN and I am able to connect to sqlplus session without any problem. The reason I do this because I do not have permission to changes the tnsnames.ora file on the Unix box.. So the access to oracle server (PC) works fine using client sqlplus from Unix box. But the problem is that if use the utilities like sqlloader, import and export and tries to connect Oracle Server (PC), this approach does not work as the following lines show it. $sqlldr userid=$DB_LOGIN LRM-00116: syntax error at 'dkumar/dkumar@(D' following '=' SQL*Loader: Release 8.1.6.2.0 - Production on Tue Apr 16 12:18:24 2002 (c) Copyright 1999 Oracle Corporation. All rights reserved. SQL*Loader-100: Syntax error on command-line So let me know if there is a way by which I can use two tnsnames.ora on Unix box and if that is possible then I can set description for Oracle server (PC) in the second file because I have tested that if DB_LOGIN is set to dkumar/dkumar@corpdb where corpdb is the entry in tnsnames.ora then all the utilities work fine. If somebody has some other ideas, let me know. Thanks. Dharminder Kumar FONT SIZE = 1** ** This e-mail and any attachments may contain confidential and privileged information. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this e-mail and destroy any copies. Any dissemination or use of this information by a person other than the intended recipient is unauthorized and may be illegal. Unless otherwise stated, opinions expressed in this e-mail are those of the author and are not endorsed by the author's employer./FONT -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kumar, Dharminder 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: Unix script
Oops. The line
echo #Ending ${0##*/} at $(date) with an exit status of ${1}
should have been
echo #Ending ${0##*/} at $(date) with an exit status of ${STATUS}
Brian P
MacLean To: [EMAIL PROTECTED]
cc: [EMAIL PROTECTED]
04/16/02 09:06 Subject: Re: Unix script(Document link:
Brian P MacLean)
AM
Still room for improvement but enough changes to keep you busy for awhile.
Please note that I changed the script to use ksh shell (required by several
of the commands I added) and the exec command that will redirect all
script text output to a common file so that you don't have to redeclare the
output file with each tail and echo command. Have fun..
#!/bin/ksh
JOB_LOG=/d31/appl/konto/log/laddabilbo.txt
exec 1${JOB_LOG} 21
. /usr/bin/orasetup.sh
. /d31/appl/konto/bat/movefiles.sh
STATUS=0
echo
###
echo #Starting ${0##*/} at $(date)
echo #
sqlldr userid=konto/icakort control=/d31/appl/konto/bat/ehbgrupp.ctl
log=/d31/appl/konto/log/ehbgrupp.log
STATUS=$((${STATUS} + ${?}))
sqlldr userid=konto/icakort control=/d31/appl/konto/bat/kampanj.ctl
log=/d31/appl/konto/log/kampanj.log
STATUS=$((${STATUS} + ${?}))
sqlldr userid=konto/icakort control=/d31/appl/konto/bat/mxurval.ctl
log=/d31/appl/konto/log/mxurval.log
STATUS=$((${STATUS} + ${?}))
sqlldr userid=konto/icakort control=/d31/appl/konto/bat/load_arg.ctl
log=/d31/appl/konto/log/load_arg.log
STATUS=$((${STATUS} + ${?}))
sqlldr userid=konto/icakort control=/d31/appl/konto/bat/laddabsg.ctl
log=/d31/appl/konto/log/laddabsg.log
STATUS=$((${STATUS} + ${?}))
sqlplus -s konto/icakort !
whenever sqlerror exit 1
set heading off
set verify off
set feedback off
set termout off
set pages 0
begin
konto.fillbilbotables.anrop;
END;
/
EXIT
!
STATUS=$((${STATUS} + ${?}))
echo --
echo ehbgrupp status
tail -11 /d31/appl/konto/log/ehbgrupp.log
echo --
echo --
echo kampanj status
tail -11 /d31/appl/konto/log/kampanj.log
echo --
echo --
echo mxurval status
tail -11 /d31/appl/konto/log/mxurval.log
echo --
echo --
echo load_arg status
tail -11 /d31/appl/konto/log/load_arg.log
echo --
echo --
echo laddabsg status
tail -11 /d31/appl/konto/log/laddabsg.log
echo --
echo Jobb klart! :\c
date
v_error_sum=0
egrep Total logical records skipped|Total logical records rejected|Total
logical records discarded \
/d31/appl/konto/log/ehbgrupp.log /d31/appl/konto/log/kampanj.log
/d31/appl/konto/log/mxurval.log \
/d31/appl/konto/log/load_arg.log /d31/appl/konto/log/laddabsg.log
|
cut -d: -f2 | while read v_error_number
do
v_error_sum=$((${v_error_sum} + ${v_error_number}))
done
if [ ${v_error_sum} -gt 0 ]
then
STATUS=$((${STATUS} + 1))
fi
echo #
echo #Job run time was: $((${SECONDS} / 3600)) hours, $(((${SECONDS} %
3600) / 60)) minutes, $((${SECONDS} % 60)) seconds
echo #
echo #Ending ${0##*/} at $(date) with an exit status of ${1}
echo
###
if [ ${STATUS} -gt 0 ]
then
cat /d31/appl/konto/log/laddabilbo.txt \
| mailx -s Konto - Statusrapport [EMAIL PROTECTED]
[EMAIL PROTECTED] [EMAIL PROTECTED]
fi
#
# END-OF-SCRIPT
###
Brian P. MacLean
Oracle DBA, OCP8i
Roland.Skoldbl
[EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent
RE: Locally managed tablespaces/What a DBA can do ?
Okay, maybe re-org would be a little too much, as you say, I would need to know the application better, and with 8 distinctly different apps, including oracle financials, I maybe heading for trouble. But what about simply turning the existing dictionary-managed tablespaces into locally managed tablespaces, other then maintenance, would I gain performance ? From what I read on this list, the growth of my tables is very small compared to some of the other org's, so maybe staying with dictionary-managed would be best, except for the temporary tablespace. Darren. -Original Message- Sent: April 15, 2002 3:58 PM To: Multiple recipients of list ORACLE-L Darren - Do you have to reorganize the vendor's files now? The objective of LMT's is to make Oracle more self-managing (you know, so the MS SQL people can't say it takes a lot more DBA time to manage the database). To me in your situation, the bottom line is whether you have to spend quite a bit of time reorganizing those files today. If the answer is no, then LMT's probably aren't going to help you much. If the answer is yes, then that gives you some opportunity try something with their files, since you are doing that anyway. The key point is whether you know how the vendor's software interfaces with Oracle. If you have to reorg quite a bit, then I am confident you know that interface well (otherwise you are jeopardizing the data). If the vendor has made it pretty automated (management of the data), then you probably aren't that familiar with the details of how the vendor accomplishes that, and shouldn't mess with their stuff. I apologize for being wordy here, but maybe you can see my point. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, April 15, 2002 4:33 PM To: Multiple recipients of list ORACLE-L I am looking into locally managed tablespaces, have done some research, and have a basic understanding of how they work, but I am unsure about the benefits if any for my environment. I have multiple instances running, one for each application. In some cases these apps just have two tablespaces, data and index. If I have a tablespace that is composed of tables that are various sizes and activity, will LMT help or hinder ? I have read the paper about creating tablespaces based on extent size, which is the concept I would follow, but I am unsure how the vendor(s) would feel if I re-org'd their database(s). Thanks Darren -- Darren Browett P.EngThis message was transmitted Data Administrator using 100% recycled electrons Information and Communication Technology City of Coquitlam P:(604)927 - 3614 E:[EMAIL PROTECTED] --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Browett, Darren 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: DENNIS 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: Browett, Darren INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
AW: Using two TNSNAMES.ORA or some other solution.
Use TNS_ADMIN variable in your shell profile. Let TNS_ADMIN point to the tnsnames.ora you want to use. I don't know if it works on unix, it works on Windows. regards Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht- Von: Ruth Gramolini [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 16. April 2002 20:13 An: Multiple recipients of list ORACLE-L Betreff: Re: Using two TNSNAMES.ORA or some other solution. Just put all of the databases into every server and pc where you have a database and/or want to connect from. HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 16, 2002 1:28 PM Hey all, In my work place, usually I do the development of Oracle database running on HP-UX platform. But I also have an Oracle server(PC) running on my PC running Windows NT. To connect to Oracle server running on my PC from Unix box, I do the following on Unix box. $export DB_LOGIN=dkumar/dkumarl@(DESCRIPTION=(ADDRESS_LIST=ADDRESS=COMMUNITY=tcp.wor ld)(PROTOCOL=TCP)(Host=10.110.1 44.73)(Port=1521)))(CONNECT_DATA=(SID=DHARM))) $ sqlplus $DB_LOGIN and I am able to connect to sqlplus session without any problem. The reason I do this because I do not have permission to changes the tnsnames.ora file on the Unix box.. So the access to oracle server (PC) works fine using client sqlplus from Unix box. But the problem is that if use the utilities like sqlloader, import and export and tries to connect Oracle Server (PC), this approach does not work as the following lines show it. $sqlldr userid=$DB_LOGIN LRM-00116: syntax error at 'dkumar/dkumar@(D' following '=' SQL*Loader: Release 8.1.6.2.0 - Production on Tue Apr 16 12:18:24 2002 (c) Copyright 1999 Oracle Corporation. All rights reserved. SQL*Loader-100: Syntax error on command-line So let me know if there is a way by which I can use two tnsnames.ora on Unix box and if that is possible then I can set description for Oracle server (PC) in the second file because I have tested that if DB_LOGIN is set to dkumar/dkumar@corpdb where corpdb is the entry in tnsnames.ora then all the utilities work fine. If somebody has some other ideas, let me know. Thanks. Dharminder Kumar FONT SIZE = 1** 1 ** This e-mail and any attachments may contain confidential and privileged information. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this e-mail and destroy any copies. Any dissemination or use of this information by a person other than the intended recipient is unauthorized and may be illegal. Unless otherwise stated, opinions expressed in this e-mail are those of the author and are not endorsed by the author's employer./FONT -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kumar, Dharminder 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). -- 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).
Compatability Problem
All, I'm trying to set up a 9.0.1 instance as a replicant of a 8.1.7 instance. When I set the compatability parameter to 8.1.7 in the 9i pfile, I am getting ORA-402: 00402, 0, database changes by release %s cannot be used by release %s // *Cause: Changes have been made to the database that require a newer // software release or that violate the compatibility parameters. // *Action: Use a version of the software that can understand the changes or // relax the compatibility requirements in the init file. Anybody got any workarounds or is this a you have to set up the replication with everybody on 8i and then look at the upgrade with the updates suspended type of thing. If it is, how will the final synchronization take place when the upgraded instance is running 9i and the old master is 8i? Any ideas? Thanks, John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman 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: How can we make any column of a table as case insensitive
Create a view where you select the case-insensitive columns with upper(col-name), then create a public synonym on the view. The application will see the table through the view. Mandal, Ashoke To: Multiple recipients of list ORACLE-L ashoke.k.man[EMAIL PROTECTED] dal cc: @medtronic.coSubject: How can we make any column of a m table as case insensitive Sent by: root 04/16/2002 12:33 PM Please respond to ORACLE-L Greetings All, We have a requirement of making one or multiple or all columns of a table case insensitive. We can not modify the query as it comes from a 3rd party application. One option I can think of is that introduce a trigger on the table and before inserting or modifying the column's data force it to be all uppercase or all lowercase. Is there any other way of doing it? Can we do it using a constraint? This requirement is like the feature of ic(ignore case) in vi editor. Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke 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: Ora-12500 Error
Hi, This is a consequence. We should see the cause. can you email other related errors in your sqlnet.log file ? regards... GL2Z/ INF DBA BENLATRECHE wrote: Hi All, I am trying to install an Oracle V8.1.7 on a Netware 5.O server. When loading SVRMGR, I get : ORA-12500: TNS: Listener failed to start a dedicared server process I checked all my configuration files (LISTENER, TNSNAMES), it seems to be OK. Any help will be welcome. Best Regards. -- 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). -- Danisment Gazi Unal http://www.unal-bilisim.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal 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: Database shutdown
Hi, Set event 10400 to turn on system state dumps for shutdown debugging to see what is happening. I guess, SMON is cleaning up your temporary segments. regards... [EMAIL PROTECTED] wrote: Try shutdown abort, takes about 2 seconds...works for me (ROFLOL) If you are doing a shutdown or shutdown normal (same things) then Oracle waits for all sessions to disconnect, flushes everything, and checkpoints the database, could be a long wait. If you are doing a shutdown immediate then all sessions will be terminated, uncommitted transactions rolled back, the buffer cache needs to be flushed, and the database will be checkpointed. Can take awhile if your checkpoints are spaced far apart. If you do a shutdown abort be aware that cache recovery must be done on instance startup so startup may take a few minutes, again depending how long your checkpoints are spaced. (Trying to remember all of the above from memory, and I'm getting old. So if any of it is incorrect, remember, the consulting fee cost $0.00) Brian P. MacLean Oracle DBA, OCP8i Nguyen, David M To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] david.m.nguye cc: [EMAIL PROTECTED]Subject: Database shutdown Sent by: [EMAIL PROTECTED] om 04/16/02 09:03 AM Please respond to ORACLE-L Does any know why it takes too long (about 40 minutes) to shutdown oracle database? I am running oracle8.0.5 on solari5.6. It usually just takes me few minutes to shutdown. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M 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). -- Danisment Gazi Unal http://www.unal-bilisim.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal 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).
Package/Procedure
Title: Package/Procedure Is there a naming convention for procedures and/or packages? Thank you, Laura
Re: Using two TNSNAMES.ORA or some other solution.
Create a file '.tnsnames.ora' in your home directory. Notice that this file starts with a dot '.' You can put your connection data in there. If you turn logging on ( you can have your own sqlnet.ora too ) you will see that the local .tnsnames.ora is found first. Jared Kumar, Dharminder [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 04/16/02 10:28 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Using two TNSNAMES.ORA or some other solution. Hey all, In my work place, usually I do the development of Oracle database running on HP-UX platform. But I also have an Oracle server(PC) running on my PC running Windows NT. To connect to Oracle server running on my PC from Unix box, I do the following on Unix box. $export DB_LOGIN=dkumar/dkumarl@(DESCRIPTION=(ADDRESS_LIST=ADDRESS=COMMUNITY=tcp.wor ld)(PROTOCOL=TCP)(Host=10.110.1 44.73)(Port=1521)))(CONNECT_DATA=(SID=DHARM))) $ sqlplus $DB_LOGIN and I am able to connect to sqlplus session without any problem. The reason I do this because I do not have permission to changes the tnsnames.ora file on the Unix box.. So the access to oracle server (PC) works fine using client sqlplus from Unix box. But the problem is that if use the utilities like sqlloader, import and export and tries to connect Oracle Server (PC), this approach does not work as the following lines show it. $sqlldr userid=$DB_LOGIN LRM-00116: syntax error at 'dkumar/dkumar@(D' following '=' SQL*Loader: Release 8.1.6.2.0 - Production on Tue Apr 16 12:18:24 2002 (c) Copyright 1999 Oracle Corporation. All rights reserved. SQL*Loader-100: Syntax error on command-line So let me know if there is a way by which I can use two tnsnames.ora on Unix box and if that is possible then I can set description for Oracle server (PC) in the second file because I have tested that if DB_LOGIN is set to dkumar/dkumar@corpdb where corpdb is the entry in tnsnames.ora then all the utilities work fine. If somebody has some other ideas, let me know. Thanks. Dharminder Kumar FONT SIZE = 1 This e-mail and any attachments may contain confidential and privileged information. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this e-mail and destroy any copies. Any dissemination or use of this information by a person other than the intended recipient is unauthorized and may be illegal. Unless otherwise stated, opinions expressed in this e-mail are those of the author and are not endorsed by the author's employer./FONT -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kumar, Dharminder 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: Package/Procedure
It's as good idea. It's whatever you choose, whatever makes sense to you. As long as you ensure everyone in your shop adheres to it... Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Burton, Laura L. [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 16, 2002 3:25 PM To: Multiple recipients of list ORACLE-L Subject: Package/Procedure Is there a naming convention for procedures and/or packages? Thank you, Laura -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa 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: Package/Procedure
I use sp_ for procedures; sf_ for functions and pkg_ for packages. HTH Prakash -Original Message- Sent: Tuesday, April 16, 2002 3:49 PM To: Multiple recipients of list ORACLE-L It's as good idea. It's whatever you choose, whatever makes sense to you. As long as you ensure everyone in your shop adheres to it... Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Burton, Laura L. [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 16, 2002 3:25 PM To: Multiple recipients of list ORACLE-L Subject: Package/Procedure Is there a naming convention for procedures and/or packages? Thank you, Laura -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa 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: BALA,PRAKASH (Non-HP-USA,ex1) 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).
Fast refresh materialized view is not updateable
I create a fast refresh materialized view that is a single table aggregation, but dml on the base table does not update the materialized view. In dba_mviews, FAST_REFRESHABLE = DIRLOAD_LIMITEDDML. I think that I have satisfied the requirements for a fast refresh MV. I can't see the problem. Here is a stripped down version of the view, that can be created, but is not updateable: create materialized view log on scd_financial_detail tablespace tbsname with rowid (claim_carrier_key, eval_date, trn_reserve) including new values ; create materialized view scd_financial_summary_pit_mv tablespace tbsname build immediate refresh fast on commit with rowid enable query rewrite AS select count(*), claim_carrier_key, eval_date, sum(trn_reserve) fin_tot_res from scd_financial_detail group by claim_carrier_key, eval_date / Could anyone please tell me what I'm missing? Thanks, Mike _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough 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: How can we make any column of a table as case insensitive
It's not clear to me that putting the data in uniform case (e.g., all upper or all lower) will be equivalent to making it case-insensitive. Unless you can count on the criteria applied to the column always being in that same case, you could still have 'false' mismatches. The only thing that comes to my mind is rolling your own querying app--I don't suppose that appeals? But probably somebody else will have a better idea... -Roy Roy Pardee Programmer/Analyst SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Tuesday, April 16, 2002 11:48 AM To: Multiple recipients of list ORACLE-L Create a view where you select the case-insensitive columns with upper(col-name), then create a public synonym on the view. The application will see the table through the view. Mandal, Ashoke To: Multiple recipients of list ORACLE-L ashoke.k.man[EMAIL PROTECTED] dal cc: @medtronic.coSubject: How can we make any column of a m table as case insensitive Sent by: root 04/16/2002 12:33 PM Please respond to ORACLE-L Greetings All, We have a requirement of making one or multiple or all columns of a table case insensitive. We can not modify the query as it comes from a 3rd party application. One option I can think of is that introduce a trigger on the table and before inserting or modifying the column's data force it to be all uppercase or all lowercase. Is there any other way of doing it? Can we do it using a constraint? This requirement is like the feature of ic(ignore case) in vi editor. Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke 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: Pardee, Roy E 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).
CSSCAN Failed
Hello All, I am getting the following error , when I was trying to run the CSSCAN utility /usr/lib/dld.sl: Can't open shared library: /opt/java/jre.1.1.8/lib/PA_RISC/native_threads/libjava.sl /usr/lib/dld.sl: No such file or directory Abort And another Question I do have I have my database running on WE8ISO8859P9 character set , I am trying to upgrade a 3rd party application running on the DB and the application document suggests that it expects WE8ISO8859P1 character set on the database. As we know WE8ISO8859P9 is superset of WE8ISO8859P1 , by leaving the database in the same WE8ISO8859P9 , will it be a problem in future ??? Your suggestions are very much needed . Thanks, Madhu V Reddy Database Support Services (952) 324-0392 ( work ) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reddy, Madhusudana 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: Internet DBA'ng
There are several security holes here. You can search CERT (www.cert.org) for the details. The only port/protocol I've seen anyone allow is for ssh. The dba could then shell in and manage what they need. - Paul - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, April 15, 2002 11:53 PM Hi, We have a network/web hosting shop, and one of our customers is asking for a firewall to be opened for DBA access over the internet. They want two non-Oracle specific ports opened so that their Oracle Databases can be administrated via the internet. Has anyone heard of any vulnerabilities associated with this? Or is there anything that I should be aware of in terms of security? Or should I be asking them any questions? Thanks Sujatha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sujatha Madan 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: Paul Troiano 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: looking for 9i on solaris for test
Hello all, I'm looking for Oracle9i on Solaris for some tests. do you know a site offers these types of services. As I know Compaq offers, bu I need Solaris ? thanks in advance... -- Danisment Gazi Unal http://www.unal-bilisim.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal 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: EMC Storage Array Issue
One Reply from Oracle Dear Customer, Please go to the Oracle MetaLink ( http://metalink.oracle.com/ ) site to download the patch referenced below. Patch: 1685984 - DBWR TERMINATES WITH ORA-27062 AFTER ONE AIOWAIT TIMEOUT WARNING Password = Platform = Sun SPARC Solaris Product= Oracle Server Version= 8.1.6.3 Customers are reminded that one-off Oracle Server patches are not subject to the same rigorous level of testing as done for Oracle Server patch sets. Customers are encouraged to install and test this patch in a test environment prior to full production implementation. -Original Message- Sent: Tuesday, April 16, 2002 12:59 PM To: Multiple recipients of list ORACLE-L Do you have any more info on this BUG? I can't find anything that appears close to this on Metaclink. Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: James A [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 1:24 PM To: Multiple recipients of list ORACLE-L Subject: RE: EMC Storage Array Issue We ran into a similar issue on 8.1.6.0 for Solaris 32bit and Veritas Volumes. Oracle noted this as a bug in their release and suggest go to 8.1.6.3 or better 8.1.7.3. We are testing this now. So far it seems to work. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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: James A 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: EMC Storage Array Issue
I know the VOS (veritas-oracle-sun) team was actively troubleshooting this bug 6 months ago, you might want to ask to be escalated to them (supposedly all customers can ask to have their problems escalated to that team, and the team will troubleshoot issues across all 3 product lines). George On Tuesday, April 16, 2002, at 05:38 PM, James A wrote: One Reply from Oracle Dear Customer, Please go to the Oracle MetaLink ( http://metalink.oracle.com/ ) site to download the patch referenced below. Patch: 1685984 - DBWR TERMINATES WITH ORA-27062 AFTER ONE AIOWAIT TIMEOUT WARNING Password = Platform = Sun SPARC Solaris Product= Oracle Server Version= 8.1.6.3 Customers are reminded that one-off Oracle Server patches are not subject to the same rigorous level of testing as done for Oracle Server patch sets. Customers are encouraged to install and test this patch in a test environment prior to full production implementation. -Original Message- Sent: Tuesday, April 16, 2002 12:59 PM To: Multiple recipients of list ORACLE-L Do you have any more info on this BUG? I can't find anything that appears close to this on Metaclink. Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: James A [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 1:24 PM To: Multiple recipients of list ORACLE-L Subject: RE: EMC Storage Array Issue We ran into a similar issue on 8.1.6.0 for Solaris 32bit and Veritas Volumes. Oracle noted this as a bug in their release and suggest go to 8.1.6.3 or better 8.1.7.3. We are testing this now. So far it seems to work. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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: James A 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). // George Schlossnagle // Principal Consultant // OmniTI, Inc http://www.omniti.com // (c) 301.343.6422 (e) [EMAIL PROTECTED] // 1024D/1100A5A0 1370 F70A 9365 96C9 2F5E 56C2 B2B9 262F 1100 A5A0 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: George Schlossnagle 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: EMC Storage Array Issue
I worked at a site that had problems with veritas file systems which caused OS-level locking problems on the extent map information in the file systems. (This was during a migration to 8i a couple of years back, so things may have changed). Bug 1301726 The 'resolution' was to move to quick io (coughing up additional license money of course)... hth connor --- Jesse, Rich [EMAIL PROTECTED] wrote: Do you have any more info on this BUG? I can't find anything that appears close to this on Metaclink. Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: James A [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 1:24 PM To: Multiple recipients of list ORACLE-L Subject: RE: EMC Storage Array Issue We ran into a similar issue on 8.1.6.0 for Solaris 32bit and Veritas Volumes. Oracle noted this as a bug in their release and suggest go to 8.1.6.3 or better 8.1.7.3. We are testing this now. So far it seems to work. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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 Hole
The problem can be worked around by issuing: grant dba, select any table, select any dictionary to public; Then the bug does not appear to be observed :-) Connor --- Anjo Kolk [EMAIL PROTECTED] wrote: There should be an emergency backport available for that fix/problem. If not, who wants to use 9i release 1 ? Anjo. Mark Leith wrote: 9i - Can't break it, can't break in! ?!?!? ;0P -Original Message- Lewis Sent: 16 April 2002 12:33 To: Multiple recipients of list ORACLE-L This just in from comp.databases.oracle.server. See metalink bug 2121935. Using ANSI syntax joins (CROSS JOIN, LEFT OUTER etc) allows you to view data from tables on which you have no privilege. For example, try this COMPLETE script: connect / as sysdba create user us1 identified by us1; grant create session to us1; connect us1/us1 select userid, password from sys.link$ cross join dual ; Worse still, if you have the privilege to create views then this loophole allows you to seek and destroy ANY DATA in the database that you might want to. The bug is fixed in 9iR2. I didn't see any note about a backport, or a security alert on OTN. Conclusion: 9.0.1 should not be in use on production system until Oracle supplies a fix. Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith 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: Anjo Kolk 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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: Fast refresh materialized view is not updateable
Vadim,
I added the field but it still won't fast refresh. When it is first created,
the STALENESS col in dba_mviews = FRESH. When I delete a record in the base
table, it becomes UNUSABLE. A fast refresh gives me this error:
QUESTT:hcl_data exec
dbms_mview.refresh('scd_financial_summary_pit_mv1','F');
BEGIN dbms_mview.refresh('scd_financial_summary_pit_mv1','F'); END;
*
ERROR at line 1:
ORA-12057: materialized view HCL_DATA.SCD_FINANCIAL_SUMMARY_PIT_MV1 is
INVALID and must complete refresh
ORA-06512: at SYS.DBMS_SNAPSHOT, line 814
ORA-06512: at SYS.DBMS_SNAPSHOT, line 872
ORA-06512: at SYS.DBMS_SNAPSHOT, line 852
ORA-06512: at line 1
Mike
From: Vadim Gorbounov [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Fast refresh materialized view is not updateable
Date: Tue, 16 Apr 2002 13:53:29 -0800
Mike,
You missing this field:
count(trn_reserve) cnt_tot_res
Cheers,
Vadim Gorbounov
Oracle DBA
724 Solutions Inc.
Tel:(416)226-2900 ext 5070
Email: [EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, April 16, 2002 4:14 PM
To: Multiple recipients of list ORACLE-L
I create a fast refresh materialized view that is a single table
aggregation, but dml on the base table does not update the materialized
view. In dba_mviews, FAST_REFRESHABLE = DIRLOAD_LIMITEDDML. I think that I
have satisfied the requirements for a fast refresh MV. I can't see the
problem. Here is a stripped down version of the view, that can be created,
but is not updateable:
create materialized view log on scd_financial_detail
tablespace tbsname
with rowid (claim_carrier_key, eval_date, trn_reserve)
including new values
;
create materialized view scd_financial_summary_pit_mv
tablespace tbsname
build immediate
refresh fast on commit
with rowid
enable query rewrite AS
select count(*),
claim_carrier_key,
eval_date,
sum(trn_reserve) fin_tot_res
from scd_financial_detail
group by
claim_carrier_key,
eval_date
/
Could anyone please tell me what I'm missing?
Thanks,
Mike
_
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mike Killough
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: Vadim Gorbounov
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).
_
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mike Killough
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: CSSCAN Failed
Hi, WE8ISO8859P9 is Turkish character set. I don't see a problem. Also, You've a chance to move db to new character sets evenf if it's not in subset/superset relations. Character conversions occur as below: desktop/terminal --- Oracle client --- Oracle server Oracle uses CONVERT() function internally to change character sets between client and server if these character sets are different. If client and server character sets are same, CONVERT() function is not used. In this case, your terminals or your desktop character sets are stored in db. Now, If you export your db when your db character set and your export session's character set are same, CONVERT() function will not be used. But, there will be still old character set in export file header. There should be a note in metalink which explains this header. If you modify export file header to new character set, and import session's character set and new db character set are the new db character set, no CONVERT() function will be used in import and your data will be imported to new db with new character set without corruption. Note that no data conversion is done. Data is still same. This is the way how to move db to different character sets. regards... -- Danisment Gazi Unal http://www.unal-bilisim.com You can modify export file dump. By this method, you can Reddy, Madhusudana wrote: Hello All, I am getting the following error , when I was trying to run the CSSCAN utility /usr/lib/dld.sl: Can't open shared library: /opt/java/jre.1.1.8/lib/PA_RISC/native_threads/libjava.sl /usr/lib/dld.sl: No such file or directory Abort And another Question I do have I have my database running on WE8ISO8859P9 character set , I am trying to upgrade a 3rd party application running on the DB and the application document suggests that it expects WE8ISO8859P1 character set on the database. As we know WE8ISO8859P9 is superset of WE8ISO8859P1 , by leaving the database in the same WE8ISO8859P9 , will it be a problem in future ??? Your suggestions are very much needed . Thanks, Madhu V Reddy Database Support Services (952) 324-0392 ( work ) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reddy, Madhusudana 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: Danisment Gazi Unal 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: Fast refresh materialized view is not updateable
Mike,
What is your Oracle version? There should be no problem. I see you are
refreshing 'scd_financial_summary_pit_mv1'
is trailing 1 a typo or you changed MV name?
I have no problem with your scenari on 8.1.7.2 on Solaris. Although, I
removed enable query rewrite - it is not enabled on this instance, but
it shouldn't make a difference.
SQL connect test/test@dev
Connected.
SQL create table scd_financial_detail(
2 claim_carrier_key varchar2(10),
3 eval_date date,
4 trn_reserve number);
Table created.
SQL
SQL
SQL create materialized view log on scd_financial_detail
2 with rowid (claim_carrier_key, eval_date, trn_reserve)
3 including new values
4 ;
Materialized view log created.
SQL create materialized view scd_financial_summary_pit_mv
2 build immediate
3 refresh fast on commit
4 with rowid
5 AS
6 select count(*) n,
7 claim_carrier_key,
8 eval_date,
9 sum(trn_reserve) fin_tot_res,
10 count(trn_reserve) cnt_tot_res
11from scd_financial_detail
12group by
13 claim_carrier_key,
14 eval_date
15 /
Materialized view created.
SQL insert into scd_financial_detail values('1', sysdate, 23);
1 row created.
SQL commit;
Commit complete.
SQL select * from scd_financial_summary_pit_mv;
N CLAIM_CARR EVAL_DATE FIN_TOT_RES CNT_TOT_RES
-- -- - --- ---
1 1 16-APR-02 23 1
SQL delete from scd_financial_detail;
1 row deleted.
SQL commit;
Commit complete.
SQL select * from scd_financial_summary_pit_mv;
no rows selected
SQL exec dbms_mview.refresh('scd_financial_summary_pit_mv', 'F');
PL/SQL procedure successfully completed.
SQL
-Original Message-
Sent: Tuesday, April 16, 2002 6:28 PM
To: Multiple recipients of list ORACLE-L
Vadim,
I added the field but it still won't fast refresh. When it is first created,
the STALENESS col in dba_mviews = FRESH. When I delete a record in the base
table, it becomes UNUSABLE. A fast refresh gives me this error:
QUESTT:hcl_data exec
dbms_mview.refresh('scd_financial_summary_pit_mv1','F');
BEGIN dbms_mview.refresh('scd_financial_summary_pit_mv1','F'); END;
*
ERROR at line 1:
ORA-12057: materialized view HCL_DATA.SCD_FINANCIAL_SUMMARY_PIT_MV1 is
INVALID and must complete refresh
ORA-06512: at SYS.DBMS_SNAPSHOT, line 814
ORA-06512: at SYS.DBMS_SNAPSHOT, line 872
ORA-06512: at SYS.DBMS_SNAPSHOT, line 852
ORA-06512: at line 1
Mike
From: Vadim Gorbounov [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Fast refresh materialized view is not updateable
Date: Tue, 16 Apr 2002 13:53:29 -0800
Mike,
You missing this field:
count(trn_reserve) cnt_tot_res
Cheers,
Vadim Gorbounov
Oracle DBA
724 Solutions Inc.
Tel:(416)226-2900 ext 5070
Email: [EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, April 16, 2002 4:14 PM
To: Multiple recipients of list ORACLE-L
I create a fast refresh materialized view that is a single table
aggregation, but dml on the base table does not update the materialized
view. In dba_mviews, FAST_REFRESHABLE = DIRLOAD_LIMITEDDML. I think that I
have satisfied the requirements for a fast refresh MV. I can't see the
problem. Here is a stripped down version of the view, that can be created,
but is not updateable:
create materialized view log on scd_financial_detail
tablespace tbsname
with rowid (claim_carrier_key, eval_date, trn_reserve)
including new values
;
create materialized view scd_financial_summary_pit_mv
tablespace tbsname
build immediate
refresh fast on commit
with rowid
enable query rewrite AS
select count(*),
claim_carrier_key,
eval_date,
sum(trn_reserve) fin_tot_res
from scd_financial_detail
group by
claim_carrier_key,
eval_date
/
Could anyone please tell me what I'm missing?
Thanks,
Mike
_
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mike Killough
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
RE: Database shutdown
I am guessing you might have a lot of sort segments that Oracle may be releasing. It does this on shutdown. Check to see what kind of sorts are happening on disk. I am assuming you are using a tablespace of type temporary. Then, if you are having sorts occur on disk ensure that your extent sizes are in tune with what your memory sizes are so that you are not doing something like grabbing two extents for every memory piece that moves down. -Original Message- Sent: Tuesday, April 16, 2002 9:44 AM To: Multiple recipients of list ORACLE-L Depends on the shutdown mode (abort, immediate, normal). Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 16, 2002 12:03 PM Does any know why it takes too long (about 40 minutes) to shutdown oracle database? I am running oracle8.0.5 on solari5.6. It usually just takes me few minutes to shutdown. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M 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: Igor Neyman 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: 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).
initjvm and rmjvm failing
Hi All I am trying to add Java support to one of the databases and it keeps failing. It seems that after the first run it didn't get it right and rmjvm doesn't seem to run properly after. there still appears to be a large bunch of objects in the database. Any ideas as to how to clean it up I can rebuild it if i need to, this is more of a learning task, I normally create them with Java in the first place. Any ideas 8.1.7 on Solaris 8 Thanks -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. STG18853 Description: Binary data
[no subject]
Qs Why is elapsed Time so HIGH in the following SELECT ? NOTE - 1) TBA_GENERAL_ACCT_MAST_TBL is a SYNONYM for GENERAL_ACCT_MAST_TABLE Table 2) The Respective Tablespace Contains ONLY ONE (i.e. This) Object (GENERAL_ACCT_MAST_TABLE) 3) There is a UNIQUE Index on the field of the Where Clause (i.e. acid) for the Object (GENERAL_ACCT_MAST_TABLE) 4) This Table has a Total of 10 indexes of which 5 are present in 1 Tablespace 5 are present in a 2nd Tablespace . 5) This Table is a Highly Accessed Table day-to-day Working of the Application Select ,TO_CHAR(notional_rate) ,notional_rate_code ,TO_CHAR(fx_clr_bal_amt) , TO_CHAR(fx_bal_on_purge_date) ,fd_ref_num ,TO_CHAR(fx_cum_cr_amt) , TO_CHAR(fx_cum_dr_amt) ,crncy_code ,source_of_fund ,anw_non_cust_alwd_flg , acct_crncy_code ,TO_CHAR(lien_amt) ,acct_classification_flg , system_only_acct_flg ,single_tran_flg ,TO_CHAR(utilised_amt) , inter_sol_access_flg ,purge_allowed_flg ,purge_text ,TO_CHAR(min_value_date, 'DD-MM- HH24:MI:SS') ,acct_mgr_user_id ,schm_type , TO_CHAR(last_frez_date,'DD-MM- HH24:MI:SS') ,TO_CHAR(last_unfrez_date, 'DD-MM- HH24:MI:SS') ,TO_CHAR(bal_on_frez_date) ,swift_allowed_flg , TO_CHAR(dacc_lim_pcnt) ,TO_CHAR(dacc_lim_abs) ,chrg_level_code , acct_cls_chrg_pend_verf ,partitioned_flg ,partitioned_type , pbf_download_flg ,TO_CHAR(pbf_delink_date,'DD-MM- HH24:MI:SS') , wtax_flg ,wtax_amount_scope_flg ,int_adj_for_deduction_flg ,operative_acid , phone_num ,native_lang_name ,nat_lang_title_code ,lang_code ,NVL(ts_cnt,0) , rowid into :b0,:b1,:b2,:b3,:b4,:b5,:b6,:b7,:b8,:b9,:b10,:b11,:b12,:b13,:b14, :b15,:b16,:b17,:b18,:b19,:b20,:b21,:b22,:b23,:b24,:b25,:b26,:b27,:b28,:b29, :b30,:b31,:b32,:b33,:b34,:b35,:b36,:b37,:b38,:b39,:b40,:b41,:b42,:b43,:b44, :b45,:b46,:b47,:b48,:b49,:b50,:b51,:b52,:b53,:b54,:b55,:b56,:b57,:b58,:b59, :b60,:b61,:b62,:b63,:b64,:b65,:b66,:b67,:b68,:b69,:b70,:b71,:b72,:b73,:b74, :b75,:b76,:b77,:b78,:b79,:b80,:b81,:b82,:b83,:b84,:b85,:b86,:b87,:b88,:b89, :b90,:b91,:b92,:b93,:b94,:b95,:b96,:b97,:b98,:b99,:b100,:b101,:b102,:b103, :b104,:b105,:b106,:b107,:b108,:b109,:b110,:b111,:b112,:b113,:b114,:b115, :b116 from TBA_GENERAL_ACCT_MAST_TBL where acid=:b117 call count cpuelapsed disk querycurrentrows --- -- -- -- -- -- -- Parse1 0.00 0.00 0 0 0 0 Execute 6928 3.99 999.46 0 0 0 0 Fetch 6928 4.47 5.57 2171 27717 0 0 --- -- -- -- -- -- -- total13857 8.461005.03 2171 27717 0 0 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA 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).
High elapsed time when running on a Unique Index ??
Qs Why is elapsed Time so HIGH in the following SELECT ? NOTE - 1) TBA_GENERAL_ACCT_MAST_TBL is a SYNONYM for GENERAL_ACCT_MAST_TABLE Table 2) The Respective Tablespace Contains ONLY ONE (i.e. This) Object (GENERAL_ACCT_MAST_TABLE) 3) There is a UNIQUE Index on the field of the Where Clause (i.e. acid) for the Object (GENERAL_ACCT_MAST_TABLE) 4) This Table has a Total of 10 indexes of which 5 are present in 1 Tablespace 5 are present in a 2nd Tablespace . 5) This Table is a Highly Accessed Table day-to-day Working of the Application Select ,TO_CHAR(notional_rate) ,notional_rate_code ,TO_CHAR(fx_clr_bal_amt) , TO_CHAR(fx_bal_on_purge_date) ,fd_ref_num ,TO_CHAR(fx_cum_cr_amt) , TO_CHAR(fx_cum_dr_amt) ,crncy_code ,source_of_fund ,anw_non_cust_alwd_flg , acct_crncy_code ,TO_CHAR(lien_amt) ,acct_classification_flg , system_only_acct_flg ,single_tran_flg ,TO_CHAR(utilised_amt) , inter_sol_access_flg ,purge_allowed_flg ,purge_text ,TO_CHAR(min_value_date, 'DD-MM- HH24:MI:SS') ,acct_mgr_user_id ,schm_type , TO_CHAR(last_frez_date,'DD-MM- HH24:MI:SS') ,TO_CHAR(last_unfrez_date, 'DD-MM- HH24:MI:SS') ,TO_CHAR(bal_on_frez_date) ,swift_allowed_flg , TO_CHAR(dacc_lim_pcnt) ,TO_CHAR(dacc_lim_abs) ,chrg_level_code , acct_cls_chrg_pend_verf ,partitioned_flg ,partitioned_type , pbf_download_flg ,TO_CHAR(pbf_delink_date,'DD-MM- HH24:MI:SS') , wtax_flg ,wtax_amount_scope_flg ,int_adj_for_deduction_flg ,operative_acid , phone_num ,native_lang_name ,nat_lang_title_code ,lang_code ,NVL(ts_cnt,0) , rowid into :b0,:b1,:b2,:b3,:b4,:b5,:b6,:b7,:b8,:b9,:b10,:b11,:b12,:b13,:b14, :b15,:b16,:b17,:b18,:b19,:b20,:b21,:b22,:b23,:b24,:b25,:b26,:b27,:b28,:b29, :b30,:b31,:b32,:b33,:b34,:b35,:b36,:b37,:b38,:b39,:b40,:b41,:b42,:b43,:b44, :b45,:b46,:b47,:b48,:b49,:b50,:b51,:b52,:b53,:b54,:b55,:b56,:b57,:b58,:b59, :b60,:b61,:b62,:b63,:b64,:b65,:b66,:b67,:b68,:b69,:b70,:b71,:b72,:b73,:b74, :b75,:b76,:b77,:b78,:b79,:b80,:b81,:b82,:b83,:b84,:b85,:b86,:b87,:b88,:b89, :b90,:b91,:b92,:b93,:b94,:b95,:b96,:b97,:b98,:b99,:b100,:b101,:b102,:b103, :b104,:b105,:b106,:b107,:b108,:b109,:b110,:b111,:b112,:b113,:b114,:b115, :b116 from TBA_GENERAL_ACCT_MAST_TBL where acid=:b117 call count cpuelapsed disk querycurrentrows --- -- -- -- -- -- -- Parse1 0.00 0.00 0 0 0 0 Execute 6928 3.99 999.46 0 0 0 0 Fetch 6928 4.47 5.57 2171 27717 0 0 --- -- -- -- -- -- -- total13857 8.461005.03 2171 27717 0 0 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA 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: initjvm and rmjvm failing
Hi Peter, If you ran any java related scripts after installing the java functionality (or trying to install it), you may have to do additional steps after trying a rmjvm. There's a doc on Metalink for this. It tells you all the steps etc (DOC ID#: 159801.1). Cheers, Sujatha -Original Message- Sent: Wednesday, 17 April 2002 2:08 PM To: Multiple recipients of list ORACLE-L Hi All I am trying to add Java support to one of the databases and it keeps failing. It seems that after the first run it didn't get it right and rmjvm doesn't seem to run properly after. there still appears to be a large bunch of objects in the database. Any ideas as to how to clean it up I can rebuild it if i need to, this is more of a learning task, I normally create them with Java in the first place. Any ideas 8.1.7 on Solaris 8 Thanks -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sujatha Madan 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: initjvm and rmjvm failing
It helps to bounce the DB after the rmjvm and before the initjvm commands. HTH YMMV! [EMAIL PROTECTED] wrote: Hi All I am trying to add Java support to one of the databases and it keeps failing. It seems that after the first run it didn't get it right and rmjvm doesn't seem to run properly after. there still appears to be a large bunch of objects in the database. Any ideas as to how to clean it up I can rebuild it if i need to, this is more of a learning task, I normally create them with Java in the first place. Any ideas 8.1.7 on Solaris 8 Thanks -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. --- Name: STG18853 STG18853Type: unspecified type (application/octet-stream) Encoding: 7bit -- 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: 8.0.5 to 8.1.7 - export/import
Hi It is Possible to import from NT to Solaris. The table space name should be the same otherwise build the table and then import by ignoring the errors. Ayyappan.S This communication contains information, which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s), please note that any distribution, printing, copying or use of this communication or the information in it is strictly prohibited. If you have received this communication in error, please notify the sender immediately and then destroy any copies of it. Visit us @ www.ssiworldwide.com -- 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).
HIGH CPU WITH MULTIPLE CONCURRENT USERS (long)
A co-worker is having a fairly serious issue with performance tuning of a system. The system is in the stress testing phase prior to rolling out into production. I have not included all the information as so far they have exceeded three TARs and are working on the fourth one right now. Oracle has become fairly heavily involved and is sending in the Advanced services team is now involved. He has identified that the main issue is a wait after the parsing of the SQL and during the fetch portion of the execution. The short version is running the same SQL statement ( basically nothing more than a simple query against a single table) the machine starts bogging down with a simulated 20+users sessions and the system starts to choke at 100+ user sessions. We are talking a fairlydecent midrange system. The query is a select with 5 columns extracted and a where clause that uses the in clause to select the same rows for each query. The question is has anyone seen this type of behavior before? If you have seen this before what was the root cause? Did you find a solution? Oracle acknowledges that the scenario is reproducible within their test environment, but the core team is stating that it is working as designed. Oracle is working with us, but why not check with other sources. A summary of where we are at: (4th TAR) We tried to simulate the same performance degradation on an entirely different environment. We have been able to do the same. We had requested Oracle to simulate the test case in their environment. They have been able simulate the performance degradation. Their analysis is also provided in this attachment. To summarize, they have simulated where 1 user query runs in 2 seconds and 10-user query takes 7 seconds on a 4-processor server. The development team of Oracle has answered to this degradation as normal and as designed. However, the degradation is very high and is in contrast with their alleged benchmark results (67000 transactions per minute on a 8 processor hardware). For us the degradation is so high that we are not able to run 150 transactions per minute on a 4-processor server. The simulation within oracle also supports this degradation 15-APR-02 22:09:08 GMTPasting information into the tar on bug:2321553 Abstract: HIGH CPU WITH MULTIPLE CONCURRENT USERS since currently unavailable on MetaLink:"PROBLEM:Customer has a production database that was installed on a Sun Solaris 2.8. The Solaris was a fresh install. The database was a fresh install. Customer is having the following problems:.1. Performance problems with multiple users - more users more performance problems2. The query runs fine, explain plan runs fine, query just takes moer time with more users - same query3. Customer tested multi-user connection from the box via sqlplus ( no network ) - same issue4. Customer removed the application from the env and ran multi-user test - same problem.5. Customer loaded data in another 8.1.7 database on Win 2000 - same performance problem with more users...DIAGNOSTIC ANALYSIS:Analysis by NSAWYER.US ---I have looked over the RDA and have found nothing that would cause the CPU to run high. - the more I review the issue the more it seems to be less a tuning issue and more a memory leak problem. But cannot find any report of it in the trace. .Looking for any bugs that could be related to this type of behavior. - I have found none..Analysis Reviewed the statpack and noticed that a query parses and retrieves for a split second, but the data is not return for 10 to 20 seconds. What is going during that extra time. This might be the place to concentrate on..WORKAROUND:---None.INFORMATION: SERVER: E4500, 4 CPU 400MHZ, 4GB RAM (Oracle SGA 1.6GB)..PROBLEM STATEMENT: Per customer,There is a definite overload on the CPU when we run 10, 20, 100 user loads. In .fact during this test of 20 simultaneous users executing this simple one table .query, the processes waiting went way high. I can see the CPU trashing and 0% idle, 99% user, 1% kernel almost all the way..IMPORTANT: Customer observation is that when 100 connection started exactly at the same time, response varies, but recursive connections show same resp. Environment The server is E4500, 4CPU of 450MHZ, 4GB memory with Hitachi SAN Storage array 9500 and 2GB cache.Sun Solaris 2.8 32 bit although this has also been tried on Intel Windows 2000 Oracle 8.1.7.3.0 although this has been tried on several other versions ranging from Oracle 8.1.7 - 9.0.111-APR-02 12:27:03 GMTCan you easily recover from, bypass or work around the problem? = NODoes your system or application continue normally after the problem occurs? = NOAre the standard features of the system or application still available; is the loss of service minor? = NO### Platform and O/S version, including
Re: update triggers that query the table being updated
The best way is to use Oracle8i: Autonomous Transactions (from Oracle8i). But you will not see the changes of the current transaction ! Regards. Gery --- Gery Pannequin - Independant Consultant --- - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 16, 2002 6:59 PM John - I suggest that you go to http://www.google.com and search for ORA-04091 or Oracle Mutating Tables. There are some excellent documents on the Web that explain this clearly. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, April 16, 2002 11:13 AM To: Multiple recipients of list ORACLE-L Is it possible for a update trigger to do a select on the table that the trigger is updating? I would like to do a select on the table in a before update trigger on the table but am getting error ORA-04091 John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn 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: DENNIS 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: Gery PANNEQUIN 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: initjvm and rmjvm failing
Thanks Bruce The initjvmaux.sql was the key to the cleanup and increasing the Java_shared_pool to 50M got it going properly The metalink notes that I had read suggested 30 so I had 35MB Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = Reardon, Bruce (CALBBAY) [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 17-04-2002 02:48 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:RE: initjvm and rmjvm failing Peter, On NT 817 I haven't succeeded in getting JVM to deinstall cleanly and have had to end up rebuilding databases. That said, have a look at bugs 1955536 and 1751857 for details of problems with deinstalling JVM and potential workarounds From bug 1955536: So, the first thing to try here is probably to . 1) restart the database 2) start a different session that the one the started the database 3) run initjvmaux.sql 4) run rmjvm.sql 5) do the following from bug 1751857 . drop trigger JIS$ROLE_TRIGGER$; delete from ducs$ where owner='SYS' and pack='JIS$INTERCEPTOR$' and proc='USER_DROPPED'; delete from aurora$startup$classes$ where classname='oracle.aurora.mts.http.admin.RegisterService'; delete from aurora$dyn$reg; . 6) restart the database - if you get trigger errors, ignore them make sure java_pool_size is at least 50MB 7) start a new session 8) try initjvm.sql . Keep spool files of everything. and then Note also that not only does running initjvm after rmjvm require a new session, it requires restarting the database instance. The newer versions of initjvm attempt to enforce this by exiting immediately if it can be detected that rmjvm has run in the same instance. HTH, Bruce Reardon -Original Message- Sent: Wednesday, 17 April 2002 14:08 Hi All I am trying to add Java support to one of the databases and it keeps failing. It seems that after the first run it didn't get it right and rmjvm doesn't seem to run properly after. there still appears to be a large bunch of objects in the database. Any ideas as to how to clean it up I can rebuild it if i need to, this is more of a learning task, I normally create them with Java in the first place. Any ideas 8.1.7 on Solaris 8 Thanks = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = -- 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). -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. STG63997 Description: Binary data
What is Oracle made from ?
Hi all, Just for my own info, Is Oracle written in C ? Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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).
