> Do you mean with starting the database? Not at all. The db will register
> when the listener comes up.
But it might take time to register. Was the interval 3 minutes?
You can use alter system register to force a database to register itself
with listeners configured in init.ora (local_ & remote
Peter,
Do you mean with starting the database? Not at all. The db will register
when the listener comes up.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Monday, November 17, 2003 4:04 PM
To: Multiple recipients of list ORACLE-L
If you remove the database dec
If you remove the database declarations from your listener.ora file
does it cause a problem if the listener is not running when
the database comes up?
Thanks,
Peter Schauss
-Original Message-
Sent: Monday, November 17, 2003 2:55 PM
To: Multiple recipients of list ORACLE-L
Peter,
If you
Thanks for all of the suggestions. I took a look at my init.ora
file and discovered that I had the services and db_domain
entries disagreed with the database global_name value and. I fixed
those entries, bounced the database and the connections started coming
in on the shared server.
Peter Schau
Peter,
If you declare in the init.ora file where the listener is running, then the
database automatically connects to the listener. This is the second tawk
entry in your lsnrctl status listing.
If you declare the database in the listener.ora file, then the listener goes
looking for the database,
When I do "lsnrctl services", I get two entries for each instance.
For example:
tawk has 1 service handler(s)
DEDICATED SERVER established:33 refused:0
LOCAL SERVER
tawk has 2 service handler(s)
DEDICATED SERVER established:0 refused:0
LOCAL SERVER
DIS
You have to make sure the dispatchers are registered with the
listener. Use "lsnrctl services" to make sure. The error you gave
shows that they are not registered.
If your listener is not on 1521, then the dispatchers won't know how
to find it to register. You'll have to add the listener= atttr
Peter:
8.1.7 is pretty picky about syntax.
Here's what I have in my 8.1.7.4 database. (It's
Solaris, but I believe the parameter is the same)
MTS_DISPATCHERS="(address=(PROTOCOL=TCP)(HOST=atex-ent-prd1))(disp=2)"
mts_servers = 20
Good luck!
Barb
--- "Schauss, Peter" <[EMAIL PROTECTED]> wrote:
Oracle version 8.1.7
AIX 4.3.3
I am trying to configure mult-threaded server on one of my development
databases. In my init.ora file, I set
(mts_dispatchers="(address=(protocol=tcp))"
mts_servers=10
When I bring up the database, I can see the dispatcher and
servers. When I connect to the dat