oracle initializaion/shutdown in prress

[satishpc]

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

[Kishore]

Check in the alert log file and post the error message.

[satishpc]

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

[sreddy]

Check out your MTS configuration setup is RIGHT.

[satishpc]

how do i do it ? i am not an experienced dba. can u please guide me ?thank u

satish

[sreddy]

Could you post your listener.ora/tnsnames.ora and mts_ parameters in your init.ora for the database thats giving problem for you...

[satishpc]

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

[sreddy]

Thats doing trick, someone configured to MTS and didn't cleanup properly. Comment it and bounce it. It should be fine.

[sreddy]

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>

[pando]

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