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

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

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

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

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

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;

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,

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.

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

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,

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

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

RE: User_product_profile and sqlplusw

Thanks but that does not work either. Rick Shaw

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

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 .

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

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

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

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

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

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

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

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

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

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:

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

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,

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

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

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

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

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

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

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:

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

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

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

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

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}

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

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

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

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.

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:

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

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

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]]

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

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.

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

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

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

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:

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

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).

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

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

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

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

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

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

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

[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

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

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

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

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

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.

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

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

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