Re: ORA-01012: not logged on

Mac Schwarz wrote:
>
> Hi,
>
> I'm trying to install Oracle8i (8.1.5) Server on a SUN Sparc Solaris
> 7.
>
> At first i created an user 'oracle' with the groups oinstall and
> dba. I set the environment variables

oracle should have as primary group dba.

> NLS_LANG=WE8DEC
NLS_LANG=american_america.we8dec
or something similar (language_territory.characterset)

> ORACLE_BASE=/u01/app/oracle
> ORACLE_HOME=/u01/app/oracle/product/8.1.5
> ORACLE_SID=testdb
> ORA_NLS33=/u01/app/oracle/product/8.1.5/ocommon/nls/admin/data
>
> for 'oracle' and started the OUI. The installation was successful
> except of the creation of the database 'testdb'. I get the error
> 'ORA-01012: not logged on' at initializing the database. The dbassist
> was started from the OUI at the end of the installation. I 'ignored'
> the error message and started the dbassist to delete 'testdb'. Same
> error.
>
> If i try to connect to the database with svrmgrl or with sqlplus as
> SYS i get the error message 'ORA-01033: ORACLE initialization or
> shutdown in progress'.

Do a shutdown abort, change NLS_LANG and try again.

>
> I think I've missed something simple but I checked the Installation
> Guide twice and don't see any difference with my installation and the
> required steps described there?
>
> Isn't the 'login'-requirement for the database the membership in group
> dba?
>
> Any hints?
>
> Regards,
> mac
>
> --
> Mac Schwarz / AERIA Projekt / Inst. f. Klassische Archaeologie
> e-mail: mac_at_aeria.phil.uni-erlangen.de / Tel.: 09131-85-24791
> FAU Erlangen-Nuernberg / Kochstr.4 / 91054 Erlangen
> <http://www.phil.uni-erlangen.de/~p1altar/aeriahome.html>
Received on Thu Jul 29 1999 - 15:18:20 CDT