Home » RDBMS Server » Server Administration » sqlplus using sys user connection hangs (Oracle 11gR2, Red Hat Linux)
sqlplus using sys user connection hangs [message #611843] Wed, 09 April 2014 06:31 Go to next message
Messages: 67
Registered: November 2005
Location: chennai

We have migrated our database server from Physical machine to Virtual Machine (Oracle database 10g) and then upgraded the database from 10g to 11gR2.

We have observed that connection to database using sys user is taking very long time (more than 2 minutes). Other users dont have any issues.

Any thoughts please to fix this issue.

Re: sqlplus using sys user connection hangs [message #611847 is a reply to message #611843] Wed, 09 April 2014 07:42 Go to previous message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
Just saying that you are facing issues after moving from physical to virtual will not help in detecting the issue. There are lot of hardware factors that are responsible for a perfect virtual environment.

I am not an expect in this area, but you can have a look at these points mentioned by Tim Hall, and then comeup with precise explanation of the issue : What's All This About Virtual Insanity
Previous Topic: Shared memory realm does not exist
Next Topic: Temp tablespace size
Goto Forum:

Current Time: Mon Sep 25 07:02:23 CDT 2023