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