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

With all due respect, this question indicates you MUST very soon read the concepts manual or some other introduction. Otherwise you will be in for a lot of frustration and dissapointment.

(My personal recommendation is http://www.oreilly.com/catalog/oressentials2 followed by http://docs.oracle.com.)

The specific solution here is to 'start, mount and open the database'. The method, as described by others as well, is

sqlplus /nolog
>> connect / as sysdba
>> startup

After the database is open for public access, the access for a regular user will be

sqlplus user/passwd

   (or)
sqlplus /nolog
>> connect user/passwd

HTH
/Hans

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]$
>
> Any suggestions would be greatly appreciated.
>
> Frank
> Hungxin_at_btnet.com.au
Received on Mon Jun 16 2003 - 10:44:50 CDT