Listener part resolved
I logged a Metalink issue, followed the instructions reference in the article below, and this did the trick.
Article-ID: Note 313026.1
Title: Rman Offline Backup Fails with ORA-12519 or ORA-12523 Error
Basically, I changed it back to SERVICE_NAME back to SID_NAME = TEST226.
I then did a lsnctrl stop and a lsnctrl start
I can now connect to the nomount instance and I'll proceed on with the other part. Thanks.
Last edited by mpoisson; 08-29-2007 at 10:25 AM.
Reason: Clarification
"There is no pleasure in having nothing to do; the fun is having lots to do and not doing it." Andrew Jackson