Re: RMAN and ORA-12519

Howard, I'd like to thank you for your reply. To answer your questions, the db was successfully mounted, lsnrctl services was ok and was registering service handlers and connections using IPC and TCP worked fine. Given all of this, read below as I figured this one out.

I figure this out late yesterday afternoon after further research deep into the bowls of Metalinks. It appears there's some sort of bug with the listener and dynamic registration, however, I had setup the database explicitly in the listener.ora. Here's the fix: 1. Comment out INSTANCE_NAME in the init.ora 2. Add event = "10258 trace name context forever, level 4" in the init.ora
3. Oracle recommends in the CONNECT_DATA portion for the db in the tnsnames.ora for it to be SERVICE_NAME = DB and not SID. However, I found this not to work and changed it back to SID. Items: 1, 2 and 3 will effectively stop the db from performing a dynamic registration.

Hope this helps anyone else running into this. Pete's

"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message news:<a8a59k$2ap$1_at_lust.ihug.co.nz>...
> Well, 12519 actually states that the Instance has not registered with the
> the Listener. You say they have. How about capturing and posting the output
> when you do a 'lsnrctl services'?
>
> Since you're doing cold backups, I presume you are successfully in the mount
> state? And connections using the service alias outside of RMAN are no
> problem?
>
> Personally, I've never needed to put quotation marks around the connect
> string, but that's probably not the issue here, just a comment.
>
> Get back to us with some additional info, OK?
> Regards
> HJR
> --
> ------------------------------------------
> Resources for Oracle : www.hjrdba.com
> ============================
>
> "Pete's" <empete2000_at_yahoo.com> wrote in message
> news:6724a51f.0204010919.cefa9dc_at_posting.google.com...
> > I'm using RMAN with Oracle 8.1.7.0 on Solaris 2.6 with Netbackup
> > Datacenter 3.4.1GA and Oracle Extensions. Here's the question, I use
> > rman nocatalog, then connect target 'internal/password_at_DBID' and
> > scripted with a run command for a database cold backup using the
> > control file as the catalog(for now). I'm getting ORA-12519 and the
> > error basically says to check the services running and there are
> > services running for the db. This worked on friday and nothing has
> > changed. The sqlnet.ora file, tnsnames.ora and listener.ora file have
> > not changed. Anyone have ideas? Could I be running into a bug
> > relating to 12519 that is fixed in 8.1.7.1?
> >
> > Please post your reply back to this group.
> >
> > TIA
> > Pete's
Received on Tue Apr 02 2002 - 08:21:40 CST