RE: Oracle connection/listener/dispatcher stops allowing connecti

Lyndon - Sorry to hear of your problems. Never a good time for this, but especially right before the holidays. I have been working with Oracle for over 10 years at a number of sites and have only encountered a handful of corrupted blocks. Oracle strives hard to maintain a reputation of protecting

Instances cannot be together LISTENER PROBLEM??

Hi, I have a Win2000 Server with a 8.1.7. ora database with an instance called XXX, after that I've created a new one, called YYY. I open both databases without problems but 45 min then both instances are down. I open the X instance, then the Y instance, checked the status of the listener

Solaris 2.7/8.1.6.3/Listener

Hi Everyone: I currently have two instances on a machine. Since one is used little if at all, I want to roll the active schema into the other instance, which is used more. Is there a way that I can fool the listener so that when a connection request comes in for the DB I want to shut down

Re: Unix script to stop pwd-protected listener

Hi, we have lsnrctl with 750 and listener.ora with 600 permissions and everything runs fine. For job stopping process you can then use the encrypted password wirtten in listener.ora. HTH, Mike [EMAIL PROTECTED] wrote: Hi, Solaris 8, Oracle 9i listener It seems that anyone who

RE: Listener Problem

Unfortunately, our company is large enough that no one ever really has to admit to anything because it is simply too difficult to run down the perpetrators. The listener did start. Some users could connect to the databases from one server but not another. We think it was related

Unix script to stop pwd-protected listener

Hi, Solaris 8, Oracle 9i listener It seems that anyone who has a login on Solaris can shut the listener down. I have tried with a non-dba userid and could stop the listener. The default file permission for ORACLE_HOME/bin/lsnrctl is 751, and for ORACLE_HOME/network/admin/listener.ora file

how to change listener port ?

guys, i have a db CLONEDB , cloned from another DB. i have did it successfully and things work fine. the listener listens on default port 1521. now i would like to change this to some other port number , say 2521. the environment is oracle 8.1.6/win2k. how do i do it ? can someone explain me

Re: how to change listener port ?

it successfully and things work fine. the listener listens on default port 1521. now i would like to change this to some other port number , say 2521. the environment is oracle 8.1.6/win2k. how do i do it ? can someone explain me the steps involved ? TIA. -- Please see the official

RE: how to change listener port ?

oraora Yes, in the listener.ora file, in the section: LISTENER = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (Host = 999.999.999.999) (Port = 2521) You don't want to accidentally select a port that something else on your network is using

Listener Problem

Yesterday we had a cpu panic followed by a spontaneous reboot of a Sun E6000 server. When the server and databases came back on line we were getting 'no listener' errors from several Unix servers but not all of them. We also lost connectivity between the mainframe and the databases

Re: Listener Problem

'no listener' errors from several Unix servers but not all of them. We also lost connectivity between the mainframe and the databases on the affected server. Those that failed were consistent, those that conected were also consistent. The Unix Admin captured the following lines from a netsta

RE: Listener Problem

As luck would have it, we just went through a similar problem. Does the listener actually startup? Can you stop and restart it manually using lsnrctl? Ours wouldn't. We tracked it down to two problems, both security related. The one that was hampering our listener was a change in /etc

RE: Listener Problem

, October 09, 2002 3:34 PM To: Multiple recipients of list ORACLE-L Subject: Re: Listener Problem Magically, it's fixed. No one has 'fessed up' but it is definietly not an Oracle problem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL

Re: Unix script to stop password-protected listener

Hi Michal, It's a security breach and bug #2366907 has been opened for that. So protect carefully your listener.ora file from non privileged readers. Regards At 01:53 08/10/2002 -0800, you wrote: Yes, you can change your listener.ora file permission up to 600 on the server side. In a shell

Re: Unix script to stop password-protected listener

to be given read access to all and also the tnsnames.ora file (If you have not gone for nameserver) . Regards Rajendra -Original Message- Sent: Tuesday, October 08, 2002 11:13 AM To: Multiple recipients of list ORACLE-L Hi, Solaris 8, Oracle 9i listener It seems that anyone

Unix shell script to stop a password-protected listener

Hi, Solaris 8, Oracle 9i listener It seems that anyone who has a login on Solaris can shut the listener down. I have tried with a non-dba userid and could stop the listener. The default file permission for ORACLE_HOME/bin/lsnrctl is 751, and for ORACLE_HOME/network/admin/listener.ora file

Unix script to stop password-protected listener

Hi, Solaris 8, Oracle 9i listener It seems that anyone who has a login on Solaris can shut the listener down. I have tried with a non-dba userid and could stop the listener. The default file permission for ORACLE_HOME/bin/lsnrctl is 751, and for ORACLE_HOME/network/admin/listener.ora file

RE: Unix script to stop password-protected listener

To: Multiple recipients of list ORACLE-L Hi, Solaris 8, Oracle 9i listener It seems that anyone who has a login on Solaris can shut the listener down. I have tried with a non-dba userid and could stop the listener. The default file permission for ORACLE_HOME/bin/lsnrctl is 751

Re: listener problem ???

Do you have a service like Oracle_HOMETNSListener? I assume that you must. You don't need a separate listener for each instance. What does the TNSNames.ora entry for LMANAGER look like

listener problem ???

Hi all, I have a database LMANAGER (817 on win2000), it's on my local machine. I can log into it using svrmgrl. But when I connect using sqlplus, I got ORA-12541: TNS:no listener. LMANAGER is already in listener.ora file, and lsnrctl status shows LMANAGER is there: (c) Copyright 1998 Oracle

Re: Listener load balance

: Tuesday, September 17, 2002 10:19 PM Subject: Re: Listener load balance Tks Kevin, I didn't setup the DNS to do that. I ping myserver and is using the new address. Don't know how to do it either. What I am planning to do is to setthe manually the ip address to the both port

Re: Listener load balance

TKS Yechiel for your help, Two more questions. Is there any way I can find out which one of the 2 addresses I am using ? Which isbetter solution this method or add another listener ? Tks for your help TIA Ramon - Original Message - From: Yechiel Adar To: Multiple

RE: Listener load balance

I did not know about the LOAD_BALANCE=ON . Thanks. -Original Message-From: Ramon E. Estevez [mailto:[EMAIL PROTECTED]]Sent: Wednesday, September 18, 2002 10:33 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Listener load balance TKS Yechiel for your help, Two

Re: Listener load balance

I do not know if you can know which connection the user use. However, these changes apply only to the initial connection. After the user connect he gets a new port number that connect directly to his thread, so I would not worry about the load on the listener. You can use a different

RE: Listener load balance

]]Sent: Wednesday, September 18, 2002 5:09 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Listener load balance Hello Ramon I think that you have an error in your parameters. As far as I know (not much) the second network card have a different TCP/IP address. You have

RE: Listener load balance

LOAD_BALANCE=ON in TNS descriptor means that the client will try to randomly connect to any of the dress descriptions in the descriptor, thus evenly spreading the load. On the other hand, you can have a listener based balancing, which is facilitated through the "local_listener"

Re: Listener load balance

: Listener load balance I do not know if you can know which connection the user use. However, these changes apply only to the initial connection. After the user connect he gets a new port number that connect directly to his thread, so I would not worry about the load

Listener load balance

Hi list, Scenario Win2000 server, 8.1.7. I added anetwork card to my DB Server. I want the listener to accept connections for the 2 IP address to make load balance. I just added a line to the listener file with a different port. How can I assure that the port 1521 is listening for the net

RE: Listener load balance

Your HOSTNAME of 'myserver' would tell you which. Since you have the same hostname on the listener, both ports would currently be using the same IP address. Did you setup DNS so that the cards share a Hostname ? -Original Message-From: Ramon E. Estevez [mailto:[EMAIL

Re: Listener load balance

= 1521)) ---Original (ADDRESS = (PROTOCOL = TCP)(HOST = 225.125.100.6)(PORT = 1526)) --- Added Ramon - Original Message - From: Kevin Lange To: Multiple recipients of list ORACLE-L Sent: Tuesday, September 17, 2002 12:03 PM Subject: RE: Listener load balance Your

Listener Configuration - Oracle 7.3.4.5.2 on Windows 2000

Title: Listener Configuration - Oracle 7.3.4.5.2 on Windows 2000 Hello Guru's, Any ideas? I have installed Oracle 7.3.4.5.2 (7.3.4.0.0 + patchset 7.3.4.5.2) workgroup onto Windows 2000. Everything appears to have gone well, except that the Listener Service was not created automatically

Re: Listener Configuration - Oracle 7.3.4.5.2 on Windows 2000

you didn't mention whether or not you know that oracle 7 isn't certified on win2k. On 25 Jul 2002 at 6:18, Denham Eva wrote: Any ideas? I have installed Oracle 7.3.4.5.2 (7.3.4.0.0 + patchset 7.3.4.5.2) workgroup onto Windows 2000. ... ---Forwarded---

Listener Log Aging Script

Could anyone share their Unix script to age the listener log file? I know that this has been posted to the group in the past, but I was unable to find it in the archives at FatCity. Thanks. Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET

RE: Listener Log Aging Script

the listener log file? I know that this has been posted to the group in the past, but I was unable to find it in the archives at FatCity. Thanks. Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858

Re: Listener Log Aging Script

I posted this answer once before. How about wrapping this is a script of your choice: ARCHIVE_LISTENER_FILENAME=listener`date +%Y%m%d%H%M`.log lsnrctl set log_file listener2.log mv listener.log $ARCHIVE_LISTENER_FILENAME mv listener2.log

RE: Listener Log Aging Script

Why is it necessary to null out the file? Does LSNR keep a open file handle open to it? -Original Message- From: Orr, Steve [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 12:25 PM To: Multiple recipients of list ORACLE-L Subject: RE: Listener Log Aging Script Make

Re: Listener Log Aging Script

PROTECTED]] Sent: Wednesday, July 24, 2002 12:25 PM To: Multiple recipients of list ORACLE-L Subject: RE: Listener Log Aging Script Make a copy of the file appended by the Julian date then empty the log via cat /dev/null listener.log. (You don't really need a cat.) -Original Message

RE: Listener Log Aging Script

It keeps the file handle to the inode not the filename so when you mv filea fileb the listener is still writing to the inode which now belongs to fileb so if you want to move it you need to do the set listener. On the other hand if you cp filea to fileb then the listener is stilled pointed

RE: Listener Log Aging Script

See John Carlson's answer. You could shut down the listener and delete or rename the file but why bother when you can just /dev/nulllistener.log -Original Message- Sent: Wednesday, July 24, 2002 10:44 AM To: Multiple recipients of list ORACLE-L Why is it necessary to null out the file

RE: listener configuration on HP serviceguard clusters

Title: RE: listener configuration on HP serviceguard clusters Do you have a listener.ora file? Which ip address is in it? Matt Adams - GE Appliances - [EMAIL PROTECTED]Enter any 11 digit prime number to continue. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL

Re: listener configuration on HP serviceguard clusters

Title: RE: listener configuration on HP serviceguard clusters Yes, I do. IP of the node on which listener is running. Like I sad, listener belongs to the none, not package. Alex. - Original Message - From: Adams, Matthew (GEA, MABG, 088130) To: Multiple recipients

listener configuration on HP serviceguard clusters

Title: listener configuration on HP serviceguard clusters If anybody out there is using HP ServiceGuard for non-OPS/RAC, I would be interested to know how you configure the listeners. Do you use the machine IP address or the package address in the listener.ora (or do you not have

RE: listener configuration on HP serviceguard clusters

Title: listener configuration on HP serviceguard clusters Matt, i hv 2 nodes in hp mc/sg non-ops config. each hving production instances. also each providing failover for other node. :( 7.3.4 on 10.2 each has it own listner listener_${ORACLE_SID} Node 1: listener: LISTENER_SID1 on 1555

Re: HTTP Listener configuration assistant

some sort of http configuration assistant after creating the database and running the Oracle Net Config Assistant. No matter. I got the HTTP listener going by editing the Apache config files. Fortunately, the files contain plenty of comments so I was able to figure out what settings to change

Re: HTTP Listener configuration assistant

in the install, and the only step that I still need to perform, was to execute a configuration assistant for Oracle9i's built-in HTTP listener. For the life of me, I can't figure out the executable name to invoke the HTTP configuration assistant. Can anyone enlighten me? Jonathan Gennick

HTTP Listener configuration assistant

I'm trying to recover from an install that bombed. The final step in the install, and the only step that I still need to perform, was to execute a configuration assistant for Oracle9i's built-in HTTP listener. For the life of me, I can't figure out the executable name to invoke the HTTP

Sqlplus hangs when using 8.1.7 db against 9.2 listener

Hello! Have you faced this kind of error: I am using win2000 and I have installed on that server both 8.1.7 and 9.2.0 oracle versions. Now I have listener92 up and running. I am able to connect mine 9.2 instances without problem (with sql*net) but when I am trying to connect 8.1.7 instance,

8.1.7 7.3.4 on one listener?

Hi All, Is anyone running versions 7.3.4 and 8.1.7 using the SQLNet8 listener? Haven't tried with 8.1.7 and I don't want to assume it works just like 8.1.6 . Been there, . No MTS Solaris 2.6 Also anyone running SUN T3 arrays? Advice? I'm starting to believe SAME is a cult New

Re: 8.1.7 7.3.4 on one listener?

in middle of crowd (pipes up): I'm not! - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, June 13, 2002 8:03 PM Hi All, Is anyone running versions 7.3.4 and 8.1.7 using the SQLNet8 listener? Haven't tried with 8.1.7 and I don't

RE: 8.1.7 7.3.4 on one listener?

Yes, we are ran 8.1.7.2 listener for 7.3.4, 8.1.6, 8.1.7, 8.1.7.2, databases on the same server. It was recently (3 days ago) upgraded to 8.1.7.4 listener when I upgraded my 8.1.7.2 database. The 7.3.4 database is still there. Although this is Dev server, the entire Development is done

RE: Install: 9i on 2000, TNS Listener service not installed

I have installed 9.0.1 many times on Win2K but with a CD and had no problem with the listener. Did you see any error messages during the installtion? Please check the install log. You could try to re-install Oracle with custom option. That would not hurt the database you have installed, except

RE: Install: 9i on 2000, TNS Listener service not installed

I've got 9.0.1 on my WinTuke WS SP2 box and the listener service installed correctly. Not that it helps you any, but I thought you should know that it worked for someone. GL! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech

RE: Install: 9i on 2000, TNS Listener service not installed

Thanks In my 9i Install, the tool to create the service was Net Manager and it was under Configuration and Management Tools. At 08:33 AM 6/10/2002 -0800, you wrote: I've got 9.0.1 on my WinTuke WS SP2 box and the listener service installed correctly. Not that it helps you any, but I thought

Install: 9i on 2000, TNS Listener service not installed

Starting to play around with 9i. Downloaded and installed on Windows 2000 Workstation. So far so good except no TNS Listener service lsnrctl start from the command line creates a listener. This may be a side effect of installing on Workstation instead of Server. Anyone have any insight? Anyone

Two Listener

I am running two listener on one server, How can I stop logging for specific listener, Itry to do this but dosn't work: set log_status listener2 off, also I have tried with set log_status listener2 0, but non of them are working. Any Idea? Hamid Alavi Office 818 737-0526 Cell818 402-1987

RE: Two Listener

listener on one server, How can I stop logging for specific listener, Itry to do this but dosn't work: set log_status listener2 off, also I have tried with set log_status listener2 0, but non of them are working. Any Idea? Hamid Alavi Office 818 737-0526 Cell818 402-1987

Re: how can listener list on two ports for the same db?

on the server (Unix based) . Listener.ora LISTENER = (ADDRESS_LIST = (ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY)) (ADDRESS= (PROTOCOL= TCP)(Host=your server ip address )(Port= 1526)) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME= hildb1.%domain_name

Re: how can listener list on two ports for the same db?

on the server (Unix based) . Listener.ora LISTENER = (ADDRESS_LIST = (ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY)) (ADDRESS= (PROTOCOL= TCP)(Host=your server ip address )(Port= 1526)) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME= hildb1.%domain_name

Re: how can listener list on two ports for the same db?

Title: how can listener list on two ports for the same db? Hello Helmut You need to configure the listener to listen on ONE host with 2 ports. The machine name is the same. You separate the connections via tnsnames.ora on the client side. I got a call today that one of our application

how can listener list on two ports for the same db?

Title: how can listener list on two ports for the same db? Hi! We have a db server (in a cluster) with two NICs and two IP-Adresses (i.e. logical names in the cluster). How do I configure the listener so that it listenes for both logical names of the machine? LISTCMDB

RE: how can listener list on two ports for the same db?

)(Host = host_name)(Port = 1555)) ) (CONNECT_DATA = (SID = db_name)) ) -Message d'origine- De: Daiminger, Helmut [mailto:[EMAIL PROTECTED]] Date: mercredi 29 mai 2002 11:28 À: Multiple recipients of list ORACLE-L Objet: how can listener list on two ports for the same db? Hi! We

Re: how can listener list on two ports for the same db?

= kfalcmdb)(Port= 1526)) ) STARTUP_WAIT_TIME_LSNR02 = 0 CONNECT_TIMEOUT_LSNR02 = 10 TRACE_LEVEL_LSNR02 = OFF Daiminger, Helmut wrote: Hi! We have a db server (in a cluster) with two NICs and two IP-Adresses (i.e. logical names in the cluster). How do I configure the listener so that it listenes

tns-12541 no listener while using connection manager

) ( RELAY_STATISTICS=yes ) ( SHOW_TNS_INFO=yes ) ( USE_ASYNC_CALL=yes ) ( AUTHENTICATION_LEVEL=0 ) ( REMOTE_ADMIN=FALSE ) )CMAN_ADMIN = (ADDRESS=(PROTOCOL=tcp)(HOST=oracle)(PORT=1650))CMANAGER_NAME = cman But i am getting the error 12541 no listener .Please help me in solving

Re: Connecting to Oracle without using Listener

You have to use listener merely to establish (!) a connection. However, it can be configured on other port. Note, that listener redirects (in general) your connection to another port (to server process or to dispatcher), so client uses another port to communicate with server. Alexandre

Connecting to Oracle without using Listener

if your real question is can I circumvent the listener, the answer is no. Keith Date: Thu, 16 May 2002 19:33:46 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Reply-to: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California Is it possible

Re: Connecting to Oracle without using Listener

You can connect directly to a dispatcher you have started on a different port. No listener required. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Fri, 17 May 2002, Keith Peterson wrote: if your real question is can I circumvent the listener, the answer is no. Keith Date

Connecting to Oracle without using Listener

Is it possible to connect to Oracle DB server using DBI/ODBC through TCP/IP with or without using Listener at port 1521? Thanks. ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

Re: Connecting to Oracle without using Listener

Hello ltiu, You can configure listener to use another port number if you want. Friday, May 17, 2002, 10:33:46 AM, you wrote: l Is it possible to connect to Oracle DB server using DBI/ODBC through TCP/IP l with or without using Listener at port 1521? l Thanks. l ltiu -- Best regards

Listener problem in Oracle 8.1.5 for RH 6.2

Hi All I have problem related to listener. On my machine I have Oracle 8.1.5 on RH 6.2. When I issued the command $ lsnrctl I got the following error message lsnrctl: error in loading shared libraries: libskgxp8.so: cannot open shared object file: No such file or directory I have downloaded

RE: Listener problem in Oracle 8.1.5 for RH 6.2

-printing characters. Try to find someone that knows more about Unix to look over your shoulder. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, May 10, 2002 2:48 AM To: Multiple recipients of list ORACLE-L Hi All I have problem related to listener

Listener question. What is PNPKEY?

The default listener.ora file contains an IPC listing with (KEY=PNPKEY). I've searched the documentation and can't find any description of what this is for. Thanks, Keith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Keith Moore INET: [EMAIL PROTECTED] Fat

ORA-12541: TNS:no listener

Do you know where I can get an answer to the following question: Why do I get the following error: ORA-12541: TNS:no listener on my win 2000 professional client when trying to connect using SQLPLUS lanier/lanier@cde mailto:lanier/lanier@cde ? 1. The client is a separate box from the server

RE: ORA-12541: TNS:no listener

Asuming your database is where the cleints tnsnames file has it, then it's a possibility the 1 Database isnt running on the server (go to server and lsnrctl status 2 The port is wrong in the tnsnames file Can you tnsping yourinstance ? If you cant chances you have incorrect syntax in the

trace external procedure listener

We have occasional problems with the external procedure listener... ORA-28575 unable to open RPC connection to external procedure agent. We are finding it very difficult to track down the source of these errors. Is there anyway to trace what the external procedure was trying to run when

RE: trace external procedure listener

John, Your error message doesn't seem to hint at a problem with what the external procedure was trying to run specifically, but in the 'call' to extproc. If I were you I'd try to put the listener in trace mode, as it looks like that's where the problem occurs. HTH. - Original Message

Rebuild Oracle Listener Service

My oracle listener service is not working on NT. Can someone send me a script to rebuild the listener service? Thanks! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

RE: Rebuild Oracle Listener Service

. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- L. Sent: Monday, April 01, 2002 10:49 AM To: Multiple recipients of list ORACLE-L My oracle listener service is not working on NT. Can someone send me a script to rebuild the listener service? Thanks

Re: Rebuild Oracle Listener Service

ORACLE-L @kmg.com[EMAIL PROTECTED] Sent by: rootcc: Subject: Rebuild Oracle Listener Service

Problem with standby database listener

Fellow dba's, We have come across a weird problem with a standby database. Every timewe issue "alter database mount standby database"on thestandby database, the primary database fails to connect through listener. It becomes OK after primary database is shutdown and restarted

RE: Problem with standby database listener

on the standby database, the primary database fails to connect through listener. It becomes OK after primary database is shutdown and restarted — of course this can is not an acceptable solution since the standby will be opened every week for reporting. Anyone experience this before? Any direction would

RE: Problem with standby database listener

Could it be that the standby is auto-registering itself with the listener for the production database? We've had a couple of incidents where a development DBA copied the init.ora file from a production database configured forMTS. But the listener parameters were not changed and all new

Web DB 2.5 listener always hung for Oracle HRMS applications V11.

Hi Gurus, We are running Oracle HRMS Applications 11I (V11.5.1) in two E450 sun servers. OS is Solaris 2.6 1st server contains the database, concurrent manager and report server. 2nd server contains the apache listener, TCF SERVER, Web DB 2.5 listener, Web DB 2.2 Listener and Form server

Re: Web DB 2.5 listener always hung for Oracle HRMS applications V11.

Catherine, Why don't you migrate from WebDB to Apache ?. There is excellent documentation on migrating from WebDB to Apache for 11i. Your WebDB listener could be hung if it is running in the wrong shell -- eg if you logout of the telnet session where the WebDB listener was started, you

RE: Web DB 2.5 listener always hung for Oracle HRMS applications

Hi Hemant, We use the at command to startup all our form server/report server/webdb listener etc so that even if we were to logout of the telnet session where the WebDB listener is started. The form server/report server/listener will not hung/died because the parent shell has died. Why don't

RE: Web DB 2.5 listener always hung for Oracle HRMS applications V11.

Catherine, You have the wrong note. Look up Note 119873.1 titled Apache Single Listener Configuration for Applications 11.5.1 I don't know how you are using the at command to startup the servers. I didn't suggest that the forms server and reports server die. I was talking of the WebDB

RE: Web DB 2.5 listener always hung for Oracle HRMS applications

Hi Hemant, Thanks for supplying the correct article number. I'll look into it. Even if my web 2.5 listener is up and running (see below), my users still cannot logon to the Oracle Applications. The listener just hung. # ps -ef | grep 8000 orahrms 4406 4404 0 07:25:03 ?0:03 wdblsnr

Oracle listener config.

all, does anyone know where I can find information on configuring Oracle to listen for requests on a UNIX server with multiple interfaces? looking to setup a failover if one network interface drops the other will carry the load... thank you in advance. Roy -- Author: Brian Haas INET:

Re: Oracle listener config.

Roy, with multiple interfaces you mean multiple network cards? or multiple protocols? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 29, 2002 1:40 PM all, does anyone know where I

RE: Oracle listener config.

multiple network cards -Original Message- Sent: Tuesday, January 29, 2002 11:36 AM To: Multiple recipients of list ORACLE-L Roy, with multiple interfaces you mean multiple network cards? or multiple protocols? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message -

Autostart of database and listener on Sun Solaris

Title: Autostart of database and listener on Sun Solaris Hi! Since I'm fairly new to Solaris, I have a rather basic question: how to I enable autostart of the database and the listener when the Solaris box is rebooted? This is 8.1.7 on Solaris 78. Thanks, Helmut

Re: Listener

I'm inclined to think that NO ONE can explain it in this medium better than the documentation. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 04, 2001 2:25 AM Hallo, Can anybody tell me simply how the listener works

Re: Listener

Oracle Networking Guide at http://technet.oracle.com [EMAIL PROTECTED] wrote: Hallo, Can anybody tell me simply how the listener works? Thanks in advance Roland S _ Do You Yahoo!? Get your free @yahoo.com address at http

RE: Listener

Bubba, Wow! That was a GREAT explanation! -Barbie -Original Message- Oracle Networking Guide at http://technet.oracle.com [EMAIL PROTECTED] wrote: Hallo, Can anybody tell me simply how the listener works? Thanks in advance Roland S -- Please see

Re: Listener

Flattery will get you everywhere... --Bubba Mohan, Ross wrote: Bubba, Wow! That was a GREAT explanation! -Barbie -Original Message- Oracle Networking Guide at http://technet.oracle.com [EMAIL PROTECTED] wrote: Hallo, Can anybody tell me simply how the listener

Listener

Hallo, Can anybody tell me simply how the listener works? Thanks in advance Roland S -- 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

LISTENER CONFIGURATION?

Hi How could configure multiple listener for diffrent database if we have single oracle home? Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ

Re: LISTENER CONFIGURATION?

Seema, It is explained in the manual. Please read it. Anjan Seema Singh wrote: Hi How could configure multiple listener for diffrent database if we have single oracle home? Thanks -Seema _ Get your FREE download of MSN

Re: LISTENER CONFIGURATION?

Seema, for this you basically define them in the listener.ora file and start each individually .. here is an e.g. LISTENER = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = yyy.zz.ea.com)(PORT = 1521)) ) LISTENER_REAL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST

Re: Listener problems

once clients are connected, you can shut down the listener... all that means is that no one else can connect once it is down. size of listener.log is OS dependent, it's just a file on disk. You can recreate it by shutting down the listener renaming or deleting the listener.log file starting

extenal procedure listener and firewall

We have just installed a firewall and are now getting lots of ORA-28575: unable to open RPC connection to external procedure agent errors, although the listener appears to be running. Anyone else had this problem? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

<    1   2   3   4   >