Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Connected to an idle instance issue

Helios-GunesEROLFeb 3 2011 — edited Feb 3 2011
Hi friend;

I have strange issue. I have 11.2.0.1 db on AIX6. ORACLE_HOME and ORACLE_SID already set.

When i try to run below command:

sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.1.0 Production on 2011

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to an idle instance.

But Oracle process is running

When i try

sqlplus sys/xx@SID as sysdba << i can connect SQL and can run query


I checked my listener.ora file and it seems okey. No any error message in alert.log,i can also login database from toad wihtout any issue.

No luck also in metalink notes, anyone face similar issue before?

PS: Memory size: 32 G - usage : 32 G

Regard
Helios

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 3 2011
Added on Feb 3 2011
#general-database-discussions
5 comments
60,746 views