All,
I currently have a strange problem and I wonder if anyone on the list has
seen this.
We currently have a RAC database (10.2.0.1) running on an AIX 5.3server. I
backed up the database using RMAN to TSM, and from this backup
wanted to build a copy of the live database on an alternate server. There
were some problems involved in this in that a) there already existed a
database on the server with the same name and dbid of the live system (I
inherited this), and b) there was no connection between the live and the
test servers.
I shut down the existing copy of live, and moved all the files out of
harms way, and then restored and recovered the backup converting it to a
single instance, (the other copy is a full RAC copy). So far so good. I
then changed the name and dbid using nid and brought the database up. It
came up successfully, but now connecting the database via sqlplus was taking
exactly 75 seconds. While it all worked fine after that, it is annoying
and having an adverse impact on our testing. Changing the tcp_keepinit
kernel parameter from 150 to 20 took the connection time from 75 to 10
seconds. This is better, but still not a fix.
I can't help thinking that there is some process trying to start and
failing, and I can't for the life of me think of what it could be. I
expect it's something blindingly obvious, but I'd be delighted to hear any
suggestions.
Thanks in advance,
graham
___________________________________________________________
Yahoo! Answers - Got a question? Someone out there knows the answer. Try
it
now.
http://uk.answers.yahoo.com/
--
http://www.freelists.org/webpage/oracle-l
