Centos configure network interface gui

Rhel client 5 3 i386 dvd iso rar

For the Bourne, Bash, or Korn shell, add the following lines to the /etc/profile file by running the following command: cat >> /etc/profile

All articles, scripts and material located at the Internet address of //www. Info is the copyright of Jeffrey M. Application to host any of the material elsewhere can be made by contacting me at [email protected] I have made every effort and taken great care in making sure that the material included on my web site is technically accurate, but I disclaim any and all responsibility for any loss, damage or destruction of data or any other property which may arise from relying on it. I will in no case be liable for any monetary damages arising from such loss, damage or destruction. Copyright (c) 1998-2017 Jeffrey M. This document may not be hosted on any other site without my express, prior, written permission. Hunter and is protected under copyright laws of the United States.

Last modified on
Monday, 14-Jul-2014 18:05:22 EDT
Page Count: 124042. Copyright (c) 1998-2017 Jeffrey M. $ su – # cp /etc/redhat-release /etc/redhat-release. D/dbora script would be defined as follows: /etc/init. This step is optional but recommended. 245 accesspoint accesspoint. If you have been following along with this article, the required scripts for switching your Oracle database environment is already included (in /usr/local/bin). This is a process known as archiving. It is even possible to be using two different databases running on different releases of the Oracle Database software. 0 chmod 755 /usr/lib/libdb. When the current online redolog fills, Oracle will switch to the next one. In situations like this, the group membership prevents unauthorized access to the database by personal who only maintain the Oracle software. From the Simple Search screen, select the “Product or Family” option in the Search By pull-down listing. Tmp UNDOTBS1 /u02/oradata/TESTDB/datafile/o1_mf_undotbs1_3rbj61p7_. 2: cannot open shared object file A workaround was posted on an Oracle forum and consists of the following tasks: As root, create the following symbolic link: ln -s /usr/lib/libgdbm. The OUI provides you with several URLs that will be activated by the OUI: The following J2EE Applications have been deployed and are accessible at the URLs listed below. Note that the Oracle database server should have a static IP address configured for the public network (eth0 for this article). About the Author Jeffrey Hunter is an Oracle Certified Professional, Java Development Certified Professional, Author, and an Oracle ACE. Bash_profile # Get the aliases and functions if [ -f ~/. 0/db_1 Available Product Components If you selected the Custom installation type, the next screen (Available Product Components) allows you to select from all available components. Note that you can utilize the same terminal shell session used in the previous section which in this case, you do not have to take any of the actions described below with regards to setting the DISPLAY variable: # su – oracle $ # IF YOU ARE USING A REMOTE CLIENT TO CONNECT TO THE $ # NODE PERFORMING THE INSTALL $ DISPLAY=:0. It is possible to receive an error about the available swap space not meeting its minimum requirements: Checking available swap space requirements. Enter the password (twice) and make sure the password does not start with a digit number. Once the DB Console application is up and running, point your web browser to //:1158/em as in the following: //vmlinux1:1158/em Login: User Name: SYSTEM Password: Connect As: Normal   The emctl start dbconsole / emctl stop dbconsole commands can be placed in the /etc/init. Ignore any messages indicating that the database contains invalid recycle bin objects similar to the following: BINlzljWIt9gfgMFeM2hVSoA==

Members of the dba group can administer Oracle databases, for example starting up and shutting down databases. In this article, we are creating the oracle user account to have both responsibilities. Note that members of the UNIX group oinstall are considered the “owners” of the Oracle software.

Enabling Archive Logs – (Optional) Oracle tracks and logs all changes to database blocks in online redolog files. This article (along with other Oracle installation guides on this site) adhere to the Optimal Flexible Architecture (OFA) and create both the oinstall and dba UNIX groups. Dbf’ resize 1024m; SQL> — UNDO Tablespace SQL> alter database datafile ‘/u02/oradata/TESTDB/datafile/o1_mf_undotbs1_3rbj61p7_. After running the root. Sh After the patch installation has completed, you will be prompted to run the root. The Oracle Database 10g Release 2 Patch Set 2 has now been successfully applied. 0/db_1 Product-Specific
Prerequisite Checks The installer will run through a series of checks to determine if the node meets the minimum requirements for installing and configuring the Oracle10g Companion CD Software. Next, unzip the archive file to the $ORACLE_BASE directory. To correct this, edit the $ORACLE_HOME/bin/dbstart script and replace the following line (approximately line 78): ORACLE_HOME_LISTNER=/ade/vikrkuma_new/oracle with this: ORACLE_HOME_LISTNER=$ORACLE_HOME The dbstart script shold now start the listener as expected. 190 george george. Database Administrator and Software Engineer for over 20 years and maintains his own website site at: //www. Given the Oracle database installation is now completed, we should now restore the original version of this file: $ su – # cp /etc/redhat-release. Confirm the Node Name is Not Listed in Loopback Address Ensure that the node name (vmlinux1) is not included for the loopback address in the /etc/hosts file. From the command prompt, simply run the following: $. I also always select to Generate Database Creation Scripts. 3 patchset will need to be downloaded from the Oracle Metalink website (//metalink. For my installation, all checks passed with no problems. The following query can be used to determine the file names for your environment: SQL> select tablespace_name, file_name 2 from dba_data_files 3 union 4 select tablespace_name, file_name 5 from dba_temp_files; TABLESPACE_NAME FILE_NAME ————— ——————————————————— SYSAUX /u02/oradata/TESTDB/datafile/o1_mf_sysaux_3rbj68np_. This section will provide the steps necessary to configure the database server to successfully run the Oracle Universal Installer (OUI). Original # echo “redhat-4” > /etc/redhat-release
Install the Oracle Database 10g Release 2 Software We are now ready to install the Oracle Database 10g Release 2 software. When all of the options are filled out, click the “Go” button. 131 vmlinux3 vmlinux3. Info is the copyright of Jeffrey M. :$ORACLE_HOME/rdbms/admin export ORACLE_SID=TESTDB export PATH=. At the same time, it also prevents database administrators from making modifications to the database software and the installation’s Inventory directory. Info
Create “oracle” User and Directories This section covers the steps required to create the UNIX groups (oinstall, dba, and oper) and user (oracle) that will be used to install the Oracle Database 10g software. Sh before running root. The type of installation to perform will be the Oracle Database 10g Products installation type. End of installation At the end of the installation, exit from the OUI. Members of the dba group can administer Oracle databases, for example starting up and shutting down databases. For the purpose of the example in this article, my log files were created in “/u01/app/oracle/product/10. Database Templates Select Custom Database Database Identification Select:
   Global Database Name: TESTDB. In this section you will download and install a collection of Oracle DBA scripts that can be used to manage many aspects of your database including space management, performance, backups, security, and session management. Verify That the User nobody Exists Before installing the Oracle software, complete the following procedure to verify that the user nobody exists on the system: To determine if the user exists, enter the following command: # id nobody uid=99(nobody) gid=99(nobody) groups=99(nobody) If this command displays information about the nobody user, then you do not have to create that user. The thing to keep in mind is that the UNIX oinstall group is completely optional and is not required if the same individuals will be maintaining the software and the database. Other Java applications that utilize the JRE are the Database Configuration Assistant and the Oracle Net Assistant. Jeff’s other interests include mathematical encryption theory, tutoring advanced mathematics, programming language processors (compilers and interpreters) in Java and C, LDAP, writing web-based database administration tools, and of course Linux. :${JAVA_HOME}/bin:$JAVA_HOME/db/bin:${PATH}:$HOME/bin:$ORACLE_HOME/bin export PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin export PATH=${PATH}:$ORACLE_BASE/dba_scripts/bin export ORACLE_TERM=xterm export TNS_ADMIN=$ORACLE_HOME/network/admin export ORA_NLS10=$ORACLE_HOME/nls/data export NLS_DATE_FORMAT=”DD-MON-YYYY HH24:MI:SS” export LD_LIBRARY_PATH=$ORACLE_HOME/lib export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib export CLASSPATH=. For the purpose of this article, I will be downloading and installing patch: 5337014. D/dbora script defined in this section uses the “su -” command to run the Oracle scripts dbstart and dbshut: su – $ORA_OWNER -c “$ORA_HOME/bin/dbstart $ORA_HOME” (and. Once an online redolog fills, Oracle moves to the next one. Bash_profile login script that was created in the section Create Login Script for oracle User Account. This will bring up the available patchsets in the Results section. Storage Options For this article, we will select to use File System. For my installation, all checks passed with no problems. 0/db_1/vmlinux1_TESTDB/sysman/log If you recieve something similar to the above output, then OEM Database Console is running. Sql script to recompile all invalid PL/SQL packages now instead of when the packages are accessed for the first time. 0/db_1/vmlinux1_TESTDB/sysman/log The OEM DB Console application may take several minutes to start. //vmlinux1:1158/em/console/aboutApplication Starting Oracle Enterprise Manager 10g Database Control. If the database is in “Archive Log Mode”, Oracle will make a copy of the online redo log before it gets reused. The Oracle instance (or thread) will use its group of online redologs in a circular manner. When the Oracle Database Configuration Assistant has completed, you will have a fully functional Oracle database running. ISQL*Plus URL: //vmlinux1:5560/isqlplus iSQL*Plus DBA URL: //vmlinux1:5560/isqlplus/dba
Install the Oracle Database 10g Companion CD Release 2 Software After successfully installing the Oracle Database software, the next step is to install the Oracle Database 10g Companion CD Release 2 software (10. When sourcing the oraenv script, it will prompt you for the ORACLE_SID, (defined in your /etc/oratab file), you want to switch to. In this section, we will be downloading and extracting the required software from Oracle to the database server. /bin/sh # chkconfig: 345 99 10 # description: Oracle auto start-stop script. Enterprise Manager – Database Console During the database creation section, we asked for DBCA to create the Enterprise Manager Database Console application. We now need to configure the /etc/hosts file. Sh script, verify the permissions of the file “/etc/oraInst. Dbf’ resize 1024m; SQL> alter tablespace users add datafile size 1024m autoextend off; SQL> create tablespace indx datafile size 1024m 2 autoextend on next 100m maxsize unlimited 3 extent management local autoallocate 4 segment space management auto; SQL> — SYSTEM Tablespace SQL> alter database datafile ‘/u02/oradata/TESTDB/datafile/o1_mf_system_3rbj5g8h_. If you do not install the NCOMP files, the “ORA-29558:JAccelerator (NCOMP) not installed” error occurs when a database that uses Java VM is upgraded to the patch release. Next, login as the oracle user account. In the Release option, select “Oracle 10. Users or third party applications with a different group identifier from that of the database owner (dba and oper for example), which try to access client-side utilities or libraries in the database home, will see permission errors when trying to access these files or directories. Bashrc fi alias ls=”ls -FA” alias s=”screen -DRRS iPad -t iPad” export JAVA_HOME=/usr/local/java # User specific environment and startup programs export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=$ORACLE_BASE/product/10.   For the purpose of this example, we will forgo the “Create Database” option when installing the Oracle Database software. He has been a Sr. Tmp’ resize 1024m; Here is a snapshot of the tablespaces I have defined for my test database environment: SQL> @dba_tablespaces Status Tablespace Name TS Type Ext. 3 $ mv p5337014_10203_LINUX. The terminal shell environment needs to run an X Windows application as the “oracle” user account. A thread must contain at least two online redologs (or online redolog groups). X Windows Server Requirements Beginning with Oracle version 8i, the Oracle Universal Installer (OUI) is a Java application and uses a JRE (Java runtime Environment) shipped on the media. //vmlinux1:1158/em/console/aboutApplication Oracle Enterprise Manager 10g is running. Miscellaneous Options This final section of the article contains several miscellaneous options that may be of use to newcomers of Oracle10g. Specify Inventory directory
and credentials Accept the default values:
   Inventory directory: /u01/app/oracle/oraInventory
   Operating System group name: oinstall Select Installation Type Select the type of installation to perform (Enterprise Edition, Standard Edition, or Custom). To check for the process, type the following: $ emctl status dbconsole TZ set to US/Eastern Oracle Enterprise Manager 10g Database Control Release 10. 0) for Linux x86 Download the Oracle Database 10g Release 2 (10. The JRE shipped by Oracle is the only one supported to run with these applications. When configuring the oracle user’s environment (later in this section) we will be assigning the location of this directory to the $ORACLE_BASE environment variable. 106 melody melody. Then, to turn UDP ICMP rejections off for next server reboot (which should always be turned off): # chkconfig iptables off
Network Configuration During the Linux operating system install we already configured the IP address and host name for the database node.   Oracle Database 10g Release 2 (10. Use the following tasks to put your new database into archive log mode. This option is available since we installed the Oracle Companion CD software. Sql ======================================== Workspace Manager ======================================== wm_create_workspace. ” and click Next to continue. Bash_profile for Oracle User #. For example, you may have two database – ORA920 (using Oracle release 9. Sh accepting all default values. Loc are not set correctly, it is possible you didn’t run orainstRoot. 3/Disk1/runInstaller Oracle 10. Modify the Red Hat Release File One of the first checks performed by the Oracle Universal Installer (OUI) is to determine if the host platform is supported. Summary On the Summary screen, click Install to start the installation. If the permissions to /etc/oraInst. Sh accepting all default values. Hunter and is protected under copyright laws of the United States. Log The easiest way to get around this error is to modify the /etc/redhat-release file replacing the current release information (CentOS release 5 (Final)) with the following: redhat-4 Before modifying /etc/redhat-release, make a backup copy of the file and ensure to replace the original one after the Oracle installation and patch process has been completed. Now that the Oracle DBA scripts have been unzipped and the UNIX environment variable ($ORACLE_PATH) has been set to the appropriate directory, you should now be able to run any of the SQL scripts in your $ORACLE_BASE/dba_scripts/sql while logged into SQL*Plus. 2 Re-execute the Configuration Assitant. 3 Patchset Installation Screen Responses Screen Name Response Welcome Screen Click Next Specify Home Details Set the destination for the ORACLE_HOME Name and Path to that of the previous Oracle10g Database software install as follows:
   Name: OraDb10g_home1
   Path: /u01/app/oracle/product/10. “” = “ORA_DB” ] ; then if [ “$PLATFORM” = “HP-UX” ] ; then remsh $HOST -l $ORACLE -n “

After hardening a system you may run into issues, hardening a system will make it more restrictive, especially SELinux or filesystem related permission hardening. When hardening a system for a specific task I recommend creating a duplicate virtual machine you can use for troubleshooting should you run into a issue that you think is related to security hardening, you’ll be able to confirm by running it on the Vanilla system.

ORA_DB” exit else rsh $HOST -l $ORACLE

To check for the process, type the following: $ emctl status dbconsole TZ set to US/Eastern Oracle Enterprise Manager 10g Database Control Release 10. Installations can no longer be performed using character mode. Sql   When the 10. The last screen of a successful Oracle Database 10g Companion CD Release 2 installation is the “End of Installation” screen. After acknowledging the database creation report and script generation dialog, the database creation will start. Bash_profile login script that was created in the section Create Login Script for oracle User Account. End of Database Creation At the end of the database creation, exit from the DBCA. Last modified on
Monday, 14-Jul-2014 18:05:22 EDT
Page Count: 124042. I left them all at their default settings. When sourcing the oraenv script, it will prompt you for the ORACLE_SID, (defined in your /etc/oratab file), you want to switch to. The thing to keep in mind is that the UNIX oinstall group is completely optional and is not required if the same individuals will be maintaining the software and the database. For example: //vmlinux1:1158/em   I like to review the log files that were created by the DBCA process. Login as the oracle User Account and Set DISPLAY (if necessary) As discussed in the previous section, (Install Oracle Database 10g Software), the terminal shell environment needs to run an X Windows application as the “oracle” user account. ——————————————————————————- Do you wish to continue (y/n) [n]: y Finished running the script successfully Please see /tmp/changePerm_err. Also, the umask setting may be off – it should be 0022. Sql perf_top_sql_by_buffer_gets. Root Script Window – Run root. D/dbora script defined in this section uses the “su -” command to run the Oracle scripts dbstart and dbshut: su – $ORA_OWNER -c “$ORA_HOME/bin/dbstart $ORA_HOME” (and. Also included are the steps required to restore the Red Hat Release File which was modified earlier in this article. 2 file: chmod 755 /usr/lib/libgdbm. Sql
Creating / Altering Tablespaces When creating the Oracle database, we left all tablespaces set to their default size. 0) for Linux x86 Download the Oracle Database 10g Release 2 (10. /u01/app/oracle owned by oracle:oinstall with 775 permissions. If the permissions to /etc/oraInst. 3 $ cd /home/oracle/orainstall/patches/database_10. Database Administrator and Software Engineer for over 20 years and maintains his own website site at: //www. Database Templates Select Custom Database Database Identification Select:
   Global Database Name: TESTDB. D/dbora #. //vmlinux1:1158/em/console/aboutApplication Oracle Enterprise Manager 10g is running. ” and click Next to continue. Jar export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib export THREADS_FLAG=native export TEMP=/tmp export TMPDIR=/tmp
Download the Oracle Database 10g Release 2 Software The next logical step is to install Oracle Database 10g Release 2 (10. 2: cannot open shared object file A workaround was posted on an Oracle forum and consists of the following tasks: As root, create the following symbolic link: ln -s /usr/lib/libgdbm. Log for errors and /tmp/changePerm. For my installation, all checks passed with no problems. 0 $ export DISPLAY
Install Oracle10g Companion CD Software Install the Oracle 10g Companion CD Software as follows: $ cd ~oracle $ /home/oracle/orainstall/companion/runInstaller Oracle Database 10g Companion CD Installation Screen Responses Screen Name Response Welcome Screen Click Next Select a Product to Install Select the Oracle Database 10g Products 10. Now that the Oracle DBA scripts have been unzipped and the UNIX environment variable ($ORACLE_PATH) has been set to the appropriate directory, you should now be able to run any of the SQL scripts in your $ORACLE_BASE/dba_scripts/sql while logged into SQL*Plus. Listener Configuration
(Next 6 Screens) The following screens are now like any other normal listener configuration. 190 george george. End of installation At the end of the installation, exit from the OUI. Verify That the User nobody Exists Before installing the Oracle software, complete the following procedure to verify that the user nobody exists on the system: To determine if the user exists, enter the following command: # id nobody uid=99(nobody) gid=99(nobody) groups=99(nobody) If this command displays information about the nobody user, then you do not have to create that user. Sh After the installation has completed, you will be prompted to run the orainstRoot. Dbf USERS /u02/oradata/TESTDB/datafile/o1_mf_users_3rbj6q3y_. Log for the log of events
Configure Oracle Networking The Database Configuration Assistant (DBCA) requires the Oracle TNS Listener process to be configured and running on the database server before it can create the database. 131 vmlinux3 vmlinux3. His work includes advanced performance tuning, Java and PL/SQL programming, developing high availability solutions, capacity planning, database security, and physical / logical database design in a UNIX / Linux server environment. No support, however, is provided and the license does not permit production use. D/dbora Associate the dbora service with the appropriate run levels and set it to auto-start using the following command: # chkconfig –level 345 dbora on The relevant instances should now startup/shutdown automatically at system startup/shutdown. 0 Copyright (c) 1996, 2006 Oracle Corporation. Dbf’ resize 1024m; SQL> alter tablespace users add datafile size 1024m autoextend off; SQL> create tablespace indx datafile size 1024m 2 autoextend on next 100m maxsize unlimited 3 extent management local autoallocate 4 segment space management auto; SQL> — SYSTEM Tablespace SQL> alter database datafile ‘/u02/oradata/TESTDB/datafile/o1_mf_system_3rbj5g8h_. After running the root. Zip archive to the $ORACLE_BASE directory. Management Option Leave the default options here which is to Configure the Database with Enterprise Manager / Use Database Control for Database Management Database Credentials I selected to Use the Same Password for All Accounts. Please note that this script may take several minutes to complete: $. In this article, I will be downloading the required Oracle software to vmlinux1 and saving it to “~oracle/orainstall”. Although these views provide a simple and easy mechanism to query critical information regarding the database, it helps to have a collection of accurate and readily available SQL scripts to query these views. Zip   (668,734,007 bytes)
Oracle Database 10g Companion CD Release 2 (10. 112 vmlinux2 vmlinux2. # # Change the value of ORACLE_HOME to specify the correct Oracle home # directory for your installation. Before executing the Database Configuration Assistant, make sure that $ORACLE_HOME and $PATH are set appropriately for the $ORACLE_BASE/product/10. 0 Copyright (c) 1996, 2006 Oracle Corporation. Tablespace Size Used (in bytes) Pct. Extract the Oracle Database 10g Software: # su – oracle $ mkdir -p ~oracle/orainstall $ cd ~oracle/orainstall $ unzip 10201_database_linux32. Note that the Oracle database server should have a static IP address configured for the public network (eth0 for this article). 3 patchset will need to be downloaded from the Oracle Metalink website (//metalink. An Oracle instance (i. Select the appropriate components for your environment and click Next to continue. D/dbora script would be defined as follows: /etc/init. INFO for the database domain. Restore the Red Hat Release File Earlier in this article during the Pre-Installation Tasks section, we were required to Modify the Red Hat Release File (/etc/redhat-release) in order for the Oracle Universal Installer to detect a supported platform. Zip
Pre-Installation Tasks This section contains the mandatory tasks that need to be completed before install the Oracle Database 10g software. For example, to query tablespace information while logged into the Oracle database as a DBA user: SQL> @dba_tablespaces Status Tablespace Name TS Type Ext. See your Exceed documentation for instructions on configuring the window manager. When working through this section, substitute the data file names that were created in your environment where appropriate. Modify the Red Hat Release File One of the first checks performed by the Oracle Universal Installer (OUI) is to determine if the host platform is supported. In the above example, if an entry exists for TESTDB, then all required environment variables would be reset to access this database. The terminal shell environment needs to run an X Windows application as the “oracle” user account. Click OK on the “Summary” screen. D/dbora script to be started and stopped when the database server is cycled. I will in no case be liable for any monetary damages arising from such loss, damage or destruction. Furthermore, using the rsh method can be problematic when attempting to use it under Fedora Core 5 and Fedora Core 6 where rsh is deprecated. Application to host any of the material elsewhere can be made by contacting me at [email protected] :$ORACLE_HOME/rdbms/admin export ORACLE_SID=TESTDB export PATH=. In almost all cases, the DBCA will automatically start the OEM Database Console application. 0) for Linux x86 Next, download the Oracle Database 10g Companion CD for Linux x86. This is a FREE account. For this example, I will create a Flash Recovery Area of 10GB. Dbf’ resize 1024m; SQL> — UNDO Tablespace SQL> alter database datafile ‘/u02/oradata/TESTDB/datafile/o1_mf_undotbs1_3rbj61p7_. Database Storage Change any parameters for your environment. If the user nobody does not exist, then enter the following command to create it: # /usr/sbin/useradd nobody
Create the Oracle Base Directory The next step is to create a new directory that will be used to store the Oracle Database software. # mkdir -p /u01/app/oracle # chown -R oracle:oinstall /u01/app/oracle # chmod -R 775 /u01/app/oracle At the end of this procedure, you will have the following: /u01 owned by root. 3 Patchset Installation Screen Responses Screen Name Response Welcome Screen Click Next Specify Home Details Set the destination for the ORACLE_HOME Name and Path to that of the previous Oracle10g Database software install as follows:
   Name: OraDb10g_home1
   Path: /u01/app/oracle/product/10. Downloading the Patchset The Oracle 10. 1 router router. Product-Specific
Prerequisite Checks The installer will run through a series of checks to determine if the node meets the minimum requirements for installing and configuring the Oracle database software. In the Release option, select “Oracle 10. If you have been following the instructions in this article, there should be no Oracle processes running: $ ps -ef | grep ora
Applying the Patchset Once all processes running in the Oracle home directory have been stopped, we can now start the patch installation process. If you haven’t patched the Oracle Database software, there is a documented bug with Oracle 10g Release 2 where calling dbstart might result in the following error message: Failed to auto-start Oracle Net Listener using /ade/vikrkuma_new/oracle/bin/tnslsnr This is due to a hard coded path in the dbstart script. D/dbora – (rsh method) #. 3/Disk1/runInstaller Oracle 10. Network Configuration During the Linux operating system install we already configured the IP address and host name for the database node. This installation type includes the Natively Compiled Java Libraries (NCOMP) files to improve Java performance. Sql ======================================== Workspace Manager ======================================== wm_create_workspace. Members of the dba group can administer Oracle databases, for example starting up and shutting down databases. If you are using a remote client to connect to the node performing the installation (SSH or Telnet to vmlinux1 from a workstation configured with an X Server), you will need to set the DISPLAY variable to point to your local workstation: # hostname vmlinux1 # xhost + access control disabled, clients can connect from any host # su – oracle $ # IF YOU ARE USING A REMOTE CLIENT TO CONNECT TO THE $ # NODE PERFORMING THE INSTALL $ DISPLAY=:0. In this article, we will be taking care of this issue when we install the database software. As of Oracle 10g Release 2 the dbstart script includes the commands to automatically start/stop the listener. 0/db_1 ORA_OWNER=oracle if [. 1 vmlinux1 localhost. End of installation At the end of the installation, exit from the OUI. Summary On the Summary screen, click Install to start the installation. If any of the checks fail, you will need to manually verify the check that failed by clicking on the checkbox. Note that you can utilize the same terminal shell session used in the previous section which in this case, you do not have to take any of the actions described below with regards to setting the DISPLAY variable: # su – oracle $ # IF YOU ARE USING A REMOTE CLIENT TO CONNECT TO THE $ # NODE PERFORMING THE INSTALL $ DISPLAY=:0. Info # # ————- [ LINUX ] ————————————- 192. -f $ORA_HOME/bin/dbstart ] then echo “Oracle startup: cannot start” exit fi case “” in ‘start’) # Start the Oracle databases: # The following command assumes that the oracle login # will not prompt the user for any values su – $ORA_OWNER -c “$ORA_HOME/bin/dbstart $ORA_HOME” ;; ‘stop’) # Stop the Oracle databases: # The following command assumes that the oracle login # will not prompt the user for any values su – $ORA_OWNER -c “$ORA_HOME/bin/dbshut $ORA_HOME” ;; esac   Note that the /etc/init. Sql ======================================== Automatic Storage Management ======================================== asm_alias. Sh before running root. Whatever the case may be, you need an efficient way to modify your environment variables to switch between these two databases. Final Notes The /etc/init. 0 $ export DISPLAY To start the NETCA, run the following: $ netca & Oracle Network Configuration Installation Screen Responses Screen Name Response Welcome Select Listener configuration. Running this script should be done only after considering all security ramifications. Confirm the Node Name is Not Listed in Loopback Address Ensure that the node name (vmlinux1) is not included for the loopback address in the /etc/hosts file. From the Simple Search screen, select the “Product or Family” option in the Search By pull-down listing. Specify Home Details Set the destination for the ORACLE_HOME Name and Path to that of the previous Oracle10g Database software install as follows:
   Name: OraDb10g_home1
   Path: /u01/app/oracle/product/10. This section will provide the steps necessary to configure the database server to successfully run the Oracle Universal Installer (OUI). For UNIX verify the following environment variable is set and included in your login shell script: ORACLE_PATH=ORACLE_PATH=$ORACLE_BASE/dba_scripts/sql:. Dbf’ resize 1024m; SQL> — Temporary Tablespace SQL> alter database tempfile ‘/u02/oradata/TESTDB/datafile/o1_mf_temp_3rbj6f1s_. 111 vmlinux1 vmlinux1. Automatic Database Startup/Shutdown in Oracle10g Once the instance is created, edit the /etc/oratab file setting the restart flag (the last field) to “Y” for the instance you want to automatically startup and shutdown. Used ——— ————— ———— ———- ——— —————— —————— ——— ONLINE UNDOTBS1 UNDO LOCAL MANUAL 241,172,480 239,075,328 99 ONLINE SYSAUX PERMANENT LOCAL AUTO 272,629,760 270,663,680 99 ONLINE USERS PERMANENT LOCAL AUTO 5,242,880 65,536 1 ONLINE SYSTEM PERMANENT LOCAL MANUAL 513,802,240 503,250,944 98 ONLINE TEMP TEMPORARY LOCAL MANUAL 29,360,128 28,311,552 96 —————— —————— ——— avg 79 sum 1,062,207,488 1,041,367,040 To obtain a list of all available Oracle DBA scripts while logged into SQL*Plus, run the help. TESTDB) will have its own set of online redolog files known as a thread. Original # echo “redhat-4” > /etc/redhat-release
Install the Oracle Database 10g Release 2 Software We are now ready to install the Oracle Database 10g Release 2 software. 0/db_1/vmlinux1_TESTDB/sysman/log If you recieve something similar to the above output, then OEM Database Console is running. If the machine name is listed in the in the loopback address entry as below: 127. The JRE shipped by Oracle is the only one supported to run with these applications. Post-Installation Tasks This section contains several tasks that can be applied to your new Oracle 10g environment in order to enhance availability as well as database management. Zip archive will be copied to /u01/app/oracle. 102 alex alex. New UNIX password: xxxxxxxxxxx Retype new UNIX password: xxxxxxxxxxx passwd: all authentication tokens updated successfully. Note that you can utilize the same terminal shell session used in the previous section which in this case, you do not have to take any of the actions described below with regards to setting the DISPLAY variable: # su – oracle $ # IF YOU ARE USING A REMOTE CLIENT TO CONNECT TO THE $ # NODE PERFORMING THE INSTALL $ DISPLAY=:0. 0/db_1 # # Change the value of ORACLE to the login name of the # oracle owner at your site. Known Issues The following known issue does not apply to this article since we applied the Oracle 10. Next, login as the oracle user account. Dbf TEMP /u02/oradata/TESTDB/datafile/o1_mf_temp_3rbj6f1s_. /u01/app owned by root. 1 localhost. Below are several optional SQL commands for modifying and creating all tablespaces for the test database. The RSH server does not get installed by default on many Linux distributions (and for good reason. For my installation, all checks passed with no problems. 0) for Linux x86 software. As already mentioned, Oracle writes to its online redolog files in a circular manner. Please note that Oracle Corporation recommends using the most restrictive file permissions as possible for your given implementation. This ownership and permissions enables the OUI to create the oraInventory directory, in the path /u01/app/oracle/oraInventory. Next, create a text file named /etc/init. 0 chmod 755 /usr/lib/libdb. If the database is in “Archive Log Mode”, Oracle will make a copy of the online redo log before it gets reused. 0) 10201_database_linux32. 0 $ export DISPLAY
Stop All Oracle Processes Before starting the OUI to install the patch set, we need to stop all listeners and other processes running in the Oracle home directory. When the Oracle Database Configuration Assistant has completed, you will have a fully functional Oracle database running. Welcome Click Finish to exit the NETCA. In this example, I will use “~oracle/orainstall”. It is even possible to be using two different databases running on different releases of the Oracle Database software. D/dbora script listed above may look a little different from a similar one used for Oracle9i — most notably the omission of the commands to start/stop the Oracle TNS listener process.    Flash Recovery Area: /u02/flash_recovery_area
   Flash Recovery Area Size: 10240 Database Content I left all of the Database Components (and destination tablespaces) set to their default value, although it is perfectly OK to select the Sample Schemas. After logging in to the Oracle Metalink website, click on the “Patches & Updates” tab on the top menu and use the following to download the correct database patchset: On the “Patches & Updates” screen, select the link for Simple Search. Other Java applications that utilize the JRE are the Database Configuration Assistant and the Oracle Net Assistant. When configuring the oracle user’s environment (later in this section) we will be assigning the location of this directory to the $ORACLE_BASE environment variable. For the case of Red Hat Enterprise Linux, Oracle Database 10g Release 2 expects either RHEL 3 or RHEL/OL 4. Initialization Parameters Change any parameters for your environment. 106 melody melody. NOTE: After executing the orainstRoot. 132 vmlinux4 vmlinux4. This may take some time to download. The Oracle TNS listener process should now be running: $ ps -ef | grep lsnr | grep -v ‘grep’ | awk ‘{print }’ LISTENER
Create the Oracle Database We will be using the Oracle Database Configuration Assistant (DBCA) to create a database / instance named TESTDB. $ su – # cp /etc/redhat-release /etc/redhat-release. Note that you can utilize the same terminal shell session used in the previous section which in this case, you do not have to take any of the actions described below with regards to setting the DISPLAY variable: # su – oracle $ # IF YOU ARE USING A REMOTE CLIENT TO CONNECT TO THE $ # NODE PERFORMING THE INSTALL $ DISPLAY=:0. To do this, run the OUI installer (runInstaller) out of the directory where you extracted the patch set to as the oracle UNIX user account: $ id -a uid=501(oracle) gid=501(oinstall) groups=501(oinstall),502(dba),503(oper) $ cd ~oracle $ /home/oracle/orainstall/patches/database_10.   If you do not currently have an account with Oracle OTN, you will need to create one. In this article, we are creating the oracle user account to have both responsibilities. You should also verify that the Oracle TNS listener service is running before attempting to start the database creation process. Localdomain localhost
Remove IPv6 Entries Remove any entry that has to do with IPv6 (for example, ::1 localhost6. 3 Database Patchset At the time of this writing, the latest patchset for Oracle Database 10g Release 2 running on Linux x86 (32-bit) is 10. Privileged Operating
System Groups Select the UNIX groups that will be used for each of the Oracle group names as follows:    Database Administrator (OSDBA) Group: dba
   Database Operator (OSOPER) Group: oper
Create Database Select the option to Install database Software only. TESTDB Notice that in the above example, we didn’t just run the oraenv script, but rather, we sourced it by using a dot followed by a space and then the script name oraenv. If you selected to configure Enterprise Manager during the database creation process, the OUI will provide the URL. Bash_profile for Oracle User #. Note that you can utilize the same terminal shell session used in the previous section which in this case, you do not have to take any of the actions described below with regards to setting the DISPLAY variable: # su – oracle $ # IF YOU ARE USING A REMOTE CLIENT TO CONNECT TO THE $ # NODE PERFORMING THE INSTALL $ DISPLAY=:0. Login to the database server as the “oracle” user account. ISQL*Plus URL: //vmlinux1:5560/isqlplus iSQL*Plus DBA URL: //vmlinux1:5560/isqlplus/dba
Install the Oracle Database 10g Companion CD Release 2 Software After successfully installing the Oracle Database software, the next step is to install the Oracle Database 10g Companion CD Release 2 software (10. Sh Script on an Oracle Database Server Home During patch set installation, all new files and directories are created with restricted access, by default. 0) 10201_companion_linux32. Create Directory for Database Files Let’s now create the directory that will be used to store the Oracle database files and backup files (on the /u02 file system): # mkdir -p /u02/oradata # chown oracle:oinstall /u02/oradata # chmod 775 /u02/oradata # mkdir -p /u02/flash_recovery_area # chown oracle:oinstall /u02/flash_recovery_area # chmod 775 /u02/flash_recovery_area
Create Login Script for oracle User Account To ensure that the environment is setup correctly for the “oracle” UNIX user account, use the following. Original /etc/redhat-release
Re-compile Invalid Objects Run the utlrp. 2 Re-execute the Configuration Assitant. If you do not install the NCOMP files, the “ORA-29558:JAccelerator (NCOMP) not installed” error occurs when a database that uses Java VM is upgraded to the patch release. 3 $ mv p5337014_10203_LINUX. Loc” are 644 (-rw-r–r–) and owned by root:root. Oracle Database 10g Release 2 (10. Keep in mind that this domain does not have to be a valid DNS domain.   For the purpose of this example, we will forgo the “Create Database” option when installing the Oracle Database software. The last screen of a successful Oracle Database 10g Release 2 installation is the “End of Installation” screen. Changing Your Oracle Database Environment In some cases, you may have more than one database running on your single database server. # # Set ORA_HOME to be equivalent to the $ORACLE_HOME # from which you wish to execute dbstart and dbshut; # # Set ORA_OWNER to the user id of the owner of the # Oracle database in ORA_HOME. For the purpose of this example, the dba_scripts_archive_Oracle. The Oracle DBA scripts archive can be downloaded using the following link //www. 0, asianux-1 or asianux-2 Failed grant dba, resource, connect to scott; SQL> alter database datafile ‘/u02/oradata/TESTDB/datafile/o1_mf_users_3rbj6q3y_. Enter the password (twice) and make sure the password does not start with a digit number. Given the Oracle database installation is now completed, we should now restore the original version of this file: $ su – # cp /etc/redhat-release. In this section, we will be downloading and extracting the required software from Oracle to the database server. When all of the options are filled out, click the “Go” button. Bash_profile: Login to the database server as the oracle user account: # su – oracle. Bashrc fi alias ls=”ls -FA” alias s=”screen -DRRS iPad -t iPad” export JAVA_HOME=/usr/local/java # User specific environment and startup programs export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=$ORACLE_BASE/product/10. 3 (also known as patch 5337014). —————————————————————— Logs are generated in directory /u01/app/oracle/product/10. All articles, scripts and material located at the Internet address of //www. At the same time, it also prevents database administrators from making modifications to the database software and the installation’s Inventory directory. 0 $ export DISPLAY
Create the Database To start the database creation process, run the following: $ dbca & Screen Name Response Welcome Screen Click Next Operations Select Create a Database. Hunter and is protected under copyright laws of the United States. Jeff graduated from Stanislaus State University in Turlock, California, with a Bachelor’s degree in Computer Science and Mathematics. For the purpose of the example in this article, my log files were created in “/u01/app/oracle/product/10. Jeff’s other interests include mathematical encryption theory, tutoring advanced mathematics, programming language processors (compilers and interpreters) in Java and C, LDAP, writing web-based database administration tools, and of course Linux.   Oracle Database 10g Release 2 (10. In the text field to the right, enter “RDBMS Server”. Sh ——————————————————————————- Disclaimer: The purpose of this script is to relax permissions on some of the files in the database Oracle Home so that all clients can access them. Problems can occur during the installation of Oracle if the oracle user account does not have read permissions to this file – (the location of the oraInventory directory cannot be determined). :$ORACLE_HOME/rdbms/admin export ORACLE_PATH   Note that the ORACLE_PATH environment variable should already be set in the. Zip The final step is to verify (or set) the appropriate environment variable for the current UNIX shell to ensure the Oracle SQL scripts can be run from SQL*Plus while in any directory. Next, unzip the archive file to the $ORACLE_BASE directory. Zip /u01/app/oracle $ cd /u01/app/oracle $ unzip dba_scripts_archive_Oracle. ) su – $ORA_OWNER -c “$ORA_HOME/bin/dbshut $ORA_HOME” Starting with Oracle10g, Oracle switched from recommending the “su” command to the “rsh” command of which I completely disagree with. The OUI uses the file /etc/redhat-release to determine the platform. 245 accesspoint accesspoint. Miscellaneous Options This final section of the article contains several miscellaneous options that may be of use to newcomers of Oracle10g. 105 bartman bartman. In this section you will download and install a collection of Oracle DBA scripts that can be used to manage many aspects of your database including space management, performance, backups, security, and session management. Bring up the Network Configuration Assistant (NETCA) and run through the process of creating a new TNS listener process and to also configure the node for local access. For the purpose of this article, I will be downloading and installing patch: 5337014. 0/db_1 directory and run root. Dbf’ resize 1024m; SQL> — SYSAUX Tablespace SQL> alter database datafile ‘/u02/oradata/TESTDB/datafile/o1_mf_sysaux_3rbj68np_. D/dbora as the root user, containing the following: /etc/init. Sh script go back to the OUI and acknowledge the “Execute Configuration scripts” dialog window. Zip Extract the Oracle Database 10g Companion CD Software: $ cd ~oracle/orainstall $ unzip 10201_companion_linux32. This document may not be hosted on any other site without my express, prior, written permission. I selected the Custom option for this example given I wanted to install Oracle Label Security and other components not available with the Enterprise or Standard Edition installation option. This article (along with other Oracle installation guides on this site) adhere to the Optimal Flexible Architecture (OFA) and create both the oinstall and dba UNIX groups. 0/db_1 Summary On the Summary screen, click Install to start the installation. Click Finish to start the database creation process. We will, instead, create the database using the Database Configuration Assistant (DBCA) after all of the software and patches have been installed. Given the RSH server (and other r* packages) do not get installed by default, the DBA would need to locate and install them before this method could be used: # — Install the rhs and rsh-server packages from the OS CD/DVD — # rpm -Uvh –force rsh-* # — Enable rsh and rlogin — # chkconfig rsh on # chkconfig rlogin on # service xinetd reload I completely disagree with the recommendation to use rsh and prefer to stick with using the su command method. Storage Options For this article, we will select to use File System. Finally, for the Platform or Language option, select “Linux x86”. 3 $ unzip p5337014_10203_LINUX. Root Script Window – Run root. Localdomain localhost it should be removed as shown below: 127. Zip (last updated 21-FEB-2007) and is 900MB in size. X Windows Server Requirements Beginning with Oracle version 8i, the Oracle Universal Installer (OUI) is a Java application and uses a JRE (Java runtime Environment) shipped on the media. Login as the oracle User Account and Set DISPLAY (if necessary) As discussed in the previous section, the terminal shell environment needs to run an X Windows application as the “oracle” user account. Info is the copyright of Jeffrey M. For the purpose of this example, the only instance defined in the /etc/oratab file is TESTDB: /etc/oratab. 0/db_1 Available Product Components If you selected the Custom installation type, the next screen (Available Product Components) allows you to select from all available components. Please keep in mind that this is an optional step. Localdomain localhost # 192. 0) and TESTDB (using Oracle release 10. Do not use DHCP naming for the public IP address; you need a static IP address.   Access to Oracle Metalink requires a valid login and CSI number. This is a process known as archiving. In cases like this where the database is in no archive log mode, it is a simple task to put the database into archive log mode. For example, you may have two database – ORA920 (using Oracle release 9. When using the rsh method, the /etc/init. Some consider it unnecessary work which adds another layer of complexity to the maintenance of the installation. End of installation At the end of the installation, exit from the OUI. 2 Change the permissions in the libdb. Sql ======================================== Automatic Shared Memory Management ======================================== asmm_components. 0) and optionally the Companion CD Release 2 (10. He has been a Sr. Expected result: 3036MB
Actual Result: 1983MB In most cases, you will have the minimum required swap space (as shown above) and this can be safely ignored. The Oracle documentation uses the following definitions when describing the UNIX groups: The oinstall group (the Oracle Inventory group) The dba group (the OSDBA group) The oper group (the OSOPER group) If you intend to use the oinstall group during the installation process, then you must set the default group to the one that will be maintaining the database before creating the database or permission problems will arise. Sh and specify the patched server Oracle home location, before accessing client-side utilities or libraries in the database home. Oracle offers a development and testing license free of charge. Copyright (c) 1998-2017 Jeffrey M. For example, perform the following as the oracle user account: $ mv dba_scripts_archive_Oracle. For the purpose of this article, my testing database will often make use of the Java Virtual Machine (Java VM) and Oracle interMedia and therefore will require the installation of the Oracle Database 10g Companion CD. Open a new console window as the “root” user account. The following query can be used to determine the file names for your environment: SQL> select tablespace_name, file_name 2 from dba_data_files 3 union 4 select tablespace_name, file_name 5 from dba_temp_files; TABLESPACE_NAME FILE_NAME ————— ——————————————————— SYSAUX /u02/oradata/TESTDB/datafile/o1_mf_sysaux_3rbj68np_. 0/db_1 Product-Specific
Prerequisite Checks The installer will run through a series of checks to determine if the node meets the minimum requirements for installing and configuring the Oracle10g Companion CD Software. Sh script, verify the permissions of the file “/etc/oraInst. The UNIX group oinstall is used by organizations that have separate teams responsible for maintaining the Oracle software and the database(s). Loc are not set correctly, it is possible you didn’t run orainstRoot. Enterprise Manager – Database Console During the database creation section, we asked for DBCA to create the Enterprise Manager Database Console application. The OUI provides you with several URLs that will be activated by the OUI: The following J2EE Applications have been deployed and are accessible at the URLs listed below. Open a new console window as the “root” user account. /bin/sh # chkconfig: 345 99 10 # description: Oracle auto start-stop script. —————————————————————— Logs are generated in directory /u01/app/oracle/product/10. Used ——— ————— ———— ———- ——— —————— —————— ——— ONLINE UNDOTBS1 UNDO LOCAL MANUAL 1,073,741,824 239,075,328 22 ONLINE SYSAUX PERMANENT LOCAL AUTO 1,073,741,824 270,663,680 25 ONLINE USERS PERMANENT LOCAL AUTO 2,147,483,648 131,072 0 ONLINE SYSTEM PERMANENT LOCAL MANUAL 1,073,741,824 503,250,944 47 ONLINE INDX PERMANENT LOCAL AUTO 1,073,741,824 65,536 0 ONLINE TEMP TEMPORARY LOCAL MANUAL 1,073,741,824 28,311,552 3 —————— —————— ——— avg 16 sum 7,516,192,768 1,041,498,112 6 rows selected. I have made every effort and taken great care in making sure that the material included on my web site is technically accurate, but I disclaim any and all responsibility for any loss, damage or destruction of data or any other property which may arise from relying on it. Once the DB Console application is up and running, point your web browser to //:1158/em as in the following: //vmlinux1:1158/em Login: User Name: SYSTEM Password: Connect As: Normal   The emctl start dbconsole / emctl stop dbconsole commands can be placed in the /etc/init. The OUI will immediately fail if it doesn’t recognize either of these two platforms: $ /home/oracle/orainstall/database/runInstaller Starting Oracle Universal Installer. Note that members of the UNIX group oinstall are considered the “owners” of the Oracle software. Log The easiest way to get around this error is to modify the /etc/redhat-release file replacing the current release information (CentOS release 5 (Final)) with the following: redhat-4 Before modifying /etc/redhat-release, make a backup copy of the file and ensure to replace the original one after the Oracle installation and patch process has been completed. INFO
   SID: TESTDB   I used IDEVELOPMENT. Bash_profile # Get the aliases and functions if [ -f ~/. We now need to configure the /etc/hosts file. About the Author Jeffrey Hunter is an Oracle Certified Professional, Java Development Certified Professional, Author, and an Oracle ACE. The Oracle Database 10g Release 2 Patch Set 2 has now been successfully applied. Zip   (705,274,421 bytes) As the “oracle” user account, extract the two packages you downloaded to a temporary directory. I left them all at their default settings. Sh After the patch installation has completed, you will be prompted to run the root. A full description of the license agreement is available on OTN. 0/db_1/vmlinux1_TESTDB/sysman/log The OEM DB Console application may take several minutes to start. If you need to manually start this application, login as the UNIX oracle user account and type the following: $ emctl start dbconsole TZ set to US/Eastern Oracle Enterprise Manager 10g Database Control Release 10. Info
Create “oracle” User and Directories This section covers the steps required to create the UNIX groups (oinstall, dba, and oper) and user (oracle) that will be used to install the Oracle Database 10g software. For the Patch Type option, select “Patchset/Minipack”. A thread must contain at least two online redologs (or online redolog groups). After the directory is created, you must then specify the correct owner, group, and permissions for it. Remember that we will create the database as a separate step using DBCA. Login to the database server as the “oracle” user account and shutdown the database: $ id -a uid=501(oracle) gid=501(oinstall) groups=501(oinstall),502(dba),503(oper) $ sqlplus “/ as sysdba” SQL> shutdown immediate Next, MOUNT the database: SQL> startup mount Enable archiving: SQL> alter database archivelog; Open the database for read/write which is now in archivelog mode: SQL> alter database open; Login to the database and verify Archive Log Mode is enabled: SQL> archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 27 Next log sequence to archive 29 Current log sequence 29
Download and Install Custom Oracle Database Scripts – (Optional) DBA’s rely on Oracle’s data dictionary views and dynamic performance views in order to support and better manage their databases. The OUI provides you with several URLs that will be activated by the OUI: Ultra Search URL: //vmlinux1:5620/ultrasearch Ultra Search Administration Tool URL: //vmlinux1:5620/ultrasearch/admin
  It has been reported that for users who installed the 10g Apache server standalone from the Companion CD on CentOS 5 (which is not discussed in this article), elicits the following error from the configuration assistant: libdb. Select this patchset in the Results section and then click the Download button to start the download process. Sh accepting all default values. Use the chmod command to set the privileges to 750: # chmod 750 /etc/init. To correct this, edit the $ORACLE_HOME/bin/dbstart script and replace the following line (approximately line 78): ORACLE_HOME_LISTNER=/ade/vikrkuma_new/oracle with this: ORACLE_HOME_LISTNER=$ORACLE_HOME The dbstart script shold now start the listener as expected. This can be downloaded from the same page used to download the Oracle Database software:   Oracle Database 10g Companion CD Release 2 (10. Oraenv ORACLE_SID = [ORA920]. Naming Methods Configuration The following screens are:
   Selected Naming Methods: Local Naming
   Naming Methods configuration complete. Creation Options Keep the default option Create Database selected. Navigate to the /u01/app/oracle/oraInventory directory and run orainstRoot. Sh script go back to the OUI and acknowledge the “Execute Configuration scripts” dialog window. Prior to modifying the Red Hat Release File, we made a backup copy of the original file. After running the root. It is possible to receive an error about the available swap space not meeting its minimum requirements: Checking available swap space requirements. Specify Inventory directory
and credentials Accept the default values:
   Inventory directory: /u01/app/oracle/oraInventory
   Operating System group name: oinstall Select Installation Type Select the type of installation to perform (Enterprise Edition, Standard Edition, or Custom). In this type of scenario, all that would be required is the UNIX group dba (and assigning dba as the primary UNIX group for the “oracle” user account). 3 patch set is applied to an Oracle Database 10g Standard Edition database or Standard Edition One database, there may be 42 invalid objects after the utlrp. Perform the following steps to change the permissions so that groups other then just the database owner (for this example, the database owner is oracle:oinstall) can access client-side utilities and libraries. Setting up Automatic Database Starting and Stopping This section contains the recommended method defined by Oracle for automating database startup and shutdown of Oracle10g and Oracle11g instances. Tmp UNDOTBS1 /u02/oradata/TESTDB/datafile/o1_mf_undotbs1_3rbj61p7_. :${JAVA_HOME}/bin:$JAVA_HOME/db/bin:${PATH}:$HOME/bin:$ORACLE_HOME/bin export PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin export PATH=${PATH}:$ORACLE_BASE/dba_scripts/bin export ORACLE_TERM=xterm export TNS_ADMIN=$ORACLE_HOME/network/admin export ORA_NLS10=$ORACLE_HOME/nls/data export NLS_DATE_FORMAT=”DD-MON-YYYY HH24:MI:SS” export LD_LIBRARY_PATH=$ORACLE_HOME/lib export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib export CLASSPATH=. When the current online redolog fills, Oracle will switch to the next one. Tablespace Size Used (in bytes) Pct. However, we must first download and extract the required Oracle software packages from the Oracle Technology Network (OTN). Welcome Select Naming Methods configuration. If you have been following along with this article, the required scripts for switching your Oracle database environment is already included (in /usr/local/bin). Sql script: SQL> @help. You may use any domain. Tmp’ resize 1024m; Here is a snapshot of the tablespaces I have defined for my test database environment: SQL> @dba_tablespaces Status Tablespace Name TS Type Ext. Database File Locations Select the option to use Use Oracle-Managed Files:
   Database Area: /u02/oradata Recovery Configuration Check the option for Specify Flash Recovery Area. Use the following tasks to put your new database into archive log mode. Install the Oracle Database 10g Release 2 Software Install the Oracle Database 10g Release 2 software as follows: $ cd ~oracle $ /home/oracle/orainstall/database/runInstaller Oracle Database 10g Software Installation Screen Responses Screen Name Response Select Installation Method Select the Advanced Method option and click Next to start the installation process. /bin/sh # chkconfig: 345 99 10 # description: Oracle auto start-stop script. Checking operating system version: must be redhat-3, SuSE-9, redhat-4, UnitedLinux-1. Although this can be done manually at the command line, it can get old real quick. 0) Software for Linux x86. //vmlinux1:1158/em/console/aboutApplication Starting Oracle Enterprise Manager 10g Database Control. I also always select to Generate Database Creation Scripts. 0 $ export DISPLAY   If you are using Hummingbird’s Exceed X-Windows emulator while installing and using Oracle10g, set the window manager to run in “Native” mode so that Microsoft windows functions as the window manager. Click Next to continue. Users or third party applications with a different group identifier from that of the database owner (dba and oper for example), which try to access client-side utilities or libraries in the database home, will see permission errors when trying to access these files or directories. Change to the install directory by using the following command: $ cd $ORACLE_HOME/install Run changePerm. Simply click the check-box for “Checking available swap space requirements. The type of installation to perform will be the Oracle Database 10g Products installation type. Sql script to recompile all invalid PL/SQL packages now instead of when the packages are accessed for the first time. This option is available since we installed the Oracle Companion CD software. Navigate to the /u01/app/oracle/product/10. Note however that this will require a short database outage. Located in Pittsburgh, Pennsylvania. [ Next ]
You will be returned to this Welcome (Type of Configuration) Screen. Zip
Login as the oracle User Account and Set DISPLAY (if necessary) As discussed in the previous section, (Install the Oracle Database 10g Companion CD Release 2 Software), the terminal shell environment needs to run an X Windows application as the “oracle” user account. The Oracle instance (or thread) will use its group of online redologs in a circular manner. If you are using a large set of drives for database storage, you may want to make a sizable testing database.   This guide adheres to the Optimal Flexible Architecture (OFA) for naming conventions used in creating the directory structure. Once an online redolog fills, Oracle moves to the next one. As the oracle user account, download the dba_scripts_archive_Oracle. Dbf SYSTEM /u02/oradata/TESTDB/datafile/o1_mf_system_3rbj5g8h_. To facilitate media recovery, Oracle allows the DBA to put the database into “Archive Log Mode” which makes a copy of the online redolog after it fills (and before it gets reused). Specify Home Details Set the Name and Path for the ORACLE_HOME as follows:
   Name: OraDb10g_home1
   Location: /u01/app/oracle/product/10. 1 localhost. If any of the checks fail, you will need to manually verify the check that failed by clicking on the checkbox. The Database Configuration Assistant (DBCA) allows users to configure a new database to be in archive log mode, however most DBA’s opt to bypass this option during initial database creation. This will bring up the available patchsets in the Results section. This step is optional but recommended. Navigate to the /u01/app/oracle/product/10. Ignore any messages indicating that the database contains invalid recycle bin objects similar to the following: BINlzljWIt9gfgMFeM2hVSoA==

  If you are using Hummingbird’s Exceed X-Windows emulator while installing and using Oracle10g, set the window manager to run in “Native” mode so that Microsoft windows functions as the window manager. See your Exceed documentation for instructions on configuring the window manager.

Enabling Archive Logs – (Optional) Oracle tracks and logs all changes to database blocks in online redolog files. Jeff currently works as a Senior Database Administrator for The DBA Zone, Inc. NOTE: Please keep in mind that the database file names (OMF files) being listed in these examples may differ from what the Oracle Database Configuration Assistant (DBCA) creates for your environment. Summary Click Install to start the installation. This requires you update environment variables like ORACLE_HOME, ORACLE_SID, PATH, LD_LIBRARY_PATH, etc. 120 cartman cartman. Sample /etc/hosts File The following is an example /etc/hosts file I used for this article: Sample /etc/hosts File # Do not remove the following line, or various programs # that require network functionality will fail. These objects belong to the unsupported components and do not affect the database operation.   You must install the Oracle database software from an X windows workstation, an X terminal, or a PC or other system with X server software installed.
Extract the Patch File As the oracle user account, extract the patch file to a temporary directory: $ id -a uid=501(oracle) gid=501(oinstall) groups=501(oinstall),502(dba),503(oper) $ mkdir -p /home/oracle/orainstall/patches/database_10. In situations like this, the group membership prevents unauthorized access to the database by personal who only maintain the Oracle software.

ORA_DB exit fi fi # case in ‘start’) $ORACLE_HOME/bin/dbstart $ORACLE_HOME ;; ‘stop’) $ORACLE_HOME/bin/dbshut $ORACLE_HOME ;; *) echo “usage:

To determine all current shared memory limits, use the following: # ipcs -lm —— Shared Memory Limits ——– max number of segments = 4096 max seg size (kbytes) = 4194303 max total shared memory (kbytes) = 1073741824 min seg size (bytes) = 1.

{start|stop}” exit ;; esac # exit Note that this method relies on the presence of an RSH server, which requires additional packages and configuration. For the case of Red Hat Enterprise Linux, Oracle Database 10g Release 2 expects either RHEL 3 or RHEL/OL 4. INFO for the database domain. 0/db_1 ORA_OWNER=oracle if [. See your Exceed documentation for instructions on configuring the window manager. Used ——— ————— ———— ———- ——— —————— —————— ——— ONLINE UNDOTBS1 UNDO LOCAL MANUAL 241,172,480 239,075,328 99 ONLINE SYSAUX PERMANENT LOCAL AUTO 272,629,760 270,663,680 99 ONLINE USERS PERMANENT LOCAL AUTO 5,242,880 65,536 1 ONLINE SYSTEM PERMANENT LOCAL MANUAL 513,802,240 503,250,944 98 ONLINE TEMP TEMPORARY LOCAL MANUAL 29,360,128 28,311,552 96 —————— —————— ——— avg 79 sum 1,062,207,488 1,041,367,040 To obtain a list of all available Oracle DBA scripts while logged into SQL*Plus, run the help. Sql script: SQL> @help. If the machine name is listed in the in the loopback address entry as below: 127. Expected result: 3036MB
Actual Result: 1983MB In most cases, you will have the minimum required swap space (as shown above) and this can be safely ignored. Dbf SYSTEM /u02/oradata/TESTDB/datafile/o1_mf_system_3rbj5g8h_. For the Patch Type option, select “Patchset/Minipack”. After logging in to the Oracle Metalink website, click on the “Patches & Updates” tab on the top menu and use the following to download the correct database patchset: On the “Patches & Updates” screen, select the link for Simple Search. 105 bartman bartman. Naming Methods Configuration The following screens are:
   Selected Naming Methods: Local Naming
   Naming Methods configuration complete. I left them all at their default settings. 0) 10201_companion_linux32. Zip /u01/app/oracle $ cd /u01/app/oracle $ unzip dba_scripts_archive_Oracle. # mkdir -p /u01/app/oracle # chown -R oracle:oinstall /u01/app/oracle # chmod -R 775 /u01/app/oracle At the end of this procedure, you will have the following: /u01 owned by root. Note that you can utilize the same terminal shell session used in the previous section which in this case, you do not have to take any of the actions described below with regards to setting the DISPLAY variable: # su – oracle $ # IF YOU ARE USING A REMOTE CLIENT TO CONNECT TO THE $ # NODE PERFORMING THE INSTALL $ DISPLAY=:0. 0 $ export DISPLAY
Create the Database To start the database creation process, run the following: $ dbca & Screen Name Response Welcome Screen Click Next Operations Select Create a Database. Problems can occur during the installation of Oracle if the oracle user account does not have read permissions to this file – (the location of the oraInventory directory cannot be determined). Database Storage Change any parameters for your environment.   This guide adheres to the Optimal Flexible Architecture (OFA) for naming conventions used in creating the directory structure. Note that members of the UNIX group oinstall are considered the “owners” of the Oracle software. Summary Click Install to start the installation. If the user nobody does not exist, then enter the following command to create it: # /usr/sbin/useradd nobody
Create the Oracle Base Directory The next step is to create a new directory that will be used to store the Oracle Database software. Dbf’ resize 1024m; SQL> — SYSAUX Tablespace SQL> alter database datafile ‘/u02/oradata/TESTDB/datafile/o1_mf_sysaux_3rbj68np_. When working through this section, substitute the data file names that were created in your environment where appropriate. 0 Copyright (c) 1996, 2006 Oracle Corporation. When using the rsh method, the /etc/init. Finally, for the Platform or Language option, select “Linux x86”. If you haven’t patched the Oracle Database software, there is a documented bug with Oracle 10g Release 2 where calling dbstart might result in the following error message: Failed to auto-start Oracle Net Listener using /ade/vikrkuma_new/oracle/bin/tnslsnr This is due to a hard coded path in the dbstart script. Login to the database server as the “oracle” user account. 3 $ unzip p5337014_10203_LINUX. # ORACLE=oracle PATH=${PATH}:$ORACLE_HOME/bin HOST=`hostname` PLATFORM=`uname` export ORACLE_HOME PATH # if [. Dbf’ resize 1024m; SQL> — Temporary Tablespace SQL> alter database tempfile ‘/u02/oradata/TESTDB/datafile/o1_mf_temp_3rbj6f1s_. Zip (last updated 21-FEB-2007) and is 900MB in size. In the above example, if an entry exists for TESTDB, then all required environment variables would be reset to access this database. Automatic Database Startup/Shutdown in Oracle10g Once the instance is created, edit the /etc/oratab file setting the restart flag (the last field) to “Y” for the instance you want to automatically startup and shutdown. 0 $ export DISPLAY
Install Oracle10g Companion CD Software Install the Oracle 10g Companion CD Software as follows: $ cd ~oracle $ /home/oracle/orainstall/companion/runInstaller Oracle Database 10g Companion CD Installation Screen Responses Screen Name Response Welcome Screen Click Next Select a Product to Install Select the Oracle Database 10g Products 10. Select this patchset in the Results section and then click the Download button to start the download process. End of installation At the end of the installation, exit from the OUI. 0/db_1 directory and run root. Changing Your Oracle Database Environment In some cases, you may have more than one database running on your single database server. 0) and TESTDB (using Oracle release 10. This may take some time to download. 1 localhost. End of Database Creation At the end of the database creation, exit from the DBCA. 0) for Linux x86 Next, download the Oracle Database 10g Companion CD for Linux x86. This document may not be hosted on any other site without my express, prior, written permission. For example: //vmlinux1:1158/em   I like to review the log files that were created by the DBCA process. —————————————————————— Logs are generated in directory /u01/app/oracle/product/10. Zip archive will be copied to /u01/app/oracle. Tablespace Size Used (in bytes) Pct. Keep in mind that this domain does not have to be a valid DNS domain. Remember that we will create the database as a separate step using DBCA. Jar export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib export THREADS_FLAG=native export TEMP=/tmp export TMPDIR=/tmp
Download the Oracle Database 10g Release 2 Software The next logical step is to install Oracle Database 10g Release 2 (10. Oracle offers a development and testing license free of charge. Sh ——————————————————————————- Disclaimer: The purpose of this script is to relax permissions on some of the files in the database Oracle Home so that all clients can access them.   The file name of the patchset to download is p5337014_10203_LINUX. Known Issues The following known issue does not apply to this article since we applied the Oracle 10. Perform the following steps to change the permissions so that groups other then just the database owner (for this example, the database owner is oracle:oinstall) can access client-side utilities and libraries. Navigate to the /u01/app/oracle/product/10. Installations can no longer be performed using character mode. Localdomain localhost
Remove IPv6 Entries Remove any entry that has to do with IPv6 (for example, ::1 localhost6. —————————————————————— Logs are generated in directory /u01/app/oracle/product/10. Some consider it unnecessary work which adds another layer of complexity to the maintenance of the installation. Sql   When the 10. INFO
   SID: TESTDB   I used IDEVELOPMENT. # # Set ORA_HOME to be equivalent to the $ORACLE_HOME # from which you wish to execute dbstart and dbshut; # # Set ORA_OWNER to the user id of the owner of the # Oracle database in ORA_HOME. 0/db_1 directory and run root. 111 vmlinux1 vmlinux1. After running the root. Tablespace Size Used (in bytes) Pct. After acknowledging the database creation report and script generation dialog, the database creation will start. In this type of scenario, all that would be required is the UNIX group dba (and assigning dba as the primary UNIX group for the “oracle” user account). Root Script Window – Run root. Login as the oracle User Account and Set DISPLAY (if necessary) As discussed in the previous section, (Install Oracle Database 10g Software), the terminal shell environment needs to run an X Windows application as the “oracle” user account. Oraenv ORACLE_SID = [ORA920]. Sh script go back to the OUI and acknowledge the “Execute Configuration scripts” dialog window. The UNIX group oinstall is used by organizations that have separate teams responsible for maintaining the Oracle software and the database(s). Log for the log of events
Configure Oracle Networking The Database Configuration Assistant (DBCA) requires the Oracle TNS Listener process to be configured and running on the database server before it can create the database.   You must install the Oracle database software from an X windows workstation, an X terminal, or a PC or other system with X server software installed. Post-Installation Tasks This section contains several tasks that can be applied to your new Oracle 10g environment in order to enhance availability as well as database management. D/dbora Associate the dbora service with the appropriate run levels and set it to auto-start using the following command: # chkconfig –level 345 dbora on The relevant instances should now startup/shutdown automatically at system startup/shutdown. [ Next ]
You will be returned to this Welcome (Type of Configuration) Screen. For the purpose of this example, the dba_scripts_archive_Oracle. As of Oracle 10g Release 2 the dbstart script includes the commands to automatically start/stop the listener. Do not use DHCP naming for the public IP address; you need a static IP address. ) su – $ORA_OWNER -c “$ORA_HOME/bin/dbshut $ORA_HOME” Starting with Oracle10g, Oracle switched from recommending the “su” command to the “rsh” command of which I completely disagree with. 2 Change the permissions in the libdb. Given the RSH server (and other r* packages) do not get installed by default, the DBA would need to locate and install them before this method could be used: # — Install the rhs and rsh-server packages from the OS CD/DVD — # rpm -Uvh –force rsh-* # — Enable rsh and rlogin — # chkconfig rsh on # chkconfig rlogin on # service xinetd reload I completely disagree with the recommendation to use rsh and prefer to stick with using the su command method. 0 Copyright (c) 1996, 2006 Oracle Corporation. End of installation At the end of the installation, exit from the OUI. 3 Database Patchset At the time of this writing, the latest patchset for Oracle Database 10g Release 2 running on Linux x86 (32-bit) is 10. The last screen of a successful Oracle Database 10g Companion CD Release 2 installation is the “End of Installation” screen. /u01/app/oracle owned by oracle:oinstall with 775 permissions. Sh and specify the patched server Oracle home location, before accessing client-side utilities or libraries in the database home. In this article, we are creating the oracle user account to have both responsibilities. Original /etc/redhat-release
Re-compile Invalid Objects Run the utlrp. TESTDB) will have its own set of online redolog files known as a thread. Listener Configuration
(Next 6 Screens) The following screens are now like any other normal listener configuration. Vmlinux1) then run the xhost + command as root from the console to allow X Server connections. The OUI will immediately fail if it doesn’t recognize either of these two platforms: $ /home/oracle/orainstall/database/runInstaller Starting Oracle Universal Installer. Zip   (668,734,007 bytes)
Oracle Database 10g Companion CD Release 2 (10. 0) for Linux x86 software. Sql perf_top_sql_by_buffer_gets. Below are several optional SQL commands for modifying and creating all tablespaces for the test database. The OUI uses the file /etc/redhat-release to determine the platform. D/dbora script listed above may look a little different from a similar one used for Oracle9i — most notably the omission of the commands to start/stop the Oracle TNS listener process. Extract the Oracle Database 10g Software: # su – oracle $ mkdir -p ~oracle/orainstall $ cd ~oracle/orainstall $ unzip 10201_database_linux32. Localdomain localhost # 192. In this example, I will use “~oracle/orainstall”. Downloading the Patchset The Oracle 10. For the purpose of this article, my testing database will often make use of the Java Virtual Machine (Java VM) and Oracle interMedia and therefore will require the installation of the Oracle Database 10g Companion CD. This is a FREE account.   If you do not currently have an account with Oracle OTN, you will need to create one. I have made every effort and taken great care in making sure that the material included on my web site is technically accurate, but I disclaim any and all responsibility for any loss, damage or destruction of data or any other property which may arise from relying on it. I left them all at their default settings. Create Directory for Database Files Let’s now create the directory that will be used to store the Oracle database files and backup files (on the /u02 file system): # mkdir -p /u02/oradata # chown oracle:oinstall /u02/oradata # chmod 775 /u02/oradata # mkdir -p /u02/flash_recovery_area # chown oracle:oinstall /u02/flash_recovery_area # chmod 775 /u02/flash_recovery_area
Create Login Script for oracle User Account To ensure that the environment is setup correctly for the “oracle” UNIX user account, use the following. This can be downloaded from the same page used to download the Oracle Database software:   Oracle Database 10g Companion CD Release 2 (10. 112 vmlinux2 vmlinux2. Zip   (705,274,421 bytes) As the “oracle” user account, extract the two packages you downloaded to a temporary directory. Zip Extract the Oracle Database 10g Companion CD Software: $ cd ~oracle/orainstall $ unzip 10201_companion_linux32. Although this can be done manually at the command line, it can get old real quick. Login as the oracle User Account and Set DISPLAY (if necessary) As discussed in the previous section, the terminal shell environment needs to run an X Windows application as the “oracle” user account. 0) and optionally the Companion CD Release 2 (10. Restore the Red Hat Release File Earlier in this article during the Pre-Installation Tasks section, we were required to Modify the Red Hat Release File (/etc/redhat-release) in order for the Oracle Universal Installer to detect a supported platform. Use the chmod command to set the privileges to 750: # chmod 750 /etc/init. Application to host any of the material elsewhere can be made by contacting me at [email protected] Simply click the check-box for “Checking available swap space requirements. 0/db_1 # # Change the value of ORACLE to the login name of the # oracle owner at your site. Please note that this script may take several minutes to complete: $. A full description of the license agreement is available on OTN. Sh script go back to the OUI and acknowledge the “Execute Configuration scripts” dialog window. D/dbora – (rsh method) #. Dbf $ sqlplus “/ as sysdba” SQL> create user scott identified by tiger default tablespace users; SQL> grant dba, resource, connect to scott; SQL> alter database datafile ‘/u02/oradata/TESTDB/datafile/o1_mf_users_3rbj6q3y_. As already mentioned, Oracle writes to its online redolog files in a circular manner. Before executing the Database Configuration Assistant, make sure that $ORACLE_HOME and $PATH are set appropriately for the $ORACLE_BASE/product/10. /bin/sh # chkconfig: 345 99 10 # description: Oracle auto start-stop script. If you have been following the instructions in this article, there should be no Oracle processes running: $ ps -ef | grep ora
Applying the Patchset Once all processes running in the Oracle home directory have been stopped, we can now start the patch installation process. NOTE: After executing the orainstRoot. In this article, I will be downloading the required Oracle software to vmlinux1 and saving it to “~oracle/orainstall”. If you need to manually start this application, login as the UNIX oracle user account and type the following: $ emctl start dbconsole TZ set to US/Eastern Oracle Enterprise Manager 10g Database Control Release 10. Specify Home Details Set the destination for the ORACLE_HOME Name and Path to that of the previous Oracle10g Database software install as follows:
   Name: OraDb10g_home1
   Path: /u01/app/oracle/product/10. Furthermore, using the rsh method can be problematic when attempting to use it under Fedora Core 5 and Fedora Core 6 where rsh is deprecated. 3 patch set is applied to an Oracle Database 10g Standard Edition database or Standard Edition One database, there may be 42 invalid objects after the utlrp. As the oracle user account, download the dba_scripts_archive_Oracle. His work includes advanced performance tuning, Java and PL/SQL programming, developing high availability solutions, capacity planning, database security, and physical / logical database design in a UNIX / Linux server environment. 2 file: chmod 755 /usr/lib/libgdbm. New UNIX password: xxxxxxxxxxx Retype new UNIX password: xxxxxxxxxxx passwd: all authentication tokens updated successfully. Info # # ————- [ LINUX ] ————————————- 192. I selected the Custom option for this example given I wanted to install Oracle Label Security and other components not available with the Enterprise or Standard Edition installation option. 132 vmlinux4 vmlinux4. 0/db_1 Summary On the Summary screen, click Install to start the installation. This requires you update environment variables like ORACLE_HOME, ORACLE_SID, PATH, LD_LIBRARY_PATH, etc. D/dbora script to be started and stopped when the database server is cycled. 0 $ export DISPLAY   If you are using Hummingbird’s Exceed X-Windows emulator while installing and using Oracle10g, set the window manager to run in “Native” mode so that Microsoft windows functions as the window manager. Open a new console window as the “root” user account. 3 $ cd /home/oracle/orainstall/patches/database_10. Navigate to the /u01/app/oracle/product/10. 1 vmlinux1 localhost. To facilitate media recovery, Oracle allows the DBA to put the database into “Archive Log Mode” which makes a copy of the online redolog after it fills (and before it gets reused). TESTDB Notice that in the above example, we didn’t just run the oraenv script, but rather, we sourced it by using a dot followed by a space and then the script name oraenv. Select the appropriate components for your environment and click Next to continue. Sample /etc/hosts File The following is an example /etc/hosts file I used for this article: Sample /etc/hosts File # Do not remove the following line, or various programs # that require network functionality will fail. Dbf USERS /u02/oradata/TESTDB/datafile/o1_mf_users_3rbj6q3y_. If you selected to configure Enterprise Manager during the database creation process, the OUI will provide the URL. Creation Options Keep the default option Create Database selected. 3 (also known as patch 5337014). The Oracle DBA scripts archive can be downloaded using the following link //www. -f $ORA_HOME/bin/dbstart ] then echo “Oracle startup: cannot start” exit fi case “” in ‘start’) # Start the Oracle databases: # The following command assumes that the oracle login # will not prompt the user for any values su – $ORA_OWNER -c “$ORA_HOME/bin/dbstart $ORA_HOME” ;; ‘stop’) # Stop the Oracle databases: # The following command assumes that the oracle login # will not prompt the user for any values su – $ORA_OWNER -c “$ORA_HOME/bin/dbshut $ORA_HOME” ;; esac   Note that the /etc/init. Prior to modifying the Red Hat Release File, we made a backup copy of the original file. Whatever the case may be, you need an efficient way to modify your environment variables to switch between these two databases. The Database Configuration Assistant (DBCA) allows users to configure a new database to be in archive log mode, however most DBA’s opt to bypass this option during initial database creation. The RSH server does not get installed by default on many Linux distributions (and for good reason. Navigate to the /u01/app/oracle/oraInventory directory and run orainstRoot. ——————————————————————————- Do you wish to continue (y/n) [n]: y Finished running the script successfully Please see /tmp/changePerm_err. Dbf TEMP /u02/oradata/TESTDB/datafile/o1_mf_temp_3rbj6f1s_. If you are using a large set of drives for database storage, you may want to make a sizable testing database. Before starting the Oracle Universal Installer, you should first verify you are logged onto the server you will be running the installer from (i. Used ——— ————— ———— ———- ——— —————— —————— ——— ONLINE UNDOTBS1 UNDO LOCAL MANUAL 1,073,741,824 239,075,328 22 ONLINE SYSAUX PERMANENT LOCAL AUTO 1,073,741,824 270,663,680 25 ONLINE USERS PERMANENT LOCAL AUTO 2,147,483,648 131,072 0 ONLINE SYSTEM PERMANENT LOCAL MANUAL 1,073,741,824 503,250,944 47 ONLINE INDX PERMANENT LOCAL AUTO 1,073,741,824 65,536 0 ONLINE TEMP TEMPORARY LOCAL MANUAL 1,073,741,824 28,311,552 3 —————— —————— ——— avg 16 sum 7,516,192,768 1,041,498,112 6 rows selected. Root Script Window – Run root. Jeff graduated from Stanislaus State University in Turlock, California, with a Bachelor’s degree in Computer Science and Mathematics. Login to the database server as the “oracle” user account and shutdown the database: $ id -a uid=501(oracle) gid=501(oinstall) groups=501(oinstall),502(dba),503(oper) $ sqlplus “/ as sysdba” SQL> shutdown immediate Next, MOUNT the database: SQL> startup mount Enable archiving: SQL> alter database archivelog; Open the database for read/write which is now in archivelog mode: SQL> alter database open; Login to the database and verify Archive Log Mode is enabled: SQL> archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 27 Next log sequence to archive 29 Current log sequence 29
Download and Install Custom Oracle Database Scripts – (Optional) DBA’s rely on Oracle’s data dictionary views and dynamic performance views in order to support and better manage their databases. If you are using a remote client to connect to the node performing the installation (SSH or Telnet to vmlinux1 from a workstation configured with an X Server), you will need to set the DISPLAY variable to point to your local workstation: # hostname vmlinux1 # xhost + access control disabled, clients can connect from any host # su – oracle $ # IF YOU ARE USING A REMOTE CLIENT TO CONNECT TO THE $ # NODE PERFORMING THE INSTALL $ DISPLAY=:0. Welcome Select Naming Methods configuration. All articles, scripts and material located at the Internet address of //www. You should also verify that the Oracle TNS listener service is running before attempting to start the database creation process. No support, however, is provided and the license does not permit production use. Log for errors and /tmp/changePerm. 120 cartman cartman. Note that you can utilize the same terminal shell session used in the previous section which in this case, you do not have to take any of the actions described below with regards to setting the DISPLAY variable: # su – oracle $ # IF YOU ARE USING A REMOTE CLIENT TO CONNECT TO THE $ # NODE PERFORMING THE INSTALL $ DISPLAY=:0. These objects belong to the unsupported components and do not affect the database operation. Note however that this will require a short database outage. 1 localhost. NOTE: Please keep in mind that the database file names (OMF files) being listed in these examples may differ from what the Oracle Database Configuration Assistant (DBCA) creates for your environment. Please note that Oracle Corporation recommends using the most restrictive file permissions as possible for your given implementation. Specify Home Details Set the Name and Path for the ORACLE_HOME as follows:
   Name: OraDb10g_home1
   Location: /u01/app/oracle/product/10. Install the Oracle Database 10g Release 2 Software Install the Oracle Database 10g Release 2 software as follows: $ cd ~oracle $ /home/oracle/orainstall/database/runInstaller Oracle Database 10g Software Installation Screen Responses Screen Name Response Select Installation Method Select the Advanced Method option and click Next to start the installation process. Click Next to continue. Zip
Login as the oracle User Account and Set DISPLAY (if necessary) As discussed in the previous section, (Install the Oracle Database 10g Companion CD Release 2 Software), the terminal shell environment needs to run an X Windows application as the “oracle” user account. You may use any domain. Although these views provide a simple and easy mechanism to query critical information regarding the database, it helps to have a collection of accurate and readily available SQL scripts to query these views. Open a new console window as the “root” user account. For this example, I will create a Flash Recovery Area of 10GB. Please keep in mind that this is an optional step. Jeff currently works as a Senior Database Administrator for The DBA Zone, Inc. Change to the install directory by using the following command: $ cd $ORACLE_HOME/install Run changePerm. The Oracle documentation uses the following definitions when describing the UNIX groups: The oinstall group (the Oracle Inventory group) The dba group (the OSDBA group) The oper group (the OSOPER group) If you intend to use the oinstall group during the installation process, then you must set the default group to the one that will be maintaining the database before creating the database or permission problems will arise.    Flash Recovery Area: /u02/flash_recovery_area
   Flash Recovery Area Size: 10240 Database Content I left all of the Database Components (and destination tablespaces) set to their default value, although it is perfectly OK to select the Sample Schemas. For example, perform the following as the oracle user account: $ mv dba_scripts_archive_Oracle. 0 $ export DISPLAY
Stop All Oracle Processes Before starting the OUI to install the patch set, we need to stop all listeners and other processes running in the Oracle home directory. Final Notes The /etc/init. Next, create a text file named /etc/init. Setting up Automatic Database Starting and Stopping This section contains the recommended method defined by Oracle for automating database startup and shutdown of Oracle10g and Oracle11g instances. Also, the umask setting may be off – it should be 0022. 0 $ export DISPLAY To start the NETCA, run the following: $ netca & Oracle Network Configuration Installation Screen Responses Screen Name Response Welcome Select Listener configuration. 0, asianux-1 or asianux-2 Failed

Prior to modifying the Red Hat Release File, we made a backup copy of the original file. Given the Oracle database installation is now completed, we should now restore the original version of this file: $ su – # cp /etc/redhat-release.

centos configure network interface gui

/u01/app/oracle owned by oracle:oinstall with 775 permissions. This ownership and permissions enables the OUI to create the oraInventory directory, in the path /u01/app/oracle/oraInventory. When configuring the oracle user’s environment (later in this section) we will be assigning the location of this directory to the $ORACLE_BASE environment variable. Create the Oracle Base Directory The next step is to create a new directory that will be used to store the Oracle Database software. # mkdir -p /u01/app/oracle # chown -R oracle:oinstall /u01/app/oracle # chmod -R 775 /u01/app/oracle At the end of this procedure, you will have the following: /u01 owned by root. After the directory is created, you must then specify the correct owner, group, and permissions for it. /u01/app owned by root.

This is where you pick the packages to install. ) So although the package group gets selected for install, some of the packages required by Oracle do not get installed. For now, install the following package groups:. Since this node will be hosting the Oracle Database software, verify that at least the following package groups are selected for install. A complete list of required packages for Oracle Database 10g will be provided at the end of this section. (Note the “Optional packages” button after selecting a package group. These packages will need to be manually installed from the CentOS CDs after the operating system install. In fact, there are some packages that are required by Oracle that do not belong to any of the available package groups (i. Note that for many of the Linux package groups, not all of the packages associated with that group get selected for installation. Most of the packages required for the Oracle software are grouped into “Package Groups” (i.

This HowTo walks you through the steps required to security harden CentOS 7, it’s based on the OpenSCAP benchmark, unfortunately the current version of OpenSCAP.

centos configure network interface gui

[text]
[text]
[text]
[text]
[text]

Install Lighttpd With PHP5 FastCGI And MySQL On Fedora 21

4 thoughts on “Centos configure network interface gui

  1. Nikish Post authorReply

    Ezjail FreeBSD Jail Tutorial – Explains how to setup FreeBSD jails using ezjail setup utility under FreeBSD operating system to improve server security.

  2. L-A-S-K-A Post authorReply

    A bootable USB drive is the best way to install or try Linux. But most Linux distributions—like Ubuntu—only offer an ISO disc image file for download.

  3. crazy Post authorReply

    A lot of work remains before they can make their way into a release. The development version of ResidualVM contains two additional work in progress games, Escape from Monkey Island and The Longest Journey. But if you are interested in helping, contact us.

  4. ALF Post authorReply

    Arch Linux – Best distro ever. 2017 January 10, 14:25 h – tags: linux pacman pacaur asdf archlinux. Update 01/18/2017: If you’re on old hardware like me, you may want.

Leave a Reply to ALF Cancel reply

Your email address will not be published. Required fields are marked *