Oracle Loopback Adapter Error
Contents |
Database Hardware and Software Certification Oracle Database Network Topics Individual Component Requirements 2.1 Oracle Database Hardware Requirements This section describes hardware component and hard oracle 11g hardware requirements disk space requirements. Hardware Component Requirements Hard Disk Space Requirements
Oracle Database Hardware Requirements
Verifying Hardware Requirements 2.1.1 Hardware Component Requirements The following hardware components are required for Oracle Database: oracle database 12c system requirements Table 2-1 Hardware Requirements Requirement Value Physical memory (RAM) 256 MB minimum; 512 MB recommended On Windows Vista, the minimum requirement is 512 MB Virtual
Minimum Requirements For Oracle 11g On Windows 8
memory Double the amount of RAM Disk space Basic Installation Type total: 2.04 GB Advanced Installation Types total: 1.94 GB See Table 2-2 for details. Video adapter 256 colors Processor 550 MHz minimum On Windows Vista, the minimum requirement is 800 MHz See Also: "Configuring Disk Storage for Oracle Data Files oracle 11g windows server 2012 compatibility and Recovery Files" "Creating Directories for Oracle Data Files or Recovery Files" "Preparing Disk Groups for an Automatic Storage Management Installation" "Installing with Minimum Memory Requirements" 2.1.2 Hard Disk Space Requirements This section lists system requirements for Windows platforms that use the NT File System (NTFS) file systems. Oracle recommends installing Oracle components on NTFS. 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 32MB required to install Java Runtime Environment (JRE) and Oracle Universal Installer on the partition where the operating system is installed. If sufficient space is not detected, installation fails and an error
display monitor, and has a media drive. This section describes how to install Oracle Database on computers that do not meet the typical scenario. It covers
Oracle 11g Environment Does Not Meet Minimum Requirements
the following topics: Installing Oracle Database on Computers with Multiple IP Addresses Installing
Oracle Job Requirements
Oracle Database on Computers with Multiple Aliases Installing Oracle Database on Nonnetworked Computers Installing a Loopback Adapter D.1 Installing oracle 12c windows server 2012 r2 Oracle Database on Computers with Multiple IP Addresses You can install Oracle Database on a computer that has multiple IP addresses, also known as a multihomed computer. Typically, a multihomed computer has https://docs.oracle.com/cd/B19306_01/install.102/b14316/reqs.htm 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 ORACLE_HOSTNAME 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 https://docs.oracle.com/database/121/NTDBI/network.htm the host name from the client computers using the short name (host name only) and the full name (host name and domain name). Both must work. Setting the ORACLE_HOSTNAME Environment Variable To set the ORACLE_HOSTNAME environment variable: Display System in the Windows Control Panel. In the System Properties dialog box, click Advanced. In the Advanced tab, click Environment Variables. In the Environment Variables dialog box, under System Variables, click New. In the New System Variable dialog box, enter the following information: Variable name: ORACLE_HOSTNAME Variable value: The host name of the computer to use. Click OK, then in the Environment Variables dialog box, click OK. Click OK in the Environment Variables dialog box, then in the System Properties dialog box, click OK. D.2 Installing Oracle Database on Computers with Multiple Aliases A computer with multiple aliases is registered with the naming service under a single IP address but with multiple aliases. The naming service resolves any of those aliases to the same computer. Before installing Oracle Database on such a computer, set the ORACLE_HOSTNAME environment variable to the computer whose host name you want to use. D.3 Installing Ora
Last updated: April 22, 2016 - 4:40 am UTC Category: SQL*Plus � Version: 9.2.0 Whilst you are here, check out some content from the AskTom team: Table Functions, Part 3a: table https://asktom.oracle.com/pls/asktom/f?p=100:11:0::NO::P11_QUESTION_ID:431775600346873836 functions as parameterized views in the PL/SQL Challenge website Latest Followup You Asked i'm running oracle on standalone computer at home.it used to work properly but from couple of days i'm getting error stating "ORA-12560: TNS:protocol adapter error " what should i do? please help.. (scott/tiger) and we said... sounds like the database is not up. you probably restarted your machine oracle 11g and the instance is not set to autostart C:\Documents and Settings\tkyte>sqlplus scott/tiger SQL*Plus: Release 10.1.0.4.0 - Production on Thu Sep 6 15:43:55 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production With the Partitioning, OLAP and Data Mining options scott%ORA10GR1> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - windows server 2012 Production With the Partitioning, OLAP and Data Mining options C:\Documents and Settings\tkyte>net stop oracleserviceora10gr1 The OracleServiceORA10GR1 service is stopping......... The OracleServiceORA10GR1 service was stopped successfully. C:\Documents and Settings\tkyte>sqlplus scott/tiger SQL*Plus: Release 10.1.0.4.0 - Production on Thu Sep 6 15:44:35 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. ERROR: ORA-12560: TNS:protocol adapter error Enter user-name: ERROR: ORA-12560: TNS:protocol adapter error Enter user-name: ERROR: ORA-12560: TNS:protocol adapter error SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus C:\Documents and Settings\tkyte>net start oracleserviceora10gr1 The OracleServiceORA10GR1 service is starting.......... The OracleServiceORA10GR1 service was started successfully. C:\Documents and Settings\tkyte>sqlplus scott/tiger SQL*Plus: Release 10.1.0.4.0 - Production on Thu Sep 6 15:45:12 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production With the Partitioning, OLAP and Data Mining options scott%ORA10GR1> in the above ora10gr1 is my oracle sid, you can use control panel instead - control panel -> services -> look for the services starting with Oracle. Reviews Write a Review Another method September 10, 2007 - 3:15 am U