Iam able to successfully login to my oracle database through SQLPLUS, and able to shut it down safely.
but the problem arises when i give the start up command.
"ORA-12514: TNS:listener does not currently know of service requested in connect
Then when i restart my oracle service (tried to restart only the listerner service alone,but still no use), am able to login to my database.so this forces my databses to be in mount state only.I cant make it no mount or restricted state.
Wondering whats wrong....!