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

Your Oracle database is not running. That is precisely what the ORA-1034 error message is telling you. Try this:

sqlplus /nolog
connect / as sysdba
startup

After that, your db will be up and running and you will be able to log in.

HTH,
Brian

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

-- 
===================================================================

Brian Peasland
oracle_dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"