RE: oracle client on PC's
we have a standard desktop or laptop image which we install the client and create a package containing the change, we then push to the pc's that require the oracle client. We use onames with a primary and secondary name server. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Jeffrey BeckstromSent: Tuesday, January 06, 2004 1:40 PMTo: Multiple recipients of list ORACLE-LSubject: oracle client on PC's Rather than installing the Oracle client on every client PC, we have been:- installing client on 1 PC - copying directory to a network server - extract the registry for "oracle" key - fix registry that was extracted to reference the network drive - load registry on client PCs - add the network pc as a search drive to the client pc. We are now experiencing problems over the WAN and looking at ways to eliminate the Oracle dll overhead. Short of installing Oracle on every client PC, what are our options? Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113
problem with mult datafiles and local mng tblspaces
I have a 9.2.0.3 DB running on AIX 4.3.3 An application running on W2K using SQLLDR to load approx 6g of data using local managed tablespaces ie.. CREATE TABLESPACE PARENTDAT DATAFILE '/vol01/oradata/e450dev/parentdat01.dbf' SIZE 2000M REUSE, '/vol01/oradata/e450dev/parentdat02.dbf' SIZE 2000M REUSE, '/vol01/oradata/e450dev/parentdat03.dbf' SIZE 2000M REUSE, '/vol01/oradata/e450dev/parentdat04.dbf' SIZE 2000M REUSE EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M NOLOGGING ONLINE; It was taking 8 hours to load this data 1) copied the data to the AIX box and ran SQLLDR local to the DB and received similar results 2) changed the tablespace to contain 1 8g datafile 3) ran SQLLDR from the W2K machine ..completed in 30minutes Also ran the same test on AIX 5.1 running oracle 9.2.0.3 and obtained the same results. I really would like to be able to create the tablespaces with multiple data files but it seems whenever I add a datafile the performance of the load degrades. Any ideas?? Thanks in advance John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Blake 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: Clone db 9.2 on AIX 5L
Thankyou all who have responded to this... as it turns out the parameters for shared_pool /large_pool were to large for the receiving machine after I decreased the values to a minimal size I was able to recreate the instance. Thanks again John -Original Message- Joan Hsieh Sent: Wednesday, October 29, 2003 9:49 AM To: Multiple recipients of list ORACLE-L I did it yesterday on AIX 5L 9.2.0.4, no problem at all Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh 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: John Blake 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: Clone db 9.2 on AIX 5L
The alert log statest that the instance is starting NORMAL and that is all she wrote No trace files all my directories exist all owned by oracle UID The cr_spap script contains all create controlfile commands and yes since the "STARTUP NOMOUNT" is failing the balance is just from the echoed output .. Basically I think I'm just missing some obscure detail here, as there was someone in the list confirming that they are performing this on a similar environment AIX5.1 and ORACLE 9.2 That in mind I have gone through the init.ora checked for directory existance now researching listener config etc.. -Original Message- Sent: Tuesday, October 28, 2003 12:33 PM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' John, Did you see any messages in the alert log? And what is in the cr_spap script? the startup nomount is failing immediately, so everything else is worthless. Review the initspap.ora file and make sure that all of the directories exist. Also, is the ORACLE_SID evironmental set prior to running sqlplus? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, October 28, 2003 11:49 AM To: Multiple recipients of list ORACLE-L SQL> @cr_spap SQL> STARTUP NOMOUNT pfile=/iu33/u01/app/oracle/admin/spap/pfile/initspap.ora ORA-03113: end-of-file on communication channel SQL> CREATE CONTROLFILE REUSE DATABASE "SPAP" RESETLOGS NOARCHIVELOG 2 MAXLOGFILES 50 3 MAXLOGMEMBERS 5 4 MAXDATAFILES 100 5 MAXINSTANCES 1 6 MAXLOGHISTORY 226 7 LOGFILE 8 GROUP 1 '/iu33/u02/oradata/spap/redo01.log' SIZE 100M, 9 GROUP 2 '/iu33/u02/oradata/spap/redo02.log' SIZE 100M, 10 GROUP 3 '/iu33/u02/oradata/spap/redo03.log' SIZE 100M 11 DATAFILE 12 '/iu33/u02/oradata/spap/system01.dbf', 13 '/iu33/u02/oradata/spap/undotbs01.dbf', 14 '/iu33/u02/oradata/spap/drsys01.dbf', 15 '/iu33/u02/oradata/spap/example01.dbf', 16 '/iu33/u02/oradata/spap/odm01.dbf', 17 '/iu33/u02/oradata/spap/tools01.dbf', 18 '/iu33/u02/oradata/spap/users01.dbf', 19 '/iu33/u02/oradata/spap/xdb01.dbf', 20 '/iu33/u02/oradata/spap/users02.dbf', 21 '/iu33/u02/oradata/spap/users03.dbf', 22 '/iu33/u02/oradata/spap/users04.dbf', 23 '/iu33/u02/oradata/spap/users05.dbf', 24 '/iu33/u02/oradata/spap/indexes01.dbf', 25 '/iu33/u02/oradata/spap/indexes02.dbf', 26 '/iu33/u02/oradata/spap/indexes03.dbf' 27 CHARACTER SET WE8ISO8859P1 28 ; CREATE CONTROLFILE REUSE DATABASE "SPAP" RESETLOGS NOARCHIVELOG * ERROR at line 1: ORA-03114: not connected to ORACLE SQL> -- RECOVER DATABASE SQL> -- ALTER DATABASE OPEN; SQL> -- ALTER TABLESPACE TEMP ADD TEMPFILE '/iu33/u02/oradata/spap/temp01.dbf' SIZE 3119M REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE ; SQL> The confusing thing is that I have instances already running on the machine. So I know the install is ok. I can start/shutdown the existing instances no problem. But when I try to clone and startup --- I get the results from above. -Original Message- Sent: Monday, October 27, 2003 5:24 PM To: [EMAIL PROTECTED] When are you getting the error? During startup? Adam "John Blake" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 10/27/2003 03:04 PM Please respond to [EMAIL PROTECTED] To Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc Subject RE: Clone db 9.2 on AIX 5L Sorry, AIX 5L to AIX 5L cold backup copies create backup controlfile to trace -- edited for the new file locations keeping the SID the same created init.ora from spfile startup nomount pfile= getting ora-3113 I have a TAR opened and figured I would check out here as well. -Original Message----- [EMAIL PROTECTED] Sent: Monday, October 27, 2003 4:44 PM To: Multiple recipients of list ORACLE-L How about some more details? Are you cloning to a similar platform? Are you using a cold backup with controlfile recreation? RMAN backup or restore? RMAN duplicate? ... Adam "John Blake" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 10/27/2003 02:24 PM Please respond to [EMAIL PROTECTED] To Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc Subject Clone db 9.2 on AIX 5L Just checking to see if anyone has been able to clone a 9.2 DB from one machine to another. I have never had a problem doing this prior to 9.2, and am just wondering if I have overlooked something peculiar to 9i. Thanks in adavance John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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 messag
RE: Clone db 9.2 on AIX 5L
SQL> @cr_spap SQL> STARTUP NOMOUNT pfile=/iu33/u01/app/oracle/admin/spap/pfile/initspap.ora ORA-03113: end-of-file on communication channel SQL> CREATE CONTROLFILE REUSE DATABASE "SPAP" RESETLOGS NOARCHIVELOG 2 MAXLOGFILES 50 3 MAXLOGMEMBERS 5 4 MAXDATAFILES 100 5 MAXINSTANCES 1 6 MAXLOGHISTORY 226 7 LOGFILE 8 GROUP 1 '/iu33/u02/oradata/spap/redo01.log' SIZE 100M, 9 GROUP 2 '/iu33/u02/oradata/spap/redo02.log' SIZE 100M, 10 GROUP 3 '/iu33/u02/oradata/spap/redo03.log' SIZE 100M 11 DATAFILE 12 '/iu33/u02/oradata/spap/system01.dbf', 13 '/iu33/u02/oradata/spap/undotbs01.dbf', 14 '/iu33/u02/oradata/spap/drsys01.dbf', 15 '/iu33/u02/oradata/spap/example01.dbf', 16 '/iu33/u02/oradata/spap/odm01.dbf', 17 '/iu33/u02/oradata/spap/tools01.dbf', 18 '/iu33/u02/oradata/spap/users01.dbf', 19 '/iu33/u02/oradata/spap/xdb01.dbf', 20 '/iu33/u02/oradata/spap/users02.dbf', 21 '/iu33/u02/oradata/spap/users03.dbf', 22 '/iu33/u02/oradata/spap/users04.dbf', 23 '/iu33/u02/oradata/spap/users05.dbf', 24 '/iu33/u02/oradata/spap/indexes01.dbf', 25 '/iu33/u02/oradata/spap/indexes02.dbf', 26 '/iu33/u02/oradata/spap/indexes03.dbf' 27 CHARACTER SET WE8ISO8859P1 28 ; CREATE CONTROLFILE REUSE DATABASE "SPAP" RESETLOGS NOARCHIVELOG * ERROR at line 1: ORA-03114: not connected to ORACLE SQL> -- RECOVER DATABASE SQL> -- ALTER DATABASE OPEN; SQL> -- ALTER TABLESPACE TEMP ADD TEMPFILE '/iu33/u02/oradata/spap/temp01.dbf' SIZE 3119M REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE ; SQL> The confusing thing is that I have instances already running on the machine. So I know the install is ok. I can start/shutdown the existing instances no problem. But when I try to clone and startup --- I get the results from above. -Original Message- Sent: Monday, October 27, 2003 5:24 PM To: [EMAIL PROTECTED] When are you getting the error? During startup? Adam "John Blake" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 10/27/2003 03:04 PM Please respond to [EMAIL PROTECTED] To Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc Subject RE: Clone db 9.2 on AIX 5L Sorry, AIX 5L to AIX 5L cold backup copies create backup controlfile to trace -- edited for the new file locations keeping the SID the same created init.ora from spfile startup nomount pfile= getting ora-3113 I have a TAR opened and figured I would check out here as well. -Original Message- [EMAIL PROTECTED] Sent: Monday, October 27, 2003 4:44 PM To: Multiple recipients of list ORACLE-L How about some more details? Are you cloning to a similar platform? Are you using a cold backup with controlfile recreation? RMAN backup or restore? RMAN duplicate? ... Adam "John Blake" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 10/27/2003 02:24 PM Please respond to [EMAIL PROTECTED] To Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc Subject Clone db 9.2 on AIX 5L Just checking to see if anyone has been able to clone a 9.2 DB from one machine to another. I have never had a problem doing this prior to 9.2, and am just wondering if I have overlooked something peculiar to 9i. Thanks in adavance John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: John Blake 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: John Blake INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services ---
RE: Clone db 9.2 on AIX 5L
Sorry, AIX 5L to AIX 5L cold backup copies create backup controlfile to trace -- edited for the new file locations keeping the SID the same created init.ora from spfile startup nomount pfile= getting ora-3113 I have a TAR opened and figured I would check out here as well. -Original Message- [EMAIL PROTECTED] Sent: Monday, October 27, 2003 4:44 PM To: Multiple recipients of list ORACLE-L How about some more details? Are you cloning to a similar platform? Are you using a cold backup with controlfile recreation? RMAN backup or restore? RMAN duplicate? ... Adam "John Blake" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 10/27/2003 02:24 PM Please respond to [EMAIL PROTECTED] To Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc Subject Clone db 9.2 on AIX 5L Just checking to see if anyone has been able to clone a 9.2 DB from one machine to another. I have never had a problem doing this prior to 9.2, and am just wondering if I have overlooked something peculiar to 9i. Thanks in adavance John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: John Blake 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).
Clone db 9.2 on AIX 5L
Title: RE: Query Tuning Help Just checking to see if anyone has been able to clone a 9.2 DB from one machine to another. I have never had a problem doing this prior to 9.2, and am just wondering if I have overlooked something peculiar to 9i. Thanks in adavance John
RE: Problems creading a Index
The duplicate keys message is stating that there are multiple rows containing the same values for the specified elements in your index (COMPANY, INVC_PREFIX, INVC_NUMBER, ITEM) thus the index can not be a unique index. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Teresita CastroSent: Monday, September 29, 2003 3:35 PMTo: Multiple recipients of list ORACLE-LSubject: Problems creading a Index HI!! I want to create the next index: CREATE UNIQUE INDEX LAWSON2.IOEINVCLINE1 ON "LAWSON2".OEINVCLINE(COMPANY, INVC_PREFIX, INVC_NUMBER, ITEM) TABLESPACE LAWSON_PRUEBAS_INDICES PCTFREE 5 STORAGE(INITIAL 40960 ) But I can't because Oracle send me the next error: The following error has occurred: ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found I checked on TOAD ( with F4 on the table name) and It give me the next script. I don't have an index with the field ITEM on it, so I don't undestand what I am getting this error. DROP TABLE OEINVCLINE CASCADE CONSTRAINTS ; CREATE TABLE OEINVCLINE ( COMPANY NUMBER (4) NOT NULL, INVC_PREFIX CHAR (2) NOT NULL, INVC_NUMBER NUMBER (8) NOT NULL, LINE_NBR NUMBER (6) NOT NULL, LINE_TYPE CHAR (1) NOT NULL, ITEM CHAR (32) NOT NULL, DESCRIPTION CHAR (30) NOT NULL, ORDER_NBR NUMBER (8) NOT NULL, SHIPMENT_NBR NUMBER (10) NOT NULL, QUANTITY NUMBER (13,4) NOT NULL, INVC_CW_QTY NUMBER (13,4) NOT NULL, SPR_UOM CHAR (4) NOT NULL, SELL_UOM CHAR (4) NOT NULL, SEC_UOM CHAR (4) NOT NULL, MULT_SPR_FL CHAR (1) NOT NULL, SPR_TO_STOCK NUMBER (13,7) NOT NULL, SELL_TO_STOCK NUMBER (13,7) NOT NULL, SEC_UOM_MULT NUMBER (13,7) NOT NULL, LOCATION CHAR (5) NOT NULL, PRICE_STATUS CHAR (1) NOT NULL, ENTERED_PRICE NUMBER (13,5) NOT NULL, UNIT_PRICE NUMBER (13,5) NOT NULL, SELL_PRC_CURR NUMBER (15,7) NOT NULL, SELL_UNIT_PRC NUMBER (15,7) NOT NULL, UNIT_COST NUMBER (13,5) NOT NULL, CURRENT_COST NUMBER (13,5) NOT NULL, NO_CHARGE_FL CHAR (1) NOT NULL, ENTERED_DISC NUMBER (15,2) NOT NULL, ADD_ON_DISC NUMBER (15,2) NOT NULL, ALLOC_DISC NUMBER (15,2) NOT NULL, TAX_EXEMPT_CD CHAR (1) NOT NULL, TAX_CODE CHAR (10) NOT NULL, ENT_TAXABLE NUMBER (15,2) NOT NULL, TAXABLE_BSE NUMBER (15,2) NOT NULL, TAX_AMT_CURR NUMBER (15,2) NOT NULL, TAX_AMT_BSE NUMBER (15,2) NOT NULL, REASON_CODE CHAR (4) NOT NULL, DISC_CODE CHAR (10) NOT NULL, ORD_DISC_FL CHAR (1) NOT NULL, CONTRACT_NBR CHAR (14) NOT NULL, PROMOTION CHAR (10) NOT NULL, ACTIVITY CHAR (15) NOT NULL, ACCT_CATEGORY CHAR (5) NOT NULL, ATN_OBJ_ID NUMBER (12) NOT NULL, ACTIVITY_C CHAR (15) NOT NULL, ACCT_CATEG_C CHAR (5) NOT NULL, ATN_OBJ_ID_C NUMBER (12) NOT NULL, FINAL_INVC_FL CHAR (1) NOT NULL, SLS_ACCT_UNIT CHAR (15) NOT NULL, SLS_ACCOUNT NUMBER (6) NOT NULL, SLS_SUB_ACCT NUMBER (4) NOT NULL, SALES_MAJCL CHAR (4) NOT NULL, SALES_MINCL CHAR (4) NOT NULL, DSC_AMT_01 NUMBER (15,2) NOT NULL, DSC_AMT_02 NUMBER (15,2) NOT NULL, DSC_AMT_03 NUMBER (15,2) NOT NULL, DSC_ACCT_UNIT_01 CHAR (15) NOT NULL, DSC_ACCT_UNIT_02 CHAR (15) NOT NULL, DSC_ACCT_UNIT_03 CHAR (15) NOT NULL, DSC_ACCOUNT_01 NUMBER (6) NOT NULL, DSC_ACCOUNT_02 NUMBER (6) NOT NULL, DSC_ACCOUNT_03 NUMBER (6) NOT NULL, DSC_SUB_ACCT_01 NUMBER (4) NOT NULL, DSC_SUB_ACCT_02 NUMBER (4) NOT NULL, DSC_SUB_ACCT_03 NUMBER (4) NOT NULL, DSC_AMT_BASE NUMBER (15,2) NOT NULL, OFF_ACCT_UNIT CHAR (15) NOT NULL, OFF_ACCOUNT NUMBER (6) NOT NULL, OFF_SUB_ACCT NUMBER (4) NOT NULL, CGS_ACCT_UNIT CHAR (15) NOT NULL, CGS_ACCOUNT NUMBER (6) NOT NULL, CGS_SUB_ACCT NUMBER (4) NOT NULL, LAST_MISC_SEQ NUMBER (3) NOT NULL, LAST_COMM_SEQ NUMBER (3) NOT NULL, TERRITORY CHAR (4) NOT NULL, SALESMAN NUMBER (4) NOT NULL, SALESMAN_2 NUMBER (4) NOT NULL, COMM_RATE_1 NUMBER (7,7) NOT NULL, COMM_RATE_2 NUMBER (7,7) NOT NULL, COMM_SPLIT
RE: Antw: 8i ORA-1652 after upgrading from AIX 4.3.3 to 5.1
May not necessarily mean TEMP tablespace... Check all of your tablespaces for available free space, that is contiguous freespace. -Original Message- Guido Konsolke Sent: Sunday, July 27, 2003 3:04 AM To: Multiple recipients of list ORACLE-L Hi Saira, maybe temp tablespace isn't large enough. did you try what the doctor suggests? Did you enlarge the temp seg? 8-)) hth, Guido <<< [EMAIL PROTECTED] 27.07. 05.54 >>> Hi Gurus, After upgrading the OS from AIX 4.3.3 to 5.1, our Oracle 8i instance is dishing out plenty of ORA-1652 which means that our application cannot commit any transactions (or so I am finding in my tests). Help. The warehouse needs to be in production tomorrow! Thanks, Saira -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke 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: John Blake 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: [Q] how to make Develper 6i talk to ORACLE 8i client??
the 8.0.6 client also works with 9.2 -Original Message- Ron Thomas Sent: Friday, July 25, 2003 5:50 PM To: Multiple recipients of list ORACLE-L The 8.0.6 client works just fine with 8.1.7 databases. Why do you want to "make" developer 6i use 8.1.7? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] Sent by: To: [EMAIL PROTECTED] [EMAIL PROTECTED]cc: .com Subject: [Q] how to make Develper 6i talk to ORACLE 8i client?? 07/25/2003 01:39 PM Please respond to ORACLE-L ORACLE Developer 6i come with ORACLE 8.0.6 client sql*net. Does their has way to make Developer 6i use ORACLE 8i (8.1.7) sql*net or NOT? Thanks. __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: mike mon 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: Ron 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: John Blake 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: Force to use a tablespace
create table ( ) tablespace ; -Original Message- [EMAIL PROTECTED] Sent: Wednesday, March 19, 2003 6:54 AM To: Multiple recipients of list ORACLE-L Hallo, anyone who knows how to force a table to use a special tablespace? Thanks in advance. Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: John Blake 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: Rownum
no, rownum is a sequential number whereas rowid is a pointer to the row of the table within the database. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Santosh VarmaSent: Wednesday, March 19, 2003 4:44 AMTo: Multiple recipients of list ORACLE-LSubject: Rownum Hello list, I wanted to know the concept of Rownum.. Is it similar to Row Id ? Thanks and Regards, Santosh
RE: multiple oracle homes
We do something similar to this, we created a series of scripts that use the oratab file to create a menu for the oracle id. this same proc is called when running batch jobs against the DB's by sending the DB name as a parm. -Original Message- Kirti Sent: Friday, February 28, 2003 10:15 PM To: Multiple recipients of list ORACLE-L Better yet, have one single generic .profile with aliases defined for each instance running on the server. Want to change env for another instance? Just type it's name. It is that simple. We do this on all our servers, some with 20+ instances running under 7.3.4, 8.0.x, 8.1.x and 9.2.x. We use only one id for all versions of Oracle s/w. The .profile file sources the alias' file as .local.aliases. This file has entries as below: #Add Database name here using the following format alias PRMT='export ORACLE_SID=PRMT; export ORAENV_ASK="NO";. oraenv;' alias PRMX='export ORACLE_SID=PRMX; export ORAENV_ASK="NO";. oraenv;' alias VP1D='export ORACLE_SID=VP1D; export ORAENV_ASK="NO";. oraenv; cd /u01/home/oracle/admin/VP1D;' alias SDSD='export ORACLE_SID=SDSD; export ORAENV_ASK="NO";. oraenv;' alias SDST='export ORACLE_SID=SDST; export ORAENV_ASK="NO";. oraenv;' alias SVRP='export ORACLE_SID=SVRP; export ORAENV_ASK="NO";. oraenv;' alias SVRT='export ORACLE_SID=SVRT; export ORAENV_ASK="NO";. oraenv;' alias IDSU='export ORACLE_SID=IDSU; export ORAENV_ASK="NO";. oraenv;' alias IWVT='export ORACLE_SID=IWVT; export ORAENV_ASK="NO";. oraenv;' PRMT --> IWVT are the instances running on the server. And finally, do change the UNIX prompt to include current ORACLE_SID, among other things !! HTH, - Kirti -Original Message- Sent: Friday, February 28, 2003 4:30 PM To: Multiple recipients of list ORACLE-L Using something other than oracle makes it more complicated - I think. Have a different .profile - can name it something that makes sense. -Original Message- Sent: Friday, February 07, 2003 10:54 AM To: Multiple recipients of list ORACLE-L Ray - My 2 cents worth. Don't ever use another username besides Oracle. Had a bad experience :-) Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, February 07, 2003 8:24 AM To: Multiple recipients of list ORACLE-L On Thu, Feb 06, 2003 at 05:08:55AM -0800, Ray Stell wrote: > > Where is it well documented how to install multiple server versions, > 8i and 9i, on the same unix server? -- Thanks for you replies. I've never tried this before and it seems like there are two different approaches on the surface: 1. use two different userids, ora817 and ora920, to do the install. This seems stupid, since it replicates the product directory structure and oraInventory stuff under different ownership. This might be safer since it is like running one version in that everything is seperate, but maybe there are operational issues to not using the oracle userid. Seems like there may be a gotcha waiting in the wings. Like maybe you can't run the same listener for both, or worse. 2. use the same oracle userid for both installs and change the environment vars as needed. Seems like you could damage the first install if you made a mistake. Also, it seems like in a stressful failure situation you don't want to have to think about who's on first? I don't know, third base. Are both paths valid? === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti 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: John Blake 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).
