Oracle 11g Server For Windows 7 64 Bit

• Oracle 11g Server For Windows 7 64 Bit Indir

Connect to an Oracle database. 2 minutes to read.In this articleTo connect to an Oracle database with Power BI Desktop, the correct Oracle client software must be installed on the computer running Power BI Desktop. The Oracle client software you use depends on which version of Power BI Desktop you've installed: 32-bit or 64-bit.Supported Oracle versions:. Oracle 9 and later.

Oracle client software 8.1.7 and laterDetermining which version of Power BI Desktop is installedTo determine which version of Power BI Desktop is installed, select File Help About, then check the Version line. In the following image, a 64-bit version of Power BI Desktop is installed:Installing the Oracle client.For the 32-bit version of Power BI Desktop,.For the 64-bit version of Power BI Desktop,.Connect to an Oracle databaseAfter you install the matching Oracle client driver, you can connect to an Oracle database. To make the connection, take the following steps:.From the Home tab, select Get Data.From the Get Data window that appears, select More (if necessary), select Database Oracle database, and then select Connect.In the Oracle database dialog that appears, provide the name of the Server, and select OK. If a SID is required, specify it by using the format: ServerName/SID, where SID is the unique name of the database. If the ServerName/SID format doesn't work, use ServerName/ServiceName, where ServiceName is the alias you use to connect.

2.1.3 Hard Disk Space RequirementsThis section lists system requirements for Windows platforms that use the NT File System (NTFS). Oracle strongly recommends that you install the Oracle database home (Oracle database binaries, trace files, and so on) on Oracle ACFS or NTFS; the database files themselves must be placed on Oracle ASM if using Oracle ACFS; otherwise they can be placed on NTFS.

Usage of Oracle ACFS and Oracle ASM or NTFS instead of FAT32 is recommended to ensure security of these files.The NTFS system requirements listed in this section are more accurate than the hard disk values reported by the Oracle Universal Installer Summary window. The Summary window does not include accurate values for disk space, the space required to create a database, or the size of compressed files that are expanded on the hard drive.The hard disk requirements for Oracle Database components include 32 MB to install Java Runtime Environment (JRE) and Oracle Universal Installer on the partition where the operating system is installed.

Oracle 11g Server For Windows 7 64 Bit Indir

If sufficient space is not detected, installation fails and an error message appears.lists the disk space requirements on NTFS for Windows 32-bit.lists the disk space requirements on NTFS for Windows x64. The starter database requires 720 MB of disk space.The figures in these tables include the starter database.

FAT32 space requirements are slightly higher. Table 2-4 Windows x64 Disk Space Requirements on NTFS Installation TypeTEMP SpaceSYSTEMDRIVE: Program FilesOracleOracle HomeData Files.TotalTypical Install500 MB4.0 MB3.80 GB1.9 GB6.22 GBAdvanced Install: All Editions500 MB4.55 MB3.80 GB.1.9 GB.6.22 GB. Refers to the contents of the admin, cfgtoollogs, flashrecoveryarea, and oradata directories in the ORACLEBASE directory. This size can be higher depending on the installation options selected, such as languages or additional components. If you choose to install Oracle Database with automated backups enabled, include at least 2 GB extra for data file disk space. 2.3.1 Remote Desktop ServicesOracle supports installing, configuring, and running Oracle Database through Remote Desktop Services, formerly known as Terminal Services, on Windows. To install Oracle Database, Oracle recommends that you start all configuration tools from the Terminal Server console session of the server (using mstsc/console).Platform-specific support information is as follows:.Windows Server 2003 and Windows Server 2003 R2: You can configure Windows Server 2003 and Windows Server 2003 R2 to use Terminal Services in Remote Desktop for Administration Mode or Terminal Server Mode.Windows client operating systems: The Remote Desktop is only available in Single User Mode.Windows Server 2008 and later: You can have multiple Remote Desktop sessions.

2.3.3 Web Browser SupportYou do not require a web browser to install Oracle Database. However, web browsers are required to access documentation, and to use Oracle Enterprise Manager Database Control and Oracle Application Express. 2.5 Confirming Host Name ResolutionTypically, the computer on which you want to install Oracle Database is connected to a network. Ensure that the computer host name is resolvable through a Domain Name System (DNS), a network information service (NIS), or a centrally-maintained TCP/IP host file, such as /etc/hosts. Use the ping command to ensure that your computer host name is resolvable.

For example:ping myhostnamepinging myhostname.example.com 192.0.2.2 with 32 bytes of data:Reply from 192.0.2.2: bytes=32 time=138ms TTL=56If your computer host name does not resolve, then contact your system administrator. 2.6.1 Installing Oracle Database on Computers with Multiple IP AddressesYou can install Oracle Database on a computer that has multiple IP addresses, also known as a multihomed computer. Typically, a multihomed computer has multiple network cards. Each IP address is associated with a host name; additionally, you can set up aliases for the host name.

By default, Oracle Universal Installer uses the ORACLEHOSTNAME environment variable setting to find the host name.Clients must be able to access the computer using this host name, or using aliases for this host name. To check, ping the host name from the client computers using the short name (host name only) and the full name (host name and domain name). 2.6.3 Installing Oracle Database on Nonnetworked ComputersYou can install Oracle Database on a non-networked computer. If the computer, such as a laptop, is configured for DHCP and you plan to connect the computer to the network after the Oracle Database installation, perform these steps before you install Oracle Database on the non-networked computer.Install a loopback adapter on the computer.The loopback adapter and local IP address simulate a networked computer. If you connect the computer to the network, Oracle Database still uses the local IP address and host name.

See Also:.Ping the computer from itself, using only the host name and using the fully qualified name, which should be in the DRIVELETTER: system32driversetchosts file.For example, if you installed a loopback adapter on a computer called mycomputer on the mydomain.com domain, check the following: DRIVELETTER: ping mycomputer Ping itself using just the hostname.Reply from 10.10.10.10 Returns local IP. DRIVELETTER: ping mycomputer.mydomain.com Ping using a fully qualified name.Reply from 10.10.10.10 Returns local IP. Note:When you ping a computer from itself, the ping command should return the local IP address (the IP address of the loopback adapter).If the ping command fails, contact your network administrator.Connecting the Computer to the Network after InstallationIf you connect the computer to a network after installation, the Oracle Database instance on your computer can work with other instances on the network. Remember that you must have installed a loopback adapter on your computer.

Your computer can use a static IP or DHCP, depending on the network to which you are connected. 2.6.4 Installing a Loopback AdapterWhen you install a loopback adapter, the loopback adapter assigns a local IP address for your computer. After the loopback adapter is installed, there are at least two network adapters on your computer: your own network adapter and the loopback adapter. To run Oracle Database on Windows, set the loopback adapter as the primary adapter.You can change the bind order for the adapters without reinstalling the loopback adapter.

The bind order of the adapters to the protocol indicates the order in which the adapters are used. When the loopback adapter is used first for the TCP/IP protocol, all programs that access TCP/IP first probe the loopback adapter. The local address is used for tools, such as Oracle Enterprise Manager. Any other applications that use a different Ethernet segment are routed to the network card.A loopback adapter is required if:.You are installing on a DHCP computer, or.You are installing on a non-networked computer and plan to connect the computer to a network after installation. Note:Loopback Adapter installed on the computer should be made the Primary Network Adapter.If there is a loopback adapter installed, you would see a section that lists the values for the loopback adapter.

For example:Ethernet adapter Local Area Connection 2:Connection-specific DNS Suffix.:Description.: Microsoft Loopback AdapterPhysical Address.: 02-00-4C-4F-4F-50DHCP Enabled.: NoIP Address.: 10.10.10.10Subnet Mask.: 255.255.0.0. 2.6.4.2 Installing a Loopback Adapter on Windows Server 2003, Windows Server 2003 R2, or Windows XPTo install a loopback adapter on Windows 2003, Windows Server 2003 R2, or Windows XP:.Open the Windows Control Panel.Double-click Add Hardware to start the Add Hardware wizard.In the Welcome window, click Next.In the Is the hardware connected? Note:Domain name is optional.Open System in the Control Panel, and select the Computer Name tab. In Windows Vista and Windows Server 2008, the Computer Name tab is not available. In Full computer name, make sure you see the host name and the domain name, for example, sales.us.example.com.Click Change. In Computer name, you should see the host name, and in Full computer name, you should see the host name and domain name.

Using the previous example, the host name would be sales and the domain would be us.example.com.Click More. In Primary DNS suffix of this computer, you should see the domain name, for example, us.example.com. 2.6.4.6 Removing a Loopback AdapterTo remove a loopback adapter:.Display System in the Windows Control Panel.In the Hardware tab, click Device Manager.

This tab is not available with Windows Vista and Windows Server 2008. Click Device Manager instead.In the Device Manager window, expand Network adapters. You should see Microsoft Loopback Adapter.Right-click Microsoft Loopback Adapter and select Uninstall.Click OK.Restart the computer.Remove the line from the DRIVELETTER: WINDOWSsystem32driversetchosts file, added after the localhost line while installing the loopback adapter on other Windows operating systems. 2.7.1.2 Choosing a Storage Option for Oracle Database Recovery FilesIf you want to enable automated backups during the installation, you must choose one of the following storage options for recovery files (the fast recovery area):.File system.Oracle Automatic Storage ManagementThe storage option that you choose for recovery files can be the same as or different to the option you choose for the data files. The recovery files must be placed on Oracle ASM if using Oracle ACFS; otherwise they can be placed on NTFS.

Note:Alternatively, for both data files and recovery files, use an Oracle Automatic Storage Management disk group.The file system that you choose should have at least 2 GB of free disk space.The disk space requirement is the default disk quota configured for the fast recovery area (specified by the DBRECOVERYFILEDESTSIZE initialization parameter).If you choose the Advanced database configuration option, you can specify a different disk quota value. After you create the database, you can also use Oracle Enterprise Manager Grid Control or Database Control to specify a different value. File TypeFile System RequirementsData filesChoose either:.A single file system with at least 950 MB of free disk space.Two or more file systems with at least 950 MB of free disk space in total.Recovery filesChoose a file system with at least 2 GB of free disk space.If you are using the same file system for multiple types of files, then add the disk space requirements for each type to determine the total disk space requirement.Note the names of the directories for the file systems that you identified.If you also want to use Oracle Automatic Storage Management, see for instructions.

Otherwise see the section. Note:If you are installing additional Oracle Database 11 g products in an existing Oracle home, then stop all processes running in the Oracle home.

You must complete this task because you cannot overwrite files that are used by the running processes.Consider the following before you install Oracle Grid Infrastructure or Oracle Database:.If you plan to use Oracle Restart, you must install the Oracle Grid Infrastructure before you install and create the database. When you perform a database installation, the database must use the same listener created during the Oracle Grid Infrastructure installation, thereafter you do not have to perform the steps listed in this section.The default listener and any additional listeners must run from the Oracle Grid Infrastructure home.If you have an existing Oracle Database 11 g Release 2 (11.2) running on Oracle Automatic Storage Management, then stop any existing Oracle ASM instance.

After you finish installing the Oracle Grid Infrastructure software, start the Oracle ASM instance again.If you choose to create a database during the installation, then most installation types configure and start a default Oracle Net listener using TCP/IP port 1521 and the IPC key value EXTPROC. However, if an existing Oracle Net listener process is using the same port or key value, Oracle Universal Installer looks for the next available free port (for example, 1522) and configures and starts the new listener on this available free port.