As DBA We all know backups play an important role in business operations but in some case backup also get corporate than we can not make database alive. To solve this kind of issue Oracle recommends us to keep a database in archive log mode. To preserve redo information, create archived copies of redo log files […]
Articles Tagged: ORACLE 11g
ORA-01031: insufficient privileges(Add) user in group
In this article we are going to learn about the privileges . The ORA-01031: “insufficient privileges” error occurs when you attempt to execute a program or function for which you have not been granted the appropriate privileges. For the DBA, the ORA-01031 can happen if the target OS executable do not have read and execute permissions (e.g. […]
Index (B-tree)
B-tree Index B-tree stands for Balanced Tree in RDBMS. It is commonly used in database and filesystem.The B-tree enables the database to find a leaf node quickly. It is a good example of a data structure for external memory. Telephone directory, library are the best example of B-tree index. Why do we use B-tree? keeps keys in […]
IOT
IOT Index IOT stands for Index Organised Table in oracle database.The idea behind an IOT is simple. You hold all the data for the table in the ordered structure of an index. Why do we use IOT? An IOT has the structure of an index and stores all the columns of the row, accesses via […]
Index In Oracle
We are living on the planet with the seven billion population.Each and every human being’s have some information. Data is an important factor in the business’s world. Every day in business’s operation we deal with data. It can be structure and un-structure data. All the report of business prepare with the help of data. We take a […]
Catalog Database Configure
Description: RDB1 as TARGET SERVER RDB2 as CATALOG SERVER create a database using DBCA on catalog server as catalog database i.e. RDB create a service in target server for the catalog server connection. check service alias using TNSPING servicename(EX:TNSPING RDB2) in terminal […]
Upgrade Oracle 11gR2 (11.2.0.4) database to 12cR2 (12.2.0.1)
Here I would be discussing how to upgrade Oracle 11gR2 (11.2.0.4) database to Oracle 12cR2 (12.2.0.1) on the same server. This upgrade process was done on Linux 6 (x86_64). I used DBUA (Database Upgrade Assistant) to perform this upgrade. DBUA is also a recommended way to perform the upgrade as it would automate almost everything […]
Displays contents of the registry history
SELECT TO_CHAR(action_time, ‘DD-MON-YYYY’) AS TIME, action, namespace, version, id, comments, bundle_series FROM sys.registry$history ORDER by 1;
How to make a table read only in Oracle
Oracle 11g allows tables to be marked as read-only using the ALTER TABLE command. ALTER TABLE table_name READ ONLY; ALTER TABLE table_name READ WRITE; Let’s create a table and make it read-only. CREATE TABLE Skant (id NUMBER); INSERT INTO Skant VALUES (1); ALTER TABLE Skant READ ONLY; Any DML statements that affect the table data […]