Re: using sqlplus nolog

No Spam wrote:
>
> oracle 1950 1 0 16:18 ? 00:00:00 ora_pmon_akan
> oracle 1952 1 0 16:18 ? 00:00:00 ora_dbw0_akan
> oracle 1954 1 0 16:18 ? 00:00:00 ora_lgwr_akan
> oracle 1956 1 0 16:18 ? 00:00:00 ora_ckpt_akan
> oracle 1958 1 0 16:18 ? 00:00:01 ora_smon_akan
> oracle 1960 1 0 16:18 ? 00:00:00 ora_reco_akan
> oracle 1962 1 0 16:18 ? 00:00:00 ora_cjq0_akan
> oracle 1964 1 0 16:18 ? 00:00:15 ora_qmn0_akan
> oracle 1966 1 0 16:18 ? 00:00:00 ora_s000_akan
> oracle 1968 1 0 16:18 ? 00:00:00 ora_d000_akan
> oracle 2006 1860 6 17:06 pts/0 00:00:00 ps -ef
> oracle 2007 1860 0 17:06 pts/0 00:00:00 grep ora

A database instance is available.

> These ar ethe error msgs I am getting with sqlplus:
>
> [oracle_at_localhost oracle]$ sqlplus
>
> SQL*Plus: Release 9.2.0.1.0 - Production on Fri Jan 9 17:18:40 2004
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
> Enter user-name: oracle
> Enter password:
> ERROR:
> ORA-01034: ORACLE not available
> ORA-27101: shared memory realm does not exist
> Linux Error: 2: No such file or directory
>

You need to set the ORACLE_SID and ORACLE_HOME properly. GO BACK AND READ THE MANUAL and/or READ THE INSTALL INFORMATION AT http://www.dizwell.com

> Enter user-name: akan_at_domain
> Enter password:
> ERROR:
> ORA-12154: TNS:could not resolve service name
>
> 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
>
> SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

YOU HAVE NOT CONFIGURED YOUR USER CORRECTLY. LEARN ABOUT ENVIRONMENT VARIABLES. Received on Fri Jan 09 2004 - 11:54:03 CST