ORA-00600: internal error code, arguments: [qkaPIdsqkn1]

We R running some querry against partitioned tables and we get the above oracle error. Metalink says something like: Bug:785518 The hint given in there does not seem to get us off the hook! Any idea welcome. 'll post the querry excerpt on request. Thanking you, --- CSW -- Please see the officia

iDevelop 2002 in Europe?

Hi,   this is a bit off topic, but does some one here know any thing about iDevelop in 2002 in Europe. Until now I found Oracle World in Koppenhagen only. Until now there were multiple places in Europe that you could visit.   TIA,   Tamas Szecsy

RE: High "elapsed" time when running on a Unique Index ??

what is the cpu utilization on your box? Waleed -Original Message- To: Multiple recipients of list ORACLE-L Sent: 4/17/02 12:43 AM > 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

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 a

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 PR

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 -

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

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 con

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 ru

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 Mes

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 i

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 t

[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 Clau

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

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 si

RE: Package/Procedure

Hi Laura, We use P_XXX_ for procedures, F_XXX_ for functions and K_XXX_ for packages where XXX is our application initial as we've many applications in one instance. Eg. P_STD_Update is a procedure pertaining to Student (STD) System. HTH Catherine -Original Message-

Oracle HR and Financials Info

Hello all,   I need to get some information regarding Oracle HRMS and Financials and also regarding Government accounting Practices, some thing like a summary yet not so short description of each and every modules etc. Can any one on this list please tell me any web sites I could go to, or se

Re: RBS question

> I have just been asked to find if there's contention in the rollback > segment header.. which tables (columns) should I look in ? v$waitstat Look in the Oracle manual, "Designing and Tuning for Performance," in the chapter, "Tuning Resource Contention." There is a section on Reducing Contenti

RE: Fast refresh materialized view is not updateable

I have no problem doing this Oracle 8.1.7.3 on Solaris 2.6: SQL> create table testmat ( c1 number , c2 number , c3 number); Table created. SQL> insert into testmat values ( 1 , 2 , 10); 1 row created. SQL> insert into testmat values ( 1 , 3 , 13); 1 row created. SQL> insert into test

Outlines

Listers, Has anyone encountered database issues, bugs, etc when using outlines to capture SQL statements and their plans? Solaris 64 Bit 2.7 running 8.1.7.2.1 64 bit Sun E10K. We are considering the use of outlines for capturing SQL statements and their plans for a particular database with nume

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 th

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() functio

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_m

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

RE: support 11.03 and 11i

11.03 should be supported for quite some time, as 10.7 is supported until 30-JUN-2003. Look on Metalink under "Product Lifecycle". Gary Gary Kirsh Next Extent Consulting -Original Message- Sent: Monday, April 15, 2002 2:43 PM To: Multiple recipients of list ORACLE-L Hi, First, I would

RE: Fast refresh materialized view is not updateable

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 cr

Close instances while installing new versions or creating new databases

Hi The install guides that I have seen specify that you shut down all instances before any installations. Is it really necessary to close all instances and listeners on a server when you are: a)Installing a new version of Oracle in a new $ORACLE_HOME OR b)Creating a new database under the ne

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 S

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

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 PROTE

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: 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 come

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

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

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

Package/Procedure

Title: Package/Procedure Is there a naming convention for procedures and/or packages? Thank you, Laura

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"

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: T

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. "M

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 th

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 [mai

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 ta

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: 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 t

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"

Re: How can we make any column of a table as case insensitive

Writing all data as upper or lower case will not make it case insensitive. Unfortunately, don't know what would be the solution. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, April 16, 2002 12:3

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 t

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/dkuma

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,

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:[

RE: update triggers that query the table being updated

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

Re: Database shutdown

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 shutd

RE: protocol.ora

FWIW, When we used protocol.ora at my previous company, we experienced a real slow down so we aborted it. This was on 8.1.6 and 8.1.5 databases. We did have a list of about 20 names it had to look through. Kathy -Original Message- Sent: Monday, April 15, 2002 7:03 PM To: Multiple re

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

RE: 8.0.5 to 8.1.7 - export/import

Lisa: You should be fine moving this direction. (It's exporting from a newer release and importing into an older release where you need to take extra steps.) The steps you outline look perfect. Good luck! Barb > -- > From: YTTRI Lisa[SMTP:[EMAIL PROTECTED]] > Reply To: [E

How can we make any column of a table as case insensitive

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 dat

RE: Security Hole

Yeah, I got all of the emails in the wrong order so I saw the bug after I saw the replies. Consequently I made an idiot of myself. Still, the sun's shining so it could be worse. =) Regards (and apologies for wasting the electrons), Mike -Original Message- Sent: Tuesday, April 16, 2002 5

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 

Database shutdown

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 P

RE: User_product_profile and sqlplusw

I had to try it out, this works on 9i and W2K. insert into product_user_profile (product,userid,attribute,char_value) values ('SQL*Plus','TRACK','INSERT','DISABLED'); Connected to: Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production With the Partitioning option JServer Release 9.0.1.1.1 -

RE: Security Hole

No , the user did not have access to link$. But that's the point. The bug allows the user access to table he/she doesn't have access to when used with a cross join. > -Original Message- > From: Hately Mike [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 16, 2002 11:39 AM > To: Multip

update triggers that query the table being updated

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

Re: Locally managed tablespaces/What a DBA can do ?

Daren, Localy managed tablespaces are good for reducing maintenance. You can limit fragmentation. In our shop we are using locally manged tablespaces and it is working fine for us. As far as Vendors are concerned, you can keep a note of what have you done as far as reorganization is concerne

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

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 data

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

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

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

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 com

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: 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 Develop

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 d

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 follow

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: 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 vie

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 betwee

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: sql & isql

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 i

Re: Security Hole

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 htt

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/ap

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

RE: User_product_profile and sqlplusw

Thanks but that does not work either. Rick Shaw

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       -

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 fil

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

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 i

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

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 compa

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

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 executabl

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

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 circumven

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 >

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