It means Oracle Instance is not active.ORA-01034: ORACLE not available
This error message is different:And how do you activate you oracle instance? Isn't this by logging on to the database as sysdba and starting it? (sorry for the sarcasm).It means Oracle Instance is not active.ORA-01034: ORACLE not available
If you have two databases in the same server, you
need to create two running oracle instances. You said
you create the firsts one with Oracle tool (I suposse
it create implicity one oracle instance related to
Later you create manually TEST01 Databases, it seems
you need to create manually and Oracle Instance for
Just another posibility.
export ORACLE_SID=TEST01Sounds like the user you're logged into the OS as is not in the same OS-group as the osdba group. When you installed the database, Oracle asked you for an OS group name. Only users in this group can log in as sysdba.
$ sqlplus "/ as sysdba"
SQL*Plus: Release 18.104.22.168.0 - Production on Thu Dec 22 11:39:03 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
ORA-01031: insufficient privileges