RE: Off topic - Oracle 9i on W2k - AMD Athlon XP or Intel Celeron

Thanks for all whoe replied, it helped me a lot. Tamas -Original Message- Sent: Friday, March 29, 2002 1:03 To: Multiple recipients of list ORACLE-L Celeron upgrade guide: http://www6.tomshardware.com/howto/01q4/011005/index.html If you surf around that site, you should find purchas

Creating Oracle Users from Win NT/2000 users

Hi, Is it possible to create users in Oracle from Win NT users? In this case all the users of a domain will be using Oracle. Any new user will also be Oracle user. TIA! Aleem -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Abdul Aleem INET: [EMAIL PROTECTED] Fat C

RE: Oracle PL/SQL Developer Needed on Long Island, New York

not when one lives with 4 cats they aren't difficult to imagine! --- "Deshpande, Kirti" <[EMAIL PROTECTED]> wrote: > Because of the sudden change in the ambient air freshness :) I bet > the > cattle still beat margaritas !! ;) > > Some things are difficult to imagine when one rides a train 1/2

RE: Rename Oracle User

If you haven't already done this, the find's are unneeded. How about replacing 1,3,4 with: create dba group usermod -l oracle -g dba oracle2 Since the ownership's in UNIX are by UID, if the username is changed then all the files are now owned by the new username(same UID). shutdown BACKUP userm

1999 Proceedings of OpenWorld

Does anyone have information on the location and format of the whitepapers and presentations from OpenWorld 1999? Was it produced on CD that year? If so does anyone have a copy? If it was published on the web, does anyone know where and if it is still there? -- Jeremiah Wilton http://www.speak

Re: Off topic - Oracle 9i on W2k - AMD Athlon XP or Intel Celeron

upgrade guide: http://www6.tomshardware.com/howto/01q4/011005/index.html If you surf around that site, you should find purchasing comparisons. The biggest stupidity with the P4 is the "crippled" LU2 cache. AMD came up with an achitecture that has a big LU2 cache, which in most (not all) cases

Re: CLIENT VERSION

Here's a way on unix: strings $ORACLE_HOME/lib/libclntsh.so | grep "^Version [7-9]" -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Thu, 28 Mar 2002, Harvinder Singh wrote: > In batch script If we need to verify the version of oracle software on > server we issue: > select * from v$ver

RE: Learn from my mistakes! Or "Helpful DBA hint of the day"

on 18/03/2002 -0800, you wrote: >In 9.0.1, when you create a DB, you would "connect / as sysdba". However, >if you also run "catalog" and "catproc" while connected like this, Oracle >Advanced Symmetric Replication WILL NOT WORK. You *MUST* be connected as >"SYS as sysdba". > >It's taken me fore

Re[2]: Odd Sql result

Stephane, Yeah, it's weird at best. Asked OTS about it, along with sending them the view defs and they replied that I should try on a supported version of Oracle. I forgot to mention in the previous post that this is on 8.0.5.2.1. Anyway, I tried on 8.1.7 & bingo it did not re-occur. The

RE: ROLLBACK SEGMENT?

<> Of course not!! :-( 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 freedom away from him. -Original Message- Sent: Thursday, March 28, 2002 3:44 PM To:

RE: Coriolis is dead

Nope, not taken the 9i OCP Upgrade yet. Started to in the UK in December but didn't. Have not had the time yet. Need to do it though. 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 consc

Re: Odd Sql result

Are you sure you aren't running 9i with: alter session set sessiontimezone = 'UTC+72:00': Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar - UK, April 3rd - 5th http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq

RE: Oracle PL/SQL Developer Needed on Long Island, New York

Because of the sudden change in the ambient air freshness :) I bet the cattle still beat margaritas !! ;) Some things are difficult to imagine when one rides a train 1/2 a mile below ground ;))) - Kirti -Original Message- Sent: Thursday, March 28, 2002 2:29 PM To: Multiple recipients

RE: Oracle PL/SQL Developer Needed on Long Island, New York

Well Steve, at least you don't totally miss out on the east coast smog. -Original Message- Sent: Thursday, March 28, 2002 2:38 PM To: Multiple recipients of list ORACLE-L When full cattle cars go by it's really "fresh." -Original Message- Sent: Thursday, March 28, 2002 1:03 PM

RE: ROLLBACK SEGMENT?

Thanks for the FYI. Do you have any details as to why they are closing up shop? I thought there Exam Cram and Black books were popular Does this mean we can freely copy these books now?? -Original Message- Sent: Thursday, March 28, 2002 3:08 PM To: Multiple recipients of list O

RE: Coriolis is dead

Robert Just bought your 8i book. Hope this doesn't affect you too badly. As a matter of interest Robert, why does your signature not mention 9i. You have taken (and passed!!) the 9i exam haven't you.? John -Original Message- Sent: 28 March 2002 20:09 To: Multiple recipients of list ORAC

RE: Oracle PL/SQL Developer Needed on Long Island, New York

When full cattle cars go by it's really "fresh." -Original Message- Sent: Thursday, March 28, 2002 1:03 PM To: Multiple recipients of list ORACLE-L Someone has been getting way to much fresh air...come out to the northeast and breath some quality smog...it will help to "clear" your head

Re: ROLLBACK SEGMENT?

Alternately run following script and set your optimal nearest to HWMSIZE as a start. It requires a lot of monitoring to set optimal according to your application requirement. select ud.name, sg.extents ext, round(sg.blocks * ts.blocksize / 1048576, 2) MB, round(s.optsize /

RE: Oracle PL/SQL Developer Needed on Long Island, New York

okay, what's the reasoning behind the half price when the train goes by? --- "Orr, Steve" <[EMAIL PROTECTED]> wrote: > Manhattan, MT is just 10 miles down the road. ;-) > They have a restaurant there where, if you order a margarita when the > train > is going by it's only half price. It's a qual

RE: Parallel execution question

Read all articles on Parallel Query at Jonathan's web site: http://www.jlcomp.demon.co.uk/ind_pqo.html You will know how it works and why... - Kirti -Original Message- Sent: Thursday, March 28, 2002 1:58 PM To: Multiple recipients of list ORACLE-L Hi Friends, I want to use paralle

Re: Odd Sql result

[EMAIL PROTECTED] wrote: > > Hey folks, > > Now I've seen some odd results form queries in the past, but I'll be d*mned > is I can figure this one out. It defies logic. > > I've two queries that each return 50 rows from the database & the rows are > the same is each case (stubby pencil

Re: urgent

Hello, Check alert.log. If there is a related error or if a trace is generated, forward them to list.     Big Planet wrote: Hi Guys ,I am getting this weired result after executing stored proc . When I run a particuler stored proc which returns two refcursors ( inside proc theres are dynamic qu

Re: Parallel execution question

Raghu Run following query to check your parallel parameters set in initSID.ora. If your running paralell degree upto 5 default is ok. However parallel execution requires lot of overhead like memory usage and temp tablespace. Please refer some Manual/book for proper understanding as it is itse

Coriolis is dead

Sorry for the repost, I put a wrong subject header on... Anyone here write books for Coriolis? They are closing up shop effective today. No more Exam Crams, black books, etc... RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoki

RE: ROLLBACK SEGMENT?

Anyone here write books for Coriolis? They are closing up shop effective today. No more Exam Crams, black books, etc... 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

RE: Oracle PL/SQL Developer Needed on Long Island, New York

Someone has been getting way to much fresh air...come out to the northeast and breath some quality smog...it will help to "clear" your head -Original Message- Sent: Thursday, March 28, 2002 2:28 PM To: Multiple recipients of list ORACLE-L Manhattan, MT is just 10 miles down the road

RE: ROLLBACK SEGMENT?

Keep the rollback segments out of the cold water. Shrinkage is bad. Scott Shafer San Antonio, TX 210-581-6217 "Common sense will not accomplish great things. Simply become insane and desperate." > -Original Message- > From: Seema Singh [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, March

Parallel execution question

Hi Friends, I want to use parallel execution to improve the performance of my Oracle7.3 database on AIX with front end baan. I read Oracle documentation, But they did't give me How to set these parameters.. PARALLEL_MIN_SERVERS PARALLEL_MAX_SERVERS PARALLEL_MIN_PERCENT My doubts are is it ok

CLIENT VERSION

Hi, In batch script If we need to verify the version of oracle software on server we issue: select * from v$version; But how to find the client version from some batch script?? Thanks -Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh

Odd Sql result

Hey folks, Now I've seen some odd results form queries in the past, but I'll be d*mned is I can figure this one out. It defies logic. I've two queries that each return 50 rows from the database & the rows are the same is each case (stubby pencil check), but of the three columns returned

Re: ROLLBACK SEGMENT?

Don't specify "OPTIMAL" parameter for rollback segment. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, March 28, 2002 1:38 PM > Hi > I am looking lot of shrinkage in rollback segment.please sug

RE: Oracle PL/SQL Developer Needed on Long Island, New York

Manhattan, MT is just 10 miles down the road. ;-) They have a restaurant there where, if you order a margarita when the train is going by it's only half price. It's a quality dive... there aren't as many trains there and they carry more cattle than people. Mooo... -Original Message- Sen

Parallel execution question

Hi Friends, I want to use parallel execution to improve the performance of my Oracle7.3 database on AIX with front end baan. I read Oracle documentation, But they did't give me How to set these parameters.. PARALLEL_MIN_SERVERS PARALLEL_MAX_SERVERS PARALLEL_MIN_PERCENT My doubts are is it ok

RE: Best way to move db from AIX to Solaris

We have been doing the reverse (SUN to AIX) here on a large number of databases anywhere from a 1GB in size to > 500 GB in size. We use parallel exports over pipes (using DD) and import at the same time. Have a GB Ethernet adapter direct connected between the two boxes. I can do a 500GB database

urgent

Hi Guys , I am getting this weired result after executing stored proc . When I run a particuler stored proc which returns two refcursors ( inside proc theres are dynamic query ) multiple times the proc executes well ...but after someexeccution ( using same connection )  the connection drops 

ROLLBACK SEGMENT?

Hi I am looking lot of shrinkage in rollback segment.please suggest. Thx -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Autho

Re: Help in unix script

#!/bin/ksh MAX=40 top -b -U norad | grep norad | awk '{ print $6, $11 }' | \ while read SIZE COMMAND do #echo "working with ${SIZE}:${COMMAND}"#DEBUG WORK="${SIZE#*M}" #echo "1->${WORK}" #DEBUG if [[ ${#WORK} -eq 0 ]] then WORK=${SIZE%%M}

RE: Help in unix script

Hi Ashoke, I see that you are using NORAD (I am the resident NORAD sales critter ;P). Can't help you much on the script help, but one thing I can say: Have you looked at the IAS agent of NORAD (the system monitoring agent)? This will be able to do all that you want.. Under the standard rules (

Re: Oracle PL/SQL Developer Needed on Long Island, New York

and I love NY, although I'd prefer Manhattan --- Gene Sais <[EMAIL PROTECTED]> wrote: > Never again Long Island! Wonder how the 495 parking lot is these > days? Just love this sunshine, pipe down Lisa, its still in the 40's > in MN :) > > >>> [EMAIL PROTECTED] 03/28/02 10:13AM >>> > Long Isla

Re: Help in unix script

Oops, forgot the mail part. change: echo "Greater than ${MAX} -> ${SIZE}:${COMMAND}" to: echo "Process ${COMMAND} is above the ${MAX}M max size, currently ${SIZE}" | mailx -s "bad boy" [EMAIL PROTECTED]

RE: How to duplicate production database onto development box

Hi New Bee, Duplicatiing Oracle Applications has become successively complicated with every release. If you are on 11i and want to use a supported method, then use the 'adclone' method - details on MetaLink. Other unsupported methods exist out there - just search the web for 'clone 11i' and you w

Re: spfile mystery on 9i

Hi! Joan Hsieh writes: > If parameters cannot modified online, then you can added into your > normal init.ora file and recreate spfile again. This is what I did today. Putting session_cached_cursors into the init.ora and recreation seems to work, since the parameter shows up in v$spparameter.

Re: Oracle PL/SQL Developer Needed on Long Island, New York

The thermometer on my garage here in Hugo, MN reads 46 deg. F. and party cloudy. We had a touch of rain early this morning and there is still is a little snow left on the ground. Ken Janusz, CPIM Hugo, MN 55038 - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PRO

Help in unix script

Greetings all, I need to do the following unix> top -b -U norad PID USERNAME THR PRI NICE SIZE RES STATE TIMECPU COMMAND 12733 norad 1 602 3936K 3392K run 0:05 7.21% dbganlz 12747 norad 4 522 13M 10M sleep 0:05 4.20% dbgora 12721 norad 1 53

RE: Best way to move db from AIX to Solaris

Helmut - There are a couple of methods that might suit your needs: 1) Because these platforms are not compatible at the binary level, you can't clone the database by copying datafiles. 2) Export/import will work. Look for FAQs on the Internet for tips on maximizing your speed. If these machines

Re: Problem in 9i - Is this a bug?

Hi, 1) Solaris 8 2) Oracle apps server 11.5.4 During installation I am getting response file error. Can anyone give me leads on this? shreepad -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Serv

Oracle PL/SQL Developer Needed on Long Island, New York

Long Island New York company needs a solid Oracle PL/SQL Developer to join its' I.T. team. PLEASE DO NOT send your resume for this position UNLESS you already live on Long Island (or within a reasonable commute) and have the skills outlined below for this position. DO NOT send your resume unless

BDE 5.0.1. and Oracle 8.1.7.3.0

Does anyone know if Borland Database Engine 5.0.1. is compatible with Oracle 8.1.7.3.0?   I am trying to contact Borland people, but one of their links was dead and I couldn't find a compatibility matrix on their Web site.   Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Sy

Re: Long-running SQL

Stephane, Thanks for your reply. I am going to check into setting the nulls with the application owner to see if that is an acceptable solution. I am unable to create a function-based index as this is a version 8.0.4 database. Thanks, Cherie

Re: Problem in 9i - Is this a bug?

Title: Problem in 9i - Is this a bug? Did you talk to Oracle support about this issue?   Igor Neyman, OCP DBA[EMAIL PROTECTED]  - Original Message - From: Arslan Dar To: Multiple recipients of list ORACLE-L Sent: Thursday, March 28, 2002 6:03 AM Subject: Probl

Re: Trigger question

Roland (and those, who thinks, that RTFM is not such a good advice),   When you are saying, that you "can't get the trigger right", please be more specific: post trigger code, that you wrote, post errors, that you are getting, or if there is no errors, tell, what your trigger does not do, tha

Re: Table Insert Lock!!

You mention a lock?  Are you getting an error message on attempted insert?  Is the transaction committed?  How about issuing the command 'rollback' ? David A. BarbourOracle DBA, OCPAISD512-414-1002 [EMAIL PROTECTED]Sent by: [EMAIL PROTECTED]03/28/2002 04:43 AM PSTPlease respond to ORACLE-L To: Mult

Re: FUNCTION.

One approach is to use object types. There is an item on my web-site that I wrote in early 8.0 days. Use the CAST() operator to convert an input string into an object table of values, then use the TABLE() operator (once the THE()) operator to insert it into your table. Check under: Miscell

Re: Trigger question

Oh my! (Is that gentle enough Jared?) Roland, I admire your ability to participate in this forum using the English language, I certainly could not pose questions within a Swedish discussion group.  Since you have the ability to use the language, might I suggest once again you subscribe at http://ot

RE: client/desktop management from network / was: Re: Net 8 insta

Eric: Thanks for your reply. We use Dell desktops here and have a state contract with Dell. I'll have our Lan people check with Dell. Have a good one. Ron -Original Message- Sent: Wednesday, March 27, 2002 3:23 PM To: Multiple recipients of list ORACLE-L installation on a server co

Re: Table Insert Lock!!

Create your record, then change the tablespace to be read-only. OR Don't grant permissions to insert/update/delete the table to anyone. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, March 28,

RE: hotbackup script for NT OR WIN2000

Brian, I probably should have been, but as Lisa mentions, you have to understand what you are doing and simply running another person's scripts isn't going to help him. I'll try and be a bit more constructive next time! Saul -Original Message- Sent: Wednesday, March 27, 2002 6:09 PM To

RE: FUNCTION.

Hamid, here is a simple proc to do what you want: CREATE OR REPLACE PROCEDURE Str_Insert ( p_recipient IN VARCHAR2 ) IS l_recipientVARCHAR2(200); start_indx NUMBER := 1; str_length NUMBER; BEGIN start_indx := 1;

Table Insert Lock!!

Hi I have to revoke insert from a table where I am the owner of the Schema. is it possible. if so? how?. E.g. Owner a have a table t1 after inserting 1 row owner wish to revoke insert for the table t1. because t1 should not have more than one row. How to incorporate this. it is 8.1.7 on su

RE: Trigger question

Title: RE: Trigger question This should work: CREATE TRIGGER "BEFORE_ROWUPD_ON_TEST"   BEFORE UPDATE OF namn   ON test   REFERENCING NEW AS NEW OLD AS OLD   FOR EACH ROW BEGIN   :NEW.namn := UPPER(SUBSTR(:OLD.namn, 1, 1) || SUBSTR(:OLD.namn), 2); EXCEPTION   WHEN OTHERS THEN     raise_applic

ORACLE REVEALS AMBITIOUS HOSTING PLANS

List, More info on the proposal for Oracle to handle your APPS database. And the cost is3 - 5 % above licensing fee?? Check it out at: http://db.ittoolbox.com/news/nr.asp?i=67582 ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET

RE: Oracle CPU Licensing

Dennis, I remember something from the past about just such a "Deal" . You notified Oracle about the CPU's you had installed and then Oracle would use a "monitoring tool" to see how many CPU's you were using and they would charge you for the actual number of CPU's that you activated and for the ti

Names Servers synchronising

Hi All, I have set up 4 names servers, all using the same region database. Seems to work OK, but I have a few questions How can I check/make sure that there will be some sort of load balancing? How can I make the 4 names servers synchronise with the region database say every 6 hours? (I did c

Trigger question

Hallo, anyone who can please helpme with a trigger script that does the following: I want this script to run when I have updated a field in a table. update test set namn = upper(substr(namn,1,1) || substr(namn),2) I want this trigger to fire only for the selected record(row), that is going to

Re: HOW OLE

Do you mean OLE: Organizational Leadership for Executives ??? JP On Wed 27. March 2002 22:25, you wrote: > Hi > How we can know whether OLE is installed in database? > Thx > -Seema > > > _ > Join the world’s largest e-mail service w

RE: Oracle CPU Licensing

One thing to be wary of is if you want Standard Edition. Typically this can only be used on machines up to 4 CPUs. However, say you want an expandable server that can take 6 CPUs max, but initially you only have 2 CPUs installed, because the server is CAPABLE of having 6 CPUs, you can only use Ent

RE: Off topic - Oracle 9i on W2k - AMD Athlon XP or Intel Celeron

Tamas The problem with the install is easily fixed.. Copy the install CD images to your hard drive, and replace each instance of symcjit.dll (I think there are around 3) with this one: http://www.cool-tools.co.uk/Products/Downloads/symcjit.dll I don't know where you got your info about the P4 B

Problem in 9i - Is this a bug?

Title: Problem in 9i - Is this a bug? Hi, While testing 9i, I have come across a problem while testing to resize the size of Shared Pool Size dynamically, As soon as I give command ALTER SYSTEM SET SHARED_POOL_SIZE= The processor goes to 100% usage, and keeps on 100%, until I kill the ORAC

RE: Off topic - Oracle 9i on W2k - AMD Athlon XP or Intel Celeron

Mark, thanks for your comments. Actually I do Forms developement on the maschine and some surfing and email handling. I do no shoot out gaming or video editing :-). I did not look at P4 because it had some problems with Ora9i installs and every body kept saying that AMD is much cheeper. Now I ch

RE: Off topic - Oracle 9i on W2k - AMD Athlon XP or Intel Celeron

Tamas, I suppose this also depends on what else you use your home machine for? I run 9i on a P4 1.3GHz, and it screams (apart from the fragmented shared pool that I keep on getting - that I need to sort out when I get the time , tips anyone? ;P). Why not put P4 in to the equation? I know it had

Best way to move db from AIX to Solaris

Title: Best way to move db from AIX to Solaris Hi! We want to migrate an Oracle db (approx. 50 GB) from AIX to Sun Solaris. What would be the best way to achieve this? Export/Import I guess, right? This is 8.1.7 on Sun Solaris/AIX. Thanks, Helmut

Re: PL/SQL - procedure - APOLOGY

I apologize for my dirty post here, Roland. I have had a bad day. I'm sorry. Jan Pruner > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > Subject:Re: PL/SQL - procedure > > > Dear Roland, > first try to use your brain th

Re: FUNCTION.

Take a look at the INSTR and SUBSTR functions. hth connor --- Hamid Alavi <[EMAIL PROTECTED]> wrote: > HI LIST, > > I need some help to write a function or procedure > to insert into a table, > the input of this function will be a comma delimiter > string like > (aaa,bbbc,d,f,ggg) and the the

Off topic - Oracle 9i on W2k - AMD Athlon XP or Intel Celeron

Hi, I know this is by far off topic, but if some one could help me with this I would be very grateful. I am running Oracle 9i on my home machine (Celeron 300 MHz) and it is pretty slow. I would like to upgrade either to Celeron 1.2 GHz or AMD XP 1400+ GHz. Apart from the (not negligible) cost di

Re: ORA-24314 service handle not initialized

anyways...how i could look the log. is there any? Stephane Faroult wrote: > paPIpapupapePO wrote: > > > > hi! > > > > every time i start Oracle9i this > > error appears in my screen. > > i dunno how to fix this. > > unfortunately, my first time > > to use Oracle. > > > > thanks in advance. > > >