ora-01034 : ORACLE not available

Tapan6415 · #1 (**permalink**) 02-04-12, 05:28

Hii..,

i am using Windows vista Business 32bit, intalled s/w Oracle 11.2.0

i created my database in oracle 11.2.0 manually and i able to mount successfully and at last i also run the 3 scripts from my command prompt but when ever i am starting my sqlplus and i am entering "scott/tiger" or "orcl/tiger" it shows me error

>ora-01034 : ORACLE not available
ora- 27101: shared memory realm does not exist
Process ID:0
Session ID:0
Serial number:0

Thanx..

anacedent · #2 (**permalink**) 02-04-12, 09:54

Code:

034, 00000, "ORACLE not available"
// *Cause: Oracle was not started up. Possible causes include the following:
//         - The SGA requires more space than was allocated for it.
//         - The operating-system variable pointing to the instance is
//           improperly defined.
// *Action: Refer to accompanying messages for possible causes and correct
//          the problem mentioned in the other messages. 
//          If Oracle has been initialized, then on some operating systems,
//          verify that Oracle was linked correctly. See the platform
//          specific Oracle documentation.

pmo · #3 (**permalink**) 02-06-12, 09:16

I'm not using Oracle on Windows, but I guess it works quite the same way as Unix. So:
You have to specify to which database you want to connect. To do that, you must set up the global variable ORACLE_SID.
Another solution is to use a tns entry (in the tnsnames.ora file) and use this sqlplus syntax:
sqlplus user/password@tns-entry-name
Note: in this second solution, you must also start a listener for this database.

anacedent · #4 (**permalink**) 02-06-12, 10:19

Ora-12560: Tns

rotocol adapter error [id 989716.1]

pmo · #5 (**permalink**) 02-06-12, 10:31

Did you check your global env variables? ORACLE_HOME, ORACLE_SID and PATH
If PATH is not set with the correct oracle_home at the beginning, you can get this error.

aflorin27 · #6 (**permalink**) 02-07-12, 03:21

Maybe your instance is not started.
Try these steps:
1. open cmd prompt
2. type: sqlplus /nolog
3. type: connect sys/your_password as sysdba
4. if you get connected to an idle instance, type: startup

Internet Services

Web Development

Digital Marketing

Consumer Tech