Connecting AS SYSDBA results in "Connected to idle instance"..

Most of the time I don’t even think about how I connect to a database: set the environment – variables,  connect /as sysdba, and voila..

Then I ran into a node in which this was not as simple as I thought. Only connections through the listener were accepted. After serious investigation in discovering some typo’s, a vague bell was ringing…. Not the first thing I would think of… :

The Linux-command:  ‘uname -a’  gave me  ‘x86_64’.  A 64-bits machine!  The database and application server turned out to be running in 32-bits emulation mode.

Switched my session into 32-bits-emulation: with the Linux-command ‘ linux32 bash’ , and the problem was solved.  Some things can be time consuming but simple (when you think of it…).

By | 2009-03-23T16:49:36+00:00 March 23rd, 2009|Categories: Database|0 Comments

About the Author:

Leave A Comment