Prev | Current Page 138 | Next

Richard Niemiec

"Oracle Database 10g Performance Tuning Tips & Techniques"

The variables for this command are shown in the following table.
C:\> ORADIM -NEW -SID SID -INTPWD PASSWORD -MAXUSERS USERS
-STARTMODE AUTO -PFILE ORACLE_HOME\DATABASE\INITSID.ORA
Variable Description
SID The name of the SID (instance identifier) of the database you are
upgrading.
PASSWORD The password for the new release 11.1 database instance. This is
the password for the user connected with SYSDBA privileges. If
you do not specify INTPWD, operating system authentication is
used and no password is required.
USERS The maximum number of users who can be granted SYSDBA and
SYSOPER privileges.
ORACLE_HOME The release 11.1 Oracle home directory. Ensure that you specify
the full pathname with the -PFILE option, including the drive letter
of the Oracle home directory.
6. If your operating system is Unix or Linux, make sure the environment variables ORACLE_
HOME and PATH point to the new release 11.1 directories, ORACLE_SID is set to the
existing database??™s SID, and the file /etc/oratab points to the new Oracle Database 11g
home directory. In addition, any server or client-side scripts that set ORACLE_HOME
must be changed to point to the new Oracle software home directory.
56 Oracle Database 11g DBA Handbook
7. Log into the system as the owner of the Oracle Database 11g software.
8. Change your directory to the $ORACLE_HOME/rdbms/admin subdirectory under the
Oracle software home directory.
9. Connect to SQL*Plus as a user with SYSDBA privileges.


Pages:
126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150
news news news news news