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
Printable View
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.
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.
#
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))"
#
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