RE: Sun Solaris

2002-12-16 Thread Markham, Richard 
Title: RE: Sun Solaris





sunhelp.org for general.
sunmanagers.org for critical. requires summary post and is more restrictive.


-Original Message-
From: Ehresmann, David [mailto:[EMAIL PROTECTED]] 
Sent: Monday, December 16, 2002 10:59 AM
To: Multiple recipients of list ORACLE-L
Subject: Sun Solaris



List,


Does anybody know a Sun Solaris e-mail list/forum that's useful like this one is for Oracle?


thanks, 


David Ehresmann


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ehresmann, David
  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: Sun Solaris

2002-12-16 Thread Kevin Lange 
Go to this page and join the SOLARIS-L list.   

http://www.openitx.com/nav/t.asp?t=507&p=607&h1=507&h2=571&h3=607

This page has a bunch of other OS lists as well.

-Original Message-
Sent: Monday, December 16, 2002 9:59 AM
To: Multiple recipients of list ORACLE-L


List,

Does anybody know a Sun Solaris e-mail list/forum that's useful like this
one is for Oracle?

thanks, 

David Ehresmann

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ehresmann, David
  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).

Re: Sun Solaris

2002-12-16 Thread Gillian 
Try this:
http://unix.ittoolbox.com/
Gillian
 "Ehresmann, David" <[EMAIL PROTECTED]> wrote:
List,Does anybody know a Sun Solaris e-mail list/forum that's useful like thisone is for Oracle?thanks, David Ehresmann-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Ehresmann, DavidINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now

RE: Sun Solaris

2002-12-16 Thread Eddie Watkins 

>
>List,
>
>Does anybody know a Sun Solaris e-mail list/forum that's 
>useful like this
>one is for Oracle?
>

Try

http://www.sunhelp.org/mailman/listinfo/sunhelp

Eddie Watkins
The Moray Council
email: [EMAIL PROTECTED]
tel: 01343 563247


  The Moray Council: Internet E-mail Notice  

The contents of this e-mail and any attachments ('this e-mail')
are confidential and intended solely for the addressee.
If this e-mail has been sent to you by mistake, please notify
[EMAIL PROTECTED] as soon as possible; you should then
delete this e-mail from your computer.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eddie Watkins
  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: Sun Solaris

2002-12-16 Thread Brian Dunbar 
SunHelp.  Oddly enough, when I asked _them_ for a list just like theirs, but
for Oracle, they directed me to Oracle-L..

http://www.sunhelp.org/lists.php

Also useful for the knowledge of all things geeky are Recsue and Geeks, same
page.

~brian

-Original Message-
Sent: Monday, December 16, 2002 9:59 AM
To: Multiple recipients of list ORACLE-L


List,

Does anybody know a Sun Solaris e-mail list/forum that's useful like this
one is for Oracle?

thanks, 

David Ehresmann

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ehresmann, David
  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: Brian Dunbar
  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: Sun Solaris

2002-12-16 Thread Barry Deevey 
David,

http://www.sunmanagers.org/

HTH

Barry

-Original Message-
Sent: 16 December 2002 15:59
To: Multiple recipients of list ORACLE-L


List,

Does anybody know a Sun Solaris e-mail list/forum that's useful like this
one is for Oracle?

thanks, 

David Ehresmann

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ehresmann, David
  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: Barry Deevey
  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: Sun Solaris

2002-12-16 Thread Bill CONNER 
This one is good:  http://www.sunmanagers.org/mailman/listinfo/sunmanagers.

-bill

At 07:58 AM 12/16/2002 -0800, you wrote:

List,

Does anybody know a Sun Solaris e-mail list/forum that's useful like this
one is for Oracle?

thanks,

David Ehresmann

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ehresmann, David
  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: Bill CONNER
 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: Sun Solaris 8 - Listener failed to start a dedicated server proce

2001-05-22 Thread Rocky Welch 

Hi Jacques,
You need to increase the processes parameter in the init.ora file then
restart the listener and database.

HTH,

-Rocky

--- Jacques Kilchoer <[EMAIL PROTECTED]> wrote:
> On one of our Sun (development) servers, we have 8 databases running for
> different versions of Oracle (7.3.4, 8.0.6, 8.1.6). I am able to connect
> with SQL*Plus on the server, but I can't connect from a client. I get
> the
> following error
> 
> ERROR:
> ORA-12500: TNS:listener failed to start a dedicated server process
> 
> The server's listener.log shows the following error:
> 22-MAY-2001 10:26:25 * service_died * 0
> 22-MAY-2001 10:27:26 * service_died * 0
> 22-MAY-2001 10:28:18 *
>
(CONNECT_DATA=(SID=dbname)(CID=(PROGRAM=C:\Oracle\Ora81\BIN\SQLPLUSW.EXE)(HO
> ST=mypc)(USER=Jacques_Kilchoer))) *
> (ADDRESS=(PROTOCOL=tcp)(HOST=xx.x.xx.xx)(PORT=4949)) * establish *
> dbname *
> 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
> 22-MAY-2001 10:28:28 * service_died * 0
> 
> 
> I would think that Solaris Error: 12 corresponds to this error number
> from
> /usr/include/sys/errno.h
> #define ENOMEM  12  /* Not enough core  */
> 
> The Sun server has 4 processors / 4GB of ram.
> 
> ipcs shows that there should be plenty of RAM available (about 680MB
> being
> used). swap -s shows that there is plenty of swap space available (4GB).
> I
> don't have an X-windows emulator on my machine so I don't think I can
> run
> admintool (is that right?)
> 
> A search on Metalink find a forum entry with the following suggestions
> (1
> through 5). I tried 1 (increase processes in init.ora) and 4 (disable
> otrace
> by deleting .dat files). I don't really want to run MTS so I am
> discounting
> option 5 for now. I think the answer lies in 2 (increase Unix kernel
> parameters).
> 
> What can I do? The System Administrator is busy so he gave me the root
> password and said "have at it."
> 
> -- From Metalink
> Intermittent TNS-12500 errors are caused by a lack of  resources on the
> server. Finding which resource is  depleted may be difficult. 
> 
> 1. The TNS-12500 can be a result of the 'processes'  parameter in the
> init.ora file being too low. 
> 
> 2. If the init.ora 'processes' parameter seems ok then you may need to
> increase the Unix kernel parameters for the maximum number of processes
> or
> users (for example, nproc or maxuprc). Check the manuals for the Unix
> operating system for more information on these parameters. 
> 
> 3. Check that you have adequate swap space. 
> 
> 4. Disable OTRACE. OTRACE is a tracing feature that can cause many
> problems.
> OTRACE is enabled by default. To disable OTRACE: 
> 
> a. Stop the Oracle database. 
> b. Go to the $ORACLE_HOME/otrace/admin directory. 
> c. Delete all files with a '.dat' extension. 
> d. Restart the Oracle database. 
> 
> 5. Use the Multi-Threaded Server (MTS) option. 
> --
> Jacques R. Kilchoer
> (949) 754-8816
> Quest Software, Inc.
> 8001 Irvine Center Drive
> Irvine, California 92618
> U.S.A.
> http://www.quest.com
> 


__
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: Rocky Welch
  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: Sun Solaris 8 - Listener failed to start a dedicated server p

2001-05-22 Thread John Kanagaraj 

Jacques,
 
I am not sure, but are you running out of semaphores? (possible as your
default limit may be too low for the 8 databases you serve). Look at
/etc/system together with the UIG - add us all the 'processes' in all
init.oras - they should be lesser than 'SEMMNS' (Number of semaphores).
Changes to /etc/system will need a server restart to become effective.
 
John Kanagaraj

-Original Message-
Sent: Tuesday, May 22, 2001 11:57 AM
To: Multiple recipients of list ORACLE-L



On one of our Sun (development) servers, we have 8 databases running for
different versions of Oracle (7.3.4, 8.0.6, 8.1.6). I am able to connect
with SQL*Plus on the server, but I can't connect from a client. I get the
following error

ERROR: 
ORA-12500: TNS:listener failed to start a dedicated server process 

The server's listener.log shows the following error: 
22-MAY-2001 10:26:25 * service_died * 0 
22-MAY-2001 10:27:26 * service_died * 0 
22-MAY-2001 10:28:18 *
(CONNECT_DATA=(SID=dbname)(CID=(PROGRAM=C:\Oracle\Ora81\BIN\SQLPLUSW.EXE)(HO
ST=mypc)(USER=Jacques_Kilchoer))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.x.xx.xx)(PORT=4949)) * establish * dbname *
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 
22-MAY-2001 10:28:28 * service_died * 0 


I would think that Solaris Error: 12 corresponds to this error number from
/usr/include/sys/errno.h 
#define ENOMEM  12  /* Not enough core  */ 

The Sun server has 4 processors / 4GB of ram. 

ipcs shows that there should be plenty of RAM available (about 680MB being
used). swap -s shows that there is plenty of swap space available (4GB). I
don't have an X-windows emulator on my machine so I don't think I can run
admintool (is that right?)

A search on Metalink find a forum entry with the following suggestions (1
through 5). I tried 1 (increase processes in init.ora) and 4 (disable otrace
by deleting .dat files). I don't really want to run MTS so I am discounting
option 5 for now. I think the answer lies in 2 (increase Unix kernel
parameters).

What can I do? The System Administrator is busy so he gave me the root
password and said "have at it." 

-- From Metalink 
Intermittent TNS-12500 errors are caused by a lack of  resources on the
server. Finding which resource is  depleted may be difficult. 

1. The TNS-12500 can be a result of the 'processes'  parameter in the
init.ora file being too low. 

2. If the init.ora 'processes' parameter seems ok then you may need to
increase the Unix kernel parameters for the maximum number of processes or
users (for example, nproc or maxuprc). Check the manuals for the Unix
operating system for more information on these parameters. 

3. Check that you have adequate swap space. 

4. Disable OTRACE. OTRACE is a tracing feature that can cause many problems.
OTRACE is enabled by default. To disable OTRACE: 

a. Stop the Oracle database. 
b. Go to the $ORACLE_HOME/otrace/admin directory. 
c. Delete all files with a '.dat' extension. 
d. Restart the Oracle database. 

5. Use the Multi-Threaded Server (MTS) option. 
-- 
Jacques R. Kilchoer 
(949) 754-8816 
Quest Software, Inc. 
8001 Irvine Center Drive 
Irvine, California 92618 
U.S.A. 
http://www.quest.com   

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Kanagaraj
  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: Sun Solaris 8 - Listener failed to start a dedicated server p

2001-05-22 Thread Jacques Kilchoer 
Title: RE: Sun Solaris 8 - Listener failed to start a dedicated server p





Thank you for the suggestions so far.
Rocky Welch suggesting increasing the "processes" parameter in the init.ora
I tried that with one of the 8.1.6 databases.
The "processes" parameter was set to 50, I increased it to 200, shut down that database, restarted the listener (lsnrctl>stop and lsnrctl>start) and restarted the database. I still got "ORA-12500: TNS:listener failed to start a dedicated server process" when trying to connect to that database from the client.

John Kangaraj has suggested checking the number of semaphores. I forgot to mention before that I had already looked at that also (I've been bitten by semaphores before.) I counted 780 semaphores being used (from ipcs) and 1024 being the maximum allowed (from /etc/system). (see below)

I'm still new to Sun Solaris and I'm totally stumped. Does anyone else have any other ideas? I really would prefer not running multi-threaded server (MTS) if I don't have to, which was one of the suggestions on Metalink.

Am I interpreting the available memory information correctly? (see below) For physical memory, I think I see 4GB available and 622 MB being used. As far as swap, I see approx. 4GB available.

 semaphores
In /etc/system I see this:
set semsys:seminfo_semmns=1024


ipcs shows me this:


$ ipcs -sa
IPC status from  as of Tue May 22 12:46:49 PDT 2001
T ID  KEY    MODE    OWNER    GROUP  CREATOR   CGROUP NSEMS   OTIME    CTIME 
Semaphores:
s    5505024   0x6f61806  --ra-r-   oracle  dba   oracle  dba   204 12:46:49 13:02:49
s 262145   0  --ra-r-   oracle  dba   oracle  dba    50 17:52:20 10:46:15
s    1703938   0x2f18d66  --ra-ra   oracle  dba   oracle  dba    59 12:42:31 14:12:02
s 983043   0xc934c46  --ra-r-   oracle  dba   oracle  dba    54  1:25:44 13:03:40
s 524292   0x81a8556  --ra-r-   oracle  dba   oracle  dba    79 12:46:34 13:06:43
s    2424837   0x40b7ad6  --ra-r-   oracle  dba   oracle  dba   204  1:29:56 13:07:46
s 589830   0  --ra-r-   oracle  dba   oracle  dba    50 12:06:06 19:22:22
s    1048584   0  --ra-r-   oracle  dba   oracle  dba    80  4:03:18 15:55:22
Total: 780
- end of semaphore information



- physical memory
$ /usr/sbin/prtconf | grep -i mem
Memory size: 4096 Megabytes
    memory (driver not attached)
    virtual-memory (driver not attached)
$ ipcs -pmb
IPC status from  as of Tue May 22 13:15:58 PDT 2001
T ID  KEY    MODE    OWNER    GROUP  SEGSZ  CPID  LPID
Shared Memory:
m  0   0x505b --rw-r--r-- root root  4   417   417
m   4201   0x9167ce10 --rw-r-   oracle  dba   58998784 26660  7608
m    802   0x63973b5c --rw-r-   oracle  dba    5824512 16908  5642
m   1403   0xc7294a0c --rw-rw   oracle  dba   18743296  7115  7584
m    604   0x826b2278 --rw-r-   oracle  dba   93601792 27580  7251
m   1005   0x59b783a4 --rw-r-   oracle  dba  146014208  1066  7579
m   1807   0xc6e2a74  --rw-r-   oracle  dba    4268032 13480  4674
m   2809   0x27a21464 --rw-r-   oracle  dba  325394432 26885 17005
- end of physical memory information


- swap space
$ /usr/sbin/swap -s
total: 910872k bytes allocated + 2232248k reserved = 3143120k used, 4208264k available
- end of swap space information

RE: Sun Solaris 8 - Listener failed to start a dedicated server p

2001-05-22 Thread eric harrington 
Title: RE: Sun Solaris 8 - Listener failed to start a dedicated server p



Jacques,
 
I've seen a similar 
error with processes and Solaris memory structures.  Someone mentioned 
increasing SEMMNS, this helped in my situation, however you can try decreasing 
the PROCESSES parameter temporarily (as low as possible) to test whether the 
Solaris memory setup is an issue.  There is a formula for sizing SEMMNS, 
cannot currently find it.
 
Good 
luck!

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Jacques KilchoerSent: 
  Tuesday, May 22, 2001 5:26 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Sun Solaris 8 - Listener failed to start a 
  dedicated server p
  Thank you for the suggestions so far. Rocky Welch suggesting increasing the "processes" parameter in the 
  init.ora I tried that with one of the 8.1.6 
  databases. The "processes" parameter was set to 50, I 
  increased it to 200, shut down that database, restarted the listener 
  (lsnrctl>stop and lsnrctl>start) and restarted the database. I still got 
  "ORA-12500: TNS:listener failed to start a dedicated server process" when 
  trying to connect to that database from the client.
  John Kangaraj has suggested checking the number of semaphores. 
  I forgot to mention before that I had already looked at that also (I've been 
  bitten by semaphores before.) I counted 780 semaphores being used (from ipcs) 
  and 1024 being the maximum allowed (from /etc/system). (see below)
  I'm still new to Sun Solaris and I'm totally stumped. Does 
  anyone else have any other ideas? I really would prefer not running 
  multi-threaded server (MTS) if I don't have to, which was one of the 
  suggestions on Metalink.
  Am I interpreting the available memory information correctly? 
  (see below) For physical memory, I think I see 4GB available and 622 MB being 
  used. As far as swap, I see approx. 4GB available.
   semaphores In 
  /etc/system I see this: set 
  semsys:seminfo_semmns=1024 
  ipcs shows me this: 
  $ ipcs -sa IPC status from  as of Tue May 22 12:46:49 PDT 2001 T 
  ID  KEY    
  MODE    OWNER    
  GROUP  CREATOR   CGROUP NSEMS   
  OTIME    CTIME Semaphores: 
  s    5505024   0x6f61806  
  --ra-r-   oracle  dba   
  oracle  dba   204 12:46:49 
  13:02:49 s 262145   
  0  
  --ra-r-   oracle  dba   
  oracle  dba    50 17:52:20 
  10:46:15 s    1703938   
  0x2f18d66  --ra-ra   oracle  
  dba   oracle  dba    59 
  12:42:31 14:12:02 s 
  983043   0xc934c46  --ra-r-   
  oracle  dba   
  oracle  dba    54  1:25:44 
  13:03:40 s 524292   
  0x81a8556  --ra-r-   oracle  
  dba   oracle  dba    79 
  12:46:34 13:06:43 s    
  2424837   0x40b7ad6  --ra-r-   
  oracle  dba   
  oracle  dba   204  1:29:56 
  13:07:46 s 589830   
  0  
  --ra-r-   oracle  dba   
  oracle  dba    50 12:06:06 
  19:22:22 s    1048584   
  0  
  --ra-r-   oracle  dba   
  oracle  dba    80  4:03:18 
  15:55:22 Total: 780 - end of semaphore information 
  - physical memory $ 
  /usr/sbin/prtconf | grep -i mem Memory size: 4096 
  Megabytes     memory (driver not 
  attached)     virtual-memory (driver 
  not attached) $ ipcs -pmb IPC 
  status from  as of Tue May 22 13:15:58 PDT 2001 
  T 
  ID  KEY    
  MODE    OWNER    
  GROUP  SEGSZ  CPID  LPID 
  Shared Memory: m  0   
  0x505b --rw-r--r-- root 
  root  4   
  417   417 m   4201   0x9167ce10 
  --rw-r-   oracle  dba   
  58998784 26660  7608 m    802   0x63973b5c 
  --rw-r-   oracle  
  dba    5824512 16908  5642 m   1403   0xc7294a0c 
  --rw-rw   oracle  dba   
  18743296  7115  7584 m    604   0x826b2278 
  --rw-r-   oracle  dba   
  93601792 27580  7251 m   1005   0x59b783a4 
  --rw-r-   oracle  dba  
  146014208  1066  7579 m   1807   0xc6e2a74  
  --rw-r-   oracle  
  dba    4268032 13480  4674 m   2809   0x27a21464 
  --rw-r-   oracle  dba  
  325394432 26885 17005 - end of 
  physical memory information 
  - swap space $ 
  /usr/sbin/swap -s total: 910872k bytes allocated + 
  2232248k reserved = 3143120k used, 4208264k available - end of swap space information

RE: Sun Solaris 8 - Listener failed to start a dedicated server p

2001-05-22 Thread Narender Akula 
Title: RE: Sun Solaris 8 - Listener failed to start a dedicated server p



hi  jacques,
I have 
a similar issue quite some time back., when everything was fine at oracle level. Try 
finding problem at unix level. like memory being less, heavy swapping. 
In my case, it turned out to be unix memory problem. A reboot of unix 
box solved it. 
 
here 
are some of options to check..
 
Here are some options for an intermittent 
TNS-12500: Intermittent TNS-12500 errors are caused by a lack of 
resources on the server. Finding which resource is depleted may be 
difficult. 1. The TNS-12500 can be a result of the 'processes' 
parameter in the init.ora file being too low. 2. If the 
init.ora 'processes' parameter seems ok then you may need to increase the 
Unix kernel parameters for the maximum number of processes or users (for 
example, nproc or maxuprc). Check the manuals for the Unix operating 
system for more information on these parameters. 3. Check that 
you have adequate swap space. 4. Disable OTRACE. OTRACE is a tracing 
feature that can cause many problems. OTRACE is enabled by default. To 
disable OTRACE: a. Stop the Oracle database. b. Go to the 
$ORACLE_HOME/otrace/admin directory. c. Delete all files with a '.dat' 
extension. d. Restart the Oracle database. 
Oracle 
support recommenda this...5. Use the Multi-Threaded Server (MTS) 
option. MTS will fix the problem since the listener does not spawn dedicated 
server processes in this environment. MTS also cuts down on the amount 
of resources being utilized by having connections threaded through 
dispatchers and by having shared server processes read dispatcher requests 
from queues. To invoke MTS: a. Stop the database b. Modify the 
init.ora file to include these parameters: 
mts_dispatchers="," mts_max_dispatchers= 
mts_servers= 
mts_max_servers= mts_service= mts_listener_address= An 
example of a working MTS configuration would be: mts_dispatchers="tcp,3" 
mts_max_dispatchers=10 mts_servers=2 mts_max_servers=4 
mts_service=ORCL mts_listener_address= 
"(address=(protocol=tcp)(host=mars1)(port=1521))" Please note for 
Oracle 8i the MTS configuration would be: mts_dispatchers = 
"(protocol=tcp)(dis=2)" mts_max_dispatchers = 4 mts_servers = 4 
mts_max_servers = 6 local_listener = "(ADDRESS_LIST = 
(ADDRESS=(PROTOCOL=TCP)(HOST=mars1)(PORT=1521)))" c. Restart the 
database. 
if 
above options donot work

check 
following things...
Use the "truss" command to trace the system calls when you get the 
ORA-12500. Example: truss -f -o error.log sqlplus 
do you 
have any 32 bit versions and 64 bit database on the same box... 

 
 
rg
naren

  -Original Message-From: eric harrington 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 23, 2001 11:05 
  AMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Sun Solaris 8 - Listener failed to start a dedicated server 
  p
  Jacques,
   
  I've seen a similar 
  error with processes and Solaris memory structures.  Someone mentioned 
  increasing SEMMNS, this helped in my situation, however you can try decreasing 
  the PROCESSES parameter temporarily (as low as possible) to test whether the 
  Solaris memory setup is an issue.  There is a formula for sizing SEMMNS, 
  cannot currently find it.
   
  Good 
  luck!
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]On Behalf Of Jacques 
KilchoerSent: Tuesday, May 22, 2001 5:26 PMTo: 
Multiple recipients of list ORACLE-LSubject: RE: Sun Solaris 8 - 
Listener failed to start a dedicated server p
Thank you for the suggestions so far. Rocky Welch suggesting increasing the "processes" parameter in the 
init.ora I tried that with one of the 8.1.6 
databases. The "processes" parameter was set to 50, 
I increased it to 200, shut down that database, restarted the listener 
(lsnrctl>stop and lsnrctl>start) and restarted the database. I still 
got "ORA-12500: TNS:listener failed to start a dedicated server process" 
when trying to connect to that database from the client.
John Kangaraj has suggested checking the number of 
semaphores. I forgot to mention before that I had already looked at that 
also (I've been bitten by semaphores before.) I counted 780 semaphores being 
used (from ipcs) and 1024 being the maximum allowed (from /etc/system). (see 
below)
I'm still new to Sun Solaris and I'm totally stumped. Does 
anyone else have any other ideas? I really would prefer not running 
multi-threaded server (MTS) if I don't have to, which was one of the 
suggestions on Metalink.
Am I interpreting the available memory information 
correctly? (see below) For physical memory, I think I see 4GB available and 
622 MB being used. As far as swap, I see approx. 4GB available.
 semaphores In

RE: Sun Solaris 8 - Listener failed to start a dedicated server p

2001-05-22 Thread Hagedorn, Linda 
Title: RE: Sun Solaris 8 - Listener failed to start a dedicated server p



It 
could also be swap is filled.  If you see Solaris Error: 12 in the 
listener.log, there isn't enough space.  Do a df -k and look for a mount 
point that is 100% full.  It is likely to be /tmp (swap).  

 
Original 
Message-From: eric harrington 
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, May 22, 2001 4:05 
PMTo: Multiple recipients of list ORACLE-LSubject: RE: Sun 
Solaris 8 - Listener failed to start a dedicated server p

  Jacques,
   
  I've seen a similar 
  error with processes and Solaris memory structures.  Someone mentioned 
  increasing SEMMNS, this helped in my situation, however you can try decreasing 
  the PROCESSES parameter temporarily (as low as possible) to test whether the 
  Solaris memory setup is an issue.  There is a formula for sizing SEMMNS, 
  cannot currently find it.
   
  Good 
  luck!
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]On Behalf Of Jacques 
KilchoerSent: Tuesday, May 22, 2001 5:26 PMTo: 
Multiple recipients of list ORACLE-LSubject: RE: Sun Solaris 8 - 
Listener failed to start a dedicated server p
Thank you for the suggestions so far. Rocky Welch suggesting increasing the "processes" parameter in the 
init.ora I tried that with one of the 8.1.6 
databases. The "processes" parameter was set to 50, 
I increased it to 200, shut down that database, restarted the listener 
(lsnrctl>stop and lsnrctl>start) and restarted the database. I still 
got "ORA-12500: TNS:listener failed to start a dedicated server process" 
when trying to connect to that database from the client.
John Kangaraj has suggested checking the number of 
semaphores. I forgot to mention before that I had already looked at that 
also (I've been bitten by semaphores before.) I counted 780 semaphores being 
used (from ipcs) and 1024 being the maximum allowed (from /etc/system). (see 
below)
I'm still new to Sun Solaris and I'm totally stumped. Does 
anyone else have any other ideas? I really would prefer not running 
multi-threaded server (MTS) if I don't have to, which was one of the 
suggestions on Metalink.
Am I interpreting the available memory information 
correctly? (see below) For physical memory, I think I see 4GB available and 
622 MB being used. As far as swap, I see approx. 4GB available.
 semaphores In 
/etc/system I see this: set 
semsys:seminfo_semmns=1024 
ipcs shows me this: 
$ ipcs -sa IPC status from 
 as of Tue May 22 12:46:49 PDT 2001 T 
ID  
KEY    
MODE    OWNER    
GROUP  CREATOR   CGROUP NSEMS   
OTIME    CTIME Semaphores: 
s    5505024   0x6f61806  
--ra-r-   oracle  dba   
oracle  dba   204 12:46:49 
13:02:49 s 
262145   0  
--ra-r-   oracle  dba   
oracle  dba    50 17:52:20 
10:46:15 s    1703938   
0x2f18d66  --ra-ra   oracle  
dba   oracle  dba    
59 12:42:31 14:12:02 s 
983043   0xc934c46  --ra-r-   
oracle  dba   
oracle  dba    54  1:25:44 
13:03:40 s 
524292   0x81a8556  --ra-r-   
oracle  dba   
oracle  dba    79 12:46:34 
13:06:43 s    2424837   
0x40b7ad6  --ra-r-   oracle  
dba   oracle  dba   
204  1:29:56 13:07:46 s 
589830   0  
--ra-r-   oracle  dba   
oracle  dba    50 12:06:06 
19:22:22 s    1048584   
0  
--ra-r-   oracle  dba   
oracle  dba    80  4:03:18 
15:55:22 Total: 780 - end of semaphore information 
- physical memory $ 
/usr/sbin/prtconf | grep -i mem Memory size: 4096 
Megabytes     memory (driver not 
attached)     virtual-memory (driver 
not attached) $ ipcs -pmb IPC status from  as of Tue May 22 13:15:58 PDT 
2001 T 
ID  
KEY    
MODE    OWNER    
GROUP  SEGSZ  CPID  LPID 
Shared Memory: m  0   
0x505b --rw-r--r-- root 
root  4   
417   417 m   4201   0x9167ce10 
--rw-r-   oracle  dba   
58998784 26660  7608 m    802   
0x63973b5c --rw-r-   oracle  
dba    5824512 16908  5642 m   1403   0xc7294a0c 
--rw-rw   oracle  dba   
18743296  7115  7584 m    604   
0x826b2278 --rw-r-   oracle  
dba   93601792 27580  7251 m   1005   0x59b783a4 
--rw-r-   oracle  dba  
146014208  1066  7579 m   1807   
0xc6e2a74  --rw-r-   oracle  
dba    4268032 13480  4674 m   2809   0x27a21464 
--rw-r-   oracle  dba  
325394432 26885 17005 - end of 
physical memory informatio

RE: Sun Solaris 8 - Listener failed to start a dedicated server p

2001-05-22 Thread John Kanagaraj 

Hi Jacques,
 
One more thing to check - the max number of processes across the entire
system as well as the max. no of processes per user. I am not sure about the
names, but you get the drift, right? You may be bumping the ceiling on
either of these values...
 
 
John Kanagaraj
 

-Original Message-
Sent: Tuesday, May 22, 2001 2:26 PM
To: Multiple recipients of list ORACLE-L



Thank you for the suggestions so far. 
Rocky Welch suggesting increasing the "processes" parameter in the init.ora 
I tried that with one of the 8.1.6 databases. 
The "processes" parameter was set to 50, I increased it to 200, shut down
that database, restarted the listener (lsnrctl>stop and lsnrctl>start) and
restarted the database. I still got "ORA-12500: TNS:listener failed to start
a dedicated server process" when trying to connect to that database from the
client.

John Kangaraj has suggested checking the number of semaphores. I forgot to
mention before that I had already looked at that also (I've been bitten by
semaphores before.) I counted 780 semaphores being used (from ipcs) and 1024
being the maximum allowed (from /etc/system). (see below)

I'm still new to Sun Solaris and I'm totally stumped. Does anyone else have
any other ideas? I really would prefer not running multi-threaded server
(MTS) if I don't have to, which was one of the suggestions on Metalink.

Am I interpreting the available memory information correctly? (see below)
For physical memory, I think I see 4GB available and 622 MB being used. As
far as swap, I see approx. 4GB available.

 semaphores 
In /etc/system I see this: 
set semsys:seminfo_semmns=1024 

ipcs shows me this: 

$ ipcs -sa 
IPC status from  as of Tue May 22 12:46:49 PDT 2001 
T ID  KEYMODEOWNERGROUP  CREATOR   CGROUP
NSEMS   OTIMECTIME 
Semaphores: 
s5505024   0x6f61806  --ra-r-   oracle  dba   oracle  dba
204 12:46:49 13:02:49 
s 262145   0  --ra-r-   oracle  dba   oracle  dba
50 17:52:20 10:46:15 
s1703938   0x2f18d66  --ra-ra   oracle  dba   oracle  dba
59 12:42:31 14:12:02 
s 983043   0xc934c46  --ra-r-   oracle  dba   oracle  dba
54  1:25:44 13:03:40 
s 524292   0x81a8556  --ra-r-   oracle  dba   oracle  dba
79 12:46:34 13:06:43 
s2424837   0x40b7ad6  --ra-r-   oracle  dba   oracle  dba
204  1:29:56 13:07:46 
s 589830   0  --ra-r-   oracle  dba   oracle  dba
50 12:06:06 19:22:22 
s1048584   0  --ra-r-   oracle  dba   oracle  dba
80  4:03:18 15:55:22 
Total: 780 
- end of semaphore information 


- physical memory 
$ /usr/sbin/prtconf | grep -i mem 
Memory size: 4096 Megabytes 
memory (driver not attached) 
virtual-memory (driver not attached) 
$ ipcs -pmb 
IPC status from  as of Tue May 22 13:15:58 PDT 2001 
T ID  KEYMODEOWNERGROUP  SEGSZ  CPID
LPID 
Shared Memory: 
m  0   0x505b --rw-r--r-- root root  4   417
417 
m   4201   0x9167ce10 --rw-r-   oracle  dba   58998784 26660
7608 
m802   0x63973b5c --rw-r-   oracle  dba5824512 16908
5642 
m   1403   0xc7294a0c --rw-rw   oracle  dba   18743296  7115
7584 
m604   0x826b2278 --rw-r-   oracle  dba   93601792 27580
7251 
m   1005   0x59b783a4 --rw-r-   oracle  dba  146014208  1066
7579 
m   1807   0xc6e2a74  --rw-r-   oracle  dba4268032 13480
4674 
m   2809   0x27a21464 --rw-r-   oracle  dba  325394432 26885
17005 
- end of physical memory information 

- swap space 
$ /usr/sbin/swap -s 
total: 910872k bytes allocated + 2232248k reserved = 3143120k used, 4208264k
available 
- end of swap space information 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Kanagaraj
  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: Sun Solaris 8 - Listener failed to start a dedicated server p

2001-05-22 Thread Shahid Nasir 

Everytime I have faced this problem, first thing I look at is the
listener.log file. If the size of this file is large, I just delete and
restart the listener and everything works fine. Maybe you should have a look
at this.
Shahid Nasir 
Database Officer 
MERCATOR 
A member of the Emirates Group.


-Original Message-
Sent: Wednesday, May 23, 2001 4:11 AM
To: Multiple recipients of list ORACLE-L



It could also be swap is filled.  If you see Solaris Error: 12 in the
listener.log, there isn't enough space.  Do a df -k and look for a mount
point that is 100% full.  It is likely to be /tmp (swap).  
 
Original Message-
Sent: Tuesday, May 22, 2001 4:05 PM
To: Multiple recipients of list ORACLE-L


Jacques,
 
I've seen a similar error with processes and Solaris memory structures.
Someone mentioned increasing SEMMNS, this helped in my situation, however
you can try decreasing the PROCESSES parameter temporarily (as low as
possible) to test whether the Solaris memory setup is an issue.  There is a
formula for sizing SEMMNS, cannot currently find it.
 
Good luck!

-Original Message-
Kilchoer
Sent: Tuesday, May 22, 2001 5:26 PM
To: Multiple recipients of list ORACLE-L



Thank you for the suggestions so far. 
Rocky Welch suggesting increasing the "processes" parameter in the init.ora 
I tried that with one of the 8.1.6 databases. 
The "processes" parameter was set to 50, I increased it to 200, shut down
that database, restarted the listener (lsnrctl>stop and lsnrctl>start) and
restarted the database. I still got "ORA-12500: TNS:listener failed to start
a dedicated server process" when trying to connect to that database from the
client.

John Kangaraj has suggested checking the number of semaphores. I forgot to
mention before that I had already looked at that also (I've been bitten by
semaphores before.) I counted 780 semaphores being used (from ipcs) and 1024
being the maximum allowed (from /etc/system). (see below)

I'm still new to Sun Solaris and I'm totally stumped. Does anyone else have
any other ideas? I really would prefer not running multi-threaded server
(MTS) if I don't have to, which was one of the suggestions on Metalink.

Am I interpreting the available memory information correctly? (see below)
For physical memory, I think I see 4GB available and 622 MB being used. As
far as swap, I see approx. 4GB available.

 semaphores 
In /etc/system I see this: 
set semsys:seminfo_semmns=1024 

ipcs shows me this: 

$ ipcs -sa 
IPC status from  as of Tue May 22 12:46:49 PDT 2001 
T ID  KEYMODEOWNERGROUP  CREATOR   CGROUP
NSEMS   OTIMECTIME 
Semaphores: 
s5505024   0x6f61806  --ra-r-   oracle  dba   oracle  dba
204 12:46:49 13:02:49 
s 262145   0  --ra-r-   oracle  dba   oracle  dba
50 17:52:20 10:46:15 
s1703938   0x2f18d66  --ra-ra   oracle  dba   oracle  dba
59 12:42:31 14:12:02 
s 983043   0xc934c46  --ra-r-   oracle  dba   oracle  dba
54  1:25:44 13:03:40 
s 524292   0x81a8556  --ra-r-   oracle  dba   oracle  dba
79 12:46:34 13:06:43 
s2424837   0x40b7ad6  --ra-r-   oracle  dba   oracle  dba
204  1:29:56 13:07:46 
s 589830   0  --ra-r-   oracle  dba   oracle  dba
50 12:06:06 19:22:22 
s1048584   0  --ra-r-   oracle  dba   oracle  dba
80  4:03:18 15:55:22 
Total: 780 
- end of semaphore information 


- physical memory 
$ /usr/sbin/prtconf | grep -i mem 
Memory size: 4096 Megabytes 
memory (driver not attached) 
virtual-memory (driver not attached) 
$ ipcs -pmb 
IPC status from  as of Tue May 22 13:15:58 PDT 2001 
T ID  KEYMODEOWNERGROUP  SEGSZ  CPID
LPID 
Shared Memory: 
m  0   0x505b --rw-r--r-- root root  4   417
417 
m   4201   0x9167ce10 --rw-r-   oracle  dba   58998784 26660
7608 
m802   0x63973b5c --rw-r-   oracle  dba5824512 16908
5642 
m   1403   0xc7294a0c --rw-rw   oracle  dba   18743296  7115
7584 
m604   0x826b2278 --rw-r-   oracle  dba   93601792 27580
7251 
m   1005   0x59b783a4 --rw-r-   oracle  dba  146014208  1066
7579 
m   1807   0xc6e2a74  --rw-r-   oracle  dba4268032 13480
4674 
m   2809   0x27a21464 --rw-r-   oracle  dba  325394432 26885
17005 
- end of physical memory information 

- swap space 
$ /usr/sbin/swap -s 
total: 910872k bytes allocated + 2232248k reserved = 3143120k used, 4208264k
available 
- end of swap space information 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Shahid Nasir
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
---

RE: Sun Solaris 8 - Listener failed to start a dedicated server p

2001-05-23 Thread Jyoti N 

Hi ,
Your problem is actually highlighted on the error message "Solaris Error: 12: Not enough space"
It is more of an Operating system resource issue. I gather that you are running about 8 instances on this machine ,right? 
Shutdown couple of unused or low priority instances and see whether you can connect.
If it does not happen, try rebooting the unix box and do a clean start . 
HTH,
Click to add Jyoti R's LiveCard to your address book. 
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jyoti N
  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: Sun Solaris 8 - Listener failed to start a dedicated server p

2001-05-23 Thread Jacques Kilchoer 
Title: RE: Sun Solaris 8 - Listener failed to start a dedicated server p





Thank you everybody for your suggestions. To recap, I had the following suggestions:
- purge listener.log (Shahid Nasir)
- check max number of processes vs. max number of processes per user (John Kanagaraj)
- swap space being filled (Hagedorn, Linda)
- Use the "truss" command to trace the system calls when you get the ORA-12500. Example: truss -f -o error.log sqlplus (Narender Akula)

- increasing number of semaphores (eric harrington)


Narender Akula had also asked if we have Oracle 32-bit and Oracle 64-bit versions both running on the same server. Yes we do.

I tried all of the above except using truss. I will experiment with that later. What I did for now to fix the problem: I made the SGA smaller on several of the test databases and the problem went away (it looks like some of the init files were copied over from a production system with no changes. No, I didn't do it, so don't start throwing tomatoes at me.) I'm still not sure why this fixed the problem since ipcs -pmb showed a total of approx. 800MB being used and the machine has 4GB of physical memory. Any further comments are appreciated (except, of course, comments of the type 'Jacques, you're an idiot, don't you know anything about UNIX?')

--
Jacques R. Kilchoer
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.com

RE: Sun Solaris 8 - Listener failed to start a dedicated server p

2001-05-23 Thread Jacques Kilchoer 
Title: RE: Sun Solaris 8 - Listener failed to start a dedicated server p





>-Original Message-
>From: Jyoti N [mailto:[EMAIL PROTECTED]]
>
>Your problem is actually highlighted on the error message "Solaris Error: 12: Not enough space"
>It is more of an Operating system resource issue.


Yes, but which one?! Is it lack of physical memory?


>I gather that you are running about 8 instances on this machine ,right?


After having made a few of the SGAs smaller, I went back to 12 instances. :)


How can I tell if I am running out of physical memory? Any of the statistics I looked at seemed to indicate that there was plenty of memory available.

P.S. When I try to run sar I get the following message:
$ sar 
sar: can't open /var/adm/sa/sa23
No such file or directory


I do see a /var/adm/sa/sa16 directory. What does this mean?

RE: Sun Solaris 8 - Listener failed to start a dedicated server p

2001-05-23 Thread Nihar 
Title: RE: Sun Solaris 8 - Listener failed to start a dedicated server p



i 
think you should check large pool size parameter in your init.ora file. You can 
actullay reduce the size and restart the instance.
 
 
-Nihar

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Jacques KilchoerSent: 
  Thursday, May 24, 2001 12:51 AMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Sun Solaris 8 - Listener failed to start a 
  dedicated server p
  >-Original Message- >From: Jyoti N [mailto:[EMAIL PROTECTED]] 
  > >Your problem is actually 
  highlighted on the error message "Solaris Error: 12: Not enough space" 
  >It is more of an Operating system resource issue. 
  
  Yes, but which one?! Is it lack of physical memory? 

  >I gather that you are running about 8 instances on this 
  machine ,right? 
  After having made a few of the SGAs smaller, I went back to 12 
  instances. :) 
  How can I tell if I am running out of physical memory? Any of 
  the statistics I looked at seemed to indicate that there was plenty of memory 
  available.
  P.S. When I try to run sar I get the following message: 
  $ sar sar: can't open 
  /var/adm/sa/sa23 No such file or directory 
  I do see a /var/adm/sa/sa16 directory. What does this 
  mean?

RE: Sun Solaris 8 - Listener failed to start a dedicated server p

2001-05-23 Thread John Kanagaraj 

$ sar 
sar: can't open /var/adm/sa/sa23 
No such file or directory 

I do see a /var/adm/sa/sa16 directory. What does this mean?   

Jacques,

This is the file (not directory?!) that records the system activity
information (in binary) via the sadc program. The file is named by
day-of-the-month (it is 23rd today). You don't seem to have access to this
file - not sure why since you normally should Or maybe you ran out of
space in the '/var' filesystem?

>From your answer re the solution - i.e. reduction of SGA - it looks like a
combination of values in SHM and SEM parameters did create the problem...
Another issue that occurs in my mind is that some filesystem - either
$ORACLE_HOME or $TNS_ADMIN or whereever sqlnet logs are kept became full..

John Kanagaraj

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Kanagaraj
  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).