Re: Slow sqlplus connection

Running a truss on the sqlplus process might provide some further insight
what it's being waited on. Just remember to trace accross forks (using -f ).

Stefan

On 7/3/07, Graham Ross <grahamaross_at_yahoo.com> wrote:
>> 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>>>