The ASM instance is configured in the same way as normal databases instance for using hugepages in Linux 7. But ASM is not using hugepages, while the normal instance is using hugepages. There are enough free hugepages available as per /etc/meminfo.
Let’s configure ASM to use HugePages.
Read more of this content when you subscribe today.
DBA is always being asked about the database size growth trend for coming months by a client or reporting manager.
If you can present the following report, that would show your great service.
Now lets’ demonstrate how to get similar report for maximum up to two years period of time from OEM repository.
Read more of this content when you subscribe today.
Sometimes the default attributes require to be modified for future partitions, or sub-partitions, specially in the situation when tables and indexes are refreshed from different environment.
Let’s check how to modify default attributes of tables, indexes, table partitions and index partitions ,etc.
Read more of this content when you subscribe today.
It is a prerequisite for both primary and secondary databases have same copy of password file, and stored in ASM diskgroup preferred
From 12.1.0.2 on, since primary database password file is stored in ASM, so it needs to be manually copied onto standby database ASM for dataguard configuration. Otherwise the below errors will occur:
*** 2017-09-06 14:34:29.216 OCISessionBegin failed. Error -1 .. Detailed OCI error val is 1017 and errmsg is 'ORA-01017: invalid username/password; logon denied ' ORA-01017: invalid username/password; logon denied OCI_DBVER attribute value retrieval failed error=1017 *** 2017-09-06 14:34:30.323 OCISessionBegin failed. Error -1 .. Detailed OCI error val is 1017 and errmsg is 'ORA-01017: invalid username/password; logon denied ' *** 2017-09-06 14:34:30.323737 4929 krsh.c Error 1017 received logging on to the standby
Read more of this content when you subscribe today.
Newly built 12.1.0.2 DataGuard got errors.
Primary Database alert.log:
Mon Sep 11 11:35:59 2017 TT01: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (3135) TT01: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned Mon Sep 11 11:35:59 2017 Errors in file /u01/app/oracle/diag/rdbms/ractest/RACTEST1/trace/RACTEST1_tt01_30967.trc: ORA-03135: connection lost contact Error 3135 for archive log file 42 to 'STBTEST' Mon Sep 11 11:35:59 2017 Errors in file /u01/app/oracle/diag/rdbms/ractest/RACTEST1/trace/RACTEST1_tt01_30967.trc: ORA-03135: connection lost contact LNS: Failed to archive log 42 thread 1 sequence 852 (3135)
Standby Database Alert.log
Fatal NI connect error 12170. VERSION INFORMATION: TNS for Linux: Version 12.1.0.2.0 - Production Oracle Bequeath NT Protocol Adapter for Linux: Version 12.1.0.2.0 - Production TCP/IP NT Protocol Adapter for Linux: Version 12.1.0.2.0 - Production Time: 06-SEP-2017 16:50:33 Tracing not turned on. Tns error struct: ns main err code: 12535 TNS-12535: TNS:operation timed out ns secondary err code: 12608 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.xx)(PORT=63637)) Wed Sep 06 16:50:34 2017 RFS[37]: Possible network disconnect with primary database
Read more of this content when you subscribe today.
Make DBA Life Easy 