RE: Cronjob misbehaving

Hi James,Connor, Hallas, Hemant Receive my heartfelt and sincere vote of thanx to you all for the brotherly guidance - I solved this and promise to pay back by helping someone else out there in turn. Simon -Original Message- Sent: Saturday, March 23, 2002 7:33 AM To: Multiple recipients

RE: iFS - storing XML via Windows Explorer

No can do. Quoting the iFS 1.1.9 [ie the one with 8.1.7] Setup and Administration Guide, Chapter 6, "Task 3: Load Files into Oracle iFS" : The Four Ways to Load Files into Oracle iFS This section discusses the four possible ways of loading documents into Oracle iFS. Remember to set the default

upgrade JRE

hai...gurus,   Do i need to upgrade JRE regularly? what should i do to upgrade the JRE to newer version.   thanks!

Re: Cronjob misbehaving

Simon -- One of the things that many people (even some of the more experienced unix types) tend to forget is that cron doesn't source the user's profile. This is why a script might work just fine from the prompt, but fail when submitted through cron. So, the solution would be either: a)

Re: Remote DB Installation

First let me say, It *CAN* be done. Given the right set of circumstances. You will need: 1. Some way of displaying X-Windows 2. A telnet or ssh session into the box. In all likelyhood, there will be a firewall involved somewhere, so some form of TCP/IP tunnel (VPN) wo

I've got that sinking feeling...

Does anyone know what this error means ? No traces, nothing in the alert log. SP2-0642: SQL*Plus internal error state 2133, context 0:0:0 Unsafe to proceed TIA, Beth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Net

RE: Centralized vs. distributed DBA

Dennis, I would go for the Corporate approach. The simple fact is that DBAs have a *lot* of responsibility in keeping the IT side of the organization running. (Ask Jeremiah Wilton - the Database *is* Amazon). Customer facing as well as Corporate/Financial/CRM type databases are extremely importan

RE: Production Oracle DBA Needed in Rochester, Minnesota

> I'm a hard changing fool Don't you mean hard chaRging? Steve Orr, where the hard charging buffalo DBA's roam... Bozeman, Montana -Original Message- Sent: Friday, March 22, 2002 4:08 PM To: Multiple recipients of list ORACLE-L Brian P Mac

RE: Production Oracle DBA Needed in Rochester, Minnesota

Brian P MacLean To: [EMAIL PROTECTED]

Centralized vs. distributed DBA

My company is looking at the future of DBA positions. Our company is medium-sized and pretty decentralized, the company divisions having separate markets. The question has been raised as to whether it would be better to have all Oracle DBAs be corporate employees or for each division to have

RE: Remote DB Installation

You don't need to ship CD to Central America. You could tar up CD locally and ftp tar file to remote server, untar it, and then run OUI (remotely) specifying directory instead of using CDROM. This works great, especially for multiple CDs. Gerardo -Original Message- Sent: Friday, March

Re: Tools for Scurity and Access to the Server?

Title: Tools for Scurity and Access to the Server? >>  Management would like to know if there is a tool that can monitor who accesses the server, what tool do they use and what they do.  Also is there a tool that can prevent users from accessing Oracle via any other tool other than the Appli

RE: Embarcadero DBArtisan Trial Version

I'm a customer of Embarcadero and use DbArtisan, and there is no chance you will get the trial version to work again. You should get in contact with sales and ask them for a trial licence key. They will give you the procedure and ask you for some imformation before they send you the key. The produ

Re: Routing question.

All depends on whether you're using DNS, and if both IP's are listed for that host in DNS (round-robin). If you want the listener to bind to both IP's and both IP's are listed in DNS, then listener.ora needs to have both IP's, not DNS name. Otherwise the listener binds only to the first IP re

Re:Routing question.

Oracle uses the OS to handle the routing. If your company is into DNS names then you should not have a problem. Just always specify "host=" not "host=192.18.5.5". Dick Goulet Reply Separator Author: "Ferguson II; Roy E" <[EMAIL PROTECTED]> Date: 3/

RE: RE: Production Oracle DBA Needed in Rochester, Minnesota

Always remember to have your tape recorders going when you talk about things like that.. -Original Message- Sent: Friday, March 22, 2002 3:05 PM To: Multiple recipients of list ORACLE-L Any lawyers on the list? This sounds like fertile grounds for an age discrimination suit. Dick Goul

RE: Production Oracle DBA Needed in Rochester, Minnesota

At 36, I am the senior senior DBA here at CSX. Yet, I am the youngest of the group of 12 or so. Go figure! RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his fre

RE: Oracle Monitoring !!!!!

Dick - Good call. Have it on my desk. Oracle DBA Checklists - Pocket Reference Author: RevealNet Publisher: O'Reilly Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, March 22, 2002 3:13 PM To: Multiple recipients of list ORAC

RE: Oracle Monitoring !!!!!

Its not the problem with books ... Its the problem with the lack of Sr, DBA , who can guide me ... All I want is to have a list , so that I can work on that list and show some results to management ... Thanks Madhu -Original Message- Sent: Friday, March 22, 2002 3:14 PM To: Reddy; Madhus

Re:RE: Production Oracle DBA Needed in Rochester, Minnesota

Hey, don't give Lisa bad vibes! My wife & I raised three of the little curtail climbers. Get to marry one off this June. But really kids are great, especially the second time around when their NOT yours. :-) Dick Goulet AKA: Grandpa Reply Separator Auth

Routing question.

All, Can you bind Oracle to communicate through a particular IP address by making note of it in the tnsnames.ora and listener.ora files. or does it use the operating system for routing? We are adding a second nic card for redundancy purposes whereby if one NIC is down, the other NIC would pick

Re:Oracle Monitoring !!!!!

Go check out O'Reilly books on Amazon or your favorite bookstore, mines Barnes & Nobel. There's a DBA checklins pocket manual for the purpose. Dick Goulet Reply Separator Author: "Reddy; Madhusudana" <[EMAIL PROTECTED]> Date: 3/22/2002 12:58 PM Hel

RE: Production Oracle DBA Needed in Rochester, Minnesota

Slightly OT, but here's to a virtual baby shower and all good wishes to you Lisa. (PS: Entirely agree with Ron, you ain't seen grey hairs yet!) John Kanagaraj > -Original Message- > From: Ron Rogers [mailto:[EMAIL PROTECTED]] > Sent: Friday, March 22, 2002 12:41 PM > To: Multiple recipie

Re:RE: Production Oracle DBA Needed in Rochester, Minnesota

Any lawyers on the list? This sounds like fertile grounds for an age discrimination suit. Dick Goulet The old grey haired one, if you can find the hair that is. Reply Separator Author: "Koivu; Lisa" <[EMAIL PROTECTED]> Date: 3/22/2002 12:00 PM Here

Oracle Monitoring !!!!!

Hello All, I am planning to have a checklist , which can have a list of things which I have to monitor on a schedule base. And I also wanted to prepare scripts which will look into database and mail me at least once in a day. So that I am going to have what's happening in the database. Its one kin

RE: Production Oracle DBA Needed in Rochester, Minnesota

Lisa, You THINK you have a few grey hairs now... wait a few years after the "Baby Oven" finishes the glorious gift for you. "Parental revenge..I hope your kids grow up to be just like you..." ROR mª¿ªm >>> [EMAIL PROTECTED] 03/22/02 03:00PM >>> Here's a good one - I interviewed for a job THR

Re: Load Testing Help Needed

Ed wrote: > > Can anyone recommend and low cost tool(s) for load testing a database > server? I looked at Quest's Benchmark Factory, but it doesn't provide > the flexibility I need in this situation I'm facing The $15K I was > quoted for the Quest tool is a bit pricey, so I don't believe more >

RE: Production Oracle DBA Needed in Rochester, Minnesota

yeah, we use those jumbo hours here and have renamed saturday to be friday part 2 "Schilling, Ben"

RE: Production Oracle DBA Needed in Rochester, Minnesota

Lisa - Gosh, you've made my day! Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, March 22, 2002 2:00 PM To: Multiple recipients of list ORACLE-L Here's a good one - I interviewed for a job THREE TIMES at a pharmaceutical company in Miami. quite

Re: Deadlock issues in 8.1.7.2

And usually they are caused by app. design issues, not database issues. Of course, unless you are dealing with MS SQL Server. Igor Neyman, OCP DBA [EMAIL PROTECTED] The degree of normality in a database is inversely proportional to that of its DBA. - Original Message - To: "Multiple

Re: Deadlock issues in 8.1.7.2

Are they 04020 deadlocks or 00060 deadlocks ? Are they deadlocking on TX mode 6 or TX mode 4 ? There isn't much useful information in your post, but if you are using bitmap star transformations it is possible that your deadlock is a TX mode 4 type due to concurrent updates in overlapping bitmap

RE: 9i install

> If I run the catexp from 9i into 8i (as SYS) > and export I will be able to import into 9i, correct? I would export your 8i database using your export utility from 8i. Then Import the dump file into your 9i database using the import utility from 9i. > My question is: Do I need to install a pa

RE: Production Oracle DBA Needed in Rochester, Minnesota

Here's a good one - I interviewed for a job THREE TIMES at a pharmaceutical company in Miami. quite a haul, but would have been a great job. I got the final call saying, They are willing to pay you $xx if you attend ONE MORE interview (people-type, I had passed all the tech interviews) and work i

alter table tabname drop column colname checkpoint #;

I've got a "process" which is consuming RBS to the point of failure (running out of tablespace). I have very little control of the code so using set transaction is not a possibility. The SQL that is failing is "alter table tabname drop column colname" with no checkpoint being specified. Accordin

ORACLE 9i DB

Hi Does any one running Oracle9i database? Let me know are any special init.ora parameter setting used? What new features I can add to get power of Oracle9i database? Please suggest. Thx -Seema _ Send and receive Hotmail on your

Re: OT: Informix User Group

http://www.iiug.org/new/ I must warn you, they love to bash oracle, very emotional group who feel let down by Informix corp, now IBM. >>> [EMAIL PROTECTED] 03/22/02 01:23PM >>> I have just been given responsibility for two Informix databases. Can anyone give me a link to an Informix user group

RE: kill the procedure Call

Rakesh, If you don't mind sending me a copy. TIA Tommy Pham P.S: We're running 2.6 Solaris. --- Rakesh Gupta <[EMAIL PROTECTED]> wrote: > John, > We use solaris version 2.7 and 2.8. Since I have > been working with solaris for the longest time, I > assume that everyone else is using solaris also -

RE: Remote DB Installation

Ken - I think that you are getting the picture that your greatest challenge may be the X-windows configuration. If you are not familiar with that, I would recommend that you line up a system administrator that is, so that they can help get you configured. By the way, are you set up in terms of

Re: OT: Informix User Group

www.iiug.org Robin "Rusnak, George A." wrote: > > I have just been given responsibility for two Informix databases. Can anyone > give me a link to an Informix user group? > > TIA > > Al Rusnak > 804-734-8453 > [EMAIL PROTECTED] > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq

RE: Production Oracle DBA Needed in Rochester, Minnesota

Brian - Hmm. . . let me see, you started work at 8 years old, so even with 20 years of experience you still meet the "under 30" image they had in mind when they advertised the position. The nature of the questions certainly sound slanted in that direction. But maybe I'm just being a paranoid DBA w

RE: Somewhat OT: Korn Shell Course

Micheal: Learn it free.. There is no need for such expensive courses. Buy a couple of Kron Shell books and practice yourself. Here is David Korn's web site http://www.kornshell.com. It has everything to learn Korn Shell.. Good Luck.. - Kirti -Original Message- Sent: Friday, March

RE: Somewhat OT: Korn Shell Course

Thats what I was going to say Lisa "Learning the Korn Shell" and also "Sed & Awk". With those two books I have learned to do a great deal with the Korn Shell. No way would I put down 2K for a course in this ! -Original Message- Sent: Friday, March 22, 2002 12:24 PM To: Multiple re

CLOB or not?

Oracle has varchar2 limit of 4000. So basically for any columns of over 4000 characters, we need to use CLOB(BLOB). My question is : what's the advantage/disadvantage? Any database design issue(I need to have a separate tablespace). And those columns will also be accessed from web via JDBC calls

RE: Production Oracle DBA Needed in Rochester, Minnesota

The "Exactly 80 hours every 2 weeks" is very accurate if you go by the hours paid "Approx Min Hourly Salary: Salaried * " Salaried = fixed pay for 1176 hours in a week, but true salaried means you get paid if you work 1 or 1176 hours. ROR mô¿ôm >>> [EMAIL PROTECTED] 03/22/02 01:23PM >>> Yup

sysdba and sysoper roles

  Hi Guys , I need some info here , What exactly is difference between sysdba and sysoper roles and how can I set up osdba osoper roles on unix ( i mean what os permissions does it need ).   -ak

Re: strange tkprof output for SQLs - II

Hello all, Thanks to Bjorn Engsig of MiracleAS.dk Also, Here is the answer from Oracle support. I wanted to share with you: # Begin tkprof substracts the child statistics from parent ones. . the trace file is missing the line for PARSE call of the blsql block - as it's missing it's imposs

OT: Informix User Group

I have just been given responsibility for two Informix databases. Can anyone give me a link to an Informix user group? TIA Al Rusnak 804-734-8453 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rusnak, George A. INET: [EMAIL PROTECTED] Fat City N

RE: Deadlock issues in 8.1.7.2

Hi, Deadlocks happen for N number of reasons. Please post the deadlock graph for further investigation. Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- [EMAIL PROTECTED] Sent: Friday, March 22, 2002 10:38 AM To: Multiple recipients of list ORACLE-L Is anyone hav

Deadlock issues in 8.1.7.2

Is anyone having deadlocking issues with the 8.1.7.2 release of Oracle? If you are, how serious are these errors? What are the consequences of the deadlock error messages.How long does it actually take to clean up the deadlocks? Does one of the transactions roll back? Does it then reissue l

RE: Production Oracle DBA Needed in Rochester, Minnesota

80 hours is what you get paid for. The rest of the hours is just for the love of the job. -Original Message- Sent: Friday, March 22, 2002 12:24 PM To: Multiple recipients of list ORACLE-L Yup. Exactly 80 hours every 2 weeks. Right. I love when job postings in IT say tha

Re: Somewhat OT: Korn Shell Course

At the risk of sounding flipid... Save your money, read the last 84,100 threads posted to comp.unix.shell http://groups.google.com/groups?hl=en&ie=ISO-8859-1&oe=ISO-8859-1&group=comp.unix.shell buy and read the books http://www.amazon.com/exec/obidos/ASIN/067248448X/qid=1016822090/sr=8-1/re

RE: Production Oracle DBA Needed in Rochester, Minnesota

I believe they are using those 90 minute jumbo sized hours. -Original Message- Sent: Friday, March 22, 2002 12:24 PM To: Multiple recipients of list ORACLE-L Yup. Exactly 80 hours every 2 weeks. Right. I love when job postings in IT say that. > -Original Message-

RE: Somewhat OT: Korn Shell Course

Or go even cheaper and buy "Learning the Korn Shell" O'Reilly title for under $50 and practice. That's how I learned it. Lisa Koivu Oracle Database Baby Oven. Fairfield Resorts, Inc. 954-935-4117 > -Original Message- > From: Michael Bush [SMTP:[EMAIL PROTECTED]] > Sent: Friday, March 2

RE: Production Oracle DBA Needed in Rochester, Minnesota

Yup. Exactly 80 hours every 2 weeks. Right. I love when job postings in IT say that. > -Original Message- > From: Johnston, Tim [SMTP:[EMAIL PROTECTED]] > Sent: Friday, March 22, 2002 11:24 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: Production Oracl

RE: Somewhat OT: Korn Shell Course

Pick up a couple Shell books at bookpool.com for < $100 and save yourself some time and money. Scott Shafer San Antonio, TX 210-581-6217 "Common sense will not accomplish great things. Simply become insane and desperate." > -Original Message- > From: Michael Bush [SMTP:[EMAIL PROTECTED]

Re: Sightly OT: Unix scripting

try... y=`date '+%y'` j=`date '+%j'` #DATE=`date '+%y%j'` #echo $DATE ystr=`expr $y - 1` echo $ystr if [ ${#ystr} -eq 1 ] then ystr=0$ystr echo $ystr fi DATE=$ystr$j echo $DATE On Thu, 21 Mar 2002, Ball, Terry wrote: > Environment: Oracle 8.1.6.3 on Solaris 5.8 > > I am not a Unix

Re: Calling a Stored procedure from Java which returns cursor value

we use java.sql.ResultSet . Works for me . -ak - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, March 21, 2002 11:13 PM > Hi all > > I was running following code in from this list only and I want to > call it from java code. Code

RE: Production Oracle DBA Needed in Rochester, Minnesota

(hope this answers your question Lisa) Alter session set RANT_SWITCH = ON; I interviewed for a DBA position there recently. I was not able to give my best interview because I had the worst cold I've had in several years (cough, dizzy, slight temperature, etc.). So in there defense, and mine,

Re: Off Topic: PGP

Hello, Use GPG... is a pgp clone but GNU software so no crummy licenses. www.gnupg.org. Paul --- www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN Smarter than adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-call, daily verifica

Somewhat OT: Korn Shell Course

I am looking at two Korn Shell Programming Courses. One is offered by IBM and is $2395 for 5 days. The other is offered by HOTT (Hands on Technology Transfer, Inc.) and is $995 for 3 days. I am a big believer in you get what you pay for, but if anyone has had any experience with HOTT I would ap

RE: Load Testing Help Needed

Check out Craig Shalamahar site www.orapub.com under tools. He got a free loadtesting tool. Cheers, RS > > Can anyone recommend and low cost tool(s) for load > testing a database > > server? I looked at Quest's Benchmark Factory, > but it > > doesn't provide > > the flexibility I need in thi

RE: Production Oracle DBA Needed in Rochester, Minnesota

Hours/2-Weeks: 80 What galaxy does this happen in for a DBA?? ;o) -Original Message- Sent: Friday, March 22, 2002 10:24 AM To: Multiple recipients of list ORACLE-L Looks like you nailed it to me... The listing from the mayo clinic site... Oracle Data Base Administer Job Post

RE: Windows NT and Virtual Memory

Thanks Jack. I am aware of this limitation under NT. But what I dont have an answer for, is why it never happened on the old server. As per business, there's no drastic increase in the number of connections. Previously, there used to be about 300-350 connections, but on the new server, it wont go

RE: Connect to Oracle via ODBC gives error sometimes

Hi Rick, I have encountered similar problems here. Here are some notes I have on it: After an application is installed, the user sometimes receives one or both of the error messages when attempting to administer ODBC from the Control Panel using ODBC Datasource Administrator. The setup routine

RE: Production Oracle DBA Needed in Rochester, Minnesota

Oohh stop Lisa, you love Florida :). You didn't show up at SFOUG, ppl were looking for you! >>> [EMAIL PROTECTED] 03/22/02 10:59AM >>> Brian, you can't say that and not say why... is the Mayo a sweatshop? Please do share, even if it's off the list. I used to live in Minneapolis and miss it ter

RE: Production Oracle DBA Needed in Rochester, Minnesota

Looks like you nailed it to me... The listing from the mayo clinic site... Oracle Data Base Administer Job Posting Number: 01-0004509 Openings: 1 Section: MIS/Managed Care Job Class: 6115 J

RE: Windows NT and Virtual Memory

Raj, Oracle can only use 2GB of RAM for all its processes under NT or Win2k unless you're using NT Enterprise Edition or Win2k Advanced Server and you set an NT / Win2k parameter to allow it to use up to 3GB or (yet another OS setup) 4GB and more. Check out the Windows-specific docs for info. an

RE: Off Topic: PGP

NT freeware can be found at: http://web.mit.edu/network/pgp.html But be warned--I've heard some horror stories about the NT install. I've never had problems myself, but know of cases where machines have been rendered inoperable... HTH, -Roy Roy Pardee Programmer/Analyst SWFPAC Lockheed Marti

Windows NT and Virtual Memory

Operating System: Windows NT 4.0 with SP 6a Oracle Version : 8.1.7 We recently migrated an Oracle database from one Windoze NT box to another. The NT administrators claim that the NT boxes are indentical in all respects, except that the old one had Service Pack 4. We have recreated the databa

RE: Production Oracle DBA Needed in Rochester, Minnesota

Brian, you can't say that and not say why... is the Mayo a sweatshop? Please do share, even if it's off the list. I used to live in Minneapolis and miss it terribly. Lisa Koivu Oracle Database Baby Oven. Fairfield Resorts, Inc. Ft. Lauderdale, FL 954-935-4117 > -Original Message- > Fro

How to retrieve DBMS_DESCRIBE info in OUT ref_cursor.

Hi All, Not exactly a DBA question but more of a developer question but any help is appreciated including how to subscribe to Oracle developer forum. What I need is for the DBMS_DESCRIBE output in a single record set in the form of a REF CURSOR that can be returned from a stored procedure as a

Off Topic: PGP

Title: Off Topic: PGP Does anyone know of any good PGP implementations for WinNt or Openvms?  Are there any free ones? TIA, Beth

Re: Production Oracle DBA Needed in Rochester, Minnesota

Can you say "Mayo Clinic"..Be afraid, be very afraid (IMAO) OraStaff

RE: RE: Intersystems Cache database

I have some past experience with MUMPS - Run like h@#$ and don't look back. If CACHE=MUMPS it most definitely is false advertising. Scott Shafer San Antonio, TX 210-581-6217 "Common sense will not accomplish great things. Simply become insane and desperate." > -Original Message- > From:

RE: Error in procedure with dba_users

Tks Suzy and all that reply, I will do some FM to take a look of DBMS_STATS Ramon -Original Message- From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> on behalf of "Suzy Vordos" <[EMAIL PROTECTED]> Sent: Thursday, March 21, 2002 7:48 PM To: "Multiple recipients of list ORACL

RE: Load Testing Help Needed

The low cost testing tool that will do the job is called "sqlplus". Just develop your scripts and fire away > -Original Message- > From: Ed [mailto:[EMAIL PROTECTED]] > Sent: Friday, March 22, 2002 8:23 AM > To: Multiple recipients of list ORACLE-L > Subject: Load Testing Help Needed

RE: Error in procedure with dba_users

Yeah, but I plan on making use of this account for other DBA functions, too. My faux pas for not mentioning that! One other priv you'll probably want for this account is ALTER SESSION in order to boost the SORT_AREA_SIZE (at least in pre-9i). :) Rich Jesse System/Dat

oracle graphics

Hi, I need to get a feeling for how Oracle graphics work. If someone can point me right direction I would appreciate it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lyuda Hoska INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 5

RE: Automatically startup database

An idle instance is an instance with no mounted database. If the service is autostart and is otherwise correctly configured, Oracle will start the instance and mount the database. You should not see this message.

RE: iFS - storing XML via Windows Explorer

No, because the user would like to use copy / paste. Tamas -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Friday, March 22, 2002 10:09 To: Multiple recipients of list ORACLE-L Have you tried FTPing the file into iFS ? There should be a "quote parsemodeoff " in FTP. Hemant K Chit

Load Testing Help Needed

Can anyone recommend and low cost tool(s) for load testing a database server? I looked at Quest's Benchmark Factory, but it doesn't provide the flexibility I need in this situation I'm facing The $15K I was quoted for the Quest tool is a bit pricey, so I don't believe more expensive tools (e.

RE: Java permissions

Title: RE: Java permissions Query DBA_JAVA_POLICY -Original Message- From: Mike Killough [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 4:28 PM To: Multiple recipients of list ORACLE-L Subject: Java permissions Could someone please tell me how to see the java permission

Re: Failed login attempts

Hi Bunyamin, All I can is that by following these exact steps I get it working! SQL> select username,action_name,returncode from dba_audit_trail; USERNAME   ACTION_NAME RETURNCODE LOGOFF_TI -- ---

RE: Remote DB Installation

I have successfully done this several times using Exceed, a product of Hummingbird Communications Ltd.   -Original Message-From: Sujatha Madan [mailto:[EMAIL PROTECTED]]Sent: Friday, March 22, 2002 1:13 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Remote DB Instal

RE: Tools for Scurity and Access to the Server?

Title: Tools for Scurity and Access to the Server? Yes, there are third party tools like DBTool, KeepTool for Oracle Databases. -Original Message-From: Denham Eva [mailto:[EMAIL PROTECTED]]Sent: Friday, March 22, 2002 4:38 PMTo: Multiple recipients of list ORACLE-LSubject: Too

Production Oracle DBA Needed in Rochester, Minnesota

Position: Oracle DBA Location: Rochester, Minnesota Salary Range: 65-75K- maybe more Description: This client company-a leader in its' field, needs an Oracle DBA to provide database support. This position includes support of all aspects of the Oracle relational database product (ASE) on primaril

OT: Connect to Oracle via ODBC gives error sometimes

Hi All, I have installed Oracle client 8.1.6 on Win NT. I have setup an DSN and it works fine testing with ODBC test and Universal Data Link Utility. However if use Programs->Adiministrative Tools -> ODBC and choose my DSN, I get "The setup routines for the Oracle ODBC driver 32 bit driver could

Re: Failed login attempts

I tried What you said . but still no rows returns from dba_audit_trail although failed login attempts occured. Bunyamin K. Karadeniz Oracle DBA / Developer Civilian IT Department Havelsan A.S. Eskisehir yolu 7.km Ankara Turkey Phone: +90 312 2873565 / 1217 Mobile : +90 535 3357729 The degree o

Tools for Scurity and Access to the Server?

Title: Tools for Scurity and Access to the Server? Hello List, Management would like to know if there is a tool that can monitor who accesses the server, what tool do they use and what they do. Also is there a tool that can prevent users from accessing Oracle via any other tool other than t

RE: Oracle Licensing - Concurrent users

Hi, A late response, but this seems like: Oracle saying: This is my product and this is how we want to sell, buy or leave. And they have considered every possibility of taking advantage or they dictate it the way it suites them. How about saying back: What ever is your product, we want to buy l

Re: iFS - storing XML via Windows Explorer

Have you tried FTPing the file into iFS ? There should be a "quote parsemodeoff " in FTP. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Szecsy Tamas <[EMAIL PROTECTED]> 22/03/2002 12:28 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L

Re: Calling a Stored procedure from Java which returns cursor value

  try reading the JDBC docs at http://download-uk.oracle.com/otndoc/oracle9i/901_doc/java.901/a90211/toc.htm   pay attention to the "Oracle REF CURSOR Type Category" section of chapter 5 and the "REF CURSORs--RefCursorExample.java" of chapter 20  (http://download-uk.oracle.com/otndoc/oracle9i/

RE: Cronjob misbehaving

Thanx. A lot of development work is going on and I need a daily report on the changes made in the packages. Recompiled Invalid objects suppliment my report. Ciao, CSW -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Friday, March 22, 2002 11:58 AM To: Multiple recipients of list ORACLE

Re: Cronjob misbehaving

Set your Oracle environment as the first thing in the cron job (typically by setting ORACLE_SID and calling oraenv) hth connor --- Simon Waibale <[EMAIL PROTECTED]> wrote: > Hi all, > Thanx for all the good work U R doing for Oracle. > I have a misbehaving cronjob > > -Cron Entry >

Re: Fav. Urban Legend...Mem vs Disk

That does add an interesting element to the version 9 "max_aggregate_pga" (or max_pga_aggregate or pga_max_aggregate .. permute as needed until the database restarts because I can't remember the order the words are in). If we set pga_aggregate_max to 500MB then Oracle tries to allocate all w

RE: Cronjob misbehaving

Title: RE: Cronjob misbehaving It looks as if your ORACLE_HOME is not being set up. Try either or both of the following 1) Amend your cron job to look like the following (I assume you are running this as user oracle) 0 5 * * * su - oracle 'usr/scripts/recompile.sh' > /ops/scripts/recompile

Re: Cronjob misbehaving

Your CRON script should also define the ORACLE_HOME, ORACLE_SID and PATH. Why do you need a CRON job to recompile database objects every day ? Why are the being invalidated every day ? Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd "Simon Waibale" <[EMAIL PROTECTED]>

RE: Automatically startup database

Title: RE: Automatically startup database Hi, This is not an error message. It has just connected to an idle instance. Regards, Manohar -Original Message- From: shuan [mailto:[EMAIL PROTECTED]] Sent: Friday, March 22, 2002 1:33 PM To: Multiple recipients of list ORACLE-L Subject

Cronjob misbehaving

Hi all, Thanx for all the good work U R doing for Oracle. I have a misbehaving cronjob -Cron Entry 0 5 * * * /usr/scripts/recompile.sh > /ops/scripts/recompile.log 2>&1 -recompile.sh #!/bin/ksh ## Program name : recompile.sh ## Purpose : Recompile Invalid Database

Re: Automatically startup database

ahis this an error message? i also like tatbut i can do all my stuffs normally. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, March 22, 2002 3:18 PM > Thanks for your help, I have checked that the > Automatic Startup Type as Da

  1   2   >