oracle@machine::9.2.0:/apps/oracle/ export ORACLE_SID=SOMESID
oracle@machine:SOMESID:9.2.0:/apps/oracle/ sqlplus "/ as sysdba"
SQL*Plus: Release 9.2.0.7.0 - Production on Mon Jul 10 13:58:57 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production
SQL> select name,log_mode from v$database;
NAME LOG_MODE
--------- ------------
SOMESID NOARCHIVELOG
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production