Red hat enterprise linux localhost login

Configuring and Monitoring a LAN - System Administration ...

Chapter 14:Berkeley Internet Name Domain (BIND) $TTL 86400 dns1. ( 2001062501 ; serial 21600 ; refresh after 6 hours 3600 ; retry after 1 hour 604800 ; expire after 1 week 86400 ) ; minimum TTL of 1 day dns1.

• log_on_failure — Tells xinetd what to log if the connection fails or is not allowed. 3:Access Control Using xinetd • log_on_success — Lets xinetd know what to log if the connection is successful. By de- fault, the remote host’s IP address and the process ID of server processing the request are recorded. Conf are often added to by each of the different services, meaning that successful and failed connections by each service will usually log more than what is indicated here. The log_on_success and log_on_failure settings in /etc/xinetd.

Zip   (705,274,421 bytes) As the “oracle” user account, extract the two packages you downloaded to a temporary directory. As of Oracle 10g Release 2 the dbstart script includes the commands to automatically start/stop the listener. 106 melody melody. This option is available since we installed the Oracle Companion CD software. This may take some time to download. ) 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.   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. 0 chmod 755 /usr/lib/libdb. When all of the options are filled out, click the “Go” button. 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. We will, instead, create the database using the Database Configuration Assistant (DBCA) after all of the software and patches have been installed. 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. For my installation, all checks passed with no problems. Zip   (668,734,007 bytes)
Oracle Database 10g Companion CD Release 2 (10. The last screen of a successful Oracle Database 10g Release 2 installation is the “End of Installation” screen. Next, unzip the archive file to the $ORACLE_BASE directory. Prior to modifying the Red Hat Release File, we made a backup copy of the original file. For this example, I will create a Flash Recovery Area of 10GB. Info is the copyright of Jeffrey M. Sh After the installation has completed, you will be prompted to run the orainstRoot. Dbf’ resize 1024m; SQL> — SYSAUX Tablespace SQL> alter database datafile ‘/u02/oradata/TESTDB/datafile/o1_mf_sysaux_3rbj68np_. If you selected to configure Enterprise Manager during the database creation process, the OUI will provide the URL. 3 patchset will need to be downloaded from the Oracle Metalink website (http://metalink. D/dbora script would be defined as follows: /etc/init. Login to the database server as the “oracle” user account. Zip
Pre-Installation Tasks This section contains the mandatory tasks that need to be completed before install the Oracle Database 10g software. 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. Select this patchset in the Results section and then click the Download button to start the download process. You may use any domain. 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. 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. Navigate to the /u01/app/oracle/product/10. ISQL*Plus URL: http://vmlinux1:5560/isqlplus iSQL*Plus DBA URL: http://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. The last screen of a successful Oracle Database 10g Companion CD Release 2 installation is the “End of Installation” screen. When working through this section, substitute the data file names that were created in your environment where appropriate. 0/db_1/vmlinux1_TESTDB/sysman/log If you recieve something similar to the above output, then OEM Database Console is running. Bash_profile for Oracle User #. Below are several optional SQL commands for modifying and creating all tablespaces for the test database. Database Templates Select Custom Database Database Identification Select:
   Global Database Name: TESTDB. 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. Dbf USERS /u02/oradata/TESTDB/datafile/o1_mf_users_3rbj6q3y_. 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. When the Oracle Database Configuration Assistant has completed, you will have a fully functional Oracle database running. 0 Copyright (c) 1996, 2006 Oracle Corporation. Running this script should be done only after considering all security ramifications. Note that members of the UNIX group oinstall are considered the “owners” of the Oracle software. In situations like this, the group membership prevents unauthorized access to the database by personal who only maintain the Oracle software. 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. An Oracle instance (i. INFO
   SID: TESTDB   I used IDEVELOPMENT. These objects belong to the unsupported components and do not affect the database operation. 0 Copyright (c) 1996, 2006 Oracle Corporation. Loc” are 644 (-rw-r–r–) and owned by root:root. Located in Pittsburgh, Pennsylvania. Sh before running root. 0) for Linux x86 Next, download the Oracle Database 10g Companion CD for Linux x86. [ Next ]
You will be returned to this Welcome (Type of Configuration) Screen. I also always select to Generate Database Creation Scripts. :$ORACLE_HOME/rdbms/admin export ORACLE_PATH   Note that the ORACLE_PATH environment variable should already be set in the. Sql perf_top_sql_by_buffer_gets. 0/db_1 directory and run root. “” = “ORA_DB” ] ; then if [ “$PLATFORM” = “HP-UX” ] ; then remsh $HOST -l $ORACLE -n “

) in zone files after all FQDNs and omit them on hostnames. If the dot is omitted, then named will place the name of the zone or the $ORIGIN value after the name to complete it. Chapter 14:Berkeley Internet Name Domain (BIND) An omitted semi-colon or unclosed ellipse section will cause named to refuse to start. • Remember to place dots (. The dot symbolizes that the name given is full and complete.

ORA_DB” exit else rsh $HOST -l $ORACLE

Vmlinux1) then run the xhost + command as root from the console to allow X Server connections. Before starting the Oracle Universal Installer, you should first verify you are logged onto the server you will be running the installer from (i.

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

The Graphical Login Screen. To log in to the root account, at the login and password prompts, type root and the root password you chose when you installed Red Hat Linux. Unless you've chosen to give your machine a name, as in a network setting, your machine will probably be called localhost.

{start|stop}” exit ;; esac # exit Note that this method relies on the presence of an RSH server, which requires additional packages and configuration. D/iptables stop Flushing firewall rules: [ OK ] Setting chains to policy ACCEPT: filter [ OK ] Unloading iptables modules: [ OK ] 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 offers a development and testing license free of charge. This requires you update environment variables like ORACLE_HOME, ORACLE_SID, PATH, LD_LIBRARY_PATH, etc. In the text field to the right, enter “RDBMS Server”. Please note that Oracle Corporation recommends using the most restrictive file permissions as possible for your given implementation. [ Next ]
You will be returned to this Welcome (Type of Configuration) Screen. Final Notes The /etc/init. Change to the install directory by using the following command: $ cd $ORACLE_HOME/install Run changePerm. Loc are not set correctly, it is possible you didn’t run orainstRoot. 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. 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). If the database is in “Archive Log Mode”, Oracle will make a copy of the online redo log before it gets reused. 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. 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. Some consider it unnecessary work which adds another layer of complexity to the maintenance of the installation. 1 vmlinux1 localhost. This installation type includes the Natively Compiled Java Libraries (NCOMP) files to improve Java performance. 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. After running the root. Oracle Database 10g Release 2 (10. 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. 1 router router. After acknowledging the database creation report and script generation dialog, the database creation will start. Welcome Click Finish to exit the NETCA. Sql ======================================== Automatic Storage Management ======================================== asm_alias. 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). Although this can be done manually at the command line, it can get old real quick. End of installation At the end of the installation, exit from the OUI. /u01/app/oracle owned by oracle:oinstall with 775 permissions. In this section, we will be downloading and extracting the required software from Oracle to the database server. Listener Configuration
(Next 6 Screens) The following screens are now like any other normal listener configuration. Tablespace Size Used (in bytes) Pct. It is possible to receive an error about the available swap space not meeting its minimum requirements: Checking available swap space requirements. 132 vmlinux4 vmlinux4. Extract the Oracle Database 10g Software: # su – oracle $ mkdir -p ~oracle/orainstall $ cd ~oracle/orainstall $ unzip 10201_database_linux32. After the directory is created, you must then specify the correct owner, group, and permissions for it. Sh Script on an Oracle Database Server Home During patch set installation, all new files and directories are created with restricted access, by default. —————————————————————— Logs are generated in directory /u01/app/oracle/product/10. 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:. TESTDB) will have its own set of online redolog files known as a thread. Members of the dba group can administer Oracle databases, for example starting up and shutting down databases. 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. 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. 131 vmlinux3 vmlinux3. Note however that this will require a short database outage. # 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. D/dbora #. 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. Miscellaneous Options This final section of the article contains several miscellaneous options that may be of use to newcomers of Oracle10g. Sh After the patch installation has completed, you will be prompted to run the root. End of installation At the end of the installation, exit from the OUI. Downloading the Patchset The Oracle 10. Summary On the Summary screen, click Install to start the installation. You can simply accept the default parameters for the next six screens:
   What do you want to do: Add
   Listener name: LISTENER
   Selected protocols: TCP
   Port number: 1521
   Configure another listener: No
   Listener configuration complete. Localdomain localhost # 192. Once an online redolog fills, Oracle moves to the next one. /bin/sh # chkconfig: 345 99 10 # description: Oracle auto start-stop script. 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. 0) 10201_database_linux32. Click Next to continue. D/dbora script to be started and stopped when the database server is cycled. 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. 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. For the case of Red Hat Enterprise Linux, Oracle Database 10g Release 2 expects either RHEL 3 or RHEL/OL 4. Create Group and User for Oracle Lets start this section by creating the UNIX oinstall and dba group and oracle user account: # groupadd -g 501 oinstall # groupadd -g 502 dba # groupadd -g 503 oper # useradd -m -u 501 -g oinstall -G dba,oper -d /home/oracle -s /bin/bash -c “Oracle Software Owner” oracle # id oracle uid=501(oracle) gid=501(oinstall) groups=501(oinstall),502(dba),503(oper) Set the password for the oracle account: # passwd oracle Changing password for user oracle. The OUI uses the file /etc/redhat-release to determine the platform. Also, the umask setting may be off – it should be 0022.   This guide adheres to the Optimal Flexible Architecture (OFA) for naming conventions used in creating the directory structure. When the current online redolog fills, Oracle will switch to the next one. Dbf SYSTEM /u02/oradata/TESTDB/datafile/o1_mf_system_3rbj5g8h_. I left them all at their default settings. Other Java applications that utilize the JRE are the Database Configuration Assistant and the Oracle Net Assistant. 2 Change the permissions in the libdb. From the Simple Search screen, select the “Product or Family” option in the Search By pull-down listing. Dbf’ resize 1024m; SQL> — UNDO Tablespace SQL> alter database datafile ‘/u02/oradata/TESTDB/datafile/o1_mf_undotbs1_3rbj61p7_. 0) for Linux x86 Download the Oracle Database 10g Release 2 (10. 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. Sh accepting all default values. 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. 0/db_1/vmlinux1_TESTDB/sysman/log The OEM DB Console application may take several minutes to start. 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. 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. 0) and optionally the Companion CD Release 2 (10. Log for errors and /tmp/changePerm. Whatever the case may be, you need an efficient way to modify your environment variables to switch between these two databases. Sh script, verify the permissions of the file “/etc/oraInst. 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. 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. 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. Sql script: SQL> @help. Tablespace Size Used (in bytes) Pct. Root Script Window – Run root. # ORACLE=oracle PATH=${PATH}:$ORACLE_HOME/bin HOST=`hostname` PLATFORM=`uname` export ORACLE_HOME PATH # if [. If any of the checks fail, you will need to manually verify the check that failed by clicking on the checkbox. 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. A full description of the license agreement is available on OTN. 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. Dbf TEMP /u02/oradata/TESTDB/datafile/o1_mf_temp_3rbj6f1s_. 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. 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. At the same time, it also prevents database administrators from making modifications to the database software and the installation’s Inventory directory. I left them all at their default settings. 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. In this article, we are creating the oracle user account to have both responsibilities. If the machine name is listed in the in the loopback address entry as below: 127. 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. $ id -a uid=501(oracle) gid=501(oinstall) groups=501(oinstall),502(dba),503(oper) $ sqlplus “/ as sysdba” SQL> @. This section will provide the steps necessary to configure the database server to successfully run the Oracle Universal Installer (OUI). 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. In this article, I will be downloading the required Oracle software to vmlinux1 and saving it to “~oracle/orainstall”. No support, however, is provided and the license does not permit production use. This will bring up the available patchsets in the Results section. The OUI provides you with several URLs that will be activated by the OUI: Ultra Search URL: http://vmlinux1:5620/ultrasearch Ultra Search Administration Tool URL: http://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. 0/db_1 Summary On the Summary screen, click Install to start the installation. 0) and TESTDB (using Oracle release 10. 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. 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. For the purpose of this example, the only instance defined in the /etc/oratab file is TESTDB: /etc/oratab. For the purpose of this example, the dba_scripts_archive_Oracle. In the Release option, select “Oracle 10. Open a new console window as the “root” user account. Do not use DHCP naming for the public IP address; you need a static IP address. Zip archive to the $ORACLE_BASE directory. Installations can no longer be performed using character mode. :$ORACLE_HOME/rdbms/admin export ORACLE_SID=TESTDB export PATH=. He has been a Sr. 3/Disk1/runInstaller Oracle 10. To check for the process, type the following: $ emctl status dbconsole TZ set to US/Eastern Oracle Enterprise Manager 10g Database Control Release 10. 102 alex alex. End of Database Creation At the end of the database creation, exit from the DBCA. 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 $ 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. A thread must contain at least two online redologs (or online redolog groups). When using the rsh method, the /etc/init. 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. Welcome Select Naming Methods configuration. The UNIX group oinstall is used by organizations that have separate teams responsible for maintaining the Oracle software and the database(s). All articles, scripts and material located at the Internet address of http://www. 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. Sh script go back to the OUI and acknowledge the “Execute Configuration scripts” dialog window. 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. 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. 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. 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. Sql script to recompile all invalid PL/SQL packages now instead of when the packages are accessed for the first time. 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. 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 purpose of this example, we will forgo the “Create Database” option when installing the Oracle Database software. :${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=. Click OK on the “Summary” screen. 3 $ unzip p5337014_10203_LINUX. 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. -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. 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). 0) Software for Linux x86. 105 bartman bartman. Zip Extract the Oracle Database 10g Companion CD Software: $ cd ~oracle/orainstall $ unzip 10201_companion_linux32. 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. Localdomain localhost it should be removed as shown below: 127. Summary Click Install to start the installation. Bash_profile login script that was created in the section Create Login Script for oracle User Account. 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. Dbf’ resize 1024m; SQL> — Temporary Tablespace SQL> alter database tempfile ‘/u02/oradata/TESTDB/datafile/o1_mf_temp_3rbj6f1s_. This document may not be hosted on any other site without my express, prior, written permission. For example, you may have two database – ORA920 (using Oracle release 9. In this article, we will be taking care of this issue when we install the database software. Http://vmlinux1:1158/em/console/aboutApplication Oracle Enterprise Manager 10g is running. Bash_profile: Login to the database server as the oracle user account: # su – oracle. /u01/app owned by root. For the purpose of the example in this article, my log files were created in “/u01/app/oracle/product/10. 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_.   If you do not currently have an account with Oracle OTN, you will need to create one. However, we must first download and extract the required Oracle software packages from the Oracle Technology Network (OTN). 120 cartman cartman. This step is optional but recommended. The Oracle DBA scripts archive can be downloaded using the following link http://www. Simply click the check-box for “Checking available swap space requirements. 1 localhost. If the firewall option is operating you will need to first manually disable UDP ICMP rejections: # /etc/rc. NOTE: After executing the orainstRoot. 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. 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. 112 vmlinux2 vmlinux2. For example: http://vmlinux1:1158/em   I like to review the log files that were created by the DBCA process. D/dbora – (rsh method) #. Before executing the Database Configuration Assistant, make sure that $ORACLE_HOME and $PATH are set appropriately for the $ORACLE_BASE/product/10. Before starting the Oracle Universal Installer, you should first verify you are logged onto the server you will be running the installer from (i. For the purpose of this article, I will be downloading and installing patch: 5337014. 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. Tmp UNDOTBS1 /u02/oradata/TESTDB/datafile/o1_mf_undotbs1_3rbj61p7_. 0/db_1 ORA_OWNER=oracle if [. Open a new console window as the “root” user account. $ su – # cp /etc/redhat-release /etc/redhat-release. Sql ======================================== Automatic Shared Memory Management ======================================== asmm_components. Zip /u01/app/oracle $ cd /u01/app/oracle $ unzip dba_scripts_archive_Oracle. Sql   When the 10. ——————————————————————————- Do you wish to continue (y/n) [n]: y Finished running the script successfully Please see /tmp/changePerm_err.    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. 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_. Navigate to the /u01/app/oracle/product/10.   Oracle Database 10g Release 2 (10. This can be downloaded from the same page used to download the Oracle Database software:   Oracle Database 10g Companion CD Release 2 (10. As the oracle user account, download the dba_scripts_archive_Oracle. 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. 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. 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. 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. Zip archive will be copied to /u01/app/oracle. Sh accepting all default values. 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. 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. Storage Options For this article, we will select to use File System. Http://vmlinux1:1158/em/console/aboutApplication Starting Oracle Enterprise Manager 10g Database Control. /bin/sh # chkconfig: 345 99 10 # description: Oracle auto start-stop script. 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. 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 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. 2 file: chmod 755 /usr/lib/libgdbm. Next, login as the oracle user account. 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. 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] 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. If the permissions to /etc/oraInst. 0) for Linux x86 software. Ignore any messages indicating that the database contains invalid recycle bin objects similar to the following: BINlzljWIt9gfgMFeM2hVSoA==

O NI5210 card (i82586 ni52. O ni52=io_port,IRQ OR ni52 Ethernet chip) io=io_port irq=IRQ NI6510 Ethernet ni65. 4:Ethernet parameters Hardware Module Parameters MiCom-Interlan NI5010 ni5010. O SMC Ultra and SMC smc-ultra=io_port,IRQ OR EtherEZ ISA ethercard smc-ultra io=io_port irq=IRQ (8K, 83c790). O PCnetPCI SysKonnect SK-98XX sk98lin. O AMD PCnet32 and AMD pcnet32.

Enabling Archive Logs – (Optional) Oracle tracks and logs all changes to database blocks in online redolog files. In almost all cases, the DBCA will automatically start the OEM Database Console application. 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. In the above example, if an entry exists for TESTDB, then all required environment variables would be reset to access this database.
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. 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. Sh script go back to the OUI and acknowledge the “Execute Configuration scripts” dialog window. 190 george george. 3 $ cd /home/oracle/orainstall/patches/database_10. Also included are the steps required to restore the Red Hat Release File which was modified earlier in this article. For example, perform the following as the oracle user account: $ mv dba_scripts_archive_Oracle. Please keep in mind that this is an optional step. # # 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. This ownership and permissions enables the OUI to create the oraInventory directory, in the path /u01/app/oracle/oraInventory. Navigate to the /u01/app/oracle/oraInventory directory and run orainstRoot. Please note that this script may take several minutes to complete: $. 111 vmlinux1 vmlinux1. 245 accesspoint accesspoint. 0/db_1 directory and run root. About the Author Jeffrey Hunter is an Oracle Certified Professional, Java Development Certified Professional, Author, and an Oracle ACE. You should also verify that the Oracle TNS listener service is running before attempting to start the database creation process. 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). Finally, for the Platform or Language option, select “Linux x86″. 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. ” and click Next to continue. This is a process known as archiving. 0) 10201_companion_linux32. Root Script Window – Run root. Naming Methods Configuration The following screens are:
   Selected Naming Methods: Local Naming
   Naming Methods configuration complete. For the Patch Type option, select “Patchset/Minipack”. If you are using a large set of drives for database storage, you may want to make a sizable testing database. We now need to configure the /etc/hosts file. Database Administrator and Software Engineer for over 20 years and maintains his own website site at: http://www. Remember that we will create the database as a separate step using DBCA. Zip (last updated 21-FEB-2007) and is 900MB in size. 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). INFO for the database domain. # # Change the value of ORACLE_HOME to specify the correct Oracle home # directory for your installation. 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. 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. Changing Your Oracle Database Environment In some cases, you may have more than one database running on your single database server. Select the appropriate components for your environment and click Next to continue. Sql
Creating / Altering Tablespaces When creating the Oracle database, we left all tablespaces set to their default size. 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. If any of the checks fail, you will need to manually verify the check that failed by clicking on the checkbox. 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. As already mentioned, Oracle writes to its online redolog files in a circular manner. It is even possible to be using two different databases running on different releases of the Oracle Database software. I will in no case be liable for any monetary damages arising from such loss, damage or destruction. 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). End of installation At the end of the installation, exit from the OUI. Jeff graduated from Stanislaus State University in Turlock, California, with a Bachelor’s degree in Computer Science and Mathematics. When sourcing the oraenv script, it will prompt you for the ORACLE_SID, (defined in your /etc/oratab file), you want to switch to. Checking operating system version: must be redhat-3, SuSE-9, redhat-4, UnitedLinux-1. Sh and specify the patched server Oracle home location, before accessing client-side utilities or libraries in the database home.   The file name of the patchset to download is p5337014_10203_LINUX. The JRE shipped by Oracle is the only one supported to run with these applications. 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. Keep in mind that this domain does not have to be a valid DNS domain. Instead you can use a single command line script to switch between all database environments declared in your /etc/oratab file. 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. —————————————————————— Logs are generated in directory /u01/app/oracle/product/10. The OUI will immediately fail if it doesn’t recognize either of these two platforms: $ /home/oracle/orainstall/database/runInstaller Starting Oracle Universal Installer.   Access to Oracle Metalink requires a valid login and CSI number. Oraenv ORACLE_SID = [ORA920]. 3 $ mv p5337014_10203_LINUX. 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. Creation Options Keep the default option Create Database selected. Jeff currently works as a Senior Database Administrator for The DBA Zone, Inc. Bash_profile # Get the aliases and functions if [ -f ~/. 0, asianux-1 or asianux-2 Failed

INFO
   SID: TESTDB   I used IDEVELOPMENT. Before executing the Database Configuration Assistant, make sure that $ORACLE_HOME and $PATH are set appropriately for the $ORACLE_BASE/product/10. When using the rsh method, the /etc/init. The Oracle instance (or thread) will use its group of online redologs in a circular manner. 0/db_1 ORA_OWNER=oracle if [. 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. Below are several optional SQL commands for modifying and creating all tablespaces for the test database. [ Next ]
You will be returned to this Welcome (Type of Configuration) Screen. 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. Jeff currently works as a Senior Database Administrator for The DBA Zone, Inc. Sql script: SQL> @help. 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. 0/db_1 # # Change the value of ORACLE to the login name of the # oracle owner at your site. As the oracle user account, download the dba_scripts_archive_Oracle. 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. 0 Copyright (c) 1996, 2006 Oracle Corporation. 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. Dbf’ resize 1024m; SQL> — UNDO Tablespace SQL> alter database datafile ‘/u02/oradata/TESTDB/datafile/o1_mf_undotbs1_3rbj61p7_. You should also verify that the Oracle TNS listener service is running before attempting to start the database creation process. Sh Script on an Oracle Database Server Home During patch set installation, all new files and directories are created with restricted access, by default. Sql ======================================== Workspace Manager ======================================== wm_create_workspace. This will bring up the available patchsets in the Results section. For the purpose of this article, I will be downloading and installing patch: 5337014. —————————————————————— Logs are generated in directory /u01/app/oracle/product/10. Navigate to the /u01/app/oracle/product/10. Application to host any of the material elsewhere can be made by contacting me at [email protected] 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. D/dbora – (rsh method) #. Log for errors and /tmp/changePerm. Next, create a text file named /etc/init. A thread must contain at least two online redologs (or online redolog groups). Welcome Select Naming Methods configuration. 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. 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. Tablespace Size Used (in bytes) Pct. Miscellaneous Options This final section of the article contains several miscellaneous options that may be of use to newcomers of Oracle10g. 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. -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.   The file name of the patchset to download is p5337014_10203_LINUX. 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. If you are using a large set of drives for database storage, you may want to make a sizable testing database. 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. 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. Jeff graduated from Stanislaus State University in Turlock, California, with a Bachelor’s degree in Computer Science and Mathematics. Http://vmlinux1:1158/em/console/aboutApplication Starting Oracle Enterprise Manager 10g Database Control. 0 Copyright (c) 1996, 2006 Oracle Corporation. Initialization Parameters Change any parameters for your environment. 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. Http://vmlinux1:1158/em/console/aboutApplication Oracle Enterprise Manager 10g is running. 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. # ORACLE=oracle PATH=${PATH}:$ORACLE_HOME/bin HOST=`hostname` PLATFORM=`uname` export ORACLE_HOME PATH # if [. Select this patchset in the Results section and then click the Download button to start the download process. 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. 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. Sql ======================================== Automatic Storage Management ======================================== asm_alias. $ id -a uid=501(oracle) gid=501(oinstall) groups=501(oinstall),502(dba),503(oper) $ sqlplus “/ as sysdba” SQL> @. These objects belong to the unsupported components and do not affect the database operation. 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. 3 $ mv p5337014_10203_LINUX. About the Author Jeffrey Hunter is an Oracle Certified Professional, Java Development Certified Professional, Author, and an Oracle ACE. For the purpose of this example, the dba_scripts_archive_Oracle. Please note that this script may take several minutes to complete: $. Please note that Oracle Corporation recommends using the most restrictive file permissions as possible for your given implementation. 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). 3 $ cd /home/oracle/orainstall/patches/database_10. 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. “” = “ORA_DB” ] ; then if [ “$PLATFORM” = “HP-UX” ] ; then remsh $HOST -l $ORACLE -n “

End of Database Creation At the end of the database creation, exit from the DBCA. Click Finish to start the database creation process. Click OK on the “Summary” screen. Creation Options Keep the default option Create Database selected. You may use any domain. INFO
   SID: TESTDB   I used IDEVELOPMENT. Storage Options For this article, we will select to use File System. For the purpose of the example in this article, my log files were created in “/u01/app/oracle/product/10. Enter the password (twice) and make sure the password does not start with a digit number. For this example, I will create a Flash Recovery Area of 10GB. This option is available since we installed the Oracle Companion CD software. If you selected to configure Enterprise Manager during the database creation process, the OUI will provide the URL. For example: http://vmlinux1:1158/em   I like to review the log files that were created by the DBCA process. I also always select to Generate Database Creation Scripts. INFO for the database domain. After acknowledging the database creation report and script generation dialog, the database creation will start. Database Templates Select Custom Database Database Identification Select:
   Global Database Name: TESTDB. Keep in mind that this domain does not have to be a valid DNS domain. Database Storage Change any parameters for your environment. When the Oracle Database Configuration Assistant has completed, you will have a fully functional Oracle database running.    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. I left them all at their default settings. 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. 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. Initialization Parameters Change any parameters for your environment. 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. I left them all at their default settings.

ORA_DB” exit else rsh $HOST -l $ORACLE

A user who accesses a. Amazon Linux is functionally compatible. A commercial Linux operating system distribution. The computer that you currently work on. Red Hat® Enterprise Linux®. Usr/local/cpanel/logs/login_log – A record of failed login attempts.

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

Tablespace Size Used (in bytes) Pct. Here is a snapshot of the tablespaces I have defined for my test database environment: SQL> @dba_tablespaces Status Tablespace Name TS Type Ext. 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.

{start|stop}” exit ;; esac # exit Note that this method relies on the presence of an RSH server, which requires additional packages and configuration. TESTDB) will have its own set of online redolog files known as a thread. 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 /u01/app/oracle $ cd /u01/app/oracle $ unzip dba_scripts_archive_Oracle. This may take some time to download. Changing Your Oracle Database Environment In some cases, you may have more than one database running on your single database server. Dbf’ resize 1024m; SQL> — Temporary Tablespace SQL> alter database tempfile ‘/u02/oradata/TESTDB/datafile/o1_mf_temp_3rbj6f1s_. Hunter and is protected under copyright laws of the United States. I also always select to Generate Database Creation Scripts. As already mentioned, Oracle writes to its online redolog files in a circular manner. 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. Use the chmod command to set the privileges to 750: # chmod 750 /etc/init. After acknowledging the database creation report and script generation dialog, the database creation will start. Sql ======================================== Automatic Shared Memory Management ======================================== asmm_components. 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. All articles, scripts and material located at the Internet address of http://www. Also included are the steps required to restore the Red Hat Release File which was modified earlier in this article. To check for the process, type the following: $ emctl status dbconsole TZ set to US/Eastern Oracle Enterprise Manager 10g Database Control Release 10. You can simply accept the default parameters for the next six screens:
   What do you want to do: Add
   Listener name: LISTENER
   Selected protocols: TCP
   Port number: 1521
   Configure another listener: No
   Listener configuration complete. This document may not be hosted on any other site without my express, prior, written permission. Known Issues The following known issue does not apply to this article since we applied the Oracle 10. Enter the password (twice) and make sure the password does not start with a digit number. Keep in mind that this domain does not have to be a valid DNS domain. Sql
Creating / Altering Tablespaces When creating the Oracle database, we left all tablespaces set to their default size. D/dbora #. 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/db_1/vmlinux1_TESTDB/sysman/log The OEM DB Console application may take several minutes to start. Located in Pittsburgh, Pennsylvania. For the purpose of this example, the only instance defined in the /etc/oratab file is TESTDB: /etc/oratab. INFO for the database domain. —————————————————————— Logs are generated in directory /u01/app/oracle/product/10. Welcome Click Finish to exit the NETCA. Root Script Window – Run root. It is even possible to be using two different databases running on different releases of the Oracle Database software. ) 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. 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. This is a process known as archiving. 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 $ 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. 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_. If the database is in “Archive Log Mode”, Oracle will make a copy of the online redo log before it gets reused. He has been a Sr. /bin/sh # chkconfig: 345 99 10 # description: Oracle auto start-stop script. When working through this section, substitute the data file names that were created in your environment where appropriate. Click Finish to start the database creation process. 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. End of installation At the end of the installation, exit from the OUI. Running this script should be done only after considering all security ramifications. Oraenv ORACLE_SID = [ORA920]. 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. 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. 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. 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). When the Oracle Database Configuration Assistant has completed, you will have a fully functional Oracle database running. Tablespace Size Used (in bytes) Pct. 0 $ export DISPLAY To start the NETCA, run the following: $ netca & Oracle Network Configuration Installation Screen Responses Screen Name Response Welcome Select Listener configuration. Database Templates Select Custom Database Database Identification Select:
   Global Database Name: TESTDB. Next, unzip the archive file to the $ORACLE_BASE directory. 0/db_1 Summary On the Summary screen, click Install to start the installation. Sql script to recompile all invalid PL/SQL packages now instead of when the packages are accessed for the first time. For example: http://vmlinux1:1158/em   I like to review the log files that were created by the DBCA process. 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 TEMP /u02/oradata/TESTDB/datafile/o1_mf_temp_3rbj6f1s_. # # 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. 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. 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. The RSH server does not get installed by default on many Linux distributions (and for good reason. Sql   When the 10. Zip (last updated 21-FEB-2007) and is 900MB in size.    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. Change to the install directory by using the following command: $ cd $ORACLE_HOME/install Run changePerm. This option is available since we installed the Oracle Companion CD software. Dbf SYSTEM /u02/oradata/TESTDB/datafile/o1_mf_system_3rbj5g8h_. 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. 3 $ unzip p5337014_10203_LINUX. Once an online redolog fills, Oracle moves to the next one. Last modified on
Monday, 14-Jul-2014 18:05:22 EDT
Page Count: 124922. 0/db_1 directory and run root. Listener Configuration
(Next 6 Screens) The following screens are now like any other normal listener configuration. 0/db_1/vmlinux1_TESTDB/sysman/log If you recieve something similar to the above output, then OEM Database Console is running. Info is the copyright of Jeffrey M. Once the DB Console application is up and running, point your web browser to http://:1158/em as in the following: http://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. Storage Options For this article, we will select to use File System. Use the following tasks to put your new database into archive log mode. Open a new console window as the “root” user account. If you selected to configure Enterprise Manager during the database creation process, the OUI will provide the URL. I left them all at their default settings. 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. From the command prompt, simply run the following: $. Tmp UNDOTBS1 /u02/oradata/TESTDB/datafile/o1_mf_undotbs1_3rbj61p7_. This step is optional but recommended. # # Change the value of ORACLE_HOME to specify the correct Oracle home # directory for your installation. Bash_profile login script that was created in the section Create Login Script for oracle User Account. Database Administrator and Software Engineer for over 20 years and maintains his own website site at: http://www. End of Database Creation At the end of the database creation, exit from the DBCA. You may use any domain. Zip archive will be copied to /u01/app/oracle. :$ORACLE_HOME/rdbms/admin export ORACLE_PATH   Note that the ORACLE_PATH environment variable should already be set in the. 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. This requires you update environment variables like ORACLE_HOME, ORACLE_SID, PATH, LD_LIBRARY_PATH, etc. Dbf USERS /u02/oradata/TESTDB/datafile/o1_mf_users_3rbj6q3y_. 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. Copyright (c) 1998-2018 Jeffrey M. 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_. Note however that this will require a short database outage. For this example, I will create a Flash Recovery Area of 10GB. Creation Options Keep the default option Create Database selected. 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. Although this can be done manually at the command line, it can get old real quick. 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. [ Next ]
You will be returned to this Welcome (Type of Configuration) Screen. 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. 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. Dbf’ resize 1024m; SQL> — SYSAUX Tablespace SQL> alter database datafile ‘/u02/oradata/TESTDB/datafile/o1_mf_sysaux_3rbj68np_. As of Oracle 10g Release 2 the dbstart script includes the commands to automatically start/stop the listener. After running the root. Instead you can use a single command line script to switch between all database environments declared in your /etc/oratab file. Sh and specify the patched server Oracle home location, before accessing client-side utilities or libraries in the database home. 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. 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. For example, perform the following as the oracle user account: $ mv dba_scripts_archive_Oracle. 3/Disk1/runInstaller Oracle 10. For example, you may have two database – ORA920 (using Oracle release 9. Click OK on the “Summary” screen. The Oracle Database 10g Release 2 Patch Set 2 has now been successfully applied. 0) and TESTDB (using Oracle release 10. Database Storage Change any parameters for your environment. 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. When the current online redolog fills, Oracle will switch to the next one. 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. In almost all cases, the DBCA will automatically start the OEM Database Console application. The Oracle DBA scripts archive can be downloaded using the following link http://www. ——————————————————————————- Do you wish to continue (y/n) [n]: y Finished running the script successfully Please see /tmp/changePerm_err. Sql perf_top_sql_by_buffer_gets. 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. D/dbora script would be defined as follows: /etc/init. I will in no case be liable for any monetary damages arising from such loss, damage or destruction. For the purpose of the example in this article, my log files were created in “/u01/app/oracle/product/10. Sh accepting all default values. Prior to modifying the Red Hat Release File, we made a backup copy of the original file. An Oracle instance (i. 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. Naming Methods Configuration The following screens are:
   Selected Naming Methods: Local Naming
   Naming Methods configuration complete. Whatever the case may be, you need an efficient way to modify your environment variables to switch between these two databases. Original /etc/redhat-release
Re-compile Invalid Objects Run the utlrp. /bin/sh # chkconfig: 345 99 10 # description: Oracle auto start-stop script. 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. Zip archive to the $ORACLE_BASE directory. When all of the options are filled out, click the “Go” button. Enterprise Manager – Database Console During the database creation section, we asked for DBCA to create the Enterprise Manager Database Console application. 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. Final Notes The /etc/init. 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. 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_. 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. D/dbora script to be started and stopped when the database server is cycled.
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. Ignore any messages indicating that the database contains invalid recycle bin objects similar to the following: BINlzljWIt9gfgMFeM2hVSoA==

2 Re-execute the Configuration Assitant. Located in Pittsburgh, Pennsylvania. 132 vmlinux4 vmlinux4. In this section, we will be downloading and extracting the required software from Oracle to the database server. $ su – # cp /etc/redhat-release /etc/redhat-release. 112 vmlinux2 vmlinux2. Use the following commands to determine the current buffer size (in bytes) of each of the IPC networking parameters: # cat /proc/sys/net/core/rmem_default 109568 # cat /proc/sys/net/core/rmem_max 131071 # cat /proc/sys/net/core/wmem_default 109568 # cat /proc/sys/net/core/wmem_max 131071 Oracle 10g Required Kernel Parameter Settings Now let’s review what has been covered thus far. For example, you may have two database – ORA920 (using Oracle release 9. Login file by running the following command: cat >> /etc/csh. -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.   Oracle Database 10g Release 2 (10. 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. 106 melody melody. Below are several optional SQL commands for modifying and creating all tablespaces for the test database. Remember that we will create the database as a separate step using DBCA. Shmmax = 2147483648 kernel. You may use any domain. D/dbora – (rsh method) #. See your Exceed documentation for instructions on configuring the window manager. We will, instead, create the database using the Database Configuration Assistant (DBCA) after all of the software and patches have been installed. For the purpose of this example, the only instance defined in the /etc/oratab file is TESTDB: /etc/oratab. Keep in mind that this domain does not have to be a valid DNS domain. Dbf’ resize 1024m; SQL> — Temporary Tablespace SQL> alter database tempfile ‘/u02/oradata/TESTDB/datafile/o1_mf_temp_3rbj6f1s_. Bash_profile login script that was created in the section Create Login Script for oracle User Account. The semop system call (function) provides the ability to do operations for multiple semaphores with one semop system call. Dbf SYSTEM /u02/oradata/TESTDB/datafile/o1_mf_system_3rbj5g8h_. 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. 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. This may take some time to download. In situations like this, the group membership prevents unauthorized access to the database by personal who only maintain the Oracle software.   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. After the directory is created, you must then specify the correct owner, group, and permissions for it. 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. Use the chmod command to set the privileges to 750: # chmod 750 /etc/init. 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 Bourne, Bash, or Korn shell, add the following lines to the /etc/profile file by running the following command: cat >> /etc/profile 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_. 102 alex alex. Change to the install directory by using the following command: $ cd $ORACLE_HOME/install Run changePerm. If any of the checks fail, you will need to manually verify the check that failed by clicking on the checkbox. Accept_source_route = 0 kernel. An Oracle instance (i. The last screen of a successful Oracle Database 10g Release 2 installation is the “End of Installation” screen. Ip_forward = 0 net. Oraenv ORACLE_SID = [ORA920]. Sql ======================================== Automatic Storage Management ======================================== asm_alias. Loc” are 644 (-rw-r–r–) and owned by root:root. 0) for Linux x86 Next, download the Oracle Database 10g Companion CD for Linux x86. This is a process known as archiving. D/iptables status Firewall is stopped. Shmall = 2097152 # +———————————————————+ # | SEMAPHORES | # | ———- | # | | # | SEMMSL_value SEMMNS_value SEMOPM_value SEMMNI_value | # | | # +———————————————————+ kernel. It is even possible to be using two different databases running on different releases of the Oracle Database software. Parameter Recommended Value Default Value How to Check shmmax 2147483648 33554432 cat /proc/sys/kernel/shmmax shmmni 4096 4096 cat /proc/sys/kernel/shmmni shmall 2097152 2097152 cat /proc/sys/kernel/shmall shmmin 1 1 ipcs -lm | grep “min seg size” &nbsp semmsl 250 250 cat /proc/sys/kernel/sem | awk ‘{print }’ semmns 32000 32000 cat /proc/sys/kernel/sem | awk ‘{print }’ semopm 100 32 cat /proc/sys/kernel/sem | awk ‘{print }’ semmni 128 128 cat /proc/sys/kernel/sem | awk ‘{print }’ &nbsp file-max 65536 102696 cat /proc/sys/fs/file-max &nbsp ip_local_port_range 1024   65000 32768   61000 cat /proc/sys/net/ipv4/ip_local_port_range &nbsp rmem_default 1048576 109568 cat /proc/sys/net/core/rmem_default rmem_max 1048576 131071 cat /proc/sys/net/core/rmem_max wmem_default 262144 109568 cat /proc/sys/net/core/wmem_default wmem_max 262144 131071 cat /proc/sys/net/core/wmem_max   If the current value for any parameter is higher than the value listed in this table, do not change the value of that parameter. 0, asianux-1 or asianux-2 Failed > /etc/security/limits. Navigate to the /u01/app/oracle/oraInventory directory and run orainstRoot. 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. Initialization Parameters Change any parameters for your environment. 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. Localdomain localhost it should be removed as shown below: 127. 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. Sh script go back to the OUI and acknowledge the “Execute Configuration scripts” dialog window. Running this script should be done only after considering all security ramifications. 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. Next, create a text file named /etc/init. Tmp UNDOTBS1 /u02/oradata/TESTDB/datafile/o1_mf_undotbs1_3rbj61p7_. Miscellaneous Options This final section of the article contains several miscellaneous options that may be of use to newcomers of Oracle10g. —————————————————————— Logs are generated in directory /u01/app/oracle/product/10. Oracle recommends setting the semopm to a value of no less than 100. Please keep in mind that this is an optional step. Before starting the Oracle Universal Installer, you should first verify you are logged onto the server you will be running the installer from (i. 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. The UNIX group oinstall is used by organizations that have separate teams responsible for maintaining the Oracle software and the database(s). Database Templates Select Custom Database Database Identification Select:
   Global Database Name: TESTDB. Conf /etc/pam. Sql perf_top_sql_by_buffer_gets. Sh before running 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. Extract the Oracle Database 10g Software: # su – oracle $ mkdir -p ~oracle/orainstall $ cd ~oracle/orainstall $ unzip 10201_database_linux32. 0 Copyright (c) 1996, 2006 Oracle Corporation. 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. Zip
Pre-Installation Tasks This section contains the mandatory tasks that need to be completed before install the Oracle Database 10g software. 0) and optionally the Companion CD Release 2 (10. For example: http://vmlinux1:1158/em   I like to review the log files that were created by the DBCA process. Application to host any of the material elsewhere can be made by contacting me at [email protected] Oracle strongly suggests to adjust the default and maximum receive buffer size (SO_RCVBUF socket option) to 1MB and the default and maximum send buffer size (SO_SNDBUF socket option) to 256KB. To check for the process, type the following: $ emctl status dbconsole TZ set to US/Eastern Oracle Enterprise Manager 10g Database Control Release 10. D/iptables stop Flushing firewall rules: [ OK ] Setting chains to policy ACCEPT: filter [ OK ] Unloading iptables modules: [ OK ] 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. Tablespace Size Used (in bytes) Pct. ) 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. 3/Disk1/runInstaller Oracle 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. Sql script: SQL> @help. [ Next ]
You will be returned to this Welcome (Type of Configuration) Screen. Database Storage Change any parameters for your environment. Info # # ————- [ LINUX ] ————————————- 192. Please note that Oracle Corporation recommends using the most restrictive file permissions as possible for your given implementation. ——————————————————————————- Do you wish to continue (y/n) [n]: y Finished running the script successfully Please see /tmp/changePerm_err. 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. Enter the password (twice) and make sure the password does not start with a digit number. 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. INFO for the database domain. Database Administrator and Software Engineer for over 20 years and maintains his own website site at: http://www. Select this patchset in the Results section and then click the Download button to start the download process. 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.    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. You should also verify that the Oracle TNS listener service is running before attempting to start the database creation process. /bin/sh # chkconfig: 345 99 10 # description: Oracle auto start-stop script. 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). 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. Shmall) put in by CentOS 5. Create Group and User for Oracle Lets start this section by creating the UNIX oinstall and dba group and oracle user account: # groupadd -g 501 oinstall # groupadd -g 502 dba # groupadd -g 503 oper # useradd -m -u 501 -g oinstall -G dba,oper -d /home/oracle -s /bin/bash -c “Oracle Software Owner” oracle # id oracle uid=501(oracle) gid=501(oinstall) groups=501(oinstall),502(dba),503(oper) Set the password for the oracle account: # passwd oracle Changing password for user oracle. Once the DB Console application is up and running, point your web browser to http://:1158/em as in the following: http://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. # 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. 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. Vmlinux1) then run the xhost + command as root from the console to allow X Server connections. 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. 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). 3 (also known as patch 5337014). The OUI uses the file /etc/redhat-release to determine the platform. As the oracle user account, download the dba_scripts_archive_Oracle. Conf to correct the values, re-run the sysctl -p command and verify the values. For this example, I will create a Flash Recovery Area of 10GB. 120 cartman cartman. 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. 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. /bin/sh # chkconfig: 345 99 10 # description: Oracle auto start-stop script. Zip   (668,734,007 bytes)
Oracle Database 10g Companion CD Release 2 (10. Conf file which is used during the boot process. Storage Options For this article, we will select to use File System. 6 it is set to unlimited. He has been a Sr. Instead you can use a single command line script to switch between all database environments declared in your /etc/oratab file. 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. 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. Copyright (c) 1998-2018 Jeffrey M. This requires you update environment variables like ORACLE_HOME, ORACLE_SID, PATH, LD_LIBRARY_PATH, etc. D/login 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_. Next, login as the oracle user account. Sh and specify the patched server Oracle home location, before accessing client-side utilities or libraries in the database home. If the values are not correct, edit the /etc/sysctl.   The file name of the patchset to download is p5337014_10203_LINUX. End of installation At the end of the installation, exit from the OUI. Select the appropriate components for your environment and click Next to continue. At the same time, it also prevents database administrators from making modifications to the database software and the installation’s Inventory directory. 190 george george. 2 file: chmod 755 /usr/lib/libgdbm. 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. Creation Options Keep the default option Create Database selected. We now need to configure the /etc/hosts file. 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. # # Change the value of ORACLE_HOME to specify the correct Oracle home # directory for your installation. As of Oracle 10g Release 2 the dbstart script includes the commands to automatically start/stop the listener. Use the following command to determine the maximum number of file handles for the entire system: # cat /proc/sys/fs/file-max 102312 Oracle recommends that the file handles for the entire system be set to at least 65536. Oracle recommends setting the semmns to the sum of the PROCESSES instance parameter setting for each database on the system, adding the largest PROCESSES twice, and then finally adding 10 for each Oracle database on the system. Other Java applications that utilize the JRE are the Database Configuration Assistant and the Oracle Net Assistant. If the firewall option is operating you will need to first manually disable UDP ICMP rejections: # /etc/rc. TESTDB) will have its own set of online redolog files known as a thread. Do not use DHCP naming for the public IP address; you need a static IP address. However, we must first download and extract the required Oracle software packages from the Oracle Technology Network (OTN). Once an online redolog fills, Oracle moves to the next one. 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. Sem = 250 32000 100 128 # +———————————————————+ # | FILE HANDLES | # ———————————————————-+ fs. After acknowledging the database creation report and script generation dialog, the database creation will start. 1 router router. 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. 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.   If you do not currently have an account with Oracle OTN, you will need to create one. 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). Final Notes The /etc/init. I also always select to Generate Database Creation Scripts. 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:. Conf, I removed the two shared memory kernel parameters (kernel. Given the Oracle database installation is now completed, we should now restore the original version of this file: $ su – # cp /etc/redhat-release. 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. The Oracle instance (or thread) will use its group of online redologs in a circular manner. 0 $ export DISPLAY To start the NETCA, run the following: $ netca & Oracle Network Configuration Installation Screen Responses Screen Name Response Welcome Select Listener configuration. Also included are the steps required to restore the Red Hat Release File which was modified earlier in this article. $ id -a uid=501(oracle) gid=501(oinstall) groups=501(oinstall),502(dba),503(oper) $ sqlplus “/ as sysdba” SQL> @. Open a new console window as the “root” user account. 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. Installations can no longer be performed using character mode. :$ORACLE_HOME/rdbms/admin export ORACLE_SID=TESTDB export PATH=. The last screen of a successful Oracle Database 10g Companion CD Release 2 installation is the “End of Installation” screen. 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. Loc are not set correctly, it is possible you didn’t run orainstRoot. The RSH server does not get installed by default on many Linux distributions (and for good reason. For example, perform the following as the oracle user account: $ mv dba_scripts_archive_Oracle. Core_uses_pid = 1 net. Bash_profile for Oracle User #. If you would like to make these kernel parameter value changes to the current system without having to first reboot, enter the following command: # /sbin/sysctl -p net. The type of installation to perform will be the Oracle Database 10g Products installation type. 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. For the purpose of the example in this article, my log files were created in “/u01/app/oracle/product/10. This is a FREE account. Oracle offers a development and testing license free of charge. Enterprise Manager – Database Console During the database creation section, we asked for DBCA to create the Enterprise Manager Database Console application. NOTE: After executing the orainstRoot. 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 example, to query tablespace information while logged into the Oracle database as a DBA user: SQL> @dba_tablespaces Status Tablespace Name TS Type Ext.   This guide adheres to the Optimal Flexible Architecture (OFA) for naming conventions used in creating the directory structure. 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. Localdomain localhost
Remove IPv6 Entries Remove any entry that has to do with IPv6 (for example, ::1 localhost6. Original /etc/redhat-release
Re-compile Invalid Objects Run the utlrp. Sysrq = 0 kernel. (By default the option to configure a firewall is selected by the installer. 131 vmlinux3 vmlinux3. # # 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. End of installation At the end of the installation, exit from the OUI. Navigate to the /u01/app/oracle/product/10. Dbf USERS /u02/oradata/TESTDB/datafile/o1_mf_users_3rbj6q3y_. INFO
   SID: TESTDB   I used IDEVELOPMENT. End of Database Creation At the end of the database creation, exit from the DBCA. This document may not be hosted on any other site without my express, prior, written permission. Please note that prior to adding the following kernel parameter values to /etc/sysctl. For this article, I identified and provide the following values that will need to be added to the /etc/sysctl. Shmmni = 4096 kernel. New UNIX password: xxxxxxxxxxx Retype new UNIX password: xxxxxxxxxxx passwd: all authentication tokens updated successfully. From the Simple Search screen, select the “Product or Family” option in the Search By pull-down listing. Note that the Oracle database server should have a static IP address configured for the public network (eth0 for this article). Known Issues The following known issue does not apply to this article since we applied the Oracle 10.
Configuring Shell Limits for the oracle User To improve the performance of the software on Linux systems, Oracle recommends you increase the following shell limits for the oracle user: Shell Limit Item in limits. 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. The receive buffers are used by TCP and UDP to hold received data until it is read by the application. 0/db_1 # # Change the value of ORACLE to the login name of the # oracle owner at your site. Zip archive will be copied to /u01/app/oracle. 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. Sh accepting all default values. In the text field to the right, enter “RDBMS Server”. This means that datagrams will be discarded if they don’t fit in the socket receive buffer, potentially causing the sender to overwhelm the receiver. For my installation, all checks passed with no problems. 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. Note however that this will require a short database outage. 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. 1 and later, Oracle makes use of UDP as the default protocol on Linux for inter-process communication (IPC), such as Cache Fusion and Cluster Manager buffer transfers between instances within the RAC cluster. 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. The OUI provides you with several URLs that will be activated by the OUI: Ultra Search URL: http://vmlinux1:5620/ultrasearch Ultra Search Administration Tool URL: http://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. Conf file, they persist each time the system reboots. 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. Sql ======================================== Workspace Manager ======================================== wm_create_workspace. 2 Change the permissions in the libdb. Dbf TEMP /u02/oradata/TESTDB/datafile/o1_mf_temp_3rbj6f1s_. 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. Tcp_syncookies = 1 kernel. Bash_profile # Get the aliases and functions if [ -f ~/. Last modified on
Monday, 14-Jul-2014 18:05:22 EDT
Page Count: 124922. 105 bartman bartman. 1 localhost. Root Script Window – Run root. 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. Sql   When the 10. 0) Software for Linux x86. 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. # ORACLE=oracle PATH=${PATH}:$ORACLE_HOME/bin HOST=`hostname` PLATFORM=`uname` export ORACLE_HOME PATH # if [. This section will provide the steps necessary to configure the database server to successfully run the Oracle Universal Installer (OUI). Whatever the case may be, you need an efficient way to modify your environment variables to switch between these two databases. When all of the options are filled out, click the “Go” button. Next, unzip the archive file to the $ORACLE_BASE directory. Wmem_max = 262144 Review the output from the above command and verify that the values are correct. Sh Script on an Oracle Database Server Home During patch set installation, all new files and directories are created with restricted access, by default. 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. Finally, for the Platform or Language option, select “Linux x86”. 0/db_1 directory and run root. This step is optional but recommended. Checking operating system version: must be redhat-3, SuSE-9, redhat-4, UnitedLinux-1. Log for errors and /tmp/changePerm. For the purpose of this article, I will be downloading and installing patch: 5337014. When sourcing the oraenv script, it will prompt you for the ORACLE_SID, (defined in your /etc/oratab file), you want to switch to. When the current online redolog fills, Oracle will switch to the next one. If any of the checks fail, you will need to manually verify the check that failed by clicking on the checkbox.   Access to Oracle Metalink requires a valid login and CSI number. 3 $ unzip p5337014_10203_LINUX. Downloading the Patchset The Oracle 10. Hunter and is protected under copyright laws of the United States. Http://vmlinux1:1158/em/console/aboutApplication Oracle Enterprise Manager 10g is running. 0/db_1 Summary On the Summary screen, click Install to start the installation. The OUI will immediately fail if it doesn’t recognize either of these two platforms: $ /home/oracle/orainstall/database/runInstaller Starting Oracle Universal Installer. 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. If the firewall option is stopped (like it is in my example below) you do not have to proceed with the following steps. For the purpose of this example, the dba_scripts_archive_Oracle. 0) and TESTDB (using Oracle release 10. This will bring up the available patchsets in the Results section. 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. Tablespace Size Used (in bytes) Pct. In this article, I will be downloading the required Oracle software to vmlinux1 and saving it to “~oracle/orainstall”. The default value for ip_local_port_range is ports 32768 through 61000 which is inadequate for a successful Oracle configuration. 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. | # +———————————————————+ # +———————————————————+ # | SHARED MEMORY | # +———————————————————+ kernel. 0/db_1 ORA_OWNER=oracle if [. 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. “” = “ORA_DB” ] ; then if [ “$PLATFORM” = “HP-UX” ] ; then remsh $HOST -l $ORACLE -n “[text] ORA_DB” exit else rsh $HOST -l $ORACLE [text] ORA_DB exit fi fi # case in ‘start’) $ORACLE_HOME/bin/dbstart $ORACLE_HOME ;; ‘stop’) $ORACLE_HOME/bin/dbshut $ORACLE_HOME ;; *) echo “usage: [text] {start|stop}” exit ;; esac # exit Note that this method relies on the presence of an RSH server, which requires additional packages and configuration. 0/db_1 directory and run root. —————————————————————— Logs are generated in directory /u01/app/oracle/product/10. Login to the database server as the “oracle” user account. I left them all at their default settings. /u01/app owned by root. Note that members of the UNIX group oinstall are considered the “owners” of the Oracle software. After running the root. Wmem_default = 262144 net. These objects belong to the unsupported components and do not affect the database operation. Click OK on the “Summary” screen. The Oracle DBA scripts archive can be downloaded using the following link http://www. Verify the ulimit setting my issuing the ulimit command: # ulimit unlimited IP Local Port Range Oracle strongly recommends to set the local port range ip_local_port_range for outgoing messages to “1024 65000” which is needed for systems with high-usage. If the permissions to /etc/oraInst. D/dbora #. After running the root. D/dbora script would be defined as follows: /etc/init. If you selected to configure Enterprise Manager during the database creation process, the OUI will provide the URL. Zip /u01/app/oracle $ cd /u01/app/oracle $ unzip dba_scripts_archive_Oracle. 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. Naming Methods Configuration The following screens are:
   Selected Naming Methods: Local Naming
   Naming Methods configuration complete. Specify Home Details Set the Name and Path for the ORACLE_HOME as follows:
   Name: OraDb10g_home1
   Location: /u01/app/oracle/product/10. 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_. File-max = 65536 # +———————————————————+ # | LOCAL IP RANGE | # ———————————————————-+ net. 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. This installation type includes the Natively Compiled Java Libraries (NCOMP) files to improve Java performance. Setting Kernel Parameters for Oracle If the value of any kernel parameter is different to the recommended value, they will need to be modified. 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. Zip Extract the Oracle Database 10g Companion CD Software: $ cd ~oracle/orainstall $ unzip 10201_companion_linux32. Sh accepting all default values. 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. Login

Enabling Archive Logs – (Optional) Oracle tracks and logs all changes to database blocks in online redolog files. Sh After the patch installation has completed, you will be prompted to run the root. When sourcing the oraenv script, it will prompt you for the ORACLE_SID, (defined in your /etc/oratab file), you want to switch to. Given the Oracle database installation is now completed, we should now restore the original version of this file: $ su – # cp /etc/redhat-release. I left them all at their default settings.

red hat enterprise linux localhost login

[text]
[text]
[text]

red hat enterprise linux localhost login

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

Instalasi CMS Swarakalibata

Leave a Reply

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