There is no Utility tool like oradim in Linux/Unix. But only processes and these processes are automatically activated when the instance is started, and removed when the instance is shut down.
To start a new instance, say for example newsid, you create an initnewsid.ora file, use the initnewsid.ora for create a new instance
How to Create new sid by using oradim in Windows environment
C:\Documents and Settings\Master>oradim -NEW -SID newsid
C:\Documents and Settings\Master>set ORACLE_SID=newsid
C:\Documents and Settings\Master>sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Nov 18 00:26:38 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount pfile=<complete path for initnewsid.ora>
How to Create new sid in Linux environment
$ export ORACLE_SID=newsid
$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Nov 18 00:26:38 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount pfile=<complete path for initnewsid.ora>
Startup and shutdown using oradim in windows
oradim -Startup -sid orcl oradim -Shutdown -sid orcl
Startup and shutdown using Linux
$ export ORACLE_SID=orcl $ sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Tue Sep 5 16:38:30 2009 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to an idle instance. SQL> startup/shutdown immediate
Help Line :
ORADIM -h
No comments:
Post a Comment