Hello All,

I'm a SQL Server DBA and new to Oracle Database administration.
We're on Oracle 9.2 on Linux platform.
In an attempt to clone an existing oracle database I did the following

Left the source database up and running.
Copied files (data files, redo log files, control files and initialization
files) from source path to target path.
Modified initialization parameter file (initSID.ora) to point to the target
file structure.
set ORACLE_SID successfully.
While I startup the target instance with the command
"startup NOMOUNT PFILE=$ORACLE_HOME/dbs/initSID.ora" I get the following
error:

--------------------------------------------------------------------------------------------------------------
/u01/app/oracle/product/9.2.0
Usage: grep [OPTION]... PATTERN [FILE]...
Try `grep --help' for more information.

SQL*Plus: Release 9.2.0.6.0 - Production on Tue Oct 30 00:17:10 2007

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

Connected.
select name, log_mode, user from v$database
*
ERROR at line 1:
ORA-01034: ORACLE not available

SQL> SQL> SQL>
SQL> SP2-0332: Cannot create spool file.
SQL> ORA-07217: sltln: environment variable cannot be evaluated.
SQL> Disconnected
--------------------------------------------------------------------------------------------------------------

Please consider this as Very Urgent.
Not sure where I went wrong.
Please, please help.

Thank you,
Murali



Oracle LazyDBA home page