Re: Re: OS authentication; remote login; domain qualification
I added the parameter to registry OSAUTH_PREFIX_DOMAIN=true but it didn't help. Any other place where i can see..? Thanks and Regards B S Pradhan --- On Mon, 19 Jan 2004 Jared Still wrote : >You must set OSAUTH_PREFIX_DOMAIN=true in the registry to >use externally identified domain accounts. > >I can't recall if the default value is true or false, but >try setting it explicitly. > >Jared > >On Sun, 2004-01-18 at 05:49, bhabani s pradhan wrote: > > Hi All, > > > > The client machine is an NT machine and it belongs to a domain "GALAXY" > > Oracle Db server is on Solaris. > > > > client sqlnet.ora has the following setting: > > > > > > NAMES.DIRECTORY_PATH= (TNSNAMES) > > LOG_DIRECTORY_CLIENT=c:\oracle\ora81\network\log > > USE_DEDICATED_SERVER=ON > > SQLNET_AUTHENTICATION_SERVICES=NTS > > > > initialization parameters: > > > > REMOTE_OS_AUTHENT=TRUE > > os_authent_prefix = "" > > > > - > > > > with an user name Without the domain remote connection is possible.. > > > > ** > > SQL> create user USER1 identified externally > > 2 default tablespace ts1 > > 3 temporary tablespace TEMP; > > User created. > > > > SQL> grant connect to USER1; > > Grant succeeded. > > > > C:\>sqlplus /@sn1 > > SQL*Plus: Release 8.1.7.0.0 - Production on Tue Dec 30 15:51:45 2003 > > (c) Copyright 2000 Oracle GALAXYoration. All rights reserved. > > Connected to: > > Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production > > With the Partitioning option > > JServer Release 8.1.7.4.0 - 64bit Production > > > > SQL> show user > > USER is "USER1" > > > > SQL> select username, osuser from v$session; > > USERNAME OSUSER > > -- -- > > > > SYS oracle > > USER1 USER1 > > *** > > > > But when i try the username with the NT domain it fails to connect remotely: > > > > * > > SQL> create user "GALAXY\USER1" identified externally > > 2 default tablespace ts1 > > 3 temporary tablespace TEMP; > > User created. > > > > SQL> grant connect to "GALAXY\USER1"; > > Grant succeeded. > > > > When I connect try using sqlplus /@sn1 it fails > > C:\>sqlplus /@sn1 > > SQL*Plus: Release 8.1.7.0.0 - Production on Tue Dec 30 15:49:56 2003 > > (c) Copyright 2000 Oracle GALAXYoration. All rights reserved. > > ERROR: > > ORA-01017: invalid username/password; logon denied > > > > > > What I think issue here is, the connection is thru tns-listener and the NT domain > > and the server machine are different. > > > > Is there any solution for this / Is it possible to connect the remote unix DB > > server with OS authentication from an NT client with domain name ? > > > > > > Thanks and Regareds > > B S Pradhan > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: Jared Still > 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: Re: OS authentication; remote login; domain qualification
Hi Thanks for the info. Let me try this. Regards, B S Pradhan --- On Mon, 19 Jan 2004 Jared Still wrote : >You must set OSAUTH_PREFIX_DOMAIN=true in the registry to >use externally identified domain accounts. > >I can't recall if the default value is true or false, but >try setting it explicitly. > >Jared > >On Sun, 2004-01-18 at 05:49, bhabani s pradhan wrote: > > Hi All, > > > > The client machine is an NT machine and it belongs to a domain "GALAXY" > > Oracle Db server is on Solaris. > > > > client sqlnet.ora has the following setting: > > > > > > NAMES.DIRECTORY_PATH= (TNSNAMES) > > LOG_DIRECTORY_CLIENT=c:\oracle\ora81\network\log > > USE_DEDICATED_SERVER=ON > > SQLNET_AUTHENTICATION_SERVICES=NTS > > > > initialization parameters: > > > > REMOTE_OS_AUTHENT=TRUE > > os_authent_prefix = "" > > > > - > > > > with an user name Without the domain remote connection is possible.. > > > > ** > > SQL> create user USER1 identified externally > > 2 default tablespace ts1 > > 3 temporary tablespace TEMP; > > User created. > > > > SQL> grant connect to USER1; > > Grant succeeded. > > > > C:\>sqlplus /@sn1 > > SQL*Plus: Release 8.1.7.0.0 - Production on Tue Dec 30 15:51:45 2003 > > (c) Copyright 2000 Oracle GALAXYoration. All rights reserved. > > Connected to: > > Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production > > With the Partitioning option > > JServer Release 8.1.7.4.0 - 64bit Production > > > > SQL> show user > > USER is "USER1" > > > > SQL> select username, osuser from v$session; > > USERNAME OSUSER > > -- -- > > > > SYS oracle > > USER1 USER1 > > *** > > > > But when i try the username with the NT domain it fails to connect remotely: > > > > * > > SQL> create user "GALAXY\USER1" identified externally > > 2 default tablespace ts1 > > 3 temporary tablespace TEMP; > > User created. > > > > SQL> grant connect to "GALAXY\USER1"; > > Grant succeeded. > > > > When I connect try using sqlplus /@sn1 it fails > > C:\>sqlplus /@sn1 > > SQL*Plus: Release 8.1.7.0.0 - Production on Tue Dec 30 15:49:56 2003 > > (c) Copyright 2000 Oracle GALAXYoration. All rights reserved. > > ERROR: > > ORA-01017: invalid username/password; logon denied > > > > > > What I think issue here is, the connection is thru tns-listener and the NT domain > > and the server machine are different. > > > > Is there any solution for this / Is it possible to connect the remote unix DB > > server with OS authentication from an NT client with domain name ? > > > > > > Thanks and Regareds > > B S Pradhan > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: Jared Still > 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).
OS authentication; remote login; domain qualification
Hi All, The client machine is an NT machine and it belongs to a domain "GALAXY" Oracle Db server is on Solaris. client sqlnet.ora has the following setting: NAMES.DIRECTORY_PATH= (TNSNAMES) LOG_DIRECTORY_CLIENT=c:\oracle\ora81\network\log USE_DEDICATED_SERVER=ON SQLNET_AUTHENTICATION_SERVICES=NTS initialization parameters: REMOTE_OS_AUTHENT=TRUE os_authent_prefix = "" - with an user name Without the domain remote connection is possible.. ** SQL> create user USER1 identified externally 2 default tablespace ts1 3 temporary tablespace TEMP; User created. SQL> grant connect to USER1; Grant succeeded. C:\>sqlplus /@sn1 SQL*Plus: Release 8.1.7.0.0 - Production on Tue Dec 30 15:51:45 2003 (c) Copyright 2000 Oracle GALAXYoration. All rights reserved. Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production With the Partitioning option JServer Release 8.1.7.4.0 - 64bit Production SQL> show user USER is "USER1" SQL> select username, osuser from v$session; USERNAME OSUSER -- -- SYS oracle USER1 USER1 *** But when i try the username with the NT domain it fails to connect remotely: * SQL> create user "GALAXY\USER1" identified externally 2 default tablespace ts1 3 temporary tablespace TEMP; User created. SQL> grant connect to "GALAXY\USER1"; Grant succeeded. When I connect try using sqlplus /@sn1 it fails C:\>sqlplus /@sn1 SQL*Plus: Release 8.1.7.0.0 - Production on Tue Dec 30 15:49:56 2003 (c) Copyright 2000 Oracle GALAXYoration. All rights reserved. ERROR: ORA-01017: invalid username/password; logon denied What I think issue here is, the connection is thru tns-listener and the NT domain and the server machine are different. Is there any solution for this / Is it possible to connect the remote unix DB server with OS authentication from an NT client with domain name ? Thanks and Regareds B S Pradhan
Heap
Hi All, I need some basic understanding of heap structure and its operation. Can anybody give me some useful links in this respect? Thank You Regards, B S Pradhan
Re: Re: Index usage
sorry, the second query uses equality operator.. WHERE UPPER(col1) = 'xyz'; index hint is not helping. regards, B S Pradhan -- On Thu, 08 Jan 2004 zions swordfish wrote : >hi, pradhan, >I don't see any kind of differences with your two queries, but >I suggest you to use hint in your query to activate index. >Regards, >Sony > >- Original Message - >DATE: Thu, 08 Jan 2004 07:09:26 >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Cc: > > > >Hi All, > >I have the query like: > >SELECT * > FROM tab1 >WHERE UPPER(col1) <> 'abc'; > >Obviously, the function based index i have is not hetting used because of the >ineqality. > >When using >SELECT * > FROM tab1 >WHERE UPPER(col1) <> 'abc'; > >index is getting used. > >How can I possibly use index in the 1st case. > > >Thanks and Regards, >B S Pradhan > > > > > > > >Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail! >http://login.mail.lycos.com/r/referral?aid=27005
Index usage
Hi All, I have the query like: SELECT * FROM tab1 WHERE UPPER(col1) <> 'abc'; Obviously, the function based index i have is not hetting used because of the ineqality. When using SELECT * FROM tab1 WHERE UPPER(col1) <> 'abc'; index is getting used. How can I possibly use index in the 1st case. Thanks and Regards, B S Pradhan
db_link timeout
Hi All Happy New Year In my plsql program i am connecting to two remote DBs and using db_links sequentially. Sometimes if the first remote db is not available or there is some network problem then it stays there for quite some time and then throws an error (which is captured in exception section). then it goes to the next block and does the work using the second db_link to the second DB. Can I reduce the time of oracle trying to get the connection of the remote Db before throwing the error. Basically i want to try for a shorter time to try connecting to a remote db and if not possibe then to go ahead. Thanks and Regards B S Pradhan
Re: Re: Re: Index usage
Thanks. Regards, B S Pradhan - On Fri, 26 Dec 2003 zhu chao wrote : >Hi, > To see why oracle choose FTS, alter session set events '10053 trace name context > forever,level 2'; > You can do alter session to change index_adj and optimizer_index_caching to > change only your session, or using hint. > >Regards >Zhu Chao. > >- Original Message - >To: Multiple recipients of list ORACLE-L >Sent: Thursday, December 25, 2003 8:09 PM > > > > >Hi All, > >Agreed.. and it should behave that way i.e > >if (cost of ind1 scan + then based on c1's selection table access for c3) > (direct >table access for c1 and c1) then oracle will use FTS with cost based optimization. >So, w/o a hint that is expected. > >But why it is not picking the index in my case i donot know. > >Also, can optimizer_index_cost_adj help? Its 100 now. Also that affects the whole DB, >so is there any way to set it for this particular query ? > > >Thanks for all the inputs. > > >Regards, >B S Pradhan > > > > > >On Wed, 24 Dec 2003 Mike Spalinger wrote : > >The difference is that the first query never has to go to the table (because you're > >selecting a constant 'x'). The second query has to go to the table to filter on c3. > > > >Mike > > > >anu wrote: > >>No. > >> The index should get used. The query result for query 2 is a subset of rows > >> with ta.c1='val1' will get selected. Subset of query 1. > >> So there is no need for a full table scan. The index can be used in the > >> following way : > >> 1) Use index ind1 to get rows with ta.c1='val1' (which is query 1). This can > >> definitely use an index. > >>2) Further filter using ta.c3 = 'val2' > >> Now may be the index is not very selective and the optimizer is going in for a > >> full table scan. What is the cardinality like? It is strange that RULE or index > >> hint is not taking it. Can you try a simple index(ta) hint or send your hint > >> syntax. Can you try the hint on another table to make sure hint is working. I do > >> not know why hint should not work. > >> Good luck. > >> > >>"Daniel W. Fink" <[EMAIL PROTECTED]> wrote: > >> > >>You answered your own question. > >> > >>ta.c3 is a nonindexed column, this means that the only way to > >>satisfy the > >>predicate is to perform a full table scan. Since this predicate > >>condition forces > >>a full table scan on ta, which will retrieve the ta.c1 column values > >>at the same > >>time, there is no need to use an index. In fact, an additional index > >>access > >>would decrease the query performance. > >> > >>Daniel Fink > >> > >>bhabani s pradhan wrote: > >> > >> > Hi All, > >> > > >> > Merry Christmas to all > >> > > >> > I have this interesting problem.. > >> > > >> > For this query index ind1 on (c1,c2) columns is getting used. > >> > SELECT 'x' > >> > FROM tab ta > >> > WHERE ta.c1='val1'; > >> > (gives index ind1 range scan) > >> > > >> > But for > >> > > >> > SELECT 'x' > >> > FROM tab ta > >> > WHERE ta.c1='val1' > >> > AND ta.c3 = 'val2'; > >> > (gives FTS) > >> > index ind1 is not being used. c3 is a nonindexed column. > >> > > >> > I have already tried index(ta ind1) , RULE hints. > >> > > >> > The table and the index are analyzed. > >> > > >> > What cud be the reason for that? > >> > > >> > Regards, > >> > B S Pradhan > >> > >>--Please see the official ORACLE-L FAQ: http://www.orafaq.net > >>--Author: Daniel W. Fink > >>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: [EM
Re: Re: Index usage
Hi All, Agreed.. and it should behave that way i.e if (cost of ind1 scan + then based on c1's selection table access for c3) > (direct table access for c1 and c1) then oracle will use FTS with cost based optimization. So, w/o a hint that is expected. But why it is not picking the index in my case i donot know. Also, can optimizer_index_cost_adj help? Its 100 now. Also that affects the whole DB, so is there any way to set it for this particular query ? Thanks for all the inputs. Regards, B S Pradhan On Wed, 24 Dec 2003 Mike Spalinger wrote : >The difference is that the first query never has to go to the table (because you're >selecting a constant 'x'). The second query has to go to the table to filter on c3. > >Mike > >anu wrote: >>No. >> The index should get used. The query result for query 2 is a subset of rows with >> ta.c1='val1' will get selected. Subset of query 1. >> So there is no need for a full table scan. The index can be used in the following >> way : >> 1) Use index ind1 to get rows with ta.c1='val1' (which is query 1). This can >> definitely use an index. >>2) Further filter using ta.c3 = 'val2' >> Now may be the index is not very selective and the optimizer is going in for a >> full table scan. What is the cardinality like? It is strange that RULE or index >> hint is not taking it. Can you try a simple index(ta) hint or send your hint >> syntax. Can you try the hint on another table to make sure hint is working. I do >> not know why hint should not work. >> Good luck. >> >>"Daniel W. Fink" <[EMAIL PROTECTED]> wrote: >> >> You answered your own question. >> >> ta.c3 is a nonindexed column, this means that the only way to >> satisfy the >> predicate is to perform a full table scan. Since this predicate >> condition forces >> a full table scan on ta, which will retrieve the ta.c1 column values >> at the same >> time, there is no need to use an index. In fact, an additional index >> access >> would decrease the query performance. >> >> Daniel Fink >> >> bhabani s pradhan wrote: >> >> > Hi All, >> > >> > Merry Christmas to all. >> > >> > I have this interesting problem.. >> > >> > For this query index ind1 on (c1,c2) columns is getting used. >> > SELECT 'x' >> > FROM tab ta >> > WHERE ta.c1='val1'; >> > (gives index ind1 range scan) >> > >> > But for >> > >> > SELECT 'x' >> > FROM tab ta >> > WHERE ta.c1='val1' >> > AND ta.c3 = 'val2'; >> > (gives FTS) >> > index ind1 is not being used. c3 is a nonindexed column. >> > >> > I have already tried index(ta ind1) , RULE hints. >> > >> > The table and the index are analyzed. >> > >> > What cud be the reason for that? >> > >> > Regards, >> > B S Pradhan >> >> -- Please see the official ORACLE-L FAQ: http://www.orafaq.net >> -- Author: Daniel W. Fink >> 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!? >>Free Pop-Up Blocker - Get it now >><http://us.rd.yahoo.com/slv/mailtag/*http://companion.yahoo.com/> > > >-- Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- Author: Mike Spalinger > 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: Re: Index usage
Hi, Nice example and it should behave similarly in my case also. I have to research more.. Regards, B S Pradhan --- On Wed, 24 Dec 2003 zhu chao wrote : >Hi, > It cound be possible that without Hint, oracle will choose FTS for second SQL, > because with col3 clause, if using index, oracle will have to do a range scan on > index ind1 and than table access by rowid. > If CBO thinks that col1='val1' will get a lot of rows then doing FTS may be > cheaper.But with hint, oracle should be able to pick that index. > > >Sample: >00:48:18 [EMAIL PROTECTED]> create table test as select * from dba_tables; > >Table created. >00:48:45 [EMAIL PROTECTED]> create index ind1 on test(owner,table_name) compute >statistics; > >Index created. >00:49:39 [EMAIL PROTECTED]> select 'x' from test where owner='PUBLIC'; > >no rows selected > >Elapsed: 00:00:00.03 > >Execution Plan >-- >0 SELECT STATEMENT Optimizer=ALL_ROWS (Cost=2 Card=5 Bytes=15) >10 INDEX (FAST FULL SCAN) OF 'IND1' (NON-UNIQUE) (Cost=2 Card > =5 Bytes=15) >00:50:00 [EMAIL PROTECTED]> select 'x' from test where owner='PUBLIC' and >tablespace_name='SYSTEM'; > >no rows selected > >Elapsed: 00:00:00.00 > >Execution Plan >-- >0 SELECT STATEMENT Optimizer=ALL_ROWS (Cost=4 Card=1 Bytes=20) >10 TABLE ACCESS (FULL) OF 'TEST' (Cost=4 Card=1 Bytes=20) > >00:51:14 [EMAIL PROTECTED]> select /*+index(test ind1)*/ 'x' from test where >owner='PUBLIC' and tablespace_name='SYSTEM'; > >no rows selected > >Elapsed: 00:00:00.01 > >Execution Plan >-- >0 SELECT STATEMENT Optimizer=ALL_ROWS (Cost=5 Card=1 Bytes=20) >10 TABLE ACCESS (BY INDEX ROWID) OF 'TEST' (Cost=5 Card=1 Byt es=20) >21 INDEX (FULL SCAN) OF 'IND1' (NON-UNIQUE) (Cost=3 Card=5) > >- Original Message - >To: Multiple recipients of list ORACLE-L >Sent: Wednesday, December 24, 2003 9:59 PM > > > >Hi All, > >Merry Christmas to all. > >I have this interesting problem.. > >For this query index ind1 on (c1,c2) columns is getting used. >SELECT 'x' > FROM tab ta >WHERE ta.c1='val1'; >(gives index ind1 range scan) > >But for > >SELECT 'x' > FROM tab ta >WHERE ta.c1='val1' >AND ta.c3 = 'val2'; >(gives FTS) >index ind1 is not being used. c3 is a nonindexed column. > >I have already tried index(ta ind1) , RULE hints. > >The table and the index are analyzed. > > > >What cud be the reason for that? > > > >Regards, >B S Pradhan > > > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: zhu chao > 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).
Index usage
Hi All, Merry Christmas to all. I have this interesting problem.. For this query index ind1 on (c1,c2) columns is getting used. SELECT 'x' FROM tab ta WHERE ta.c1='val1'; (gives index ind1 range scan) But for SELECT 'x' FROM tab ta WHERE ta.c1='val1' AND ta.c3 = 'val2'; (gives FTS) index ind1 is not being used. c3 is a nonindexed column. I have already tried index(ta ind1) , RULE hints. The table and the index are analyzed. What cud be the reason for that? Regards, B S Pradhan
InstallActions.log
Hi All What is the location for InstallActions.log ? Thanks and Regards B S Pradhan
Re: Re: Oracle's jdbc driver
Yes Thanks a lot regards b s pradhan On Sat, 13 Dec 2003 David Hau wrote : >The method you need is: OracleDatabaseMetaData.getDriverVersion() > >Write a small Java program to call this method, or take a look at Metalink note >94091.1 or 73629.1 for sample code to get JDBC driver version. > >Regards, >Dave > > >[EMAIL PROTECTED] wrote: >>Hi All >> >>How can I findout what is the version of the jdbc driver installed with oracle >>client install. >> >> >>Thanks and Regards >>B S Pradhan >> > >-- Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- Author: David Hau > 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).
Oracle's jdbc driver
Hi All How can I findout what is the version of the jdbc driver installed with oracle client install. Thanks and Regards B S Pradhan
Re: Re: log_archive_dest_2
Yes. It worked.. Thanks a lot regards b s pradhan --- On Wed, 03 Dec 2003 Tanel Poder wrote : >Try archive log stop; and archive log start; after setting the parameters.. > >Tanel. > > > Hi All, > > > > When I set log_archive_dest_2 to a valid local destination > > Dynamically on 8.1.7.0 it is not generating the archive files.. > > It is generating the archive files on on log_archive_dest_1 > > > > I even tried with the following settings .. > > 1] both log_archive_dest_1 and log_archive_dest_2 made MANDATORY > > 2] log_archive_min_succed_dest = 2 > > 2] log_archive_process = 10 > > > > Still it is not creating archives in the second location. > > > > Am i missing something? > > > > Thanks and Regards > > B S Pradhan > > > > > > > > > > > > > >
log_archive_dest_2
Hi All, When I set log_archive_dest_2 to a valid local destination Dynamically on 8.1.7.0 it is not generating the archive files.. It is generating the archive files on on log_archive_dest_1 I even tried with the following settings .. 1] both log_archive_dest_1 and log_archive_dest_2 made MANDATORY 2] log_archive_min_succed_dest = 2 2] log_archive_process = 10 Still it is not creating archives in the second location. Am i missing something? Thanks and Regards B S Pradhan
Recovery Concepts
Hi All I have a few basic questions: 1] How Oracle knows that media recovery is needed during STARTUP ? Is it based on mismatch of SCN or ckpt# or anything else ? I understand, if the datafile is missing then in Mount stage it throws error. Is there any other situation where it throws media recovery reqd. And, can a single block corruption be the reason enough for media recovery- error message during Startup. I believe, block corruption in a non-system datafile does not shutdown the instance and it gives error for the session accessing the block. So during next instance startup will this corrupted block cause any problem? 2] How oracle comes to know that instance recovery is needed during startup. 3] say we have a backup of the controlfile and we are using it as we lost all the present control files. In the backup controlfile in user_dump_dest I see All the datafiles (both SYSTEM and NON-SYSTEM) are listed in the 'create controlfile ' cmd. Then after creating the new controlfile in NO-mount stage , how can we associate the non system tablespace names with the existing OK datafiles ? Please help me clear my doubts? Thanks a Lot Regards B S Pradhan
Re: RE: RE: Data Modeling
Thanks for the information. The thumb rule and all will definitely help me in modelling. Thanks a Lot Best Regards B S Pradhan On Wed, 22 Oct 2003 Michael Milligan wrote : >Hi Again, > >What I do when a model is going to change is try to make it as flexible as >possible from the start. Build more abstraction into the model than you >normally would. Normalization is even more important here, even going to 4th >or 5th form, or at least Boyce-Codd 3rd. You want to design it so that when >someone wants to change the structure, it may be facilitated by the addition >of a new record instead of a new column. A very simplistic example would be >to have a separate address entity allowing for the possibility of multiple >addresses per customer, instead of building the address attributes right >into the customer entity. A good rule of thumb: whatever will change should >be changeable by addition or subtraction of a row. Whatever won't change is >a candidate for a column. That's a generalization, but a good rule >nonetheless. > >Data Architect from Sybase, ER/Studio from Embarcadero, Erwin from Computer >Associates are all good tools and easy to learn. QDesigner is the Data >Architect physical modeler repackaged by Quest and sold for less. Excellent >tool. > >Michael > > >This e-mail, including attachments, may include confidential and/or >proprietary information, and may be used only by the person or entity to >which it is addressed. If the reader of this e-mail is not the intended >recipient or his or her authorized agent, the reader is hereby notified that >any dissemination, distribution or copying of this e-mail is prohibited. If >you have received this e-mail in error, please notify the sender by replying >to this message and delete this e-mail immediately. >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: Michael Milligan > 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: Re: Data Modelling
Thank you all for all the help/suggestion/links and information about data modelling. Regards B S Pradhan --- On Tue, 21 Oct 2003 [EMAIL PROTECTED] wrote : >ive been told 'data modelling for mere mortals' is a good place to start. > > > > From: "bhabani s pradhan" <[EMAIL PROTECTED]> > > Date: 2003/10/21 Tue AM 08:54:25 EDT > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > Subject: Data Modelling > > > > >Hi All >I have not done data modelling as a major task so far. Would like to know from where >can I make a good start. I have basic(conceptual) knowledge of ER-Diagram and >Normalization. But if anybody can give me some case studies/links etc., >I see the responsibilities would include modelling and coping with Frequent changes >of the database object structures. >Please Help >Thanks a Lot >Regards >B S Pradhan > >Hi All > >I have not done data modelling as a major task so far. Would like to know from where >can I make a good start. I have basic(conceptual) knowledge of ER-Diagram and >Normalization. But if anybody can give me some case studies/links etc., > >I see the responsibilities would include modelling and coping with Frequent changes >of the database object structures. > >Please Help > >Thanks a Lot > >Regards >B S Pradhan > >
Re: RE: Data Modeling
Hey Michael I enjoyed your write-up.. especially a few db guys telling 'its relational because they are related'... I have also heard about it and the fact is that SQL the language for all the RDBMA is based on relational algebra and relational calcus and there in maths a rwo-column structure is called a relation. During my acadamics I have studied the book by Korth and Sudarshan and i know er-diagram and normalization theoritically. My major experience is with production dbs (where the schema structure hardly changes) and the new assignment mostly involves data modelling.. and that too the model will not be freezed soon. it will change very frequently for quite sometime. Was wondering how can i manage db table/proc structure changes from different sectors and integrate them at the end of the day. I donot know erwin or designer etc. Thanks a lot Regards B S Pradhan -- On Tue, 21 Oct 2003 Michael Milligan wrote : >I would read some of C.J. Date's papers, or books from his "Relational >Database Writings" series. Also, there is a recent book called "Data >Modeling for Everyone" by Sharon Allen (Curlingstone Press) which is good. > >Most importantly, understand the fundamental principles of relational theory >as it pertains to relational databases. If you make an effort at this >you'll be ahead of 90% of developers/DBAs in this area, in my opinion. I've >heard "database experts" say that relational databases are called that >because they "relate" one table to another. This is false. It is called >"relational" because it is based on relational math, and because columns are >grouped together into special relations called relational tables. We call >them tables for short. > >The important thing to note here is this: the relationship that matters most >is the relationship among the columns of the SAME TABLE. That they really do >belong together is the most important thing to be sure of in data modeling. >They need to be "functionally dependent" on the same set of primary key >columns. Functional dependency is hugely important to understand and is the >basis of good data modeling. > >Some authors: > >C.J. Date >Fabian Pascal >Sharon Allen > >many others as well. > >HTH, > >Michael Milligan >Oracle DBA >Ingenix, Inc. >2525 Lake Park Blvd. >Salt Lake City, Utah 84120 >wrk 801-982-3081 >mbl 801-628-6058 >[EMAIL PROTECTED] > > > >This e-mail, including attachments, may include confidential and/or >proprietary information, and may be used only by the person or entity to >which it is addressed. If the reader of this e-mail is not the intended >recipient or his or her authorized agent, the reader is hereby notified that >any dissemination, distribution or copying of this e-mail is prohibited. If >you have received this e-mail in error, please notify the sender by replying >to this message and delete this e-mail immediately. >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: Michael Milligan > 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).
Data Modelling
Hi All I have not done data modelling as a major task so far. Would like to know from where can I make a good start. I have basic(conceptual) knowledge of ER-Diagram and Normalization. But if anybody can give me some case studies/links etc., I see the responsibilities would include modelling and coping with Frequent changes of the database object structures. Please Help Thanks a Lot Regards B S Pradhan
Re: Cache a table
when the table is 1] frequently accessed 2] relatively small Regards B S Pradhan On Tue, 21 Oct 2003 Gunnar Berglund wrote : >Hi all, > >when you would consider to put a table a cache... > >rgds > >gb > > >Want to chat instantly with your online friends? Get the FREE Yahoo! >Messenger http://mail.messenger.yahoo.co.uk >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: =?iso-8859-1?q?Gunnar=20Berglund?= > 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: RE: Strange Request
Try this: A shell script calling sql env to ANALYZE certain table. kill the process running the shell script before it is done. You might get ora-00600 with argumrnt[1113] Thanks Pradhan On Wed, 08 Oct 2003 Sinardy Xing wrote : >ora-600 may result your db down or crash > >-Original Message- >Sent: 08 October 2003 10:09 >To: Multiple recipients of list ORACLE-L > > >I want the DB to see and act on an ORA-00600, not just record >one in the alertSID.log > >Thanks, >Mike > > >-Original Message- >Sent: Tuesday, October 07, 2003 6:54 PM >To: Multiple recipients of list ORACLE-L > > >did you just want to see it in an alert.log? or are you working with a >dump? > >joe > > >Vergara, Michael (TEM) wrote: > > >Ok...strange request time. I want to test a script that I found > >on the DBA Village web site. It's supposed to capture some > >information whenever there's a DB error. > > > >Does anybody know how to trigger a 'benign' ORA-600 so I can test > >this functionality? > > > >Thanks, > >Mike > > > > > >--- > >=== > >Michael P. Vergara > >Oracle DBA > >Guidant Corporation > > > > > > > >-- >Joseph S Testa >Chief Technology Officer >Data Management Consulting >614-791-9000 >It's all about the "CACHE" > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: Joe Testa > 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: Vergara, Michael (TEM) > 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: Sinardy Xing > 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: consistent gets
Hi consistent gets are when the SQL needs the data in consistent mode i.e not the current data. SELECT statements contribute to consistent gets (read from the RBS). DML normally contribute to db block gets, but say an UPDATE based on a search criterion -- will contribute to consistent gets. Thanks and Regards Pradhan - On Wed, 08 Oct 2003 Sultan Syed wrote : >Hi, > >What does the meaning for this consistent gets. >Some time my statement return more consistent gets in statistics. >How I can reduce this Consistent gets. > >Thanks in advance. > >
Re: "SQL AREA" and "LIBARARY CACHE" size?
You cannot control the sizes of sql area and library cache individually Regards On Thu, 25 Sep 2003 ManojKr Jha wrote : > > > >Hi, > >Any body have any idea about how to control the size of "library >cache" and >"sql area" in shared_pool? > >With Regards, >Manoj Kumar Jha > > > >A transcendentalist engaged in auspicious activities does not >meet with >destruction either in this world or in the spiritual world; one >who does >good, >is never overcome by evil. > > >DISCLAIMER: The information contained in this message is intended >only and >solely for the addressed individual or entity indicated in this >message and >for the exclusive use of the said addressed individual or entity >indicated >in this message (or responsible for delivery of the message to >such person) >and may contain legally privileged and confidential information >belonging >to Tata Consultancy Services. It must not be printed, read, >copied, >disclosed, forwarded, distributed or used (in whatsoever manner) >by any >person other than the addressee. Unauthorized use, disclosure or >copying is >strictly prohibited and may constitute unlawful act and can >possibly >attract legal action, civil and/or criminal. The contents of this >message >need not necessarily reflect or endorse the views of Tata >Consultancy >Services on any subject matter. Any action taken or omitted to be >taken >based on this message is entirely at your risk and neither the >originator >of this message nor Tata Consultancy Services takes any >responsibility or >liability towards the same. Opinions, conclusions and any other >information >contained in this message that do not relate to the official >business of >Tata Consultancy Services shall be understood as neither given >nor endorsed >by Tata Consultancy Services or any affiliate of Tata Consultancy >Services. >If you have received this message in error, you should destroy >this message >and may please notify the sender by e-mail. Thank you. > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: ManojKr Jha > 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). _______ Art meets Anesthesia; Shefali Weds Dr. Raman. Rediff Matchmaker strikes another interesting match !! Visit http://matchmaker.rediff.com?1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: bhabani s pradhan 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: Re: wrapping packages
one caution: there is no unwrap cmd/exe Regards On Sat, 20 Sep 2003 Pete Finnigan wrote : >Hi > >Research the wrap command, the binary is located in >$ORACLE_HOME/bin and >running it for example would be like this for instance: > >$ wrap iname=./test.sql oname=./test.plb > >kind regards > >Pete > >In article <[EMAIL PROTECTED]>, >[EMAIL PROTECTED] >components.com writes > >how can I wrap package bodies in oracle8i > >-- >Pete Finnigan >email:[EMAIL PROTECTED] >Web site: http://www.petefinnigan.com - Oracle security audit >specialists >Book:Oracle security step-by-step Guide - see >http://store.sans.org for details. > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: Pete Finnigan > 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). ___ Art meets Anesthesia; Shefali Weds Dr. Raman. Rediff Matchmaker strikes another interesting match !! Visit http://matchmaker.rediff.com?1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: bhabani s pradhan 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: RE: RE: RE: RE: Bus Error (Urgent)
yes that problem is resolved actually there are two problems: 1] Solaris Error: 12: Not enough space sys admin killed some processes and now other client machines can connect and work on the db 2]tnsping and sqlplus on one particular client machine give Bus Error (core dumped) seems its a disk corruption error (can that be?) from oracle's side where else can i see for this "Bus Error (core dumped)" error. Regards --- On Sat, 13 Sep 2003 Mladen Gogala wrote : >Then, you have a problem with the number of processes on the OS >level. The >investigation should continue on the server. > >-- >Mladen Gogala >Oracle DBA > > > > > -----Original Message- > > From: bhabani s pradhan [mailto:[EMAIL PROTECTED] > > Sent: Friday, September 12, 2003 5:46 PM > > To: Mladen Gogala > > Subject: Re: RE: RE: RE: Bus Error (Urgent) > > > > > > its a 2gig memory > > > > shmsys:shminfo_shmmax=4294967295 > > shmsys:shminfo_shmmin=1 > > > > parameter processes = 150 > > > > and v$process returns 25 > > > > --- > > > > > > > > On Sat, 13 Sep 2003 Mladen Gogala wrote : > > >You don't have enough oracle processes on the server. >Increase > > >"PROCESSES" > > >parameter. > > >You might need to adjust SHMMAX and SEMMNS in /etc/system > > > > > >-- > > >Mladen Gogala > > >Oracle DBA > > > > > > > > > > > > > -Original Message- > > > > From: bhabani s pradhan >[mailto:[EMAIL PROTECTED] > > > > Sent: Friday, September 12, 2003 5:34 PM > > > > To: Mladen Gogala > > > > Subject: Re: RE: RE: Bus Error (Urgent) > > > > > > > > > > > > donot know much about unix > > > > shell variables are exported > > > > > > > > from the client machine it soes not return anything: > > WW_WS> truss > > > > -o /tmp/truss.out -af tnsping tradedb1 WW_WS> > > > > > > > > > > > > > > > > i got this from the listener.log > > > > > > > > 12-SEP-2003 11:24:45 * > > > > > > > >(CONNECT_DATA=(SERVICE_NAME=TRADEDB1)(CID=(PROGRAM=)(HOST=trad > > > > e-host2)(USER=rubix))) > > > > * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.8.27)(PORT=40838)) >* > > establish > > > > * TRADEDB1 * 12500 > > > > TNS-12500: TNS:listener failed to start a dedicated server >process > > > > TNS-12540: TNS:internal limit restriction exceeded > > > >TNS-12560: TNS:protocol adapter error > > > > TNS-00510: Internal limit restriction exceeded > > > > Solaris Error: 12: Not enough space > > > > > > > > > > > > Regards > > > > === > > > > > > > > > > > > > > > > On Sat, 13 Sep 2003 Mladen Gogala wrote : > > > > >OK, this seems to have been created with netca. Are >your > > >shell > > > > >variables > > > > >exported? You should do "truss -o /tmp/truss.out -af > > >tnsping > > > > >tradedb1". > > > > >That should tell you where does the error occur. Bus >error > > >means > > > > >that the > > > > >process cannot connect to the server. It's very similar >in > > >nature > > > > >to > > > > >ORA-3113. > > > > >If it was oracle process you were trying to connect, >you'd > > >get an > > > > >oracle > > > > >error, > > > > >but your're getting bus error, which means that the >problem > > >is on > > > > >the OS > > > > >level. > > > > >Turn on tracing (TRACE_LEVEL=ADMIN in sqlnet.ora on >both > > >server > > > > >and client) > > > > >and > > > > >see what that gives you. What else can you tell me? Is > > >there > > > > >anything > > > > >unusual > > > > >in that combination? Did it work before? What has >changed? > > >How > > > > >much > > > > >experience > > > > >do you have with Unix and oracle? > > > > > > > > > >-- > > > > >Mladen Gogala > > > > >
Re: Re: Bus Error (Urgent)
listener is running okay it has refused some connections: WW_DB> lsnrctl stat LSNRCTL for Solaris: Version 8.1.7.0.0 - Production on 12-SEP-2003 14:49:01 (c) Copyright 1998 Oracle Corporation. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC))) STATUS of the LISTENER Alias LISTENER Version TNSLSNR for Solaris: Version 8.1.7.0.0 - Production Start Date01-MAY-2003 16:13:23 Uptime133 days 22 hr. 35 min. 38 sec Trace Level off Security OFF SNMP OFF Listener Parameter File /export/oracle/product/8.1.7/network/admin/listener.ora Listener Log File /export/oracle/product/8.1.7/network/log/listener.log Services Summary... PLSExtProchas 1 service handler(s) TRADEDB1 has 1 service handler(s) TRADEDB1 has 2 service handler(s) The command completed successfully WW_DB> lsnrctl services LSNRCTL for Solaris: Version 8.1.7.0.0 - Production on 12-SEP-2003 14:49:07 (c) Copyright 1998 Oracle Corporation. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC))) Services Summary... PLSExtProchas 1 service handler(s) DEDICATED SERVER established:0 refused:0 LOCAL SERVER TRADEDB1 has 1 service handler(s) DEDICATED SERVER established:2 refused:0 LOCAL SERVER TRADEDB1 has 2 service handler(s) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D000 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=trade-db2.webwayllc.com)(PORT=32804))(PRESENTATION=oracle.aurora.server.SGiopServer)(SESSION=RAW)) Presentation: oracle.aurora.server.SGiopServer DEDICATED SERVER established:213656 refused:4442 LOCAL SERVER The command completed successfully WW_DB> the problem is with One particular client machine. Regards On Sat, 13 Sep 2003 [EMAIL PROTECTED] wrote : > >Oddly enough, I received the same error today on one of our >Solaris >servers while trying to start a listener. I ran 'top' and >noticed that all >of the available swap space on the machine was being used. After >the >guilty process was killed, I was able to start the listener. >FYI, the >process was picld, an O/S process that is known to have a memory >leak. > >Hope that helps... > >Alan > > >Alan Aschenbrenner >Oracle DBA >IHS Group >[EMAIL PROTECTED] > > > > > "bhabani s > pradhan" To: >Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > <[EMAIL PROTECTED]cc: > ffmail.com> Subject: Re: >Bus Error (Urgent) > Sent by: > [EMAIL PROTECTED] > com > > > 09/12/2003 04:14 > PM > Please respond to > ORACLE-L > > > > > > > From the listener.log I am getting: > >12-SEP-2003 11:24:20 * >(CONNECT_DATA=(SERVICE_NAME=TRADEDB1)(CID=(PROGRAM >=)(HOST=trade-host2)(USER=rubix))) >* (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.8.28)(PORT=40837)) * >establish * TRADEDB1 * 12500 >TNS-12500: TNS:listener failed to start a dedicated server >process > TNS-12540: TNS:internal limit restriction exceeded >TNS-12560: TNS:protocol adapter error > TNS-00510: Internal limit restriction exceeded > Solaris Error: 12: Not enough space > >Regards > >-- >On Sat, 13 Sep 2003 bhabani s pradhan wrote : > >Hi All > > > >I am able to connect to my database from a set of different > >clients from different machines. > > > > From one particular machine i am not able to connect to the > >DB > >server machine. > > > >ping works fine > >but tnsping gives > > > >Bus Error (core dumped) > > > > > >Please help > > > >Thanks and Regards > > > >___ > >Interior meets Software; Rani Weds Gaurav. > >Rediff Matchmaker strikes another interesting match > >Visit http://matchmaker.rediff.com?1 > > > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.net > >-- > >Author: bhabani s pradhan > > INET: [EMAIL PROTECTED] > > > >Fat City Network Services-- 858-538-5051 > >http://www.fatcity.com > >San Diego, California-- Mailin
Re: RE: Bus Error (Urgent)
While running tnsping and sqlplus i am getting this: WW_WS> tnsping TRADEDB1 Bus Error (core dumped) WW_WS> sqlplus rubix/[EMAIL PROTECTED] Bus Error (core dumped) WW_WS> /usr/sbin/ping 10.10.8.44 10.10.8.44 is alive WW_WS> echo $ORACLE_HOME /export/home/oracle/product/8.1.7 WW_WS> echo $ORACLE_SID TRADEDB1 WW_WS> Please help . Regards ___ Interior meets Software; Rani Weds Gaurav. Rediff Matchmaker strikes another interesting match Visit http://matchmaker.rediff.com?1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: bhabani s pradhan 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: Bus Error (Urgent)
From the listener.log I am getting: 12-SEP-2003 11:24:20 * (CONNECT_DATA=(SERVICE_NAME=TRADEDB1)(CID=(PROGRAM=)(HOST=trade-host2)(USER=rubix))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.8.28)(PORT=40837)) * establish * TRADEDB1 * 12500 TNS-12500: TNS:listener failed to start a dedicated server process TNS-12540: TNS:internal limit restriction exceeded TNS-12560: TNS:protocol adapter error TNS-00510: Internal limit restriction exceeded Solaris Error: 12: Not enough space Regards -- On Sat, 13 Sep 2003 bhabani s pradhan wrote : >Hi All > >I am able to connect to my database from a set of different >clients from different machines. > > From one particular machine i am not able to connect to the >DB >server machine. > >ping works fine >but tnsping gives > >Bus Error (core dumped) > > >Please help > >Thanks and Regards > >___ >Interior meets Software; Rani Weds Gaurav. >Rediff Matchmaker strikes another interesting match >Visit http://matchmaker.rediff.com?1 > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: bhabani s pradhan > 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). ___ Interior meets Software; Rani Weds Gaurav. Rediff Matchmaker strikes another interesting match Visit http://matchmaker.rediff.com?1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: bhabani s pradhan 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: RE: Bus Error (Urgent)
both client and server on Sun OS 5.8 ORACLE_HOME and ORACLE_SID in .profile tnsnames.ora TRADEDB1 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = trade-db1)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = TRADEDB1) ) ) INST1_HTTP = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = trade-db)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = SHARED) (SERVICE_NAME = TRADEDB1) (PRESENTATION = http://admin) ) ) sqlnet.ora -- # SQLNET.ORA Network Configuration File: /export/home/oracle/product/8.1.7/network/admin/sqlnet.ora # Generated by Oracle configuration tools. NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME) now ?? Regards --- On Sat, 13 Sep 2003 Mladen Gogala wrote : >Which platform & version, how did you define your ORACLE_HOME >and >ORACLE_SID, >did you export them, what do your tnsnames.ora and sqlnet.ora >look like? >This way, I can only tell you to wait for another bus. > >-- >Mladen Gogala >Oracle DBA > > > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >On > > Behalf Of bhabani s pradhan > > Sent: Friday, September 12, 2003 5:00 PM > > To: Multiple recipients of list ORACLE-L > > Subject: Bus Error (Urgent) > > > > > > Hi All > > > > I am able to connect to my database from a set of different > > clients from different machines. > > > > From one particular machine i am not able to connect to the >DB > > server machine. > > > > ping works fine > > but tnsping gives > > > > Bus Error (core dumped) > > > > > > Please help > > > > Thanks and Regards > > > > ___ > > Interior meets Software; Rani Weds Gaurav. > > Rediff Matchmaker strikes another interesting match > > Visit http://matchmaker.rediff.com?1 > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: bhabani s pradhan > > 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). > > > > > > >Note: >This message is for the named person's use only. It may contain >confidential, proprietary or legally privileged information. No >confidentiality or privilege is waived or lost by any >mistransmission. If you receive this message in error, please >immediately delete it and all copies of it from your system, >destroy any hard copies of it and notify the sender. You must >not, directly or indirectly, use, disclose, distribute, print, or >copy any part of this message if you are not the intended >recipient. Wang Trading LLC and any of its subsidiaries each >reserve the right to monitor all e-mail communications through >its networks. >Any views expressed in this message are those of the individual >sender, except where the message states otherwise and the sender >is authorized to state them to be the views of any such entity. > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: Mladen Gogala > 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). ___ Interior meets Software; Rani Weds Gaurav. Rediff Matchmaker strikes another interesting match Visit http://matchmaker.rediff.com?1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: bhabani s pradhan INET: [E
Bus Error (Urgent)
Hi All I am able to connect to my database from a set of different clients from different machines. From one particular machine i am not able to connect to the DB server machine. ping works fine but tnsping gives Bus Error (core dumped) Please help Thanks and Regards ___ Interior meets Software; Rani Weds Gaurav. Rediff Matchmaker strikes another interesting match Visit http://matchmaker.rediff.com?1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: bhabani s pradhan 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: Killing jobs
2] dbms_job.submit() needs a COMMIT Regards B S pradhan On Sun, 24 Aug 2003 [EMAIL PROTECTED] wrote : >Hello list > >Q1. How can a dba remove the a job scheduled by another user ? >DBMS_JOB does not allow a user to touch any jobs except their >own. > >Q2. Every time I schedule a job using dbms_job it doesn't show up >properly >in dba_jobs or all_jobs or user_jobs until I logoff and log on >again . >Let me explain : I have scheduled a job as scott on my test >database >9iRelease 2 9.2.0.1.0 on windows. > >There is a table called Test in the scott schema . It has a >single column of >type date. I want to insert date into it every 30 seconds. > >I ran the following as scott : > >variable jobno number ; >variable instno number ; > >begin > > select instance_number into :instno from v$instance; > > dbms_job.submit ( job => :jobno, what => 'insert into >scott.test >values( sysdate ); commit ; ', next_date => trunc (sysdate + >1/(24*60), >'MI'), interval => 'sysdate + 1 / (24*60*2)', no_parse => true, >instance => >:instno, force => false ) ; > >end ; >/ > >print jobno > >This completed sucessfully. at time 13:13:43 hrs >Now I check user_jobs > >select JOB, last_date, next_date, next_sec > from user_jobs where job = :jobno; > >JOB LAST_DATENEXT_DATE >-- -- >--- > 5 24-aug-003 >13:14:00 > >I checked again at 13:14:30 , 13:15:00 , 13:15:30 , 13:16:00 , >13:16:30 , >etc >and it always says the same as above. (null value in last_date >and 13:14:00 >as next_date) > >I logout at 13:17:00 and log back in. Now when I run the query I >get > >JOB LAST_DATENEXT_DATE >-- --- >--- > 724-aug-003 13:17:05 24-aug-003 13:17:35 > >and the scott.test table has a single value >select * from scott.test ; > >24-aug-003 13:17:05 > >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). ___ Art meets Army ; Swapna Weds Capt. Rajsekhar. Find interesting matches on Rediff Matchmaker ! Visit http://matchmaker.rediff.com?1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: bhabani s pradhan 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: Re: RAID select
Thanks a Lot === On Mon, 21 Jul 2003 Thomas Day wrote : > >Assuming that you have 3 physical devices (NON-RAID, RAID-1, and >RAID-0+1) >my quick-and-dirty take on this is: > >NON-RAID > redo logs - mirrored by Oracle > control logs - mirrored by Oracle > ORACLE_HOME > RBS01 > RBS02 > TEMP > STAT(For PERFSTAT) > > > >RAID-1 > SYSTEM > RWEBCONFIG(Less Accessed) > RTRADE(Less Accessed) > Archive destination - move to tape > Backups - copy to tape > >RAID-0+1 > USERS01(Heavily Accessd) > INDEX01(Heavily Accessd) > INDEX02(Heavily Accessd) > >I wouldn't worry about putting the indexes on the same device >with the >tables. It is a multi-platter device and each datafile will be >stripped >across multiple platters. You may want to look into the stripe >size >depending on the number of users who will be concurrently >accessing the >database. Basic rule-of-thumb, the more concurrent users the >larger the >stripe size. > > > > > "bhabani s > pradhan" To: Multiple >recipients of list ORACLE-L <[EMAIL PROTECTED]> > @rediffmail.com> Subject: RAID >select > Sent by: > ml-errors > > > 07/20/2003 12:49 > PM > Please respond > to ORACLE-L > > > > > > >Hi > >I have a DB server with RAID-1 >and RAID-0+1 (There is no RAID-0). >Also the NON-RAID diska are available. > >I have the tablespaces as: >SYSTEM >USERS01(Heavily Accessd) >RWEBCONFIG(Less Accessed) >RTRADE(Less Accessed) >INDEX01(Heavily Accessd) >INDEX02(Heavily Accessd) >RBS01 >RBS02 >TEMP >STAT(For PERFSTAT) > >What could be a suitable configuration for >the datafiles under these tablespaces across >the available RAIDs. Also where the backups >and archive_dest should be. > >Can anybody give me some tips on this > >Thanks and Regards > > >___ >Download the hottest & happening ringtones here! >OR SMS: Top tone to 7333 >Click here now: >http://sms.rediff.com/cgi-bin/ringtone/ringhome.pl > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: bhabani s pradhan > 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: Thomas Day > 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). ___ Download the hottest & happening ringtones here! OR SMS: Top tone to 7333 Click here now: http://sms.rediff.com/cgi-bin/ringtone/ringhome.pl -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: bhabani s pradhan 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: RE: Different Platform
FORTE compiler On Mon, 21 Jul 2003 Richard Ji wrote : >So which compiler will you standarize on? GCC? >On Solaris I believe the Sun C Compiler is supported but not gcc, >though >you can make it work. > >-Original Message- >Sent: Sunday, July 20, 2003 12:50 PM >To: Multiple recipients of list ORACLE-L > > >Hi All > >Our production environment is on Sun OS 5.8 sparc. >DB is > >Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production >PL/SQL Release 8.1.7.0.0 - Production >CORE 8.1.7.0.0 Production >TNS for Solaris: Version 8.1.7.0.0 - Production >NLSRTL Version 3.4.1.0.0 - Production > >The application has a lot of Pro*C programs. >-- > >We are planning to have the development/test DB on Linux 2.4 on >Intel platform. > >We will be doing modifications/upgrades to the application and >DB >and will be applying the changes to production. > > >Will there be ANY kind of compatibility problem (relating to >OCI, >or plsql procs etc) ? > >Thanks in Advance >Regards > >___ >Download the hottest & happening ringtones here! >OR SMS: Top tone to 7333 >Click here now: >http://sms.rediff.com/cgi-bin/ringtone/ringhome.pl > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: bhabani s pradhan > 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: Richard Ji > 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). ___ Download the hottest & happening ringtones here! OR SMS: Top tone to 7333 Click here now: http://sms.rediff.com/cgi-bin/ringtone/ringhome.pl -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: bhabani s pradhan 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: Re: DB shift
thanks a lot On Sun, 20 Jul 2003 Tanel Poder wrote : >Hi! > >When moving to binary compatible platform, you can directly copy >over the >files (and software). > >It's even possible with different versions of OS - like from >SunOS 2.6 to >Solaris 8. > >For upgrading to 8.1.7.4 follow the patchset readme notes. > >Tanel. > >- Original Message - >To: "Multiple recipients of list ORACLE-L" ><[EMAIL PROTECTED]> >Sent: Sunday, July 20, 2003 7:49 PM > > > > Hi All > > > > We are planning to Shift our Db to a new hardware(having >RAIDs). > > The OS is exactly same on both the servers. > > Presently Oracle Version is 8.1.7.0.0 > > In the new server Oracle 8.1.7.4 is installed. > > > > What I am planning is to Shift the DB by copying the data >files > > from old to new server. > > Renaming them in mount stage if required. > > > > For the Oracle version change (upgrade) will there be any > > problem? > > So that export/import will be the only option. > > > > Thanks for your valuable input. > > > > Regards > > > > > > ___ > > Download the hottest & happening ringtones here! > > OR SMS: Top tone to 7333 > > Click here now: > > http://sms.rediff.com/cgi-bin/ringtone/ringhome.pl > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: bhabani s pradhan > > 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: Tanel Poder > 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). ___ Download the hottest & happening ringtones here! OR SMS: Top tone to 7333 Click here now: http://sms.rediff.com/cgi-bin/ringtone/ringhome.pl -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: bhabani s pradhan 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: Re: DB shift
Yes We will bedoing it thru exp/imp as downtime is there thanks On Mon, 21 Jul 2003 zhu chao wrote : >Hi, > I suggest you upgrade your old server from 8170 to 8174 and >then copy >the datafiles there. > Or if downtime is limited, you can use standby database to >switch your >database from old to new hardware. > >Regards >zhu chao >msn:[EMAIL PROTECTED] >www.cnoug.org >- Original Message - >To: "Multiple recipients of list ORACLE-L" ><[EMAIL PROTECTED]> >Sent: Monday, July 21, 2003 12:49 AM > > > > Hi All > > > > We are planning to Shift our Db to a new hardware(having >RAIDs). > > The OS is exactly same on both the servers. > > Presently Oracle Version is 8.1.7.0.0 > > In the new server Oracle 8.1.7.4 is installed. > > > > What I am planning is to Shift the DB by copying the data >files > > from old to new server. > > Renaming them in mount stage if required. > > > > For the Oracle version change (upgrade) will there be any > > problem? > > So that export/import will be the only option. > > > > Thanks for your valuable input. > > > > Regards > > > > > > ___ > > Download the hottest & happening ringtones here! > > OR SMS: Top tone to 7333 > > Click here now: > > http://sms.rediff.com/cgi-bin/ringtone/ringhome.pl > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: bhabani s pradhan > > 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: zhu chao > 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). ___ Download the hottest & happening ringtones here! OR SMS: Top tone to 7333 Click here now: http://sms.rediff.com/cgi-bin/ringtone/ringhome.pl -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: bhabani s pradhan 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).
DB shift
Hi All We are planning to Shift our Db to a new hardware(having RAIDs). The OS is exactly same on both the servers. Presently Oracle Version is 8.1.7.0.0 In the new server Oracle 8.1.7.4 is installed. What I am planning is to Shift the DB by copying the data files from old to new server. Renaming them in mount stage if required. For the Oracle version change (upgrade) will there be any problem? So that export/import will be the only option. Thanks for your valuable input. Regards ___ Download the hottest & happening ringtones here! OR SMS: Top tone to 7333 Click here now: http://sms.rediff.com/cgi-bin/ringtone/ringhome.pl -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: bhabani s pradhan 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).
Different Platform
Hi All Our production environment is on Sun OS 5.8 sparc. DB is Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production PL/SQL Release 8.1.7.0.0 - Production CORE 8.1.7.0.0 Production TNS for Solaris: Version 8.1.7.0.0 - Production NLSRTL Version 3.4.1.0.0 - Production The application has a lot of Pro*C programs. -- We are planning to have the development/test DB on Linux 2.4 on Intel platform. We will be doing modifications/upgrades to the application and DB and will be applying the changes to production. Will there be ANY kind of compatibility problem (relating to OCI, or plsql procs etc) ? Thanks in Advance Regards ___ Download the hottest & happening ringtones here! OR SMS: Top tone to 7333 Click here now: http://sms.rediff.com/cgi-bin/ringtone/ringhome.pl -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: bhabani s pradhan 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).
RAID select
Hi I have a DB server with RAID-1 and RAID-0+1 (There is no RAID-0). Also the NON-RAID diska are available. I have the tablespaces as: SYSTEM USERS01(Heavily Accessd) RWEBCONFIG(Less Accessed) RTRADE(Less Accessed) INDEX01(Heavily Accessd) INDEX02(Heavily Accessd) RBS01 RBS02 TEMP STAT(For PERFSTAT) What could be a suitable configuration for the datafiles under these tablespaces across the available RAIDs. Also where the backups and archive_dest should be. Can anybody give me some tips on this Thanks and Regards ___ Download the hottest & happening ringtones here! OR SMS: Top tone to 7333 Click here now: http://sms.rediff.com/cgi-bin/ringtone/ringhome.pl -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: bhabani s pradhan 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).
OS Kill
hi list one session in our database is in ACTIVE state since long. it is doing no activity at all. it has locked one table also. because of this other sessions are also in ACTIVE state. so it is required for us to kill the session. i got the corresponding spid for that session from v$process. i checked the following:: $ps -ef | grep oracle 21556 1 0 Feb 20 ?0:09 ora_snp3_TRADEDB1 isn't this the OS process/thread for the oracle background process? i want to kill the process at OS level if it is not working at DB level TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: bhabani s pradhan 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).