Discover how to start cluster service oracle rac, include the articles, news, trends, analysis and practical advice about how to start cluster service oracle rac on alibabacloud.com
Installing enterprise Oracle databases requires two parts: Oracle RAC, Oracle database. Refer to this article for the Oracle RAC principle. This article is the original introduction of the RAC
IP Planning and setting node name IP Configuration Table
Node name
P Ublicip
Vip
P rivate IP
Scanip
18cdbrac1
128.0.5.101
128.0.5.103
10.10.10.1
128.0.5.105
10.10.10.2
128.0.5.106
128.0.5.107
18cdbrac2
128.0.5.102
128.0.5.104
10.10.10.5
10.10.10.6
Dns
128.0.5.253
Storage Planning
1. I would like to do a RAC experiment, but I cannot configure my computer. This is my first problem.
2. I bought a new computer and started my experiment. First, VMware Server 1 + Oracle 10 + RAC + RedHat is not very familiar with Linux. Failed.
3. on the Windows platform, oracle_10g_rac_on_windows2003_using_vmware cannot install the win2003 operating system.
Tags: Oracle Tutorials Oracle Training Oracle Database Tutorials Oracle Engineers training Oracle Database TrainingWind Brother Linux system Oracle 12CR2 RAC
A customer's 11.2 RAC for Linux x86-64 environment fails after a power outage and the RAC environment does not start automatically.
After you log on to the database server, you discover that the cluster process exists and then try to start the database manually:
$ sqlplus/
Tags: Oracle CRSFor unknown processes to crs_stop-f the process nameStart againCRS failed to start Crs_start-all Crs-0184:cannot communicate with the CRS daemon.Because Crs_start is an application-level directive, it fails when it starts CRS[Email protected] ~]$ Crs_start-allCrs-0184:cannot communicate with the CRS daemon.[Email protected] ~]$ crs_stat-tCrs-0184:cannot communicate with the CRS daemon.Ps-ef
The two machines use disk arrays to store ORACLE data files for RAC. Configure an Oracle service. In this way, the client can configure the Oracle address and service description on the two machines.
JDBC:
Linux NTP service configuration for Oracle RAC tutorial, ntprac
When installing Oracle 11g RAC, We need to configure the ntp service. There are many ways to configure the clock synchronization mode when using virtual machines. Yo
Oracle 10g RAC Start-Stop archive modeIf the Oracle database is running in archive mode, you may need to pause the archive of the database when you perform database maintenance, and then restart the archive mode after maintenance is complete.You can convert from archive mode to non-archive mode by using the followin
Label:before closing the backup control file/parameter file:Sqlplus/as Sysdbaalter Database backup controlfile to '/home/oracle/control.ctl.bak '; Create pfile= '/home/oracle/init lt; instance name >.ora ' from SPFile;One, Oracle 11g RAC shutdown sequence1. Stop the EM ServiceSu-oracleExport ORACLE_UNQNAME=DB11Emctl St
Environment Introduction:Vmware12+redhat linux7.5 x86_64+oracle 18CSystem InstallationCreate a virtual hostSystem partitionSelect a desktop environmentPerform the installation processDescription1, the system installation, grid installation directory space requirements greater than 100G (before the installation of 12c requirements)2, after the installation of a database server, directly with the full cloning of the way to replicate to another database
ArticleDirectory
Step 1:
Step 2:
Step 3:
Step 4:
Step 1:
Step 2:
Step 3: In ideal cases, all are OK. If any problem occurs, handle the problem one by one.
Close sequence: [other nodes]-> [first node]
Operation: Step 1:
{
Use a grid user or close the listener: {crs_stop listener Resource Name | srvctl stop listener}-- Global
|
Oracle user disable listener: {LSNRCTL stop}-- Single Node
} Step 2:
Shut down the d
Crs-4124:oracle High Availability Services startup failed.
Crs-4000:command Start failed, or completed with errors.
OHASD failed to start:inappropriate IOCTL for device
OHASD failed to start at/u01/app/11.2.0/grid/crs/install/rootcrs.pl line 443. The first time you install 11GR2 RAC encountered this 11.0.2.1 classic
One instance of RAC is found to be abnormal. view the spfile
SQL> show parameter spfile
NAME TYPE VALUE
-----------------------------------------------------------------------------
Spfile string
The result value does not contain spfile and is not started from spfile. view the pfile file under dbs and find that the Pfile content of the instance has been changed.
Instance 2
SQL> show parameter spfile
NAME TYPE VALUE
------------------------------------
of two attempts to connect before failoverQuerying Service resource Properties[Email protected] ~]$ srvctl config service-d king-s saleService Name:saleService is enabledServer Pool:king_saleCardinality:1Disconnect:falseService role:primaryManagement policy:automaticDTP Transaction:falseAQ HA Notifications:falseFailover type:sessionFailover Method:basicTAF Failover Retries:3TAF Failover Delay:5Connection L
For more information, see the following blog:
Oracle racfailover details
Http://blog.csdn.net/tianlesoftware/article/details/5340788
How to configure Server Side transparentapplication failover [ID 460982.1]
1. Create tafservice
[Oracle @ db1 bin] $./srvctl add service-D orcl-s server_taf-R "orcl1, orcl2"-P basic
-- Here, orcl is the database name, And orcl1
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.