-
hi,
my oracle used to take a lot of time to start. but now, it simply says oracle initializaion/shutdown in prress. what do i do. please help. it is urgent. thanks a lot
satish
-
Check in the alert log file and post the error message.
Thanks
Kishore Kumar
-
i checked the file in oracle\admin\finlap\bdump\alrt.log. it says
starting up 1 dispatcher(s) for network address
'(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
AND IT HAS BEEN IN THIS STATE FOR LAST HALF HOUR. WHAT DO I DO ?
SATISH
-
Check out your MTS configuration setup is RIGHT.
-
how do i do it ? i am not an experienced dba. can u please guide me ?thank u
satish
-
Could you post your listener.ora/tnsnames.ora and mts_ parameters in your init.ora for the database thats giving problem for you...
-
my init.ora contains only one parameter starting with mts and that is
mts_dispatchers = "(PROTOCOL=TCP)(PRE=ORACLE.AURORA.SERVER.SGIOPServer)"
my tnsnames.ora and listener.ora seem normal. can i comment the mts statement in my init.ora file ?
satish
-
Thats doing trick, someone configured to MTS and didn't cleanup properly. Comment it and bounce it. It should be fine.
-
Needs to have all the parameters not just the one you mentioned for MTS Configuration. I don't think they mentioned that parameter right. It shouls be as follows.
<font face=courier>
#
mts_dispatchers="tcp,3"
mts_max_dispatchers=10
mts_servers=2
mts_max_servers=5
mts_service=xyz
mts_listener_address="(ADDRESS=(PROTOCOL=tcp)(HOST=APPS)(PORT=1521))"
#
</font>
-
No one set up MTS, by default Oracle dbassistant sets up one dispatcher, gods knows why, even we created in dedicated server mode
Happens to me quite a few times already, always had to delete that line manually
I think it only does this in 8.1.6
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|