SAP BASIS,HANA AND ORACLE DBA BLOGS

ORA-01031: insufficient privileges on Windows Hi folks, while after installation we are unable to login as sysdba in cmd prompt so these are possible solution for same. sqlplus / as sysdba   does not works   ( ORA-01031: insufficient privileges ), But sqlplus sys/oracle as sysdba  works fine . ********************************************************************************* C:\Windows\system32>sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Mon Dec 2 17:15:06 2013 Copyright (c) 1982, 2010, Oracle. All rights reserved. ERROR: ORA-01031: insufficient privileges ================================================================================== Verified remote_login_passwordfile to be EXCLUSIVE ================================================================================== C:\Windows\system32>  sqlplus sys/oracle as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Mon Dec 2 17:15:06 2013 Copyright (c) 1982, 2...

POSTGRESQL DATABASE Table of Contents Major features of Postgresql Architecture diagram: Details for memory components shared_buffers temp_buffers work_mem maintenance_work_mem Wal buffer Utility Process (background process): Enable Stats collection in Postgresql database Insertion operations with WAL Oracle instance vs postgresql instance Difference between template0   and  template1 LETS STARTS WITH DATABASE: Create new directory locations where you want to create database files: FILE LOCATIONS: The pg_ident.conf file Need to install rpm to run and install PostgreSQL database How to start postgresql database How to start sql prompt in postgresql to run sql query How to check port in postgresql database To check version of postgresql database How to Enabling access for network/remote users Server up time Total number of tables Create, select and delete database List of Roles To check all database Connect to databas...

Oracle Database Upgrade 11gR1 (11.1.0.6) to 11gR1 (11.1.0.7) Go to path where path is placed   And unzip the .zip file by unzip command Step 1 Verify the Time Zone Definitions         The 11.1.0.7 patch set includes the Oracle time zone definitions Version 4.         This version of the time zone definitions includes the changes to daylight savings time in the USA in 2007 and other updates.         SQL> SELECT version FROM v$timezone_file;                    VERSION         ----------                  4                 If the query reports version 4, no action is required. ...