Re: Oracle 9.2 on Solaris.

$ export ORACLE_SID='blorfo'
$ sqlplus

SQL*Plus: Release 9.2.0.6.0 - Production on Fri Aug 26 17:01:14 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Enter user-name: a
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist HP-UX Error: 2: No such file or directory

In other words, it's quite possible you didn't have to do anything except source your environment! (as Sybrand implied in the ORCL comment)

jg

--
@home.com is bogus.
http://blogs.washingtonpost.com/securityfix/2005/08/arrest_of_zotob.html