Note: You CANNOT use the same database that the Applications are running in. The tool must be installed in a separate database from the Applications.
Note: Before you run the Oracle Installer, ensure that an X Windows manager is running.
b. Install RDBMS 10g using the following command:
./runInstaller
c. Specify the desired ORACLE_HOME location.
d. Choose "Enterprise Edition".
e. Uncheck the option called "Create Starter database". Click NEXT.
f. Optionally, specify the oraInventory and operating system group, then click NEXT.
g. After successful Product-Specific Prerequisite Checks, choose "Install database Software only" and click NEXT
h. Click INSTALL.
i. When the installation has completed, exit the installer.
-----------------------
2. Install a new standalone Oracle 10g iAS ORACLE_HOME
Download Oracle iAS 10g (10.1.3)
a. Set the DISPLAY variable appropriately and export it.
Note: Before you run the Oracle Installer, ensure that an X Windows manager is running.
b. Run the installer.
./runInstaller
c. Specify the installation directory.
d. Choose "Advanced Installation Mode" and click NEXT.
e. Choose "Web Server and Process Management" (or "Integrated Web Server, J2EE Server and Process Management") and click NEXT.
f. Select your desired method of port configuration and click NEXT.
g. Optionally, select your desired Administration Instance settings and click NEXT.
h. Specify your Cluster Topology Configuration and click NEXT.
i. Click INSTALL.
j. Exit the installer.
k. When the installation has completed, exit the installer.
----------
3. Create the database.
a. Set the ORACLE_HOME variable appropriately.
ORACLE_HOME=
b. Change to the bin directory.
cd $ORACLE_HOME/bin
c. Run the database creation utility.
./dbca
d. Choose "Create a Database".
e. Choose "General Purpose".
f. Specify the Global Database Name.
g. Specify whether to configure to database with Enterprise Manager.
h. Set the default password for the SYS and SYSTEM accounts. (PLEASE, record these in a secure location!)
i. Choose your storage mechanism. We recommend that you choose "File System" and select a Common Location.
j. Specify any desired recovery options.
k. Specify NO sample schemas.
l. In the Character Sets tab, do NOT modify the Default Language (American) and Default Date Format (US).
m. Specify the desired values for parameters SGA, PGA and processes.
n. When the process has completed, exit the Database Creation Assistant.
----------------------
4. Set up the listener for the Oracle RDBMS ORACLE_HOME.
Create LISTENER.ora and TNSNAMES.ora files in the Oracle RDBMS $ORACLE_HOME/network/admin directory.
Use of a sqlnet.ora file is not necessary for operation of SQL*Net. We strongly recommend against creating a sqlnet.ora file. If you are using a sqlnet.ora file and experience database connection issues with the Maintenance Wizard, it may be related to parameters such as "defaultdomain". Please consult the SQL*Net manual for details. You may use netca to configure your listener, or modify the following template: LISTENER.ORA file
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = yourhost.us.oracle.com)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = myora10g)
(ORACLE_HOME = /u02/ora10g/10.2.0)
(SID_NAME = myora10g)
)
)
TNSNAMES.ora file
ORA9I =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = yourhost.us.oracle.com)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = myora10g)
)
)
5. Set up the listener for the Oracle iAS ORACLE_HOME. Either copy the tnsnames.ora file or create a symbolic link.
To copy the file:
cp
Or, to create a symbolic link:
cd
ln -s
6. Create the NEWEOF tablespace where the Maintenance Wizard schema objects will be stored. Connect to sqlplus as the system user, and execute the following command substituting in the full path to your datafile.
create tablespace NEWEOF datafile '/u01/oracle/oradata/eof01.dbf' size 50M AUTOEXTEND ON NEXT 5M MAXSIZE 75M;
Note: Do not create a Maintenance Wizard schema; the tool creates it automatically.
7. Verify that Zip and UnZip executables are installed and that ping is in the $PATH using the following commands:
8. Set the default shell for all UNIX accounts to Korn shell. You must do this for the MW UNIX owner on the MW node, as well as for all user accounts that will be used on the remote nodes (applmgr, oracle). For Linux ONLY, you will first have to manually install ksh into the /bin directory of each machine. The UNIX Korn shell is not automatically installed on Linux.
Installing the Oracle Maintenance Wizard
1. Login to the system as the same UNIX user that you used to install the RDBMS and iAS.
2. Ensure that the $ORACLE_HOME environment variable is set to point at RDBMS 10g before proceeding. At a minimum, take sure the following variables are set.
ORACLE_HOME=
PATH=$ORACLE_HOME/bin:$PATH; export PATH
TWO_TASK=
TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN
3. Create a directory to extract the tool into (this will become your $EOF_HOME). Oracle recommends that you create the Maintenance Wizard directory in the RDBMS $ORACLE_HOME directory. Then set the $EOF_HOME environment variable as follows:
cd $ORACLE_HOME
mkdir eof
EOF_HOME=$ORACLE_HOME/eof; export EOF_HOME
4. Download the latest Maintenance Wizard Full Install version from Downloads and unzip it into ${EOF_HOME}.
5. Change directory to the $EOF_HOME/config directory.
cd ${EOF_HOME}/config
6. Run the installation script.
./setup.sh
7. Respond to the prompts shown below. Default values are shown in brackets.
8. You have the option to review your entries and make changes before the install begins.
Domain =
Oracle Home =
Connect String =
System Password =
Database Schema =
EOF Patch Stage =
Email for Anonymous FTP =
OracleMetaLink Username =
OracleMetaLink Password =
Maintenance Wizard Password =
Note: The automated patching and administration features of the tool require that a defaults file be located in the $APPL_TOP/admin/[SID] directory. The file may be named either defaults.txt or adalldefaults.txt. You must update this file whenever you make changes to entries that it references, such as changing a database password or moving directory paths. For more information about the defaults.txt file, please see Oracle Applications Maintenance Utilities.
10. Choose option 2 to review the todo.txt file for information about additional steps that you must perform, then choose option 3 to exit the installer.
11. It is strongly recommended that you increase the Timeout parameter in the httpd.conf file for Apache to a value of 10800 (3 hours) to allow long running steps (like patch downloads and merges) to complete successfully.
12. Stop and restart iAS.
opmnctl stopall
opmnctl startall
Note: You can rerun setup.sh to change the configuration if required (for example, if you make a mistake in your initial setup, or decide to use a different machine or location.)
Post Install Steps
1. Secure the $EOF_HOME/EOF.env file.
chmod 700 $EOF_HOME/EOF.env
2. Setup a client machine with Microsoft Internet Explorer (IE) 6.0 or higher.
3. In IE, under Tools -> Internet Options, click Settings. Select the radio button for "Every visit to the page."
4. If you are using IE 7.0 or higher, you need to allow the MW to set the status via a script so that your autorefresh works properly. Go to Tools -> Internet Options -> Security -> Local Intranet Zone -> Custom Level -> Scripting and set "Allow status bar updates via script" to checked.
5. Some customers have found that they had to change their Cookie settings as well. If you receive an ORA-1403 in the Apache error log while trying to log into the tool, you should go to Tools -> Internet Options -> Privacy Tab, click Advanced. In the Cookies section, choose Override automatic cookie handling. Under First-party cookies, select Accept. Select Always Allow Session Cookies.
6. Save and exit the IE Internet Options.
7. Login to the tool using the following URL and the pre-assigned username and password that you assigned it when you chose back in step 7 of Installation: SYSADMIN/YOURPASS:
http://hostname:portno/EOF/
8. Download the User Guide to learn how to create and configure customers and projects.
Uninstall Steps
1. Login to the database as the sys user.
2. Drop the Maintenance Wizard user and objects.
drop user neweof cascade;
3. Drop all directory objects that begin with "CONFIG_INSTANCE_" or "LOG_INSTANCE_".
declare
cursor all_dirs is
select * from dba_directories
where directory_name like 'CONFIG_INSTANCE_%'
or directory_name like 'LOG_INTANCE_%';
begin
for each_dir in all_dirs
loop
execute immediate 'drop directory ' each_dir.directory_name;
end loop;
end;
/
4. Stop and restart the database.
5. Under the iAS $APACHE_TOP/Apache/conf directory, edit the oracle_apache.conf file and remove the following section (where $EOF_HOME is your specific value):
# begin customizations
# Include EOF configuration information for Apache
include $EOF_HOME/config/EOF.conf
# end customizations
6. Under the $IAS_HOME/Apache/modplsql/conf directory, remove the dad information from the dads.conf file.
7. Stop and restart iAS.
opmnctl stopall
opmnctl startall
8. Remove Maintenance Wizard directories from the system.
9. Remove directories/files created under each user's home directory.
10. Remove entries from .rhosts or authorized_keys files.
1 comment:
Good Post..
Post a Comment