RE: tnsnames.ora not working ?
If you have a line like this on your sqlnet.ora names.default_domain = world Then try putting an entry like this in tnsnames.ora dbname.world=(etc. etc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Quest....
I like Spotlight. It's about the only GUI type thing I use. It provides a lot of info in a handy format. You still have to use your brain to interpret the info, but you at least have a convenient way of collecting the info. -Original Message- Hey Any thoughts on that quest material? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Quest....
As far as I know (which isn't real far), spotlight just uses the Oracle client. -Original Message- Has anyone tried to run spotlight on linux with windows crossover software? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Quest....
Now I get the question. Sorry about that. -Original Message- but it needs windows os to run ... Right? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: simple question
I'll add that if you have foreign keys, they will mess you up. Here is an old script I have in my stash that you can modify with info already provided by others. procedure truncate_all(code_word in varchar2 default 'XXX') is cursor c1 is select table_name,constraint_name from user_constraints where constraint_type = 'R'; cursor c2 is select table_name from user_tables; handle integer; rows integer; begin if code_word != 'NUKE' then raise_application_error(-20001, 'WRONG MAGIC WORD, BUCKWHEAT.'); end if; dbms_output.enable(10); handle := dbms_sql.open_cursor; for t in c1 loop dbms_sql.parse(handle,'alter table '||t.table_name||' disable constraint '||t.constraint_name, dbms_sql.native); rows := dbms_sql.execute(handle); end loop; for t in c2 loop dbms_sql.parse(handle,'truncate table '||t.table_name, dbms_sql.native); rows := dbms_sql.execute(handle); end loop; for t in c1 loop dbms_sql.parse(handle,'alter table '||t.table_name||' enable constraint '||t.constraint_name, dbms_sql.native); rows := dbms_sql.execute(handle); end loop; exception when others then dbms_output.put_line(SQLCODE||': '||SQLERRM); end; -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Any good product / option for Source code control
PVCS http://www.softlanding.com/merant/vm.htm I used this back when it was Intersolv that owned it. One useful thing about it was that the command line interface was well implemented so scripts to automate check in, check out, software builds, etc. could be written (and were written). -Original Message- I am looking for any good product/option for centralized source code control. Any pointer or experiences shall be appreciated. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Any good product / option for Source code control
Contrary to what note, Jeph? -Original Message- Both tools have a command line capability contrary to Steven's note. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Convert to Locally-Managed Tablespaces
An additional consideration: If you convert the tablespaces in place with dbms_space_admin, check the default storage for initial and next extent. When you do the conversion with dbms_space_admin, a space header is created and the extent allocation for the space header will be whatever the default extent allocation is. You might also have to change how you monitor the free space in your locally managed tablespaces. For example, we used to monitor for the ability to add additional extents for whatever the largest next extent size for all the tables in the tablespace. Monitoring would e-mail for inability to accommodate two additional extents and send out a page for inability to accommodate one additional extent. We had to change this some with local management using uniform extents. With uniform extents, it is likely that you will be using smaller extents. So if you don't trust the users enough to allow auto-extend, then your space monitoring must be enhanced to take into consideration smaller uniform extents. The dbms_space_admin conversion takes only a few seconds even on 50 Gig tablespaces. And if you don't like what you see, you can convert the tablespace back to dictionary managed; then back to local; then back to dictionary Oh this is fun! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OCP Question (Perf Tuning)
Think like a computer. Which execution plan will be the result? result of what? an insert statement? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OCP Question (Perf Tuning)
What I meant is that the question cannot be answered without making human assumptions about the question itself. It is a little difficult (Note little not lot) to believe that such a poorly written question would appear on a test that costs money to take. -Original Message- Someone suggested that you think like a computer. Well, for the philosophy behind the exam, think like an organization, namely Oracle University. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: rman restore question
I have never attempted what you are doing, so I must confess some ignorance. But, looking at your error message, it appears that rman knows what file it needs and is unable to get it. One must assume there is no file named /rmanbackup/ADVDBA_F_20031231:15:03:39_1.450.rman available on the hard drives. -Original Message- After I did some testing, it is impossble to restore and recover a deleted obsolete backupset. So I took off the delete obsolete command. Retention policy to redundancy still keep it to 1. I did couple backups and run list backup of database and report obsolete command. Although report obsolet show the backupset but they also shown in list backup of database report and status is valid. Now I have to rephase my question, is it possible to recover from an old backups? I tried restore full, it keep give me the error and asking the newest backupset which I intend move to somewhere else. RMAN-03002: failure of restore command at 12/31/2003 15:36:27 ORA-19505: failed to identify file /rmanbackup/ADVDBA_F_20031231:15:03:39_1.450.rman ORA-27037: unable to obtain file status IBM AIX RISC System/6000 Error: 2: No such file or directory -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Exporting a partition with transport tablespace
Your brain is getting full. You should stop studying so much. See what it does to you? -Original Message- Yep, I didn't remember the exact clause in the exchange partition syntax. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Display unix directory hierarchy
It suddenly popped into my head a couple days ago that there could be a problem with the script (isn't it crazy what the subconscious mind does?). Note that when it cd's to a new directory, it ASS-U-MEs that it can do that; and then it calls the script again. I haven't verified if for sure (shoot me now), but I think this could set up a nasty loop. So one should test the readability and executability (??) of the directory before trying to cd into it -- the solution to which is left as an exercise for the reader. (AAAUGH! Yeah, I've had a Math course or two.) -Original Message- In addition to the fine solution from Bambi, Here's another approach that I think will work. I did only minimal testing (in TRUE development tradition. But ... But ... It worked OK in test!). One caveat: This relies on recursion, so on a big directory tree you might get swatted with OS resource limitations. -- #!/bin/ksh if [ $# -eq 1 ]; then ARG=$1 else ARG=0 export MYNAME=`pwd`/`basename $0` fi X=0 PAD= while [ $X -lt $ARG ]; do PAD=$PAD X=$(( X + 1 )) done ## list non-directory files first for i in `ls -a1 2 /dev/null`; do if [ $i = . -o $i = .. ]; then continue fi if [ ! -d $i ]; then echo $PAD$i fi done ## then plow into the directories ## NO. They ain't folders. They're DIRECTORIES. for i in `ls -a1 2 /dev/null`; do if [ $i = . -o $i = .. ]; then continue fi if [ -d $i ]; then echo $PAD/$i { cd $i $MYNAME $(( $ARG + 1 )) cd .. } fi done -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Database Instance
It is not necessarily true that an error in one application will affect all applications. If there is a problem with oracle instance or the database, then all applications might be affected. Multiple schemas which have the same table names can be a problem. If your applications uses public synonyms, then you might have a big problem. If everything is working fine now, it seems pointless to move things around. But this is philosophy. I do believe that isolating applications from each other as much as possible is usually a good thing. Good fences make good neighbors. (usually) But, if your manager insists on it, you have no choice. Just do your best to keep the old stuff around in case it becomes apparent that the new way will not work and you must go back to the old way. -Original Message- Lately, my manager want me to remove all the databases and remain a single instance. I was wondering if i move everything into single database then if one of the application fail due to oracle error , then all other four application will fail also rite ? Each of our web application needs to have 2 schema and both schema have to be transparent to each other. While other application schema will be invisible to each other. Since i have 5 web app then i will need 10 schema.One major problem is all the 10 schema will contain same table name. It will be a mess putting so much app in a single db . Pls correct me if i am wrong and do let me know what are the pro and cons or maybe you can educate me with some of the best practice to setup a proper production server environment. Thank You Regards, Jkean -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Risk of knowing password hash value (Was: OEM permissions)
When I brought the issue up, I didn't know if one could in fact maliciously use that info. And, as I originally stated, it was something I had not tried. But paranoia (healthy, I think) dictates there's gotta be a way. When one looks at the Unix password world which brought about the necessity for a shadow file, and the evils of the old NIS where ypcat was available, you have to wonder why allowing access to the encrypted passwords for Unix is considered a dumb thing to do, but somehow in Oracle it would be an OK thing to do. I'm inclined to say that Oracle restricted access to the views and underlying tables for reasons more substantial than just to frustrate non-privileged users. And, if I'm not mistaken, the specs on the views are subject to change without notice. I have enough to do without trying to stay on top of every stinkin' view in Oracle in every stinkin' release and how one might use that view in naughty ways. For what it's worth, after haggling and fussing, we were able to compromise on this. We haven't tried to tear each of these apart to see how it might be abused. If any of you have some warnings to provide, please do! -- Must run this as SYS create role DBARTISAN_USER_ROLE; grant SELECT on SYS.V_$PROCESS to DBARTISAN_USER_ROLE; grant SELECT on SYS.V_$SESSION to DBARTISAN_USER_ROLE; grant SELECT on SYS.V_$LATCH to DBARTISAN_USER_ROLE; grant SELECT on SYS.V_$LATCHNAME to DBARTISAN_USER_ROLE; grant SELECT on SYS.V_$LATCHHOLDER to DBARTISAN_USER_ROLE; grant SELECT on SYS.V_$LOCK to DBARTISAN_USER_ROLE; grant SELECT on SYS.V_$SESSTAT to DBARTISAN_USER_ROLE; grant SELECT on SYS.V_$MYSTAT to DBARTISAN_USER_ROLE; grant SELECT on SYS.V_$SYSSTAT to DBARTISAN_USER_ROLE; grant SELECT on SYS.V_$STATNAME to DBARTISAN_USER_ROLE; grant SELECT on SYS.V_$ACCESS to DBARTISAN_USER_ROLE; grant SELECT on SYS.V_$FILESTAT to DBARTISAN_USER_ROLE; grant SELECT on SYS.V_$ROLLNAME to DBARTISAN_USER_ROLE; grant SELECT on SYS.V_$ROLLSTAT to DBARTISAN_USER_ROLE; grant SELECT on SYS.V_$SGA to DBARTISAN_USER_ROLE; grant SELECT on SYS.V_$PARAMETER to DBARTISAN_USER_ROLE; grant SELECT on SYS.V_$ROWCACHE to DBARTISAN_USER_ROLE; grant SELECT on SYS.V_$LIBRARYCACHE to DBARTISAN_USER_ROLE; grant SELECT on SYS.V_$INSTANCE to DBARTISAN_USER_ROLE; grant SELECT on SYS.V_$DISPATCHER to DBARTISAN_USER_ROLE; grant SELECT on SYS.V_$SQLAREA to DBARTISAN_USER_ROLE; grant SELECT on SYS.V_$SQLTEXT to DBARTISAN_USER_ROLE; grant SELECT on SYS.V_$SQLTEXT_WITH_NEWLINES to DBARTISAN_USER_ROLE; grant SELECT on SYS.V_$OPEN_CURSOR to DBARTISAN_USER_ROLE; grant SELECT on SYS.V_$PQ_SYSSTAT to DBARTISAN_USER_ROLE; grant SELECT on SYS.V_$SGASTAT to DBARTISAN_USER_ROLE; grant SELECT on SYS.V_$SHARED_SERVER to DBARTISAN_USER_ROLE; grant SELECT on SYS.V_$DATAFILE to DBARTISAN_USER_ROLE; grant SELECT on SYS.V_$TABLESPACE to DBARTISAN_USER_ROLE; grant SELECT on SYS.V_$SESS_IO to DBARTISAN_USER_ROLE; grant SELECT on SYS.ALL_OBJECTS to DBARTISAN_USER_ROLE; grant SELECT on SYS.DBA_ROLLBACK_SEGS to DBARTISAN_USER_ROLE; grant SELECT on SYS.PRODUCT_COMPONENT_VERSION to DBARTISAN_USER_ROLE; grant SELECT on SYS.DBA_EXTENTS to DBARTISAN_USER_ROLE; grant DBARTISAN_USER_ROLE to USER_WE_DONT_LIKE; -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Display unix directory hierarchy
In addition to the fine solution from Bambi, Here's another approach that I think will work. I did only minimal testing (in TRUE development tradition. But ... But ... It worked OK in test!). One caveat: This relies on recursion, so on a big directory tree you might get swatted with OS resource limitations. -- #!/bin/ksh if [ $# -eq 1 ]; then ARG=$1 else ARG=0 export MYNAME=`pwd`/`basename $0` fi X=0 PAD= while [ $X -lt $ARG ]; do PAD=$PAD X=$(( X + 1 )) done ## list non-directory files first for i in `ls -a1 2 /dev/null`; do if [ $i = . -o $i = .. ]; then continue fi if [ ! -d $i ]; then echo $PAD$i fi done ## then plow into the directories ## NO. They ain't folders. They're DIRECTORIES. for i in `ls -a1 2 /dev/null`; do if [ $i = . -o $i = .. ]; then continue fi if [ -d $i ]; then echo $PAD/$i { cd $i $MYNAME $(( $ARG + 1 )) cd .. } fi done -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Spam: RE: Risk of knowing password hash value (Was: OEM permi
I wonder if there is a pre-encrypted list available of all Monty Python words, Babylon 5 words, Star Trek words, etc. etc. Actually, I can't think of any better password than LEXADOIG. -Original Message- Not really... you could easily compile a list of passwords and their associated hashes. Once this is done, it's just a simple matter of matching the hashes. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Duplicating with rman
Yeah. I noticed that too and wondered about it. The script that was posted was, in fact, the script that was run. Maybe same kind of line length limitation? -Original Message- From: Yong Huang [mailto:[EMAIL PROTECTED] Sent: Saturday, December 20, 2003 2:24 PM To: Multiple recipients of list ORACLE-L Subject: Re: Duplicating with rman Hi, I'm not sure why your RMAN output says LOGFILE GROUP 1 ( '/z01/oradata/DEVL/redo_01a.dbf', '/z02/oradata/DEVL/redo_01b.dbf', GROUP 2 ( '/z01/oradata/DEVL/redo_02a.dbf', Where's the ) reuse shown in your RMAN script? Are you sure the script you showed here was run? Yong Huang you wrote: RMAN-06162: sql statement: CREATE CONTROLFILE REUSE SET DATABASE DEVL ... LOGFILE GROUP 1 ( '/z01/oradata/DEVL/redo_01a.dbf', '/z02/oradata/DEVL/redo_01b.dbf', GROUP 2 ( '/z01/oradata/DEVL/redo_02a.dbf', '/z02/oradata/DEVL/redo_02b.dbf', ... RMAN-06136: ORACLE error from auxiliary database: ORA-02236: invalid file name RMAN-06097: text of failing SQL statement: CREATE CONTROLFILE REUSE SET ... LOGFILE GROUP 1 ( '/z01/oradata/DEVL/redo_01a.dbf', '/z02/oradata/DEVL/redo_01b.dbf', GROUP 2 ( '/z01/oradata/DEVL/redo_02a.dbf', '/z02/oradata/DEVL/redo_02b.dbf', ... RMAN script is: run { allocate auxiliary channel d1 type disk; set until logseq 5115 thread 1; set newname for datafile 1 to '/u03/oradata/DEVL/system_01.dbf'; ... duplicate target database to DEVL nofilenamecheck logfile group 1 ('/z01/oradata/DEVL/redo_01a.dbf','/z02/oradata/DEVL/redo_01b. dbf') reuse, group 2 ('/z01/oradata/DEVL/redo_02a.dbf','/z02/oradata/DEVL/redo_02b. dbf') reuse, group 3 __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Duplicating with rman
I was using RMAN to duplicate a database -- my first time (please be gentle). Copied an on-disk rman backup to target box. started clone instance nomount. rman nocatalog connect target abc/[EMAIL PROTECTED] connect auxiliary xyz/[EMAIL PROTECTED] @script (see below) Everything was going OK until Got error: RMAN-08523: restoring datafile 00016 to /u03/oradata/DEVL/ora_audit_idx_01.dbf RMAN-08023: channel d1: restored backup piece 1 RMAN-08511: piece handle=/u05/oracle/admin/HRP1/backup/dnf9b1m4_1_1_DATA tag=BACKUP_DB_FULL params=NULL RMAN-08024: channel d1: restore complete RMAN-06162: sql statement: CREATE CONTROLFILE REUSE SET DATABASE DEVL RESETLOGS ARCHIVELOG MAXLOGFILES 32 MAXLOGMEMBERS 2 MAXDATAFILES 254 MAXINSTANCES 1 MAXLOGHISTORY 907 LOGFILE GROUP 1 ( '/z01/oradata/DEVL/redo_01a.dbf', '/z02/oradata/DEVL/redo_01b.dbf', GROUP 2 ( '/z01/oradata/DEVL/redo_02a.dbf', '/z02/oradata/DEVL/redo_02b.dbf', GROUP 3 ( '/z01/oradata/DEVL/redo_03a.dbf', '/z02/oradata/DEVL/redo_03b.dbf', GROUP 4 ( '/z01/oradata/DEVL/redo_04a.dbf', '/z02/oradata/DEVL/redo_04b.dbf' DATAFILE '/u03/oradata/DEVL/system_01.dbf' CHARACTER SET US7ASCII RMAN-03026: error recovery releasing channel resources RMAN-08031: released channel: d1 RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03002: failure during compilation of command RMAN-03013: command type: Duplicate Db RMAN-06136: ORACLE error from auxiliary database: ORA-02236: invalid file name RMAN-06097: text of failing SQL statement: CREATE CONTROLFILE REUSE SET DATABASE DEVL RESETLOGS ARCHIVELOG MAXLOGFILES 32 MAXLOGMEMBERS 2 MAXDATAFILES 254 MAXINSTANCES 1 MAXLOGHISTORY 907 LOGFILE GROUP 1 ( '/z01/oradata/DEVL/redo_01a.dbf', '/z02/oradata/DEVL/redo_01b.dbf', GROUP 2 ( '/z01/oradata/DEVL/redo_02a.dbf', '/z02/oradata/DEVL/redo_02b.dbf', GROUP 3 ( '/z01/oradata/DEVL/redo_03a.dbf', '/z02/oradata/DEVL/redo_03b.dbf', GROUP 4 ( '/z01/oradata/DEVL/redo_04a.dbf', '/z02/oradata/DEVL/redo_04b.dbf' RMAN-06099: error occurred in source file: krmk.pc, line: 7544 RMAN **end-of-file** - - RMAN script is: run { allocate auxiliary channel d1 type disk; set until logseq 5115 thread 1; set newname for datafile 1 to '/u03/oradata/DEVL/system_01.dbf'; set newname for datafile 2 to '/u03/oradata/DEVL/rbs_01.dbf'; set newname for datafile 3 to '/u03/oradata/DEVL/users_01.dbf'; set newname for datafile 4 to '/u03/oradata/DEVL/tools_01.dbf'; set newname for datafile 5 to '/u03/oradata/DEVL/temp_01.dbf'; set newname for datafile 6 to '/u03/oradata/DEVL/css_temp_01.dbf'; set newname for datafile 7 to '/u03/oradata/DEVL/css_tools_01.dbf'; set newname for datafile 8 to '/u03/oradata/DEVL/css_tools_index_01.dbf'; set newname for datafile 9 to '/u03/oradata/DEVL/css_data_01.dbf'; set newname for datafile 10 to '/u03/oradata/DEVL/css_data_index_01.dbf'; set newname for datafile 11 to '/u03/oradata/DEVL/css_pay_01.dbf'; set newname for datafile 12 to '/u03/oradata/DEVL/css_pay_index_01.dbf'; set newname for datafile 13 to '/u03/oradata/DEVL/css_pay2_01.dbf'; set newname for datafile 14 to '/u03/oradata/DEVL/css_pay2_index_01.dbf'; set newname for datafile 15 to '/u03/oradata/DEVL/ora_audit_01.dbf'; set newname for datafile 16 to '/u03/oradata/DEVL/ora_audit_idx_01.dbf'; duplicate target database to DEVL nofilenamecheck logfile group 1 ('/z01/oradata/DEVL/redo_01a.dbf','/z02/oradata/DEVL/redo_01b.dbf') reuse, group 2 ('/z01/oradata/DEVL/redo_02a.dbf','/z02/oradata/DEVL/redo_02b.dbf') reuse, group 3 ('/z01/oradata/DEVL/redo_03a.dbf','/z02/oradata/DEVL/redo_03b.dbf') reuse, group 4 ('/z01/oradata/DEVL/redo_04a.dbf','/z02/oradata/DEVL/redo_04b.dbf') reuse; } - - The error ORA-02236: invalid file name would seem to indicate a syntax problem in the rman script. But I can't figure it out. Recreating the control file by hand then running: RMAN run { 2 allocate auxiliary channel d1 type disk; 3 set until logseq 5115 thread 1; 4 recover clone database; 5 } Worked OK. Any suggestions? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of
RE: OEM permissions
Maybe I'm a being a bit touchy here; but it seems that my comments about having access to dba_users went completely unnoticed. Let's put it this way: There is NO WAY you can prevent somebody from setting up their own private oracle instance. It they have access to dba_users in your database, they can create the SAME users with the SAME passwords in their private database. And they can create database links in their private database. Now, is this a problem? -Original Message- From: Michael Thomas [mailto:[EMAIL PROTECTED] Sent: Friday, December 19, 2003 12:34 PM To: Multiple recipients of list ORACLE-L Subject: RE: OEM permissions A possibly related question: I'm curious if everyone allows your developers to see V$SQL... views? If not, then ... whatever ... no comment. I'm disappointed with some perspectives in these threads regarding developers. Rather than close doors, why not use 'development' instances, and role based privs on the 'production' instance and grant the access required to the developers. E.g. Help them determine which Data Dictionary tables support their development? Good luck. --- Yong Huang [EMAIL PROTECTED] wrote: Hi, Raj, 9i doesn't allow a user with select any table privilege to view any object owned by SYS. So the sys.link$ risk is gone. But select any dictionary, a new privilege in 9i, allows that. In practice, I always grant select_catalog_role to any developer, but refrain from granting select any dictionary or select any table. As DBAs, we should encourage developers to make full use of data dictionary views and open the database to them as much as they can study it. I would help the consultant in your case instead of just throw back a NO to him. Yong Huang Jamadagni, Rajendra wrote: Dennis, select any table has to be a big no no ... anyone can select from sys.link$. But I am still trying how OEM can be used for _development_?? what am I missing? As for ... One of our groups hired a new consultant and he (claimed to have DBA background) immediately shot off an email saying he needed select any table and select catalog role to do his work. We shot off reply Thanks for your email, while we appreciate your requirements for development, the privileges you are requesting are a tad different than we grant other developers. However we request that you submit a justification for these privileges and tell us how your development would be affected without these and we will accommodate your request. This was 3 months ago and we _still_ haven't heard back. __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OEM permissions
Wouldn't this allow viewing DBA_USERS? I haven't tried this myself, but it seems that I could set up another oracle instance, create a user identified by values, then create database link. -Original Message- We have a new manager that wants his group to use OEM for development access, as an alternative to Toad. He has requested a special Oracle userid with the following grants: SELECT_CATALOG_ROLE SELECT ANY DICTIONARY SELECT ANY TABLE Does this seem reasonable for OEM? The manager is responsible for the data in the database, so I don't see a problem with him viewing the data. There are few database links, and I'll be reviewing them. Any ideas on what mischief could occur? Thanks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OffTopic : sed : Alternate (2,4,6..) replacement
Will this work? -- #!/usr/bin/ksh THINGY=0 cat swt | sed 's/:/ /' | while read A B JUNK; do if [ $THINGY -eq 1 ]; then B=that THINGY=0 else THINGY=1 fi echo $A:$B $JUNK done -- You can set up a similar loop in awk too. The sed 's/:/ /' changes the colon to a space so that the read A B JUNK will work. -Original Message- Hi List I need some help on this; How do i replace the 2nd,4th,6th occurances of a column (vertical) in a file. I know sed does it within a row $ cat swt 01:this is a file1 this 02:this is a file1 this 03:this is line3 04:this is line4 $ sed 's/this/that/2' swt 01:this is a file1 that 02:this is a file1 that 03:this is line3 04:this is line4 $ sed 's/this/that/1' swt 01:that is a file1 this 02:that is a file1 this 03:that is line3 04:that is line4 But i want 01:this is a file1 this 02:that is a file1 this 03:this is line3 04:that is line4 I tried awk but awk seems to be going one line at a time. Thanks in Advance. GovindanK -- http://www.fastmail.fm - The professional email service -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Unreadable time_stamp format
Possibly a Boolean date? -Original Message- Which I assume means you have no idea how to get a readable date out of that? A thought, it could a be a julian date of some kind. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OffTopic : sed : Alternate (2,4,6..) replacement
OK. You got me going on this for a solution when GNU sed is not available. (See what you did.) Instead of the ksh example, here's a non-GNU sed one that works. It works on GNU sed too. sed ' $!N s/\(^.*\n.*:\)\(this\)\(.*$\)/\1that\3/ p d ' Here's an awk that is essentially the equivalent of the ksh thing. awk -F':| ' ' BEGIN{ x = 1 } (x = 0||(x-1)) == 1 {$2 = that} {print $1:$2,$3,$4,$5,$6,$7,$8,$9} ' -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: NT - Win2K causes performance degradation..
Might also be they bumped shared_pool way up and they aren't using bind variables? -Original Message- When they upgraded the memory, by just now much did they increase db_block_buffers? If increased too much, they could be spending a lot of time waiting on latches, as there may be too much memory to search through. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: dc_used_extents ,dc_free_extents and dc_histogram_defs
No no. That's the rings of Saturn made of lost airline luggage, discarded accordions, and now secrets. I think microchannel bus is up there. -Original Message- Graveyard is full of companies whose secrets are safe. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: PERL?
I've written one shell script using the coprocess. I don't like using it. But that's just me. I think one way of describing ksh (for the male readers out there, anyway) is that ksh is like the legally blonde girlfriend: There are times when you wish there was more intelligence there. But she has enough features to satisfy; and she's so easy, you just going back to her. -Original Message- I don't think any UNIX shell has some package or module written for any database. So the only way to talk to Oracle is using shell as a wrapper around sqlplus (or any application you developed). In sqlplus, you can use bind variables easily. In this sense, we can say shell does allow you to use bind variables. Speaking of Perl versus shell, Perl may still be quite primitive in supporting two-way communication with an external program e.g. sqlplus. (I have an example at www.stormloader.com/yonghuang/computer/OracleAndPerl.html#2way tosqlplus using IPC::Open2). But I think a KornShell coprocess (not a here document) does it nicely, i.e. piping a SQL command in and reading the result back, piping another command in, reading again, without exiting your sqlplus session. If you use Perl DBI (or the old OraPerl), Jared may know this but I'm not sure if you can send any arbitary SQL command such as explain plan, shutdown... and read its output. Yong Huang One BIG advantage of Perl is DBI. Via shell you can't use bind variables which sometimes come in handy. An admin dweeb here developed a __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: PERL?
The difference that has affected me the most in writing utility scripts is that PERL can talk to the database like using a telephone. Ksh must talk like using a walkie-talkie; that is, each side of the conversation must talk then release the push-to-talk (PTT) button before the other side can talk. Using a small amount of cleverness (which is good, because that's about how much I have) in ksh, you can program around most of the communication limitations. For example, to deal with sqlplus getting stuck for one reason or the other, you can run the subsection of the script in the background (as a ksh job). Then you check on the job later in the script. If the job is still there longer than it should be, the script can kill the job. THEN, for good measure, look for sqlplus (and possible another ksh that got forked by the script) with parent process ID (PPID) of me and kill them. This is similar to the other side failing to release the PTT button. Unlike PERL, which can maybe yell into to telephone to wake the other side up, ksh must launch an artillery shell onto the other guy which, in a rather violent manner, will cause him to release the PTT button (well ... actually .. the PTT switch kind of got blown up too). Then, depending on the situation, retry the sqlplus or conclude that something is wrong. That being said, ksh is so easy to use and so handy, that I still use it for automating database management and monitoring. I'm sure a big part of that is because I learned shell, sed, awk, etc. programming before perl was standard equipment on Unix boxes. I suppose if you are starting from the beginning, then the way to go would be perl. But you can still do a heck of a lot with ksh (the REAL ksh; not the POS public domain ksh that tends to show up with linux). For an excellent book on getting started with this, go to Amazon and search on Mark G. Sobell (or just Sobell). Here's a tinyurl link to what I think is still must-have book. Even though a lot of it is outdated, the sections on getting around in Unix and shell scripting are still entirely relevant. http://tinyurl.com/y8x6 (Note that the used book sellers are just about giving away the book) There is also a BSD version of the above book. And you want to get O'Reilly's book on Sed and Awk. Those should get you going down the wonderful world of shell scripting ... which is the ORIGINAL, and still great, Rapid Application Development. -Original Message- I've read a lot about PERL on this list. And, I am wondering what can you do with PERL that you cannot do with SQL*Plus, PL/SQL or Unix shell scripts? Any information will be greatly appreciated. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: PERL?
Don't know why not. Using the here document anything you can type in on the sqlplus command line can be entered with ksh ... including the defining of bind variables. -Original Message- Via shell you can't use bind variables which sometimes come in handy. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: PERL?
#!/usr/bin/ksh sqlplus -s -XXX joecool/jomama var xyz char(50) var abc char(50) begin :xyz := 'HELLO WORLD'; select :xyz into :abc from dual; end; / print abc XXX -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RMAN questions
I suppose just how much redundancy makes you sleep well is up to you. But, one additional bit of info to keep in mind is that the backup info also gets stored in the control files, and rman can use those too if no catalog database is available. Making a copy of a control file after the backup finishes, and saving that copy, can be a part of the rman backup. That way, if you lost all control files and your catalog database, rman can use your saved control file copy get back at least most, if not all, of your stuff. -Original Message- Any suggestions would be appreciated. I can handle the scripting my self. Im just looking for a viable plan. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: UNIX OT: exclude files in tar
Expanding the logic to its logical conclusion, we produce philosophies similar to that found at www.despair.com. CONSULTING: If you aren't part of the solution, then there is good money to be made in prolonging the problem. -Original Message- I like that logic! I might just start (ab)using Perl now. Thanks to all replies. Now I've got a few options to play around with to do this 'exclude files' and not necessarily tar . -Original Message- On 11/25/2003 11:44:26 AM, [EMAIL PROTECTED] wrote: Maybe can use -prune option of find to send file list to tar: Why do it in a simple way when there is an opportunity to (ab)use perl? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: UNIX OT: exclude files in tar
Maybe can use -prune option of find to send file list to tar: cd /home find ./user01 -name mark03 -prune -o -print -Original Message- I can't seem to get the tar command right. I wanted to tar a directory but EXCLUDE one of the subdirectory in it. Example: /home/user01 /home/user01/mark01 /home/user01/mark01/ask.txt /home/user01/mark01/ghost.txt /home/user01/mark02 /home/user01/mark02/ask.txt /home/user01/mark02/ghost.txt /home/user01/mark03 /home/user01/mark03/ask.txt /home/user01/mark03/ghost.txt I wanted to tar everything except /home/user01/mark03/* man pages on tar says there is an option to exclude files but I just can't get it to work for me. Can someone show me how to do this right? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: LF and CR (chr(10)||chr(13)) problem
Maybe possible that this is related to what Unix needs at that end of a line and what DOS needs at the end of line and what happens when such files get FTP-ed in ascii mode from one to the other? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Clean temporary tablespace
I got the impression that the poster was thinking segments allocated in temp tablespace must be released, cleaned out, blown away, etc. before something else can come along and use the space. -Original Message- End of the day, read to it through fast, what can I say. I totally blew by the part that said 'TEMPORARY'. Now that I realize which thread I'm in, going back through it reveals that the original poster has still not clarified his original post. eg. there isn't enough information provided to form any conclusions -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Clean temporary tablespace
Ja. That was my point ... and probably why some people didn't quite understand the original question (a lot of assumption on my part, but I think that is what the confusion was about). -Original Message- From: Thater, William [mailto:[EMAIL PROTECTED] Sent: Friday, November 14, 2003 12:09 PM To: Multiple recipients of list ORACLE-L Subject: RE: Clean temporary tablespace [EMAIL PROTECTED] scribbled on the wall in glitter crayon: I got the impression that the poster was thinking segments allocated in temp tablespace must be released, cleaned out, blown away, etc. before something else can come along and use the space. i was always under the impression that you didn't need to do anything to the temp tablespace. that the segments were just reused as needed. am i behind the times here? -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] -- -- Shift to the left! Shift to the right! Pop up, push down, byte, byte, byte! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Need A Split File Option
Do you mean something like this? #!/usr/bin/ksh cat input_file | while read A B C D JUNK; do if [ $D != auto ]; then echo $A $B $C $D $JUNK error_file else echo $A $B $C $D $JUNK ${C}_AUTO fi done -Original Message- A developer in our shop would like to read an input file and based on some field values for each record in the file split them into multiple files. The output files will be used by a 3rd party package for processing. (the package does not need the oracle database) For example: Input File: record a: WI auto ... record b: WI auto ... record c: NY auto ... record d: YY home ... Output file WI_AUTO: record a: WI auto ... record b: WI auto ... Output file NY_AUTO: record c: NY auto ... Error file: record d: YY home ... (no entry in the criteria lookup table to pick up this record therefore send it to an error file) Their solution is to load an oracle table with the input file. An additional table would contain the criteria and the name of the output file to write to. They would write a procedure to read the criteria and input table and utilize the utl_file package to create the output files. There may be 50+ output files initially and likely will grow over time. My gut tells me that this does not belong in the database, rather we should be able to split the file using C or a utility such as syncsort (which we do not have). We are currently at 8.1.7.4 on AIX 4.3.3. Is there a more elegant solution and what would it be??? Are there any open source unix utilities that may help? Thanks American Express made the following annotations on 11/13/2003 12:20:23 PM -- ** This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this message and any attachments is prohibited. If you have received this communication in error, please notify us by reply e-mail and immediately and permanently delete this message and any attachments. Thank you. ** == -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tracy Rahmlow INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Stop using SYS, SYSTEM?
And for an opposing opinion: Let's see now. We create another user and grant that user all the privileges needed to do ANYTHING. And that makes things so much more secure? If that's the prevailing thought among the database world, then it's safe to say that the Unix admins have infinitely more common sense by logging as root when functioning as root. Well NO! We should create a user named rewt with the same UID and GID as root; and then always log in as rewt (or route). For what it's worth, if you have many databases, it's going to be a real pain in the ass to track every stinkin' DBA account and not have those DBA accounts that we forgot about when old Joe quit or (worse) when Billy Bob decided to become a developer instead of a DBA. If somebody can't log in as SYSTEM or SYS without fouling things up, they shouldn't be logging in at all. And if they have DBA privs, they can make a mess regardless of whether they log in as SYSTEM or CISTUM. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Remote SQL*Loader session won't die
I have no idea why the same command would work differently on different machines if all other things are the same. Just a shot in the dark here: Sometimes rsh must be used with -n option (see man page.) Of course, you know using r commands is in hideous opposition to politically correct security and auditing requirements ... you know ... like the requirement that people to log in as CISTUM rather than SYSTEM. -Original Message- We are creating some Unix (DEC/Compaq/HP) ksh scripts to move data to a remote system and then execute SQL*Loader (Oracle 8.1.6). Logging in on the remote system, this works fine. If the commands are executed from the command line using rsh, it works fine. But when SQL*Loader is executed through rsh, within a script, the load works fine, but the process doesn't terminate, just hangs. To add another wrinkle, going to a different machine works fine also, but the system administrator says there isn't any difference between the machines. And executing anything other than SQL*Loader works fine. I'm stumped and would welcome any ideas. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: for years I have been using korn shell
Concerning pdksh: Unless it has been fixed (and I don't think it has), it is too buggy to be used for scripting. If you are going to download and install ksh, get The Real Thing. If you have way too much time on your hands and want a monster shell -- the biggest of them all, get zsh; it's strictly for certified geeks as evidence by your consumption of Twinkies and Mountain Dew. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL*Plus question - a bit urgent - Can we suppress 'Connected
My reply was probably a bit too brief. The most robust way for doing this would be to use pattern matching utilities such as sed and awk (Perl? What's Perl?) to parse that output for stuff like ORA- (N is a digit of a number) TNS- SP- etc. But for a quick and dirty approach, select an additional dummy word in the select statement then parse for that word as the first word in the line; that's what the read statement does for you. You could add another condition outside the while read loop to see if the value you got is reasonable. For example set MY_VARIABLE='BROKE' before running sqlplus, then see if MY_VARIABLE is still BROKE or empty when the loop is done. -Original Message- I take back that statement of mine. Gotta take Unix lessons. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL*Plus errors... how to hide?
If the data is supposed to be strictly numeric, you can intercept the bad data prior to running the sql. X='' while [ -z $X ]; do echo echo Enter a number or Q to quit read X if [ $X = Q ]; then echo Exiting ... exit 0 fi if [ -z $X ]; then echo echo That was a blank entry. Try again. echo continue fi if [ -n `echo $X | sed -n '/[^0-9]/p'` ]; then echo echo You entered at least one non-numeric character. echo You entered -${X}- echo Try again. echo X= continue fi done -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL*Plus question - a bit urgent - Can we suppress 'Connected
Rather than try to get output using the ` characters, see what you can do with this method: { sqlplus -s -XXX $USER/[EMAIL PROTECTED] set heading off feedback off trims on lines 300 pages set whatever else do this; do that; do the other thing; XXX } | while read LINE; do parse $LINE with sed, awk, whatever if [ this is true ]; then do something fi done If all you want is to do a simple select that is supposed to return one line, one cheap, but not especially robust, way of doing it is like { sqlplus -s -XXX $USER/[EMAIL PROTECTED] set heading off feedback off trims on lines 300 pages set whatever else select 'DOINK',name from v$database; -- or select 'DOINK '||name from v$database; XXX } | while read DOINK LINE; do if [ $DOINK = DOINK ]; then DBNAME=$LINE fi done Now, if one is proficient in sed and awk, more elegant and robust means can be devised. -Original Message- From: Charu Joshi [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 6:05 AM To: Multiple recipients of list ORACLE-L Subject: SQL*Plus question - a bit urgent - Can we suppress 'Connected.' message? Hello all, I am calling SQL*Plus from a unix shell script and storing the results of the query executed in a shell variable. It goes like this: FL_SUFFIX=`sqlplus -s /nolog EndOfSQL SET ECHO OFF SET FEEDBACK OFF SET VERIFY OFF SET PAGESIZE 0 CONN $ORA_ID/$ORA_PASS SELECT dummy FROM dual; -- Dummy query.. unrelated to the question. EXIT SQL.SQLCODE EndOfSQL` But the contents of the FL_SUFFIX are 'Connected.' instead of the value returned by the query. This is obviously because of the 'CONN $ORA_ID/$ORA_PASS' statement. Is there a way to suppress the 'Connected.' message that comes on connecting to database? I have thought about 2 solutions: 1. Use sqlplus -s $ORA_ID/$ORA_PASS :- This would be the last alternative in case everything else fails .. obviously from security point of view. 2. Create a .sql script as: SET ECHO OFF SET FEEDBACK OFF SET VERIFY OFF SET PAGESIZE 0 SET TERMOUT OFF -- The important bits. SPOOL /dev/null -- CONN $ORA_ID/$ORA_PASS SPOOL OFF -- SET TERMOUT ON -- The important bits. SELECT dummy FROM dual; -- Dummy query. EXIT SQL.SQLCODE and then call this script as FL_SUFFIX=`sqlplus -s /nolog @a.sql` I think solution 2 will work, but I am loathe to writing a script for a single SQL statement unless there is no other way. Any new ideas would be greatly appreciated, the quicker the better. Thanks regards, Charu. * Disclaimer This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Refresh option for Materialized view , want to use it during
This was my original suggestion. The only snag I can think of is if you have a bunch of dependencies like stored procedures and triggers. Even if somebody was selecting from the old table when you renamed it, the select would continue OK ... as long as you don't truncate it. You could even delete from the old table without hosing a running select ... as long as the rollback segment holds up. You could rename the tables, then truncate maybe an hour later. -Original Message- Arup, I really appreciate your answer in great details. I got on prebuilt table work. Thanks a lot for your help. Here is another question: Do you see any advantage to use materialized view on prebuilt table for my data loading over just simple renaming tables as steps below: 1. create table t that is always accessed by applications 2. create table t1 that is a temp table for loading 3. load data into table t1 4. rename table t to table t2 5. rename table t1 to t 6. rename table t2 to t1 7. truncate table t1 for next day loading David -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-4031 errors no a high Load Database
There is/(are) known bug/(s) in 9.2.0.3 where the shared pool becomes fragmented and will refuse to un-fragment itself. Attempts to flush the shared pool fail. So far, based own our experience here, this seems to be fixed in 9.2.0.4. Things like shared pool details tend to leak out of my head despite multiple readings of the material ... but I would comment that a 1 gig shared pool with a 2 gig large pool and a 350 meg shared pool reserve seem a bit unusual. -Original Message-From: VIVEK_SHARMA [mailto:[EMAIL PROTECTED]Sent: Monday, October 27, 2003 5:59 AMTo: Multiple recipients of list ORACLE-LSubject: ORA-4031 errors no a high Load Database Intermittent ORA-4031 errors Out of shared Pool :- Oracle ver 9203 Solaris 9 Concurrent Users = 6000 Shared Servers / MTS being used Listeners = 4 Application using Bind Variables Application = Banking - Hybrid in Nature Database size = 1 TB m/c = SF15K How can this issue be approached ? Should we consider moving to Oracle 9204 / higher ? large_pool_size big integer 2147483648 max_shared_servers integer 1000 mts_circuits integer 11000 mts_dispatchers string (address=(protocol=tcp)(host=1 0.16.14.236))(listener=CONSOLD GLIST)(dispatchers=7), (addres s=(protocol=tcp)(host=10.16.14 .236))(listener=OEMDGLIST)(dis patchers=7), (address=(protoco l=tcp)(host=10.16.14.236))(lis tener=BBYDGLIST6)(dispatchers= 7), (address=(protocol=tcp)(ho st=10.16.14.236))(listener=BBY DGLIST2)(dispatchers=7), (addr ess=(protocol=tcp)(host=10.16. 14.236))(listener=BBYDGLIST3)( dispatchers=7), (address=(prot ocol=tcp)(host=10.16.0.215))(l istener=BBYDGLIST4)(dispatcher s=7), mts_listener_address string mts_max_dispatchers integer 150 mts_max_servers integer 1000 mts_multiple_listeners boolean FALSE mts_servers integer 300 mts_service string bby01 mts_sessions integer 10995 shared_pool_reserved_size big integer 367001600 shared_pool_size big inte056964608 Will provide any Data needed Thanks
RE: anyone have opinions on the future of the 'grid'?
And if your nose is raw from having nothing better to do with your time, (Remember: You can pick your friends; and you can pick your nose; but you cannot pick your friend's nose.) you can tune in to some of Sun's marketing on the subject. (from a Sun e-mail) Whatever your business, it makes good economic sense to use the IT infrastructure you've already got to raise productivity, maintain availability, and minimize downtime. Learn how and why customers are deploying over 7,000 Sun Grids, from local clusters to global solutions. REGISTER TODAY! http://see.sun.com/Apps/DCS/mcp?r=70041$EQ47ezI0120003ITy041$EQ0mSCYaSCzF TITLE: Grid Computing: Put All of Your IT Infrastructure to Work DATE: Tuesday, November 4, 2003 TIME: 9-10am PT/12-1pm ET AGENDA -Joerg Schwarz, Senior Group Manager, Science Engineering, Sun Microsystems, Inc. -David Simmons, Manager, Grid Solutions, Sun Microsystems, Inc. -Dr. Steven Newhouse, Technical Director, London e-Science Centre, Imperial College REGISTER TODAY! http://see.sun.com/Apps/DCS/mcp?r=70041$EQ47ezI0120003ITx041$EQ0mSCYaSCzF Unable to attend? Register for the replay information, Sun will send you information on how to view the event archive at your convenience. Thank You, Sun Microsystems -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: wait/notify syntax for unix help please
Here's another idea. Expand on it and modify as needed. COUNT=1 while [ $COUNT -le 8 ]; do ## The first jobs command is to clear out any jobs completed messages. jobs /dev/null if [ -z `jobs` ]; then break; fi sleep 30 COUNT=$(( $COUNT + 1 )) done jobs /dev/null echo SLEPT $COUNT times $LOG_FILE ## Kill any remaining jobs. for JOB_NUMBER in `jobs | sed 's/\([^0-9]*\)\([1-9][0-9]*\)\(.*\)/\2/'`; do kill %${JOB_NUMBER} echo killed job number $JOB_NUMBER $LOG_FILE done I need to parallelize some sql operations and Im running them from unix scripts. I want to spawn off a few in the background from a master script, then have the master script 'wait' for them to finish. Ive done this in Java and with dbms_alert, but I cant dig up the syntax to do this with korn shell on solaris. Also, if I want to wait for a specific PID, how do I get the PID of the thread I want to wait for? so I have nohup run_sql wait(on previous nohup) then to use notify, I just use 'notify()' inside the script right? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle pricing ain't going down
You forgot No Unix. -Original Message- Here's a start. MSSQLServer EE has ... No bitmap indexes, no partitioned indexes, no function-based indexes, no domain indexes, no reverse key indexes, no object tables, no before triggers (can be kludged, not pretty), no multiple actions per trigger event, no 3rd-party language support a la Oracle's JVM and pro*... modules, no built-in OLAP (it's a weird bolt-on), no control over extent size, no control over block size, no star query optimisation, no sequences, no synonyms, no packages, no structured exception handling in stored proc language (TSQL), no MINUS union operator, no multiplexing or mirroring of log files, no cyclical log management, no escalation-free locking, no index organised tables. (Working with both every day, do you get the feeling I've been asked this before? :-)) Half of those things are available in Oracle SE One :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ** temp tablespace
4GB isn't all that huge. A couple of questions I can think of are: 1. How many users are simultaneously trying to sort stuff? 2. How often does some dufus fire up a Cartesian join? -Original Message- Hi, I have a huge temp tablespace (4GB) and not much usage (current usage is 50MB from v$ tables) . However it keeps running out of space. It ran out of space yesterday and I was hoping it would release but it got an error again. The database is only 35GB mostly small tables. IT is temporary (contents). How can i tell how much is *actually* free. dba_free_space shows hardly any free even when there is no activity. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to call unix shell scripts from 'C'?
I think you need the system command. The unix man page explains it. -Original Message- The unix and C forums are pretty inactive. Hope its ok to ask this here. Anyone know how to do this? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Boolean dates...
Are you sure he didn't mean Julian dates? Somewhere, someplace you are bound to find the algorithm that converts between Julian and Gregorian dates. I had it once a long time ago. -Original Message- Hi to all! We have an old app that manages something that my boss calls: boolean dates. He told me that exists an algorithm that manages dates as a boolean format. We have several tables in this form: Note: The following table: PAAM has the field BDATE defined as NUMBER. sql select bdate from paam sql where rownum 6 BDATE -- 728464 728434 728403 728495 728283 now, I need to convert that format to an 'understandable' format to get the old data and old dates. I'm looking (google-ing) for that subject but, without luck. any ideas? help?, pls... Thanks in advance Regards! JL __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jose Luis Delgado INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Boolean dates...
Oh, that's a bunch of Bool Sheet! -Original Message- From: Mladen Gogala [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 22, 2003 11:49 AM To: Multiple recipients of list ORACLE-L Subject: Re: Boolean dates... Nope. It's the dates according to the format invented by Booleous Caesar. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Refresh option for Materialized view , want to use it during
One possibility would be to replicate each of the four source tables, then perform the join on the replicated tables. This will require you to create snapshot logs on the source tables. Obviously, this will slow the performance of the whatever report is running against the replicated data since the join must be done for each query instead of when the data was originally replicated. But the data will remain continuously available. -Original Message-From: Siddharth Haldankar [mailto:[EMAIL PROTECTED]Sent: Tuesday, October 21, 2003 2:59 AMTo: Multiple recipients of list ORACLE-LSubject: Refresh option for Materialized view , want to use it during refresh Hi Gurus, I have a materialized view, which is based on Oracle Apps tables and on remote database. The view refresh takes around ½ hour, during this time period I cannot see any records in the materialized view and therefore my application faces errors. The following is the view definition CREATE MATERIALIZED VIEW CT_PRODUCTID_VW BUILD IMMEDIATE REFRESH START WITH SYSDATE NEXT (SYSDATE + 1) AS SELECT msi.segment1 productid, msi.description description, msi.inventory_item_id inventory_item_id, mc.segment1 product_family, mc.segment2 product_type FROM [EMAIL PROTECTED] mcs, [EMAIL PROTECTED] mc, [EMAIL PROTECTED] mic, [EMAIL PROTECTED] msi where 1=1 and mc.structure_id = 50112 and mc.segment3 != 'SPARE' and mc.global_name = 'US' and mc.enabled_flag = 'Y' and mcs.global_name = mc.global_name and mcs.category_set_name = 'PROD GROUP' and mic.category_set_id = mcs.category_set_id and mic.category_id = mc.category_id and mic.global_name = mc.global_name and mic.organization_id = 1 and mic.inventory_item_id = msi.inventory_item_id and msi.organization_id = mic.organization_id and msi.global_name = mc.global_name AND msi.auto_created_config_flag = 'N' AND msi.item_type IN ('ATO MODEL','CONFIG SPARE','CONFIG SUB','FEATURE PACK','PRODUCT LIST$0','PTO MODEL','SPARE') and msi.inventory_item_status_code IN ('ENABLE-MAJ','ENABLE-NON','ENABLE-OPT','NONORD') Please note that the tables referenced are remote tables and Oracle Apps tables and not logging on it is possible. Please suggest an appropriate refresh mechanism to see the records even during refresh period. Thanks in advance. With Warm Regards Siddharth Haldankar Zensar Technologies Ltd. Cisco Systems Inc. (Offshore Development Center) # : 091 020 4128394 [EMAIL PROTECTED] [EMAIL PROTECTED]
RE: object compilation scripts
connect / as sysdba @?/rdbms/admin/utlrp -Original Message- Hi, Can someone send all object compilation script? Thx -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Refresh option for Materialized view , want to use it during
Here's a weird idea to consider: You might replicate to a dummy table XYZ, then rename CT_PRODUCTIED_VW to CRAP; then rename XYZ to CT_PRODUCTIED_VW. Then rename CRAP to XYZ. If there are any dependent stored procedures, you will probably be required to recompile them. But, if the dependencies aren't toohairy,this could be put into a little script that executes in about two seconds. Then there's the idea of fiddling with partitions and swapping them in and out. -Original Message-From: Siddharth Haldankar [mailto:[EMAIL PROTECTED]Sent: Tuesday, October 21, 2003 2:59 AMTo: Multiple recipients of list ORACLE-LSubject: Refresh option for Materialized view , want to use it during refresh Hi Gurus, I have a materialized view, which is based on Oracle Apps tables and on remote database. The view refresh takes around ½ hour, during this time period I cannot see any records in the materialized view and therefore my application faces errors. The following is the view definition CREATE MATERIALIZED VIEW CT_PRODUCTID_VW BUILD IMMEDIATE REFRESH START WITH SYSDATE NEXT (SYSDATE + 1) AS SELECT msi.segment1 productid, msi.description description, msi.inventory_item_id inventory_item_id, mc.segment1 product_family, mc.segment2 product_type FROM [EMAIL PROTECTED] mcs, [EMAIL PROTECTED] mc, [EMAIL PROTECTED] mic, [EMAIL PROTECTED] msi where 1=1 and mc.structure_id = 50112 and mc.segment3 != 'SPARE' and mc.global_name = 'US' and mc.enabled_flag = 'Y' and mcs.global_name = mc.global_name and mcs.category_set_name = 'PROD GROUP' and mic.category_set_id = mcs.category_set_id and mic.category_id = mc.category_id and mic.global_name = mc.global_name and mic.organization_id = 1 and mic.inventory_item_id = msi.inventory_item_id and msi.organization_id = mic.organization_id and msi.global_name = mc.global_name AND msi.auto_created_config_flag = 'N' AND msi.item_type IN ('ATO MODEL','CONFIG SPARE','CONFIG SUB','FEATURE PACK','PRODUCT LIST$0','PTO MODEL','SPARE') and msi.inventory_item_status_code IN ('ENABLE-MAJ','ENABLE-NON','ENABLE-OPT','NONORD') Please note that the tables referenced are remote tables and Oracle Apps tables and not logging on it is possible. Please suggest an appropriate refresh mechanism to see the records even during refresh period. Thanks in advance. With Warm Regards Siddharth Haldankar Zensar Technologies Ltd. Cisco Systems Inc. (Offshore Development Center) # : 091 020 4128394 [EMAIL PROTECTED] [EMAIL PROTECTED]