Re: Database Too Slow - Suggestions???
What is Buffer Cache Hit Ratio? LC Hit RAtio? What's the hardware? Run top or mpstat or sar to get the system stats... We had seen somewhat somilar bstat estat data... +Rachna - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 29, 2003 4:23 AM Hi Gurus, We have an OLTP 8i database on Win 2K RAM 1GB with about 10 million rows, Total size 100GB. Have done a bit of tuning here and there (see stats below). What do you read of these stats? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachna Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL question
And, can you have two columns as arguements for COUNT? I guess its either one column or rows +Rachna - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 29, 2003 1:19 PM Hello Listers, How to find out the COUNT of DISTINCT values of multiple columns? For eg. SQL SELECT DISTINCT ename FROM emp; -- This works. SQL SELECT COUNT(DISTINCT ename) FROM emp; -- So does this. SQL SELECT DISTINCT ename, job FROM emp; -- And this too. SQL SELECT COUNT(DISTINCT ename, job) FROM emp; -- So why does this fail? I can do a COUNT(DISTINCT ename || job), but that doesn't seem to be elegant way of doing it. I have a feeling I might be missing some fairly basic syntax, but feeling dumb is better than suspense. Thanks regards, Charu. * Disclaimer This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachna Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle is a time machine!!
Does it have any relation to year 1752 adjustment for leap year? Try following on unix .. cal 9 1752 September 1752 S M Tu W Th F S 1 2 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 -Rachna - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, November 22, 2002 12:55 PM Don't believe me?? Try this: create table test(the_date date); insert into test values (to_date('10-05-1582','mm-dd-') ); select to_char(the_date, 'mm/dd/') from test; What do you get? :-)) Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! Londo Mollari: Ah, arrogance and stupidity all in the same package. How efficient of you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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.com -- Author: Rachna Vaidya 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).
RMAN compatibility issues
DBAs, I experienced following while trying to test interoperatibility between 816 and 817. Any comments, experiences? Target - 817 Catalog - 816 rman rcvcat rman/rman@rcatqual connect target register database; . RMAN-06429: RCVCAT database is not compatible with this version of RMAN . Target - 816 Catalog - 817 rman rcvcat rman/rman@rcattest connect target register database; . RMAN-08006: database registered in recovery catalog . -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachna Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle DBA with SAP Needed
Makes sense if... Base Salary is 155K-to maybe high 160s Firm. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 06, 2002 2:12 PM I doubt they can fill this position at that salary. Oracle DBA's that work with SAP can easily earn much more than that. Jared Markham, Richard [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/06/2002 07:56 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Oracle DBA with SAP Needed What does Base Salary is 55K-to maybe high 60s Firm. mean? You can throw the possibility of a raise out the window? =) -Original Message- Sent: Wednesday, November 06, 2002 9:49 AM To: Multiple recipients of list ORACLE-L If you are an Oracle DBA With SAP experience looking for a stable company where you can work within a great team environment, this company in Toledo, Ohio is the place for you. This Fortune 500 employer has experienced steady growth over the hundred years it has been in business and is looking for a top notch candidate. This company is located in a very reasonable cost of living area and offers a varied choice of neighborhood communities. If you are looking for a place to grow within your career in a smaller city atmosphere this is the opportunity to check out. Relocation Assistance is provided. PLEASE DO NOT send your resume for this position UNLESS you have the skills outlined below for this position. DO NOT send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. If you are employed by a consulting company you must have a long term project history. This is a full time staff position so no sub-contractors or third parties please. NO H-1B candidates please. *Requirements: -MUST be a team player. -3+ years Oracle DBA experience. -SAP experience -Must have experience with:Installation, Backup and recovery, Implementation, Conversion, Performance tuning, Troubleshooting, Development, Database Design, Monitoring, and Support. -MUST have excellent communications skills -Major plusses are: SQL Backtrack, DB Artisan, Powerbuilder, Shell scripting and experience with Sybase and/or SQL Server. Base Salary is 55K-to maybe high 60s Firm. The employer itself offers a comprehensive medical plan, dental insurance, life insurance, sick leave and disability plans, a retirement plan, vacation days, a 401K Plan, and much more. For immediate consideration, please email your resume as an attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Phone: 1-800-549-8502. Please Use Job Code: one/Toledo/DBA-SAP/Jenni I pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the position described above- if it is not a match for your skills. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff 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.com -- 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.com -- Author: Rachna Vaidya 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: LOCALLY MANAGED TABLESPACE LOCALLY MANAGED TABLESPACE LOCALLY MANAGED TABLESPACE LOCALLY MANAGED TABLESPACE
Why do you always SHOUT in your subject line? Or are you not aware of simple net-etiquettes? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 24, 2002 2:49 PM Hi I am thinking to change our few dictinary manages tablespace to locally managed tablespace.Can any one experienced any issues with locally managed tablespace? Do any one experience what gain after changing to locally managed tablespace? Thx -Seema _ Unlimited Internet access for only $21.95/month. Try MSN! http://resourcecenter.msn.com/access/plans/2monthsfree.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh 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.com -- Author: Rachna Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: oracle or mssql
Is MSSQL server available on UNIX? -Rachna - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 23, 2002 11:25 AM Its been a while since I used MS SQL but one of the downsides that I experienced was the fact that MSSQL could not support the user loads we needed right out of the box. We had to cluster servers together to get the throughput that we got out of Oracle. MSSQL might be cheaper at the database software level but it was more expensive at the hardware level.. at least in our case. -Original Message- Sent: Wednesday, October 23, 2002 10:09 AM To: Multiple recipients of list ORACLE-L No it doesn't. MicroSoft is a card-carrying member of the Axis Of Evil. Last I heard they were developing nuclear weapons, probably in a huge bunker under Bill Gates' house. --Walt Weaver Bozeman, Montana -Original Message- Sent: Wednesday, October 23, 2002 8:54 AM To: Multiple recipients of list ORACLE-L It depends on your companies needs. On Tue, 22 Oct 2002 [EMAIL PROTECTED] wrote: Hi list Please input why my boss must invest into oracle rather than the cheaper mssql. His opinion is that most features are almost the same but mssql does that at half the price as oracle does. So why he should not choose mssql is the question g.g. kor rdw ict groningen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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.com -- Author: Alex 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.com -- Author: Weaver, Walt 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.com -- Author: Kevin Lange 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.com -- Author: Rachna Vaidya 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: Multiple Listeners
Here are my current findings Auto Registration : === 1. Auto Registration takes place with default listener when local_listener=(ADDRESS=(PROTOCOL=TCP)HOST=lightening)(PORT=1526)) When the above line was NOT present in init.ora of the database (db7) for whcih the second listener is configured, the database Auto registered with the old listener (v816, PORT=1521) too. So, that I could connect to the database through both listeners. 2. Auto Registration does NOT take place with default listener when local_listener=(ADDRESS=(PROTOCOL=TCP)HOST=lightening)(PORT=1526)) When the above line was present in init.ora of the database (db7) for whcih the second listener is configured, the database Auto registered with the new listener. So, now I could connect to the database through the new listener only! Multiple Listeners : 1. Is it possible to have single listener? You can use the 'higher' version of the listener for all databases running on = higher version, unless you need multiple listeners for other reasons Net8 Admin Guide should have enough information. So, using signel v817 listener for v817 as well as v816 databases was possible. 2. What's involved in configuring multiple listeners? There are metalink docs explaining it in details, But in short : They have to be of different names. Explicit name needs to be used for non default (name other than LISTENER) listeners while using lsnrctl command. They need to be listening on different ports. The KEY value for IPC needs to be different in each listener.ora. 3. Why I decided to run single listener in the end? When I was running two listeners, each was listening on different ports. Initially, I had only one listener at PORT=1521. So all my client side configuration in tnsnames.ora were pointing to PORT=1521. Now with this second listener listening at PORT=1526, I would have needed to change all of my client side configuration. (We are not using Names Server currently.) Thanks for the discussion! -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachna Vaidya 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).
Multiple Listeners
DBAs, Any quick start guides / scripts / notes for having multiple version listeners on same Solaris box? Scenario : I am in process of upgrading. There are two databases on a machine db6 and db7 db6 - 8.1.6 db7 - 8.1.6 db6 and db7 use the listener of version 8.1.6 Now, db7 migrated to 8.1.6 I am thinking of something like : db6 - listener of 8.1.6 (status quo) db7 - listener_817 of 8.1.7 (new version listener) Two separate listener.ora files lsnrctl status listener (for 8.1.6 listener) lsnrctl status listener_817 (for 8.1.7 listener) Thanks in advance, -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachna Vaidya 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).
RMAN lost RECOVERY_CATALOG_OWNER after upgrade from 816 to 817
DBAs, It seems that RMAN user has lost the RECOVERY_CATALOG_OWNER role when I upgraded the catalog database from 816 to 817. I could not even connect to the database as rman user. It even lacked CREATE SESSION. I tried giving grant create session to rman; and I could connect. Later on, upon running upgrade catalog I got hundreds of error messages (mostly looked like permissions issue). After grant RECOVERY_CATALOG_OWNER to rman; upgrade catalog seemed to work fine. Has anyone experienced anything similar? Thanks, -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachna Vaidya 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: Multiple Listeners
Thanks for the inputs. This is how I did it. 1. There are two listener.ora files /opt/app/oracle/product/816/listener.ora : FILE816 /opt/app/oracle/product/817/listener.ora : FILE817 FILE817 is a copy of FILE816 2. Entries for db7 are removed from FILE816 FILE816 listner name is left unchanged as LISTENER FILE816 entry for IPC was left unchanged : (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) FILE816 entry for PORT was left unchanged : (ADDRESS = (PROTOCOL = TCP)(HOST = lightening)(PORT = 1521)) 3. Entries for db6 are removed from FILE817 and ORACLE_HOME path changes are made FILE817 listner name was changed to LISTENER_817 FILE817 entry for IPC was changed as : (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_817)) ORACLE_HOME path changes were made to FILE817 FILE817 entry for PORT was changed as : (ADDRESS = (PROTOCOL = TCP)(HOST = lightening)(PORT = 1526)) 4. To use 816 listener ORACLE_HOME=$/opt/app/oracle/product/816 cd $ORACLE_HOME/network/admin $ORACLE_HOME/bin/lsnrctl stop listener $ORACLE_HOME/bin/lsnrctl start listener $ORACLE_HOME/bin/lsnrctl status listener 9. To use 817 listener ORACLE_HOME=$/opt/app/oracle/product/817 cd $ORACLE_HOME/network/admin $ORACLE_HOME/bin/lsnrctl stop listener_817 $ORACLE_HOME/bin/lsnrctl start listener_817 $ORACLE_HOME/bin/lsnrctl status listener_817 And I think I am having a. two separate Listeners b. for two different databases c. in different version (having different ORACLE_HOME) d. listening at different ports Am I correct or there is some mistake / improvement? Thanks for the inputs. -Rachna - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 16, 2002 2:39 PM -Original Message- Any quick start guides / scripts / notes for having multiple version listeners on same Solaris box? It works fine. Here is an example of some commands to put into a general Oracle startup script. export ORACLE_BASE=/oracle/app/oracle export LOGFILE=${ORACLE_BASE}/log/ora-startup.log exec $LOGFILE 21 touch $LOGFILE chmod a+r $LOGFILE print \nStarting ora-startup date # Automatically export all variables set -a # Start the databases $ORACLE_BASE/admin/dbascripts/init.d/dbstart # Start the listeners export ORACLE_HOME=$ORACLE_BASE/product/9.2.0 $ORACLE_HOME/bin/lsnrctl start LIST_V920 export ORACLE_HOME=$ORACLE_BASE/product/9.0.1 $ORACLE_HOME/bin/lsnrctl start LIST_V901 #Start the listeners export ORACLE_HOME=$ORACLE_BASE/product/8.1.7 $ORACLE_HOME/bin/lsnrctl start LIST_DSNR4 $ORACLE_HOME/bin/lsnrctl start LIST_V817 $ORACLE_HOME/bin/lsnrctl start LIST_V817_2 export ORACLE_HOME=$ORACLE_BASE/product/8.1.7.4 $ORACLE_HOME/bin/lsnrctl start LIST_V8174 etc. etc. etc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee 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.com -- Author: Rachna Vaidya 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: Multiple Listeners
Hmm, The db7 (upgraded to 817) automatically registers itself to listener. Why? And, changing the PORT, wouldn't I need to change all tnsnames.ora ? Nabil, your and Kirti's suggestion for one listener has this particular benefit. Still thinking.I am. - Original Message - To: 'Rachna Vaidya' [EMAIL PROTECTED] Sent: Wednesday, October 16, 2002 2:33 PM again, I think its better to use one listener. Unless you have some reason for needed two of them. just me 2 cents :-) nabil -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachna Vaidya 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: Multiple Listeners
Hmm, The db7 (upgraded to 817) automatically registers itself to listener. Why? And, changing the PORT, wouldn't I need to change all tnsnames.ora ? Nabil, your and Kirti's suggestion for one listener has this particular benefit. Still thinking.I am. -Rachna - Original Message - To: 'Rachna Vaidya' [EMAIL PROTECTED] Sent: Wednesday, October 16, 2002 2:33 PM again, I think its better to use one listener. Unless you have some reason for needed two of them. just me 2 cents :-) nabil -Original Message- From: Rachna Vaidya [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 16, 2002 1:21 PM To: LazyDBA.com Discussion Subject: Re: Multiple Listeners Thanks for the inputs. This is how I did it. 1. There are two listener.ora files /opt/app/oracle/product/816/listener.ora : FILE816 /opt/app/oracle/product/817/listener.ora : FILE817 FILE817 is a copy of FILE816 2. Entries for db7 are removed from FILE816 FILE816 listner name is left unchanged as LISTENER FILE816 entry for IPC was left unchanged : (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) FILE816 entry for PORT was left unchanged : (ADDRESS = (PROTOCOL = TCP)(HOST = lightening)(PORT = 1521)) 3. Entries for db6 are removed from FILE817 and ORACLE_HOME path changes are made FILE817 listner name was changed to LISTENER_817 FILE817 entry for IPC was changed as : (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_817)) ORACLE_HOME path changes were made to FILE817 FILE817 entry for PORT was changed as : (ADDRESS = (PROTOCOL = TCP)(HOST = lightening)(PORT = 1526)) 4. To use 816 listener ORACLE_HOME=$/opt/app/oracle/product/816 cd $ORACLE_HOME/network/admin $ORACLE_HOME/bin/lsnrctl stop listener $ORACLE_HOME/bin/lsnrctl start listener $ORACLE_HOME/bin/lsnrctl status listener 9. To use 817 listener ORACLE_HOME=$/opt/app/oracle/product/817 cd $ORACLE_HOME/network/admin $ORACLE_HOME/bin/lsnrctl stop listener_817 $ORACLE_HOME/bin/lsnrctl start listener_817 $ORACLE_HOME/bin/lsnrctl status listener_817 And I think I am having a. two separate Listeners b. for two different databases c. in different version (having different ORACLE_HOME) d. listening at different ports Am I correct or there is some mistake / improvement? Thanks for the inputs. -Rachna - Original Message - From: Stephen Lee [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 16, 2002 2:39 PM Subject: RE: Multiple Listeners -Original Message- Any quick start guides / scripts / notes for having multiple version listeners on same Solaris box? It works fine. Here is an example of some commands to put into a general Oracle startup script. export ORACLE_BASE=/oracle/app/oracle export LOGFILE=${ORACLE_BASE}/log/ora-startup.log exec $LOGFILE 21 touch $LOGFILE chmod a+r $LOGFILE print \nStarting ora-startup date # Automatically export all variables set -a # Start the databases $ORACLE_BASE/admin/dbascripts/init.d/dbstart # Start the listeners export ORACLE_HOME=$ORACLE_BASE/product/9.2.0 $ORACLE_HOME/bin/lsnrctl start LIST_V920 export ORACLE_HOME=$ORACLE_BASE/product/9.0.1 $ORACLE_HOME/bin/lsnrctl start LIST_V901 #Start the listeners export ORACLE_HOME=$ORACLE_BASE/product/8.1.7 $ORACLE_HOME/bin/lsnrctl start LIST_DSNR4 $ORACLE_HOME/bin/lsnrctl start LIST_V817 $ORACLE_HOME/bin/lsnrctl start LIST_V817_2 export ORACLE_HOME=$ORACLE_BASE/product/8.1.7.4 $ORACLE_HOME/bin/lsnrctl start LIST_V8174 etc. etc. etc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee 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 documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachna Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego
Re: Replication
Replication implementation for a newbie in 10 days? Having worked on replication for two and half hears, I would say it should not be done. Replication is way too complex. Read the Anita Badreen's white paper and it would emphasize the importance of understanding and planning repliction. There are several good white papers / notes on replication too on metalink. From my expereience, I would say, read Oracle Manual for Replication 2-3 times atleast. If you want to be good at it, come to the stage where you can do it without GUI (so that you know it pretty well.) They say that Replication Manager GUI is very good. But I have never felt need to use it, except, some basic monitoring... Practice, practice, practice Understand exactly needs of application very well and then decide what kind of replication to use HTH, -Rachna - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, October 14, 2002 11:43 AM and, if possible, start with Anita Bardeen's white paper Replication DOs and DON'Ts. (You'll probably find it at OTN). This is only a few pages, but it's full of invaluable tips. Barb -- From: DENNIS WILLIAMS[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Monday, October 14, 2002 8:58 AM To: Multiple recipients of list ORACLE-L Subject: RE: Replication Robin Your management sounds like some people I dealt with that assumed they would just flip the replication switch. How much of the 30-gig. do they plan to replicate? What replication interval? What tools do they plan to use? What is the replication direction - master-slave, peer-peer? How many sites? Ask for a copy of their replication policies. How will replication problems be detected? How will they be rectified? For reading, I would recommend what are the only 2 books I could locate (does that give you a hint about the popularity of replication?) Data Replication, Marie Buretta (lots of information about why policies are vital and how to write them). Oracle Distributed Systems, Charles Dye. The key to replication success (I can only speak from book knowledge) is in the people and the policies that coordinate their efforts and ensure nothing is overlooked, not in the technology. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, October 14, 2002 8:58 AM To: Multiple recipients of list ORACLE-L Hi all, Does anyone have the appropriate time on implementing replication for a newbe? I am given a time frame on doing the replication for 10 days which is including testing on test server and move to production. I've never done that before, now just start reading. This DB is about 30G on Oracle 8.1.7. TIA Robin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robin Li 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.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara 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.com -- Author: Rachna Vaidya INET: [EMAIL PROTECTED] Fat City
8.1.7.2 or 8.1.7.4
Which patch is recommended? Which is more stable? Obvious answer from Oracle Support was 8.1.7.4 for the reason that it was latest. But some of my friends have advised 8.1.7.2 Any opinions? Thanks, -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachna Vaidya 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: 8.1.7.2 or 8.1.7.4
We are running Solaris 6. Currently 8.1.6.3 Planning for 8.1.7 Management is pressing for the patch in the same go due to downtime issues. -Rachna - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, October 11, 2002 3:12 PM I'm investigating an 8.1.7 upgrade also. My impression is that the stability may vary by platform, so it might be helpful to specify the platform that is involved. I'm on HP/Compaq Tru64 myself. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, October 11, 2002 1:46 PM To: Multiple recipients of list ORACLE-L Vaidya I'm running 8.1.7.2 on all instances when I go to upgrade it will probably be 9iR2 starting with a test db, then from there, onto the least important db upwards. Of course I'm stalling to let all the venturous customers test thease new realeases (and abundantly advancing I might add) out for me =). I haven't had an issue where I couldn't get support because I wasn't at .3 or .4, nor has an issue arose in .2 that left me no choice to upgrade... -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Friday, October 11, 2002 2:14 PM To: Multiple recipients of list ORACLE-L Which patch is recommended? Which is more stable? Obvious answer from Oracle Support was 8.1.7.4 for the reason that it was latest. But some of my friends have advised 8.1.7.2 Any opinions? Thanks, -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Rachna Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com 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.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachna Vaidya 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).
8.1.6 to 8.1.7 upgrade
Gurus! Any docs / URLs / do's don'ts / tips for 8.1.6 to 8.1.7 upgrade? I have gone throught the metalink docs and Oracle Documentation. Thanks, -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachna Vaidya 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).