Home > TroubleShooting > Slow sqlpus connection

Slow sqlpus connection

Symptoms

1. Get connected fast to the database with sysdba as the following
[oracle@SGRAC1 ~]$ sqlplus ‘/as sysdba’

2. Get connected slowly to the database with other user with tnsname
[oracle@SGRAC1 ~]$ sqlplus vod/vod@sgcmsdev1
SQL*Plus: Release 11.1.0.7.0 – Production on Tue May 11 01:54:40 2010
Copyright (c) 1982, 2008, Oracle. All rights reserved. <– Stuck at here and wait about 10 seconds.

Connected to: Oracle Database 11g Release 11.1.0.7.0 – 64bit Production With the Real Application Clusters option

SQL>

Fixed

Remove /etc/resolv.conf, the problem get solved

Advertisements
Categories: TroubleShooting
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: