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
>
>
>

-- 
=========================

Stefan P Knecht
Consultant
Infrastructure Managed Services

Trivadis AG
Europa-Strasse 5
CH-8152 Glattbrugg

Phone +41-44-808 70 20
Fax +41-808 70 12
Mobile +41-79-571 36 27
stefan.knecht_at_trivadis.com
http://www.trivadis.com

=========================

--
http://www.freelists.org/webpage/oracle-l