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
yeah!! SMPP connections come with the assurance of guaranteed delivery of SMS without failure. SMPP Software remain constant while being connected with servers and this means that they do not require any kind of validations by the use of usernames and passwords for sending messages.
ReplyDelete