Registering a database with RMAN....

[B14speedfreak]

Hi all,

My thanks in advance for reading and any subsquent posts.

I am trying to register an oracle 9.2.0.4.0 database onto another 9i catalog all on the same box, all under Linux Redhat enterprise 3.

In RMAN everytime I do a

Connect target /

Connect catalog rman/rman@rman (passwords and username and sid)

After that I try to run a:

Register database;

Every time I run this I get a:

Memory fault

The same thing happens when I run a resync catalog as well. Anyone any ideas??? I posted the same question on the metalink forums, and I carn't really find any examples of this on the net or metalink.

Thanks again in advance for reading and any posts,

B14... aka... marky mark...

 

[LKBrwnDBA]

This seems like OS error.

Check the OS Kernel parameters to see if they match the Oracle required values.




----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[B14speedfreak]

I will have a look at OS parameters, however one thing that might make things a bit clearer. We currently use the catalog on a few (4/5 other databases) a mix of solaris/linux redhat but they do connect and I can perform resyncs etc... This box that I am using is essentially the standby for a lot of the production systems, however I cannot resync the catalog or register the databases with the catalog without getting the memory fault error...

The catalog and the databases on that this box share the same oracle home, could this have something to do with it?

Thanks for the post,

B14... aka... marky mark...

 

[B14speedfreak]

Ok have had a look at into this the kernal parameters, these seem to be ok. However I think the issue maybe be 2 slightly different varsions of RMAN. Not exactly sure how I am going to get round this, any ideas would be most welcomed (I didn't install the software!)

Thanks again for the replies,

B14... aka... marky mark

 

[LKBrwnDBA]

I bet that the other 4/5 databases are: 1) On different servers and 2) You execute RMAN on target server.

It makes no difference if RMAN Catalog shares same Oracle home as databases on same server.

However I beleive you cannot register standby database in same catalog as main database because database name and db-id are the same.

But in any case "memory fault" looks like OS error.

Just a thought: Check if your Oracle_Home mount point is 100% full.










----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[B14speedfreak]

No the mount points are fine. Yeah the other systems are standby's and yeah I guess you couldn't put them into the catalog unless you used a different username or tablespace.

However the system that I am really trying to register is not a standby. Thats the really puzzling thing. The versions of oracle are slightly different as well (9.2.0.6.0 one that works and 9.2.0.4.0 on the box that doesn't work).

As temporay work around I might try to use the box that workses version of RMAN and connect to the database that I am trying register.

Anyhow thanks for the posts all the ideas are of use,

thanks again,

B14... aka... marky mark...

 

[stefanhei]

Mark, does the syslog tell you anything about that error?
Did you check the os-users ulimit?

Stefan