oracle exadata machine

Oracle can only be natively connected and not connected to other computers on the networkOracle listens only to local 127.0.0.1, causing the network other computers to not connect to the workaround:Modify the Listener.ora listening file to change the localhost to a computer name. Restart Oralce monitoring and service. This article from "No Worry" blog, declined reproduced!Oracle listens only to the

The previous article wrote, the installation of centos6.5 on the virtual machine, the results in accordance with the article very smooth installation, but with Yum installation software. Error, source has a problem, can not download, and then ping the ferry. Very sad.DNS cannot parse, cat/etc/resolv.conf, find empty, join for example the following parsingWatermark/2/text/ahr0cdovl2jsb2cuy3nkbi5uzxqv/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/dissolv

Tags: color program rar database 10g installation Word complex query nbspWindows Server 2008 64-bit machine has a 10g client, 32 and 64 bits unclear With the service name of the Netmanager inside the company.Data Source=o10ga;user id=djzd;password=cy2015;Direct display Tns12514 error, library connection not on ... If you use Data source= (description= (address_list= (address= (protocol=tcp) (host=10.72.5.13)) (port=1521) (ADDRESS= TCP) (host=10.72.5.1

: 14. Hang 5 new volumes in the 5 blank folders above Mount OCR, right-click the first new volume, select "Change Drive letter and path" Add to Load a blank NTFS folder, browse Select the blank folder you just created All the way, the same steps to complete the other mounts, sequentially ocr=>data1=>data2=>data3=>fra. When you are finished, create a new blank folder as follows: Share the C and D drives, in order to implement a RAC that installs two servers on one server, that is, after the

time zone is asia/beijing, not EAT-8, and then to the system directory/usr/share/zoneinfo query, found no EAT-8. Then modify the previous command, the TZ set to asia/beijing, problem solving.Before this, someone has had this hint, but not very clear the database inside the mechanism, stumbled, always set the wrong, understand the principle, also targeted.Change the time zone setting for Oracle.such as alter DATABASE SET time_zone= ' +8.00 ';After modification, restart the

: Select NAT. (NAT needs to see Vmnet8,host-onlyneed to see VMNET1) disk File: Enter "LOCALDISK.VMDK". Click Finish. 2.2 Repeat the following steps to create four virtual SCSI hard disks-ocfs2disk.vmdk (512MB), ASMDISK1.VMDK (3GB), ASMDISK2.VMDK (3GB), and ASMDISK3.VMDK (2GB).added Hard Disk. Select disk: Specify disk Capacity: Input "01:02.3 Add a virtual NIC for private interconnect2.4 Set additional parameters to enable disk sharing between two virtual RAC nodes. To modify the configuration f

Tags: os ar file Art SP C installer RHow Oracle VM VirtualBox automatically turns on virtual machines with your system@ECHO OFFCd..CD E:Cd..CD E:\VirtualBox\Start VIRTUALBOX.EXE-STARTVM CentOS1: Find the program installation directory2: Start the virtual machine that needs to start CentOS for the virtual machine that needs to be started, note that case sensitivit

Virtual Machine Files:Http://pan.baidu.com/s/1pJL5TubBackup one to prevent invalidationHttps://pan.baidu.com/s/1nvbZQadReadme file:Database version:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit ProductionLinux version:Red Hat Enterprise Linux Server release 5.8 (Tikanga)VMware version:Vmware 9.0User name:Root/oracleOracle/oracleDB user name password:System|managerIP:192.168.0.151TNSNames:test_11g=(DESCRIPTION =(ADDRESS = (PROTOCOL =

Then the second article http://www.cnblogs.com/myrunning/p/3996183.html4. Installing the Cluster Software 4.1 verifying the installation environmentAfter inspection, the following 3 package checks were found to have failed:compat-gcc-7.3-2.96.128compat-gcc-7.3-2.96.128openmotif-2.2.3Check that the installation package in the system has been installed by this package and should be different from the version to cause the check to fail, ignoring this check error.4.2 Installing the Cluster softwareV

Tags: kcm_headroom_warn_1 ora-00600Oracle database startup failure due to time reversal of VM virtual machineThis article is original article, if reproduced please indicate the source:http://blog.csdn.net/msdnchina/article/details/38782163Alert logs directly on the database:Fri APR 22:00:54 Oracle database startup failure due to time reversal of VM virtual machine

The previous article writes, installs the centos6.5 on the virtual machine, the result according to the article very smoothly installs, but uses the Yum installs the software, the error, the source has the question, cannot download, then pings the ferry, very sad urgesDNS cannot parse, cat/etc/resolv.conf, Discovery is empty, add the following parsingPing the Find or notUse the Ifconfig command to check the configuration of the network card, found tha

After the first article http://www.cnblogs.com/myrunning/p/3993824.html3. Cluster configuration 3.1 Configuring the Hosts fileThis configuration needs to be configured on two nodes.3.2 Configuring the Hangcheck TimerThis configuration needs to be configured on two nodes.Can be written to the file:3.3 Configuring user equivalence 3.3.1 1th machine3.3.2 2nd Machine3.3.3 Validation EquivalenceBoth machines have to be verified.3.4 Configuring the shared disk 3.4.1 on the 1th

Scenario Description: A friend asked, MSSQLServer to restore the database backup to other machines is very convenient, basically is a fool operation, Oracle has control files, parameter files a pile of things, Feel that the restoration is very complex; in fact, I took some time to simply demonstrate the case, friends, under the reference. For simplicity and speed, I use Rman backup and restore --Description:(1). The db_name needs to be the same w

If at this point after the click of the setup has been a long time or not pop-up in the content, then you need to delete the database of the entire file, and then re-unzipNeed to be aware of legal risks1.DBMS Excel software similar to office, which does not contain the data itself, is used only to interpret Excel files (databases).2. And the database is actually a set of files, similar to Excel files, out of the DBMS, it is impossible to interpret the data inside the database. (Note that creatin

-------------------- ---------- --------------------------------Bull 1991 1993Rockets 1994 1995Bull 1996 1998Lakers 2000 2002Lakers 2009 2010Query the current employee's previous employee and the last employee's salary variance with the current employee:Select Ename,hiredate,sal,deptno,sal-pre_sal,sal-nex_sal from (select Ename,hiredate,sal,deptno,lag (sal,1,0) over ( ORDER by HireDate) Pre_sal,lead (sal,1,0) through (order by HireDate) Nex_sal from EMP)Table BC1 C2------------ ------2005-01-01