Sunday, August 8, 2010

Using ORADIM Utility on Linux

The ORADIM Utility is not found in Linux/Unix operating systems,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 ORCL, you create an initORCL.ora file, use the initORCL.ora for creating a new instance

Create new sid using oradim in Windows environment:

D:\>oradim -NEW -SID ORCL
D:\>set ORACLE_SID = ORCL
D:\>sqlplus / as sysdba

Connected to an idle instance.

SQL> startup nomount pfile='initORCL.ora'

Create new sid in Linux environment:

$ export ORACLE_SID = ORCL
$ sqlplus / as sysdba

Connected to an idle instance.

SQL> startup nomount pfile='initORCL.ora'

No comments: