Skip to content
Saturday, March 06, 2021
Database Learners
Menu
  • About Database
  • Oracle
    • ASM
    • Data Pump
    • Backup and Recovery
    • Patching and Upgradation
    • Performance Tuning
    • Data Guard
    • Real Application Cluster
    • Golden Gate
  • MySQL
  • MS SQL Server
  • MongoDB
  • SQL
  • PL/SQL
  • Linux
  • About Me
  • Contact Us
Latest Posts
  • ORA-Errors
    ORA-01031: Insufficient Privileges When Connect As Sysdba
  • Oracle RAC
    Oracle RAC log files locations
  • DB Scripts
    Drop all tables in Oracle DB (Schema)
  • Oracle
    How to Determine If the Oracle Redo Log File Size Is a Problem
  • Oracle
    Who is connected to my Oracle database?
  • Home

ORA-01031: Insufficient Privileges When Connect As Sysdba

8 September 20208 September 2020 AdministratorLeave a Comment on ORA-01031: Insufficient Privileges When Connect As Sysdba

Not able to connect Oracle database, When issue command — > sqlplus “/ as sysdba” [[email protected] ~]$ sqlplus “/ as sysdba”SQL*Read More…

Oracle RAC log files locations

2 September 20202 September 2020 AdministratorLeave a Comment on Oracle RAC log files locations

If you are using RAC system (doesnt matter how many nodes you have) You need to know where log files are located. In this post, I share those log Read More…

Drop all tables in Oracle DB (Schema)

2 September 20204 September 2020 AdministratorLeave a Comment on Drop all tables in Oracle DB (Schema)

Imagine you have a list of tables in your Oracle DB and you want to drop them all using a client like SQLDeveloper. That’s easier said then done, as Read More…

How to Determine If the Oracle Redo Log File Size Is a Problem

2 September 20202 September 2020 AdministratorLeave a Comment on How to Determine If the Oracle Redo Log File Size Is a Problem

Two potential problems are possible that should be addressed when considering whether to increase the size of Oracle log files: batch jobs that donRead More…

Who is connected to my Oracle database?

2 September 20202 September 2020 AdministratorLeave a Comment on Who is connected to my Oracle database?

Would you like to know who is connected to your Oracle database? Is there anybody currently connected? How to check where the connections come from? Read More…

Renaming SYSTEM datafiles of Oracle Database

2 September 20202 September 2020 AdministratorLeave a Comment on Renaming SYSTEM datafiles of Oracle Database

System tablespace is the most critical tablespace in Oracle database. To rename datafiles related to SYSTEM tablespace , we cannot proceed as we procRead More…

ORA-01555: snapshot too old

2 September 20202 September 2020 AdministratorLeave a Comment on ORA-01555: snapshot too old

The ORA-01555 error is caused by Oracle read consistency mechanism and is usually associated with long running UPDATE SQL and too small UNDO. This isRead More…

How to solve ORA-01031: insufficient privileges when creating a materialized view

2 September 20202 September 2020 AdministratorLeave a Comment on How to solve ORA-01031: insufficient privileges when creating a materialized view

At first, I got the following error from the Oracle server when exeuting the “CREATE MATERIALIZED VIEW” script: where tab2.year > to_numbeRead More…

Oracle DB – Monitor with nagios using check oracle health

2 September 20202 September 2020 AdministratorLeave a Comment on Oracle DB – Monitor with nagios using check oracle health

This tutorial explains how to set-up the check_oracle_health script (credits to Gerhard Lausser) to work on your Nagios environment onRead More…

HOW TO RESIZE INNODB LOGS?

1 September 20201 September 2020 AdministratorLeave a Comment on HOW TO RESIZE INNODB LOGS?

If for any reason you need to change the size of InnoDB log files (also known as transaction logs), but not sure how to do it, this post will guRead More…

Posts navigation

Older posts

Recent Posts

  • ORA-01031: Insufficient Privileges When Connect As Sysdba
  • Oracle RAC log files locations
  • Drop all tables in Oracle DB (Schema)
  • How to Determine If the Oracle Redo Log File Size Is a Problem
  • Who is connected to my Oracle database?

Categories

  • ASM (40)
  • Backup and Recovery (52)
  • Data Guard (36)
  • Data Pump (28)
  • DB Scripts (26)
  • General (1)
  • Golden Gate (7)
  • Interview Questions (24)
  • Linux (86)
  • MS SQL Server (8)
  • MySQL (119)
  • ORA-Errors (45)
  • Oracle (301)
  • Oracle 10g (19)
  • Oracle 11g (24)
  • Oracle 12c (9)
  • Oracle RAC (101)
  • Oracle XE (7)
  • Patching and Upgradation (19)
  • Performance Tuning (61)
  • PL/SQL (26)
  • RMAN (85)
  • SQL (32)

Visitors

  • 1
  • 15
  • 2,633

Reference Links:

  • https://docs.oracle.com/en/database/index.html
  • https://dev.mysql.com/doc/
  • https://docs.mongodb.com/manual/
  • https://docs.microsoft.com/en-us/sql/sql-server/?view=sqlallproducts-allversions
@2020 databaselearners.com | Theme: BlogMagazine by Dinesh Ghimire.