Archive

Archive for the ‘oradim in Linux’ Category

Use oradim in Linux

November 17, 2009 1 comment

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
Categories: oradim in Linux Tags: