RMAN produces ORA-12519 Error

[hellsing]

I'm running RMAN against an Oracle9i database. I'm trying to do a backup and before starting I'm issuing the command:

STARTUP FORCE DBA;

When I issue this command I get the errors:

"failure of startup command, could not obtain a fully authorized session"

Follows by:

"Ora-12519 TNS: no appropriate service handler found"

Can anyoneplease urgently help.

Many Thanks

 

[KenCunningham]

Does lsnrctl services show tha instance as registered with the listener?

 

[hellsing]

It does show up but has a status of unknown. I checked a few sites out and they say that this is not a problem and its just because I'm using a SID_LIST in the listener.ora.

I've found a bit more out about this now in that if I reboot my server I can connect to the database through Enterprise Manager and RMAN. If I then issue this STARTUP FORCE DBA, I get the above error but when I then try to connect to the database again I get:


Recovery Manager: Release 9.2.0.1.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-12523: TNS:listener could not find instance appropriate for the client connection

Any ideas would be hugely appreciated.