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
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
$ 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
Title: Sun Solaris 8 - Listener failed to start a dedicated server process
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
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
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).
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
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
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
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
increased it to 200, shut down
that database, restarted the listener (lsnrctlstop and lsnrctlstart) 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
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
On system A I am running oracle 8.1.7 on Solaris 5.7. I have a listener.ora
file which specifies port 1521. I start the listener. After about 1 to 2
minutes the PMON process registers the second listener and things look like
this...
LSNRCTL services
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY
Hi!
How Do I create a second listener service on Windows NT/2000?
Any ideas anybody?
This is 8.1.6 on Win2k.
Thanks,
Helmut
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Helmut Daiminger
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051
Hi Helmut,
From memory, 3 stages as below:
1) setup the new listener correctly in your listener.ora file
suppose your first one is called listener and listens on port 1521
you might call the 2nd one l1526 and have it listen on port 1526
2) Use lsnrctl to start the second listener
---
Forms 6i Patch 4: Forms Listener Servlet for Deployment of Forms on the Internet
February 2001
Author: Regis Louis
Oracle Corporation
World Headquarters
500 Oracle Parkway
Redwood Shores, CA 94065
U.S.A.
Worldwide Inquiries:
Phone: +1.650.506.7000
Fax: +1.650.506.7200
www.oracle.com
Oracle
Hi all,
Something strange happened here this morning.
I created a standby database on our standby box this morning (Sun server OS
2.51 Oracle 7.3.4.5), all went well.
I check the status of the listener on the standby box, it was up (I don't
know why I even cared).
The production listener went
Nothing strange - you had wrong hostname in the listener.ora
Use localhost instead of DNS hostname in ADDRESS description in listener.ora
and you will never get situation like this. This implies that your listener
and database run on the same box.
Alex Hillman
-Original Message
Hello list,
Yesterday I had a problem with my computer, and I had to repair my
NT installation, and I lost all the data stored in the registers ( NT services).
As I dont have the services installed, I cant start/stop
them from NT services.
When I try to start the listener from the command
and other stuff wouldn't but I don't know what error you got.
Jim
[EMAIL PROTECTED] 03/12/01 06:46PM
Hi all:
Our listeners have evolved over time, whereby when we moved from 8.0 to 8.1, a new
listener was created to support this instead of having one listener listening to all
databases of different
Hi all:
Our listeners have evolved over time, whereby when we moved from 8.0 to 8.1, a new
listener was created to support this instead of having one listener listening to all
databases of different versions. We are trying to consolidate so that we only are
running one listener (8.1
- Production on 22-FEB-2001
08:53:03
(c) Copyright 1998 Oracle Corporation. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL
LSNRCTL services
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
TNS-01169: The listener has not recognized the passwo
run the script, and even read the script, but can't see the
password because he can only cat the script, not the password file.
Thank You Chuk Hamilton.
Rao
[EMAIL PROTECTED]
Hi DBAs,
I would like to find out whether a specific listener service is up or not
without running the command --- lsnr
I've just installed Oracle 8.1.7 on a Win 2K box and multiple 8.1.7 clients
on other NT computers. When I try to connect to the database through SQL
Plus I get an ora-12545 -CONNECT FAILED BECAUSE TARGET HOST OR OBJECT DOES
NOT EXISTS error.
Host string is DEVL2. The database server listener
-
De: Woody Mckay [SMTP:[EMAIL PROTECTED]]
Enviado el: jueves 22 de febrero de 2001 17:11
Para: Multiple recipients of list ORACLE-L
Asunto: ORA-12545 client with multiple listener service handlers
I've just installed Oracle 8.1.7 on a Win 2K box and multiple 8.1.7
clients
on other
Title: RE: How to find a listener service without running lsnrctl services
Mohan,
Thanks for
your suggestion.
Ps ef |
grep tns --à gives me only the LISTENER. I would like to know a specific service that is started
by a listener service or
alternately I would like to grep
Title: RE: How to find a listener service without running lsnrctl services
hmmmyou could do some grepping in the listener.log i
'spose..
-Original Message-From: Rao, Maheswara
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 21,
2001 8:06 AMTo: Multiple recipients
Hey Maheswar,
If unix user wants lsnrctl services you can write a shell script like this
read sid
lsnrctl EOF$HOME/lis(HOME is user's HOME directiory)
stat lis_a
EOF
grep $sid $HOME/lis 0/dev/null
if [ $? -eq 0 ]
then
echo "YOUR SERVICE IS UP"
fi
Write this shell script and write a
Why don't you want to use lsnrctl? Wouldn't this tell you if a listener
service is started?
$ lsnrctl stat | grep PRD
PRD1 has 1 service handler(s)
From: "Mohan, Ross" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTE
how about a script that simply does a connect dummy/user and issues a select
ping from dual;
This way, you are connecting to the database (through the listener) and you
even know the database is up..
Nothing fancy, no bells and whistles..
HTH
Mark
-Original Message-
Maheswara
Sent
Hi Djordje,
Thank you for the suggestion.
Doing grep for a specific service on an output produced by lsnrctl services,
yes, I could get the answer. However, I am trying to create a shell script
through which the user will find whether a specific listener service is up
or not. The problem is I
I believe what Rao meant was to do a 'PS' command and grep for the listener.
We found that for some reason this fails every once in a while. Instead, we
put a script in place that actually issues a select on V$Database. This way
we know the listener and database are up and we are able
Hi DBAs,
I would like to find out whether a specific listener service is up or not
without running the command --- lsnrctl services. Is there any way I can
do this through a shell script or unix command?
My environment : Solaris 2.7 : Oracle 8.0.4
Thanks for your help,
Rao
[EMAIL PROTECTED
Title: RE: How to find a listener service without running lsnrctl services
ps -ef | grep tns
-Original Message-
From: Rao, Maheswara [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 20, 2001 6:00 PM
To: Multiple recipients of list ORACLE-L
Subject: How to find a listener service
ORACLE-L |
|| |
|+---
--|
| |
| To: Multiple recipients of list|
| ORACLE-L [EMAIL PROTECTED]|
| cc: (bcc: William Dong/New York|
| Life Asset Management) |
| Subject: RE: automatic startup and |
| shutdown o
automatic startup and |
| shutdown of LISTENER |
--|
william,
I also dont want the user to interact, i want it to remain as a automated
startup and shut down process. At this time, even if I run it as,
su - oracle8 -c $O
. Remember
this is automatic startup or shutdown, you do'nt want to interact with the
scripts. Just try this:
su - USERID -c $ORACLE_HOME/bin/lsnrctl eof
start listener
exit
eof
I know this may not answer your question, but this is more reasonable.
Wi
Hello,
If I want to achieve the following in a shell script, how can I do that:-
I put the following in a shell:-
USERID=$1
PASSWD=$2
su - $USERID -c $ORACLE_HOME/bin/lsnrctl eof
start listener
Hi Van,
Looks like you have a space between the path and lsnrctl. That might be the problem.
HTH,
-Rocky
"Van M. Etheridge" [EMAIL PROTECTED] wrote:
I would like to be able tostartup and shutdown the listener when my SA shutsdown and brings the Unix box back up. What happens when my
37
Does anyone know if there is a way to tell Oracle to properly log TNS
listener failures on NT servers?
I know I can set the auditing level higher in listener.ora, but all I want
is for the listener to put an entry in Event Viewer when it fails. I don't
want my log files to grow exponentially.
I have
Repeat 2 times
80003060 80003064 80003064 [..0d..0d]
80003070 800D0D28 [...(] =20
ksllt ksimlgds_ [8000307C, 800030E4) =3D 0800 =
...
Dump of memory from 0x8000308C to 0x800030E4
80003080
Is somebody copied your listener.ora and tnsnames.ora on other system
for working with new database with same name and using these files without
changing DB/SIDname. It happened to us last week when one of our
group member did that on new box and old box listener/database went down.
Regards
and auto registration with Listener
Hi Kirti,
I have the same problem here on Aix 4.3..3 / RDBMS 8.1.7 :
restarting or reloading the listener, pmon gets stuck on socket
(close_wait status) and never register again the database.
But today i find a workaround simply putting INSTANCE_NAME parameter
Hello All,
While using the default port number and default listener name with Oracle
8.1.7, the automatic service registration takes place when the database is
started after starting the 8.1.7 Listener. But if the listener is bounced
then the 8.1.7 database does not auto register. However, other
301 - 344 of 344 matches
Mail list logo