10/15/2021 0 Comments Oracle Database For Mac
The process works just as well for 11.2.0.3, which you can download from MOS.1 Using Oracle MAC You will be accessing Oracle database through SQL Developer. I decided write this post regarding the configuration and working principle of database listeners in a Oracle 11gR2 RAC.I've purposely left this as an 11.2.0.1 installation as this version is downloadable from OTN without the need for a My Oracle Support (MOS) CSI. If you set up NFS, then you can download and unzip Oracle on the Mac, into a directory you share using NFS (Downloads, look for Database 10g for Linux, 32 bit).3 While it's downloading, it might be a good time to install your favourite Firefox bookmark synchronisation service - I use Foxmarks.Hyperpie 2 mac.Oracle Database 11g Release 2 RAC On Windows 2008 Using VirtualBoxOne of the biggest obstacles preventing people from setting up test RAC environments is the requirement for shared storage. Oracle Database 11g Release 2 (11.2.0.3.0) RAC On Oracle Linux 6.3 Using VirtualBox Navigate to the data ribbon and select New Database Query From Database Select the User or. A free graphical user interface, Oracle SQL Developer allows database users and administrators to do their database tasks in fewer clicks and keystrokes.Open Microsoft Excel and open a spreadsheet (new or existing).The finished system includes the host operating system, two guest operating systems, two sets of Oracle Grid Infrastructure (Clusterware + ASM) and two Database instances all on a single server. In addition, it allows you to set up shared virtual disks, overcoming the obstacle of expensive shared storage.Before you launch into this installation, here are a few things to consider. A third option is to use virtualization to fake the shared storage.Using VirtualBox you can run multiple Virtual Machines (VMs) on a single server, allowing you to run both RAC nodes on a single machine. A cheaper alternative is to use a FireWire disk enclosure to allow two machines to access the same disk(s), but that still costs money and requires two servers.
![]() Oracle Database Install Your FavouriteThis approach will not work if you are using 11.2.0.2 onward and you must use the DNS. In this article I've defined it as a single IP address in the "/etc/hosts" file, which is wrong and will cause the cluster verification to fail, but it allows me to complete the install without the presence of a DNS. The Single Client Access Name (SCAN) should really be defined in the DNS or GNS and round-robin between one of 3 addresses, which are on the same subnet as the public and virtual IPs. It's simply to allow you to get used to installing and using RAC. Virtual Machine SetupNow we must define the two virtual RAC nodes. On RHEL and its clones you do this with the following type of command as the root user.# rpm -Uvh VirtualBox-4.2-4.2.6_82870_fedora17-1.x86_64.rpmOnce complete, VirtualBox is started from the "Applications > System Tools > Oracle VM VirtualBox" menu option. Oracle 11g Release 2 (11.2) Software (64 bit)First, install the VirtualBox software. This article uses the 64-bit versions of Oracle Linux and Oracle 11g Release 2. If you want to avoid this, define 3+Gig of swap. Guest Operating System InstallationWith the new VM highlighted, click the "Start" button on the toolbar. Scroll down the "Details" tab on the right and click on the "Network" link.Make sure "Adapter 1" is enabled, set to "Bridged Adapter", then click on the "Adapter 2" tab.Make sure "Adapter 2" is enabled, set to "Bridged Adapter" or "Internal Network", then click on the "System" section.Move "Hard Disk" to the top of the boot order and uncheck the "Floppy" option, then click the "OK" button.The virtual machine is now configured so we can start the guest operating system installation. If you can spread the virtual disks onto different physical disks, that will improve performance.The "ol5-112-rac1" VM will appear on the left hand pane. Enter the name "ol5-112-rac1", OS "Linux" and Version "Oracle (64 bit)", then click the "Next" button.Enter "4096" as the base memory size, then click the "Next" button.Accept the default option to create a new virtual hard disk by clicking the "Create" button.Acccept the default hard drive file type by clicking the "Next" button.Acccept the "Dynamically allocated" option by clicking the "Next" button.Accept the default location and set the size to "30G", then click the "Create" button. IP Address eth1: 192.168.1.101 (private address)You are free to change the IP addresses to suit your network, but remember to stay consistent with those adjustments throughout the rest of the article. Default Gateway eth0: 192.168.0.1 (public address) IP Address eth0: 192.168.0.101 (public address) Desktop Environments > GNOME Desktop EnvironmentTo be consistent with the rest of the article, the following information should be set during the installation: More specifically, it should be a server installation with a minimum of 4G+ swap, firewall disabled, SELinux set to permissive and the following package groups installed: A general pictorial guide to the installation can be found here. Refresh button doesnt work on dolphin emulator macThis includes the 64-bit and 32-bit versions of some packages.Add or amend the following lines to the "/etc/sysctl.conf" file.# semaphores: semmsl, semmns, semopm, semmniNet.ipv4.ip_local_port_range = 9000 65500Run the following command to change the current kernel parameters.Add the following lines to the "/etc/security/limits.conf" file.Add the following lines to the "/etc/pam.d/login" file, if it does not already exist.Useradd -u 1100 -g oinstall -G dba oracleCreate the directories in which the Oracle software will be installed.Mkdir -p /u01/app/oracle/product/11.2.0/db_1Perform the following steps whilst logged into the "ol5-112-rac1" virtual machine as the root user.Install the following package from the Oracle grid media after you've defined groups.If you are not using DNS, the "/etc/hosts" file must contain the following information. Automatic SetupIf you plan to use the "oracle-validated" package to perform all your prerequisite setup, follow the instructions at to setup the yum repository for OL, then perform the following command.All necessary prerequisites will be performed automatically.It is probably worth doing a full update as well, but this is not strictly speaking necessary.If you have not used the "oracle-validated" package to perform all prerequisites, you will need to manually perform the following setup tasks.In addition to the basic OS installation, the following packages must be installed whilst logged in as the root user. The Additional Setup is required for all installations.
0 Comments
Leave a Reply. |
AuthorNikki ArchivesCategories |