Re: Cannot login to Oracle 9i on Linux7.1

Hongxin Zhou wrote:
> Hello....
>
> I have installed Oracle9i database server Enterprise Edition on my Linux 7.1
> system. At the end of installation, in Oracle configuration Assistant, I
> have succeed to change the users' (sys and system) passwords. The post
> installation configuration is complex. I am not very confident for some
> configurations. After I install Oracle 9i, I have the problem to login as
> any kind of user, including sys and system. Could you please help me to
> solve this problem?
> The following is the response when I logined.
>
> [oracle_at_localhost oracle]$
> [oracle_at_localhost oracle]$ sqlplus
>
> SQL*Plus: Release 9.2.0.1.0 - Production on Thu Aug 1 08:17:06 2002
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
> Enter user-name: sys
> Enter password:
> ]ERROR:
> ORA-01034: ORACLE not available
> ORA-27101: shared memory realm does not exist
> Linux Error: 2: No such file or directory
>
>
> Enter user-name: system
> Enter password:
> ERROR:
> ORA-01034: ORACLE not available
> ORA-27101: shared memory realm does not exist
> Linux Error: 2: No such file or directory
>
>
> Enter user-name:
> ERROR:
> ORA-01017: invalid username/password; logon denied
>
>
> SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
> [oracle_at_localhost oracle]$
>

HI,

Try connect via sqlplus, fist define ORACLE_SID enviroment variable:

$ export ORACLE_SID=YOUR_Instance_name
$ sqlplus '/ as sysdba'

This connection type is similar to sys/PASSWORD as sysdba

Regards

-- 

   www.konsultancIT.pl
Oracle&MS-SQL consulting