Configuring multi-threaded server

, Peter Schauss -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Configuring multi-threaded server

is not on 1521, then the dispatchers won't know how to find it to register. You'll have to add the listener= atttribute to the mts_dispatchers parameter. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Mon, 17 Nov 2003, Schauss, Peter wrote: Oracle version 8.1.7 AIX 4.3.3 I am trying

RE: Configuring multi-threaded server

/~jwilton On Mon, 17 Nov 2003, Schauss, Peter wrote: Oracle version 8.1.7 AIX 4.3.3 I am trying to configure mult-threaded server on one of my development databases. In my init.ora file, I set (mts_dispatchers=(address=(protocol=tcp)) mts_servers=10 When I bring up the database, I can

RE: Configuring multi-threaded server

is not on 1521, then the dispatchers won't know how to find it to register. You'll have to add the listener= atttribute to the mts_dispatchers parameter. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Mon, 17 Nov 2003, Schauss, Peter wrote: Oracle version 8.1.7 AIX 4.3.3 I am trying

Multi-threaded server - will it help in this case

, for example, by eliminating the overhead of starting a dedicated server for each connection? Thanks, Peter Schauss -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

Multithreaded server - effect of POOLING=ON option

Thanks for all of the input on the multi-threaded server. I have one more question: What is the effect of the POOLING option on the MTS_DISPATCHERS specification? Thanks, Peter Schauss -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter INET: [EMAIL

RE: 8.1.7 to 8.1.7.4 database migration - step 10 hangs

to be 1 or greater. I will send you the metalink note tomorrow if it isn't too late. HTH, Mike Schauss, Peter [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] c.com

8.1.7 to 8.1.7.4 database migration - step 10 hangs

. Has anyone else had this problem? Is there a workaround? Thanks, Peter Schauss -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: 64 bit Oracle (8.1.7) on a 32 bit AIX kernel (AIX 4.3.3)

Edition Release 8.1.7.0.0 - 64bit Production How can I be running the 64 bit server on a system with a 32 bit kernel? Thanks, Peter Schauss -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

8.1.7 on AIX 5.2

We are getting ready to migrate one of our instances from AIX 4.3.3 to 5.2. Do I need to get different media for this? Thanks, Peter Schauss -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858

64 bit Oracle (8.1.7) on a 32 bit AIX kernel (AIX 4.3.3)

- 64bit Production How can I be running the 64 bit server on a system with a 32 bit kernel? Thanks, Peter Schauss -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

Finding dedicated server processes associated with a specified us

How do you determine which dedicated server processes are associated with a given user session? Thanks, Peter Schauss -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Raid 1 vs Raid 5 for tablespaces

ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

sqlnet.expire_time

the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Restricting access via sqlplus

found a note the the archives which suggested making an entry into the SQLPLUS_PRODUCT_PROFILE table, but I have not been able to make this work. Oracle version: 8.1.7 AIX 4.3.3 Thanks, Peter Schauss -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter

AIX firmware changes - impact on Oracle software

Our systems people are getting ready to upgrade the firmware on one of my AIX 4.3.3 database servers. Will I need to relink the Oracle software? Thanks, Peter Schauss -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City

Failed to archive log#...

these messages mean? Thanks, Peter Schauss -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: ORA-04031

0.0 -Original Message- Sent: Friday, June 27, 2003 6:10 PM To: Multiple recipients of list ORACLE-L What patch level of 8.1.7 are you on?? --Walt --- Schauss, Peter [EMAIL PROTECTED] wrote: One of our third party applications gave us the following message: ORA-04031: unable

RE: ORA-04031

: Friday, June 27, 2003 6:10 PM To: Multiple recipients of list ORACLE-L What patch level of 8.1.7 are you on?? --Walt --- Schauss, Peter [EMAIL PROTECTED] wrote: One of our third party applications gave us the following message: ORA-04031: unable to allocate 4192 bytes of shared memory

Oracle unlimited concurrent license

users and Processor Based. Has anyone heard of this other type? Thanks, Peter Schauss -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

ORA-04031

enough so that I won't get the ORA-04031 errors? 3. Is there any other init.ora parameter I ought to be looking at here? Thanks, Peter Schauss -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858

Inserting blanks from a PROCOBOL program

to go into the field? Oracle version is 8.1.7 on AIX 4.3 Procobol 1.8.52.0.0 Thanks, Peter Schauss -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

dbshut script - shutdown or shutdown immediate

-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: sysresv doesn't work on AIX

Schauss, Peter [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/26/2003 12:33 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:sysresv doesn't work on AIX Poking around metalink I found a reference

RE: sysresv doesn't work on AIX

-Original Message- Sent: Wednesday, March 26, 2003 4:44 PM To: Multiple recipients of list ORACLE-L Login as the owner of the shared mem segments and run it. It just worked for me on RH 7.2 with 8.1.7 Jared Schauss, Peter [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/26/2003 12:33 PM

sysresv doesn't work on AIX

0xfa5fbc28 --rw-r- oracle oinstall m 2 0x02da4bbc --rw-r- oracle oinstall Anyone else have similar experiences? Thanks, Peter Schauss Northrop Grumman Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat

ORA-00445: background process PMON did not start after 120 seco

Grumman Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Moving an index

In 8.1.7, is rebuilding the appropriate way to move an index to a different tablespace? Thanks, Peter Schauss Northrop Grumman Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

RE: Bind variable use in C++ SQL Calls

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: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network

switch logfile vs. archive log current

backup controlfile to '$BACKUP_DIR$DIR1/control01.bak'; alter system switch logfile; exit EOF # Thanks, Peter Schauss Northrop Grumman Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services

RE: Questions about constraints

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: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: SQL*LOADER question

://www.orafaq.net -- Author: Schauss, Peter 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

RE: switch logfile vs. archive log current

the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

re: ORA-27100: shared memory realm already exists - status

the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

ORA-27100: shared memory realm already exists

tell for certain which segment is being used by which instance? (The other instance on the box is production and a mistake might cost me a few friends.) Thanks, Peter Schauss Northrop Grumman Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter INET

RE: Hot backups

-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Hot backups

not have to use the until cancel option. Thanks, Peter Schauss Northrop Grumman Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Experience with Quest Shareplex

] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Oracle DBA vs JAVA programmer???

: http://www.orafaq.com -- Author: Schauss, Peter 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

Interpretation of TKPROF output

-- Author: Schauss, Peter 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

Session Data Unit and tcp.nodelay

, Peter Schauss Northrop Grumman Corporation [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

Named User Licensing for Oracle Programmer (precompilers)

this product? Thanks, Peter Schauss Northrop Grumman Corporation [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: osh error when running oraenv

] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Transfering data from DB2 to Oracle

this? thanks, Peter Schauss -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Ids and passwords for application users

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Errors trying to connect from 8.1.7 client to 7.3.2 server

of the suggestions so far. Peter Schauss Northrop Grumman Corporation [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

Errors trying to connect from 8.1.7 client to 7.3.2 server

suggestions? Thanks in advance, Peter Schauss Northrop Grumman Corporation [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Loading tables from XML files

to do it. thanks, Peter Schauss Northrop Grumman Corporation [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

Storage of numeric data

not get out 0.08599). If I use a format like number(4,3), will this give me the result that I want or should I use char(5)? thanks, Peter Schauss Northrop Grumman Corporation [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL

RE: Storage of numeric data

11:08 AM To: Schauss, Peter; Multiple recipients of list ORACLE-L Peter, For numeric data where you can't exactly define the size precision use a plain old number data type. It's the equivalent of float or double. I do not allow numeric data to be stored in a char or varchar field because

Oracle client won't install on Windows 2000

ideas what might be wrong? Thanks Peter Schauss Northrop Grumman Corporation [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

Capacity planning courses

://www.orafaq.com -- Author: Schauss, Peter 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

Training courses

://www.orafaq.com -- Author: Schauss, Peter 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

Oracle to DB2 (OS/390) gateways

need? Short of using ODBC drivers, is there a less expensive alternative which would allow me to query DB2 tables from Oracle. thanks, Peter Schauss Northrop Grumman Corporation [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET

Memory usage by an Oracle instance

to determine how much (if any) of the memory listed here is in the form of shared libraries or shared memory segments? Peter Schauss Northrop Grumman Corporation [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat

Oracle Diagnostic and Tuning Packs

Are these addons to OEM worth buying? Thanks Peter Schauss Northrop Grumman Corporation [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

RE: Favorite Urban Myth

516-346-3148 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Automatic shutdown of Oracle on NT

] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Accessing databases with different character sets

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

ERwin problem

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Oracle Transparent Gateway

feedback. thanks, Peter Schauss Northrop Grumman Corporation 516-346-3148 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Oracle interface to DB2 on OS/390

Corporation 516-346-3148 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Inserting data from XML

Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists