Oracle Database Appliance X5-2 nodes each contain 2 CPUs and each CPU has 18 cores. When you deploy Oracle Database Appliance X5-2, all 72 cores (36 cores in each server) are active with hyper-threading enabled by default. Below show processor showing each node having two processors and each with 18 cores i.e. Node 0:...
Continue reading...RMAN backup details, Display last 5 days
Following query can be used to get rman backup job details for last 5 days. set lines 220 col output_bytes_display for a30 col time_taken_display for a30 select session_key,input_type,status, to_char(start_time,’yyyy-mm-dd hh24:mi’) start_time, to_char(end_time,’yyyy-mm-dd hh24:mi’) end_time, output_bytes_display, time_taken_display from v$rman_backup_job_details where END_TIME > sysdate-5 order by session_key asc;
Continue reading...CRS-0804, PROC-44, CRS-4535, PROC-44: Error in network address
Getting following error during CRS start. we had a server reboot post maintenance. CRS-0804, PROC-44, CRS-4535, PROC-44: Error in network address CRS-4638: Oracle High Availability Services is online CRS-4535: Cannot communicate with Cluster Ready Services CRS-4529: Cluster Synchronization Services is online CRS-4534: Cannot communicate with Event Manager [crsd(12451930)]CRS-0804:Cluster Ready Service aborted due to Oracle...
Continue reading...Oracle Database 18c, Database of Year 2018
Oracle database 18c is now available…it’s about a week since announcement made on 16 Feb. So we download a copy and try it … Well wait a sec..its released only on Oracle Cloud & Engineered Systems. So what does 18c stands for, the ‘c’ of course stands for cloud, but why 18c not 13c....
Continue reading...Single Instance to RACOne Node Conversion.
Convert single instance to RAC using rconfig utility. Verify the database is added to cluster and is SINGLE Instance. [oracle@SAMOELNODE01 ~]$ srvctl config database -d ORCL Database unique name: ORCL Database name: Oracle home: /u01/app/oracle/product/11.2.0.4/dbhome_2 Oracle user: oracle Spfile: Domain: Start options: open Stop options: immediate Database role: PRIMARY Management policy: AUTOMATIC Server pools:...
Continue reading...Configure unixODBC in Linux
Configuring unixODBC on Linux, can be a general requirement for Peoplesoft or many Application to connect to Oracle database. Check whether all required RPMs present or Not…as follows. [root@SAMOEL47UAT2 unixODBC-2.2.14]# rpm -q unixODBC unixODBC-2.2.11-1.0.1.RHEL4.1 [root@SAMOEL47UAT2 unixODBC-2.2.14]# rpm -q qt qt-3.3.3-13.RHEL4 [root@SAMOEL47UAT2 unixODBC-2.2.14]# rpm -q unixODBC-kde unixODBC-kde-2.2.11-1.0.1.RHEL4.1 Output of following command should be /usr...
Continue reading...
Recent Comments