Log in sys as sysdba

Why am I getting an idle instance when I login as sys as sysdba?
I don't get an idle instance when I log in as sysyem.
lium1Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
The message indicates the instance isn't running.

I'm not sure why system doesn't produce the idle instance message but I figure it will generate a message if you try to execute any command.
0
lium1Author Commented:
I log in as system and do some query and it works. What do you mean by removed Unix OS Zone? When I do ps -ef | grep pmon, what message that I should be looking to make sure instances are running okay?
0
slightwv (䄆 Netminder) Commented:
>>I log in as system and do some query and it works.

Then when you are connecting as SYSDBA, you aren't connecting to the same instance or the database isn't in an 'open' state.

Make sure your ORACLE_HOME is set properly.

>>When I do ps -ef | grep pmon, what message that I should be looking to make sure instances are running okay?

All that ps command does is make sure the pmon Oracle process is running.  This is just an indication the database is running.
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

lium1Author Commented:
How do I make sue ORACLE_HOME is set properly, in Unix?
Do I have to say set or export?
If you could, please exact syntax?

Thanks in advance!
0
slightwv (䄆 Netminder) Commented:
Sorry ORACLE_HOME was a typo.  I meant ORACLE_SID.

Yes, export of variables is correct:
export ORACLE_SID=ORCL

Where ORCL is the database SID you are trying to connect to.
0
lium1Author Commented:
Thanks, but when I do grep ORACLE_SID, it shows all pmon, smon, and background processes.
So, do I still need to export ORACLE_SID?
0
slightwv (䄆 Netminder) Commented:
We are getting way off topic here.

ORACLE_SID is just an environment variable that tells Oracle tools and utilities what instance it should try to connect to.

The message about the idle instance means:  The instance is down or not fully opened or you are trying to connect to an instance that doesn't exist.

For example if your instance name is ORCL and ORACLE_SID is set to BILL:
export ORACLE_SID=BILL

If you try to connect as sys, you will likely get an idle instance message.
0
lium1Author Commented:
ORACLE_SID=ORCL is already set as environment variable in .cshr file. When I login as sys as sysdba/password@databasename, I am getting an idle instance message. What exactly that I need to resolve it?
0
slightwv (䄆 Netminder) Commented:
>>When I login as sys as sysdba/password@databasename, I am getting an idle instance message

The @databasename is telling oracle to connect to a different database than the one set in ORACLE_SID.  Which database depends on what is set in $ORACLE_HOME/network/admin/tnsnames.ora and the databasename entry.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
lium1Author Commented:
I think the problem is solved by source .cshrc.
Thanks for your help any way, and I will give all credits to you.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.