Home > oradim in Linux > Use oradim in Linux

Use oradim in Linux

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
Advertisements
Categories: oradim in Linux Tags:
  1. No comments yet.
  1. January 2, 2011 at 2:51 pm

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: