RE: Urgent - tnsnames problem..
Title: RE: Urgent - tnsnames problem.. May be your ORACLE_SID is in lower case(vuntest) and your SID in the listener.ora is in upper case (SID = VUNTEST).. Check'em.. -Original Message-From: Adams, Matthew (GEA, 088130) [mailto:[EMAIL PROTECTED]]Sent: Thursday, April 26, 2001 11:44 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Urgent - tnsnames problem.. what error are you getting? Is the listener process running? R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Meddle not in the affairs of troff, for it is subtle and quick to anger. > -Original Message- > From: Manivannan Muthukrishnan [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 26, 2001 2:16 PM > To: Multiple recipients of list ORACLE-L > Subject: Urgent - tnsnames problem.. > > > Hi > I have a problem. I've installed Oracle 8.0.5 on HPUX. > I've created the database. But I can't connect thro tns. Its giving me > Oracle not available error. I've > checked the entries. > Here is the tnsnames.ora file > > > # > # Installation Generated Net8 Configuration > # Version Date: Oct-27-97 > # Filename: Tnsnames.ora > # > extproc_connection_data = > (DESCRIPTION = > (ADDRESS = (PROTOCOL = IPC)(KEY = extproc)) > (CONNECT_DATA = (SID = extproc)) > ) > > VUNTEST = > (DESCRIPTION = > (ADDRESS = (PROTOCOL= TCP)(Host= 163.122.1.35)(Port= 1521)) > (CONNECT_DATA = (SID = VUNTEST)) > ) > > > Thanks in advance.. > Manivannan.M > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Manivannan Muthukrishnan > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > > 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 Licensing for a Clustered Server Configuration
Title: Oracle Licensing for a Clustered Server Configuration Hi, Does Oracle Corp. require you to buy the RDBMS license for the fail-over server (as well) in a 2-node cluster server environment? Thanks Nagesh
RE: Oracle Licensing for a Clustered Server Configuration
Title: Oracle Licensing for a Clustered Server Configuration John, are/were you in a similiar env.. ..very curious..coz Oracle is forcing us to buy a second license for the passive fail-over server .. Thanks -Original Message-From: Shaw, John B [mailto:[EMAIL PROTECTED]]Sent: Monday, August 27, 2001 12:21 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle Licensing for a Clustered Server Configuration Only if it's active on the fail over node - if it's passive you don't need a second license. -Original Message-From: Srinagesh Battula [mailto:[EMAIL PROTECTED]]Sent: Monday, August 27, 2001 1:07 PMTo: Multiple recipients of list ORACLE-LSubject: Oracle Licensing for a Clustered Server Configuration Hi, Does Oracle Corp. require you to buy the RDBMS license for the fail-over server (as well) in a 2-node cluster server environment? Thanks Nagesh
RE: Oracle Licensing for a Clustered Server Configuration
Title: RE: Oracle Licensing for a Clustered Server Configuration Our failover server neither has a standby database nor oracle binaries. In our Clustered server configuration, when a fail over happens the entire diskgroups will be de-ported from the primary and imported on the failover server. So, at any given point only one node will be running oracle.. > -Original Message- > From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] > Sent: Monday, August 27, 2001 12:01 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Oracle Licensing for a Clustered Server Configuration > > > for a standby database? yes. If you are USING the binaries on > the machine > (to apply the archived logs) they want the money. > > However, if you have a backup copy of the binaries loaded, > but are not > running Oracle, they don't ask for the money. > > > >From: Srinagesh Battula <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >Subject: Oracle Licensing for a Clustered Server Configuration > >Date: Mon, 27 Aug 2001 10:07:29 -0800 > > > > > >Hi, > > > >Does Oracle Corp. require you to buy the RDBMS license for > the fail-over > >server (as well) in a > >2-node cluster server environment? > > > >Thanks > > > >Nagesh > > > _ > Get your FREE download of MSN Explorer at > http://explorer.msn.com/intl.asp > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rachel Carmichael > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > > 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[2]: Oracle the best
- You might want to consider using orastack.exe to reduce the memory requirements. By default, every thread (oracle,tns, svrmgrl, sqlplus) takes 1M. That is more than enough of stack space. I would reduce it to 500K using the orastack.exe. - In addition to this, you may reduce your SGA to a convenient size. - Look into 4GT tuning. This will allow oracle to use memory beyond 2G limitation (incl SGA+PGA ..) - What are the sort area settings that you have? > > -Original Message- > > Sent: Friday, November 09, 2001 9:00 AM > > To: Multiple recipients of list ORACLE-L > > > > > > Hi, > > > > All of us believe Oracle is the best database server. > > We can keep our application data on Oracle and just > > forget the rest. I strongly believe I can do anything > > I want, with Oracle. > > > > We have a problem with Oracle. Ours is a small > > application with most hits. Lot of people will be > > using our solution and each hit results in database > > access. > > > > We have limitation on the maximum number of > > connections that can be made from Java > > application(servlet). We are accessing from 16 servlet > > machines to the database and making around 500 > > connections. We are using a connection pool from > > Javaexchange(DbConnectionBroker). When the application > > reaches beyond 500(I think the number is still less) > > connections, the database stops responding. Database > > machine's CPU usage goes 100%. And any requests from > > servlets at this point, will wait for a long time to > > get response from oracle. > > > > We are using Oracle 8.1.7, on Windows 2000. System RAM > > is 3GB. We are using 1.5GB of SGA. System is 1GHz > > processor. > > > > We are using CLOB very frequently. > > > > Thanks in advance for your suggestion on tuning. > > > > Regards, > > > > Prasad BAV. > > > > __ > > Do You Yahoo!? > > Find a job, post your resume. > > http://careers.yahoo.com > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Prasad BAV > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / > Mailing Lists > > > > 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: Rao, Maheswara > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / > Mailing Lists > > > > 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!? > Get your free @yahoo.com address at http://mail.yahoo.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Prasad BAV > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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 FAX: (858) 538-5051 > San Diego, California-- Public
CKPTs are not happening with FAST_START_IO_TARGET
Title: CKPTs are not happening with FAST_START_IO_TARGET RDBMS: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production OS: SunOS e6500a 5.6 Generic_105181-19 sun4u sparc SUNW,Ultra-Enterprise The init params are set as follows: .. db_block_size=8192 db_block_buffers=2 fast_Start_io_target=5000 log_checkpoints_to_alert = TRUE log_checkpoint_timeout = 2147483647 log_checkpoint_interval = 9 We have 4 Redo log groups with 200M each. We have a requirement that the instance recovery must be done within 60 secs. So, we are trying to use the fast_Start_io_target param. The issue here is, we don't see any checkpoints being done (as seen in the alert logs as well as v$sysstat). THe only checkpoints that we see are the ones that happen during a log switch or if you issue "alter system checkpoint". Any ideas on why the checkpoints are not being performed. Thanks in advance.
RE: standby database in managed recovery mode
What is your standby_archive_dest set to? can u show us the params from the init.ora > -Original Message- > From: Richard Huntley [mailto:[EMAIL PROTECTED]] > Sent: Thursday, May 03, 2001 10:21 AM > To: Multiple recipients of list ORACLE-L > Subject: FW: standby database in managed recovery mode > > > > Suggestions anyone?? I'm attempting to get a standby > database to run in > > managed recovery mode, so that the archived logs > > are automatically applied, however, when running the > command 'recover > > managed standby database' I receive the following error message: > > SVRMGR> recover managed standby database; > > ORA-00308: cannot open archived log > > '/u03/apps/oracle/admin/db/arch/1_194.arc' > > ORA-27037: unable to obtain file status > > SVR4 Error: 2: No such file or directory > > Additional information: 3 > > > > This is after I've brought the primary and standby up to > the same max > > recid number in the v$log_history. I have attempted to rebuild the > > standby database and also to execute the command 'recover > standby database > > until cancel' after confirming that all archived log files > were in the > > proper location, however I'm always prompted for the next > archive log > > which doesn't exist yet and I can't get into "managed" > recovery mode. > > I've also went to the primary database, forced a log switch and then > > applied the newest archived log file, but that hasn't > worked either. > > > > > > Richard Huntley > > Software Developer > > Phone: (800) 223-3732 (614) 880-1817 > > E-mail: [EMAIL PROTECTED] > > MindLeaders (www.mindleaders.com) > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Richard Huntley > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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: Srinagesh Battula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Intermedia
To install Intermedia as a separate product, the db has to be shutdown for oracle exe to be relinked Once the Intermedia product has been installed, the following steps must be performed to configure it as shown below. How to configure Intermedia? Create the CTXSYS tablespace create tablespace ctxsys datafile '/u02/oradata/dev/ctxsys01.dbf' size 100M autoextend on next 100M maxsize 1000M; export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/ctx/lib 548:oracle@devdb> pwd /u01/app/oracle/product/8.1.7/ctx/admin As sys run @dr0csys.sql ctxsys ctxsys temp As ctxsys @dr0inst.sql /u01/app/oracle/product/8.1.7/ctx/lib/libctxx8.so As ctxsys select object_type, count(*) from user_objects group by object_type; select * from user_libraries ; @?/ctx/admin/defaults/drdefus.sql > -Original Message- > From: A. Bardeen [mailto:[EMAIL PROTECTED]] > Sent: Friday, May 11, 2001 4:18 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Intermedia > > > Bryan, > > A good start is Note: 101493.1 "QUICK START GUIDE: > InterMedia Text Installation" > > There are others on metalink: > > Technical Libraries button > Server -> Oracle interMedia Text and ConText Option > > HTH, > > -- Anita > > --- "Miller, Bryan" <[EMAIL PROTECTED]> wrote: > > Does anyone have instructions or know where to find > > concise instructions on > > setting up the Intermedia database objects (i.e. > > CTXSYS and what not) in an > > 8.1.6 instance? Like what scripts to run or is there > > a utility. > > TIA > > Bryan M. Miller > > Junior Oracle DBA > > IT Operations > > Telergy Inc. > > Email: [EMAIL PROTECTED] > > Phone: (315)362-2642 > > Pager: (315)647-1908 > > > > > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Miller, Bryan > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: > > (858) 538-5051 > > San Diego, California-- Public Internet > > access / Mailing Lists > > > > > 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!? > Yahoo! Auctions - buy the things you want at great prices > http://auctions.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: A. Bardeen > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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: Srinagesh Battula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Vocabulary
It comes from the Metric System. > -Original Message- > From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, May 16, 2001 11:41 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: Vocabulary > > > way cool -- thank you :) > > > >From: "Khedr, Waleed" <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >Subject: RE: Vocabulary > >Date: Wed, 16 May 2001 10:19:24 -0800 > > > >Look at this: > > > >http://www.kshitij.com/utilities/LnCtoMnB.shtml > > > >-Original Message- > >Sent: Wednesday, May 16, 2001 1:56 PM > >To: Multiple recipients of list ORACLE-L > > > > > >I have seen this several times, and I am very curious as to > what "lakhs" > >are. Is this a standard of measurement? > > > >At 10:35 PM 5/15/01 -0800, you wrote: > > >Dear DBA Gurus, > > > > > > I have some static data in two of my tables which > contains lakhs > >of > > >records. > > > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > >-- > >Author: Regina Harter > > INET: [EMAIL PROTECTED] > > > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > >San Diego, California-- Public Internet access / > Mailing Lists > > > >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: Khedr, Waleed > > INET: [EMAIL PROTECTED] > > > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > >San Diego, California-- Public Internet access / > Mailing Lists > > > >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). > > _ > Get your FREE download of MSN Explorer at http://explorer.msn.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rachel Carmichael > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > -------- > 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: Srinagesh Battula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to make DBA cannot 'see' User's Tables?
You can encrypt & Decrypt data using the DBMS_OBFUSCATION_TOOLKIT package (comes with 8.1.6) Srinagesh "What do I know any way" Battula > -Original Message- > From: Khedr, Waleed [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, May 16, 2001 4:21 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: How to make DBA cannot 'see' User's Tables? > > > Data Encryption? > > -Original Message- > Sent: Wednesday, May 16, 2001 7:01 PM > To: Multiple recipients of list ORACLE-L > > > > Dear gurus, > How to make DBA cannot 'see' user's datas? > I build an application which very important and top secret > even DBA cannot > 'see' this data. But DBA can backup this data.What is the > solution for this > problem? > > TIA, > > > Ahmadsyah Alghozi Nugroho > Database Engineering Specialist > PT Infoglobal AutOptima > Jl. Baruk Tengah I/49 > Surabaya - Jawa Timur > phone : +62 (31) 8708456 ext.113 > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Khedr, Waleed > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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: Srinagesh Battula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Your views on Quest - Shareplex
Title: RE: Your views on Quest - Shareplex Our production runs on a multi-threaded app. And, it is the Single threaded nature of Shareplex with the LONG columns in the db that did not make it suitable for us. Shareplex just could not catch up with the DML activity in our Production. -Original Message-From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]Sent: Tuesday, May 29, 2001 4:20 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Your views on Quest - Shareplex >-Original Message- >From: Brian MacLean [mailto:[EMAIL PROTECTED]] >As of a year ago it was single threaded >and didn't handle long columns. I talked to one of the SharePlex developers. a) Shareplex has handled long columns for as long as she remembers (a little more than three years). b) Shareplex has recently supported LOB columns in a production release. c) The next version will include multi-threaded posting. Mr. Goulet, just out of curiosity (for feedback to the product managers), what was it in Eyal Aronoff's response that made you think you would not like to use Shareplex? -- Jacques R. Kilchoer (949) 754-8816 Quest Software, Inc. 8001 Irvine Center Drive Irvine, California 92618 U.S.A. http://www.quest.com