Installation Of Oracle Database 11g R 2 (11.2) On Fedora 14 (F14)
Download the next software.
Oracle Database 11g Release 2 (11.2) Software
Unpack Files
Unzip the files.
unzip linux.x64_11gR2_database_1of2.zip unzip linux.x64_11gR2_database_2of2.zip
You should now take over a single directory called "database" containing installation files.
Hosts File
The "/etc/hosts" file must have a fully qualified reputable name the server.
Set Kernel Parameters
Oracle recommend the subsequent minimum parameter settings.
Add or amend this lines inside "/etc/sysctl.conf" file.
Open /etc/sysctl.conf and add the subsequent lines without the linespace.
fs.aio-max-nr = 1048576 fs.file-max = 6815744 kernel.shmall = 2097152 kernel.shmmax = 536870912 kernel.shmmni = 4096 kernel.sem = 250 32000 100 128 net.ipv4.ip_local_port_range = 9000 65500 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048586
Run the next command to alter the current kernel parameters.
/sbin/sysctl -p
Add the next lines towards the "/etc/security/limits.conf" file with virtually no linespace.
oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536
Add these line to your "/etc/pam.d/login" file, when it does not already exist.
session required pam_limits.so
Start the Firewall administration dialog (System > Administration > Firewall). Click the "Disable" button as well as the apply button for the toolbar, then close the dialog.
Disable secure linux by editing the "/etc/selinux/config" file, being confident that the SELINUX flag is defined as follows.
SELINUX=disabled
Alternatively, this alteration can be achieved using the GUI tool (Applications > System Settings > Security Level). Click within the SELinux tab and disable the feature. If SELinux is disabled after installation, the server need a reboot with the change to work.
Restart your body.
Setup
If you might have installed the suggested package groups through the installation, the vast majority of necessary packages will already be installed. The following packages are listed as required, such as 32-bit version of a number of the packages.
If gives error like
[root@localhost oracle]# yum install binutils
Loaded plugins: langpacks, presto, refresh-packagekit
Adding en_US to language list
Error: Cannot retrieve repository metadata (repomd.xml) for repository: fedora. Please verify its path and try again
Solution
It turned out that my local DNS server was the condition so I stopped it and put in /etc/hosts these 2 lines:
Code:
80.239.156.215 mirrors.fedoraproject.org 213.129.242.84 mirrors.rpmfusion.org
yum install binutils yum install compat-libstdc++-33 yum install compat-libstdc++-33.i686 yum install elfutils-libelf yum install elfutils-libelf-devel yum install gcc yum install gcc-c++ yum install glibc yum install glibc.i686 yum install glibc-common yum install glibc-devel yum install glibc-devel.i686 yum install glibc-headers yum install ksh yum install libaio yum install libaio.i686 yum install libaio-devel yum install libaio-devel.i686 yum install libgcc yum install libgcc.i686 yum install libstdc++ yum install libstdc++.i686 yum install libstdc++-devel yum install make yum install numactl-devel yum install sysstat yum install unixODBC yum install unixODBC.i686 yum install unixODBC-devel yum install unixODBC-devel.i686
Create the revolutionary groups and users.
groupadd oinstall groupadd dba groupadd oper groupadd asmadmin useradd -g oinstall -G dba,oper,asmadmin oracle passwd oracle
Note. We are not about to use the "asmadmin" group, because installation won't use ASM.
Create the directories where the Oracle software will probably be installed.
mkdir -p /u01/app/oracle/product/11.2.0/db_1 chown -R oracle:oinstall /u01 chmod -R 775 /u01
Login as root and issue these command.
xhost +
Edit the "/etc/redhat-release" file replacing the actual release information "Fedora release 14 (Laughlin)" with this.
redhat release 5
Login since the oracle user and add the next lines after the ~/.bash_profile file.
# Oracle Settings TMP=/tmp; export TMP TMPDIR=$TMP; export TMPDIR ORACLE_HOSTNAME=localhost.localdomain; export ORACLE_HOSTNAME ORACLE_UNQNAME=orcl; export ORACLE_UNQNAME ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME ORACLE_SID=orcl; export ORACLE_SID ORACLE_TERM=xterm; export ORACLE_TERM PATH=/usr/sbin:$PATH; export PATH PATH=$ORACLE_HOME/bin:$PATH; export PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH if [ $USER = "oracle" ]; then if [ $SHELL = "/bin/ksh" ]; then ulimit -p 16384 ulimit -n 65536 else ulimit -u 16384 -n 65536 fi fi
Log into your oracle user. If you happen to be using X emulation then set the DISPLAY environmental variable.
DISPLAY=:0.0; export DISPLAY
Restart your laptop.
Start the Oracle Universal Installer (OUI) by issuing the next command inside database directory.
[oracle@localhost ~]$ cd database/
./runInstaller
The OUI (Oracle Universal Installer) should start and you need to see following screens from the order given below:
1. Provide your email and Oracle support password for getting security updates from Oracle.
2. Installation options like developing a database, installing oracle software only or upgrading the database. Select "Create and configure a database".
3. Choose the system class here. Select "Server Class" it offers a superior more advanced options.
4. Choose from creating 1 node installation or RAC.
5. Choose your installation Typical or Advanced. We will go along with typical at this time.
6. If you choose typical install in the past screen, then you'll see this page for Install Configurations. Provide Oracle software installation location, database files location and administrator password etc.
7. Specify the Oracle install inventory location and Operating system group "oinstall".
8. Now all prerequisite checks will probably be performed here of course, if every thing is fine you will probably be moved for the install summary page. You can hit the "Back" button accessible back to start to see the status of all of the checks performed.
9. Installation Summary page. Hit "Finish" to get started on the Installation.
10. Installation Progress. This will take several minutes and this will automatically invoke Database COnfiguration Assistant to make a database.
11. Database Configuration Assistant invoked from the installer.
12. Once DBCA has finished creating the database, it can show a webpage like this. It is a report on the database which includes just been created.
13. As a last step you are going to be asked to execute some configuration scripts as root.
Edit the "/etc/redhat-release" file restoring the initial release information.
Fedora release 14 (Laughlin)
Edit the "/etc/oratab" file setting the restart flag for every instance to 'Y'.
orcl:/u01/app/oracle/product/11.2.0/db_1:Y
What needs to connect PUTTY to Fedora 14 ?
Make sure the sshd service is enabled and started.
Code:
su -c 'chkconfig sshd on' su -c 'service sshd restart'
Internet lag and Windows Network "failed to retrieve share list from server"
I have solved by disabling Firewall and after that apply. The other ways is under:
Well Problem Solved! I searched around around the forums determined a thread that taught me to be out.
http://forums.fedoraforum.org/showth...re+list+server
Explained what I necessary to do to configure my machine
It works out that I was required to install the samba client. I installed the packages
su root
yum install samba-client.i686 samba-common.i686
Then, I had to set up
I ran
system-config-samba
and it seemed to begin with up fine. This config file looks like it's geared towards the windows platforms accessing shares out of your linux box. I didn't configure anything here. The thread then says to change your firewall.
I then ran
system-config-firewall
and enabled samba inside the "trusted services". It was capable of access my windows network shares and then.
I did the configurations over the gui of each one of the config files, however if anyone incorporates a spare second, I'd like to learn the best way to configure the settings from the inside the terminal itself. Or a connection to a thread explaining the commands in terminal could be great!
Note:
customize the below lines of above ~/.bash_profile file by reopening in vi and other editor.
ORACLE_HOSTNAME = ora11g.home.com with your own individual host name and
ORACLE_SID=ora11g with your personal SID name which you've got entered during the time of oracle installation
Automating Database Startup and Shutdown on Linux
The following represents the Oracle recommended way for automating database startup and shutdown of Oracle 9i instances on Linux, but it really works as well for Oracle 10g, 11G and 12c also. It can be used on any RHEL-style distribution, including Oracle Linux, approximately an including RHEL6.
Once the instance is established, edit the "/etc/oratab" file setting the restart flag for every single instance to 'Y'.orcl:/u01/app/oracle/product/11.2.0/db_1:Y
Next, make a file called "/etc/init.d/dbora" because root user, containing the subsequent.
This method can nonetheless be used under Oracle 10g, 11g and 12c, provided the "ORA_HOME" variable is amended to makes use of the correct path which is added for the end from the dbstart and dbshut lines. The lines to get started on and stop the listener are easy to remove under Oracle 10g Release 2 onward, since the dbstart command includes an automated start from the listener.
#!/bin/sh # chkconfig: 345 99 10 # description: Oracle auto start-stop script. # # Set ORA_HOME to become equivalent for the $ORACLE_HOME # where you wish to execute dbstart and dbshut; # # Set ORA_OWNER towards the user id with the owner from the # Oracle database in ORA_HOME. #ORA_HOME=/u01/app/oracle/product/10.2.0/db_1 #ORA_HOME=/u01/app/oracle/product/11.1.0/db_1
ORA_HOME=/u01/app/oracle/product/11.2.0/db_1 #ORA_HOME=/u01/app/oracle/product/12.1.0/db_1 ORA_OWNER=oracle export ORACLE_UNQNAME=orcle if [ ! -f $ORA_HOME/bin/dbstart ] then echo "Oracle startup: cannot start" exit fi case "$1" in 'start') # Start the Oracle databases: # The following command assumes that this oracle login # won't prompt anyone for any values su $ORA_OWNER -c "$ORA_HOME/bin/dbstart $ORA_HOME" touch /var/lock/subsys/dbora ;; 'stop') # Stop the Oracle databases: # The following command assumes that this oracle login # will never prompt the person for any values su $ORA_OWNER -c "$ORA_HOME/bin/dbshut $ORA_HOME" rm -f /var/lock/subsys/dbora ;; esac
Use the chmod command to put the privileges to 750.
chmod 750 /etc/init.d/dbora
Associate the dbora service using the appropriate run levels and hang up it to auto-start using the next command.
chkconfig --add dbora
Create symbolic links to your dbora script from the appropriate run-level script directories as follows.
# ln -s /etc/init.d/dbora /etc/rc.d/rc0.d/K01dbora
# ln -s /etc/init.d/dbora /etc/rc.d/rc3.d/S99dbora
# ln -s /etc/init.d/dbora /etc/rc.d/rc5.d/S99dbora
Next, we should create the "startup.sh" and "shutdown.sh" scripts inside "/home/oracle/scripts". First make the directory.
# mkdir -p /home/oracle/scripts # chown oracle.oinstall /home/oracle/scripts
The "/home/oracle/scripts/startup.sh" script should contain this commands.
#!/bin/bash
export TMP=/tmp
export TMPDIR=$TMP export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOSTNAME=localhost.localdomain
export ORACLE_UNQNAME=orcl
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
#export ORACLE_HOSTNAME=ol6-121.localdomain #export ORACLE_UNQNAME=db12c #export ORACLE_HOME=$ORACLE_BASE/product/12.1.0/db_1 export PATH=/usr/sbin:$ORACLE_HOME/bin:$PATH export ORACLE_SID=db12c ORAENV_ASK=NO . oraenv ORAENV_ASK=YES # Start Listener lsnrctl start # Start Database sqlplus / as sysdba << EOF STARTUP; EXIT; EOF
The "/home/oracle/scripts/shutdown.sh" script is comparable.
#!/bin/bash export TMP=/tmp export TMPDIR=$TMP export ORACLE_BASE=/u01/app/oracle
export ORACLE_UNQNAME=orcl
export ORACLE_HOSTNAME=localhost.localdomain
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1 #export ORACLE_HOSTNAME=ol6-121.localdomain #export ORACLE_UNQNAME=db12c #export ORACLE_HOME=$ORACLE_BASE/product/12.1.0/db_1 export PATH=/usr/sbin:$ORACLE_HOME/bin:$PATH export ORACLE_SID=db12c ORAENV_ASK=NO . oraenv ORAENV_ASK=YES # Stop Database sqlplus / as sysdba << EOF SHUTDOWN IMMEDIATE; EXIT; EOF # Stop Listener lsnrctl stop
Note. You could move the planet settings to the "dbora" file or in a separate file that may be sourced from the startup and shutdown script. I kept it local for the script therefore you could understand the type of issues that need to get set in case you've to write a script to manage multiple installations, instances and listeners.
Make sure the permissions and ownership in the files is correct.
# chmod u+x /home/oracle/scripts/startup.sh /home/oracle/scripts/shutdown.sh # chown oracle.oinstall /home/oracle/scripts/startup.sh /home/oracle/scripts/shutdown.sh
Restart one's body and you will start to see the listener and database can start preventing automatically with all the machine. You may test as follows:
login as: oracle
oracle@192.168.1.200's password:
Last login: Wed Feb 6 05:10:13 2013 from 192.168.1.141
[oracle@localhost ~]$ sqlplus
SQL*Plus: Release 11.2.0.1.0 Production on Wed Feb 6 05:24:31 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Enter user-name: sys/syspassward@databasename as sysdba
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> grant connect,resource,dba to username identified by passward;
In Oracle 11g a brand new parameter called SEC_CASE_SENSITIVE_LOGON and that is defaults to TRUE for case sensitive passwords. My SCOTT password was "tiger" is small case and Forms 10g was taking it "TIGER" on runtime. Solution 1: - Connect as sys and alter the parameter to false.alter system set SEC_CASE_SENSITIVE_LOGON = FALSE;
Otherwise following error will occured.
ORA-01017 Invalid username/password logon denied
--Duplicating a Database
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmdupdb.htm
http://www.oracle-base.com/articles/11g/duplicate-database-using-rman-11gr2.php
http://gemsofprogramming.wordpress.com/2013/03/18/duplicate-a-11gr2-database-with-rman-the-one-where-we-duplicate-from-a-backup/
http://www.dbspecialists.com/blog/database-backups/duplicating-an-11gr2-oracle-database-with-no-connection-to-the-target/
All rights reserved. Connected to an idle instance.
If you want to do a basic smoketest from the installed database software to substantiate the installation was successful, try doing this:
$ cd $ORACLE_HOME $ pwd /app/oracle/product/11.2.0 $ $ id uid=501(oracle) gid=501(oinstall) groups=501(oinstall),502(dba),503(oper),504(asmadmin) $ emctl stop dbconsole Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0 Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved. https://ultra.xfpmurphy.com:1158/em/console/aboutApplication Stopping Oracle Enterprise Manager 11g Database Control ... ... Stopped. $ lsnrctl stop LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 04-DEC-2010 14:28:44 Copyright (c) 1991, 2009, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) The command completed successfully [oracle@ultra 11.2.0]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Sat Dec 4 14:28:54 2010 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> shutdown Database closed. Database dismounted. ORACLE instance banned. SQL> quit $ $ lsnrctl start LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 04-DEC-2010 14:30:21 Copyright (c) 1991, 2009, Oracle. All rights reserved. Starting /app/oracle/product/11.2.0/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 11.2.0.1.0 - Production System parameter file is /app/oracle/product/11.2.0/network/admin/listener.ora Log messages written to /app/oracle/diag/tnslsnr/ultra/listener/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ultra.xfpmurphy.com)(PORT=1521))) Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) STATUS with the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production Start Date 04-DEC-2010 14:30:21 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /app/oracle/product/11.2.0/network/admin/listener.ora Listener Log File /app/oracle/diag/tnslsnr/ultra/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ultra.xfpmurphy.com)(PORT=1521))) The listener supports no services The command completed successfully $ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Sat Dec 4 14:30:45 2010 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 839282688 bytes Fixed Size 2217992 bytes Variable Size 524290040 bytes Database Buffers 310378496 bytes Redo Buffers 2396160 bytes Database mounted. Database opened. SQL> quit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options $ $ emctl start dbconsole Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0 Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved. https://ultra.xfpmurphy.com:1158/em/console/aboutApplication Starting Oracle Enterprise Manager 11g Database Control ....... started. ------------------------------------------------------------------ Logs are generated in directory /app/oracle/product/11.2.0/ultra.xfpmurphy.com_orcl/sysman/log $
If you've got this far along with your installation of Oracle 11g, all is well. The core Oracle 11g database software program is installed and dealing. You may have some tweaking to complete for your particular requirements but that is certainly outside the scope in this post.
As part with the database installation a sample HR schema was installed but left locked. Here is tips on how to unlock this sample schema using sqlplus:
$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Sat Dec 4 16:51:07 2010 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> ALTER USER hr ACCOUNT UNLOCK IDENTIFIED BY xxxxxxx; User altered. SQL> quit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options $
At this stage you should be capable to invoke the Oracle sqldeveloper GUI by invoking $ORACLE_HOME/sqldeveloper/sqldeveloper/bin/sqldeveloper. However which causes the area log in, you've to configure a legitimate connection. As an example of tips on how to configure a current connection, we have found my HR connection properties:
Once you could have configured a current connection, you will likely be able to login as user HR and examine the HR schema.
To automatically start and prevent the Oracle database during system startup and shutdown you must place a proper script from the /etc/rc.d/init.d directory and symbolically link it on the appropriate rc directories. See this post to have an example of this sort of script.
An Oracle Instant Client gives customers a chance to quickly install and deploy Oracle applications including sqlplus on various platforms including Microsoft Window 7 without installing the common Oracle client or getting an ORACLE_HOME. Instant Clients for 32-bit Microsoft Windows are offered here . You need to download two packagee, i.e the Instant Client Package - Basic Lite (contains English error messages and Unicode, ASCII, and Western European character set support) along with the Instant Client Package - SQL*Plus (contains additional libraries and executable for running SQL*Plus with Instant Client.)
Unzip the 2 packages into one particular directory including C:SQLPLUS. Then edit the configuration file tnsnames.ora that you just will see in this directory to configure the partnership to your Fedora 14 system.
ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL =TCP) (HOST = ultra.xfpmurphy.com) (PORT = 1521) ) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl.xfpmurphy.com) ) )
If you might be using a firewall on your own Fedora 14 platform (which you have to be!), you will have to change iptables to look at port 1521 for TCP packet send and receive. Here are the proper lines to increase /etc/sysconfig/iptables:
-A INPUT -p tcp --dport 1521 -j ACCEPT -A OUTPUT -p tcp --sport 1521 -j ACCEPT
In a production environment these rules ought to be modified to restrict the plethora of IP addresses which could access the 1521 port.
Once you've got configured a sound connection, you is going to be able to connect towards the Oracle database out of your Windows 7 platform.
If security just isn't an issue, it's fine to use a shortcut as shown above so that you might be automatically associated with a schema.
Well, time and energy to stop. The information in this post must be enough for getting you installed and operating. Please make me aware if I omitted anything crucial that you feel would of been of assistance to you in installing Oracle 11g on Fedora 14 and I will add it for this post.
