The server 192.168.75.131 is asking for your username and password. The server reports that it is from XDB After I installed Oracle Database 12c, I tested logging in to EM Express for a PDB 12c by chrome then, I got an asking box from XDB again and again. I can’t connect it, and I try […]
“ORA-65096: invalid common user or role name” on Oracle Database 12C When I installed Oracle Database 12c the, first time, I was connecting the database by sys user and creating user then, I got this error ORA-65096: invalid common user or role name So, However, This problem is because of the multitenant architecture introduced in […]
before we go to generate for enable privilege audit, I have to talk about the structure of oracle, They have many kinds of audit types so I think the three types of audit that I’ll say about, it’s exactly the same meaning, let get the look. Using Default Auditing for Security-Relevant SQL Statements and Privileges […]
Interactive Command Mode (CTRL+C) When running the expdp or impdp utilities the log output is also shown on the screen, but I can stop this and switch to the interactive mode by issuing CTRL+C. Once in the interactive mode, we have access to a number of commands described here (expdp, impdp). There are some differences […]
Getting Started Prepare directories for users who want to use the export data pump [oracle@labdbT1 trace]$ df -h Filesystem Size Used Avail Use% Mounted on /dev/mapper/ol-root 27G 18G 9.0G 67% / devtmpfs 3.8G 0 3.8G 0% /dev tmpfs 3.9G 1.9G 2.0G 48% /dev/shm tmpfs 3.9G 13M 3.9G 1% /run tmpfs 3.9G 0 3.9G 0% /sys/fs/cgroup […]
Before export or import, You have to create a directory for an object, it can access. The directory object is only a pointer to a physical directory, creating it does not actually create the physical directory on the file system of the database server. A data pump is a logical Backup, You can back up […]
How are we choosing to enable or disable archivelog Archivelog Mode You can perform a backup when the database is online(Hot backup) and the database is offline(Cold Backup) that means if You see a problems or disasters something with your database then you’ll have the copy data and archive the log file to recover a […]
When you do maintenance, upgrade and migration. You have to keep data before and after to compare to the same thing. For count object SELECT OWNER,OBJECT_TYPE,COUNT(*) FROM DBA_OBJECTS WHERE OWNER NOT IN (‘SYS’,’SYSTEM’,’SYSMAN’,’ANONYMOUS’, ‘APPQOSSYS’,’DBSNMP’, ‘EXFSYS’,’MDSYS’,’ORACLE_OCM’ ,’ORDSYS’ ,’OUTLN’ ,’SYSTEM_LOAD_TEST’,’TSMSYS’,’WMSYS’,’XDB’,’XS$NULL’,’ORDDATA’,’CTXSYS’) GROUP BY OWNER,OBJECT_TYPE ORDER BY OWNER,OBJECT_TYPE; 2. For counting objects by status SELECT OWNER,OBJECT_TYPE,STATUS,COUNT(*) FROM DBA_OBJECTS WHERE […]
Enable standard Audit Trail 1. Log in as SYS with SYSDBA privileges [oracle@labdbt2 bin]$ sqlplus “/as sysdba” 2. Check the current settings SQL> show parameter audit NAME TYPE VALUE ———————————— ———– —————————— audit_file_dest string /oracle/admin/dblabt1/adump audit_sys_operations boolean TRUE audit_syslog_level string audit_trail string NONE unified_audit_sga_queue_size integer 1048576 3. Set the type of auditing you want by […]
Segments The level of logical database storage greater than an extent is called a segment. A segment is a set of extents, each of which has been allocated for a specific data structure and all of which are stored in the same tablespace. A segment and all its extents are stored in one tablespace. Within a […]
| M | T | W | T | F | S | S |
|---|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | 5 | 6 | 7 |
| 8 | 9 | 10 | 11 | 12 | 13 | 14 |
| 15 | 16 | 17 | 18 | 19 | 20 | 21 |
| 22 | 23 | 24 | 25 | 26 | 27 | 28 |
| 29 | 30 | 31 | ||||