How to Shutdown and Startup Oracle Database on OGG
How to Shutdown and Startup Oracle Database on OGG Target Database Shutdown: SQL> alter system set job_queue_processes=0;~]$ lsnrctl stop~]# ps -ef | grep 'LOCAL=NO' | grep orcl | kill -9 `awk '{print $2}'`GGSCI> stop rept00GGSCI> stop mgrSQL> alter system switch logfile;SQL> alter system checkpoint;SQL> shutdown immediate Startup: SQL> startupGGSCI> start mgrGGSCI> start rept00SQL> alter system set job_queue_processes=1000;~]$ lsnrctl start Source Database SQ...
HPE ProLiant DL360 Gen9 Service Manual
HPE ProLiant DL360 Gen9 Service Manual Raid Controller P440ar Replacement Symptoms: After the HPE P440ar Controller has replaced, the OS unable to boot from HDD. Solution: Power cycle, press F10 Intelligent Provisioning -> HPE Smart Storage Administrator (SSA) -> Set Bootable Logical Drive/Volume
The SQLServer cluster resource unable to bring online
The SQLServer cluster resource unable to bring online Symptoms The SQL Server (MSSQLSERVER) cluster resource goes to a "failed" state and doesn't come online. Cause Check the cluster disk drive letter/path is correct. Check the service account credentials is valid. Such as error 1069. Solution Analyze the database log file ERRORLOG. Type the correct credentials in SQL Server Configuration Manager -> Services -> SQL Server service. Reference ・ Error 1069 occurs when you start SQ...
Hitachi Storage Performance Data Collection
Hitachi Storage Performance Data Collection ・ Hitachi Storage Performance Data Collection.docx | ・ AutoPfm.zip | Reference ・ Performance Data Collection - Open Systems Requirements
INS-75012
INS-75012 OGG 12.2 Symptoms During installing the OGG software, pop-up that the installation directory already contains OGG. Solution Delete the entry which contains /ggs directory. ~]$ sed -i '/\/ggs/d' /u01/app/oraInventory/ContentsXML/inventory.xml
Huawei RP200-55T Service Manual
Huawei RP200-55T Service Manual TE50 The default password of advance setting is 12345678. 证书过期 电视开机显示证书过期: Cause: ・ 关于部分智真终端产品证书即将过期问题的预警通知 Solution: 只影响有使用 sip/tls 协议的功能,可通过升级软件版本解决。
Register the ASM or Database resource to CRS
Register the ASM or Database resource to CRS Symptoms The resource ora.DATA.dg does not exist ~]$ crsctl stat res -t--------------------------------------------------------------------------------NAME TARGET STATE SERVER STATE_DETAILS--------------------------------------------------------------------------------Local Resources--------------------------------------------------------------------------------ora.LISTENER.lsnr ONLINE ONLINE ...
Installing Oracle Database 11.2.0.4 ASM on OL 7.4
Installing Oracle Database 11.2.0.4 ASM on OL 7.4 Operating System: Oracle Linux Server 7.4 Oracle Database: p13390677_112040_Linux-x86-64_{1..3}of7.zip Packages Requirements rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' \bc binutils elfutils-libelf elfutils-libelf-devel fontconfig-devel \glibc glibc-devel ksh libaio libaio-devel libXrender libX11 libXau \libXi libXtst libgcc libnsl librdmacm libstdc++ libstdc++-devel gcc \libxcb libibverbs make smartmontools sysstat pdksh gcc-...
Deploying OGG 12.2 Replication from Oracle 11g ASM to Oracle 11g ASM
Deploying OGG 12.2 Replication from Oracle 11g ASM to Oracle 11g ASM OGG 12.2.0.1.1 1 Environment Preparation Source: IP: 192.168.3.151 Hostname: oracle11gasm01 Database: 11.2.0.4.0 - 64bit SID: orcl OS: Oracle Linux Server 7.4 Target: IP: 192.168.3.152 Hostname: oracle11gasm02 Database: 11.2.0.4.0 - 64bit SID: orcl OS: Oracle Linux Server 7.4 Requirements: DB size > 1TB, blob column Disable DDL replicate, encrypt password Using RMAN to initialize target database Unidirectional replica...
Connect to cluster failed on Failover Cluster Manager
Connect to cluster failed on Failover Cluster Manager Symptoms Situation 1 Issue: Cannot connect to cluster, error code 0x80070005, access is denied. This situation is that not have access rights. Situation 2 Issue: The operation has failed, access is denied. This situation is that have access rights, but the credential is incorrect. Solution Update the system patches to the latest. Ensure that the account have sufficient permissions to access the cluster. Get-ClusterAccess -Cluste...














