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. ...
Posts
ORACLE FORMATTING MANY PROBLEM SOLVED :)
- Get link
- X
- Other Apps
FORMATTING OPTIONS AS FOLLOWS: Line and Page display format. SQL> SET LINES 150 SQL> SET PAGESIZE 500 TO FORMAT COLUMNS SQL> column username format a18 ==================================== SQL> SELECT MAX(LENGTH(USERNAME)), MAX(LENGTH(ACCOUNT_STATUS)),MAX(LENGTH(DEFAULT_TABLESPACE)),MAX(LENGTH( TEMPORARY_TA LESPACE)) FROM DBA_USERS; MAX(LENGTH(USERNAME)) MAX(LENGTH(ACCOUNT_STATUS)) MAX(LENGTH(DEFAULT_TABLESPACE)) --------------------- --------------------------- ------------------------------- MAX(LENGTH(TEMPORARY_TABLESPACE)) --------------------------------- 18 16 6 4 SQL> CO...
ORACLE: Grant Privs and dba_roles
- Get link
- X
- Other Apps
SQL> DESC DBA_OBJECTS Name Null? Type ----------------------------------------------------- -------- ------------------ OWNER VARCHAR2(30) OBJECT_NAME VARCHAR2(128) SUBOBJECT_NAME VARCHAR2(30) OBJECT_ID NUMBER DATA_OBJECT_ID NUMBER OBJECT_TYPE VARCHAR2(19) CREATED DATE LAST_DDL_TIME DATE TIMESTAMP VARCHAR2(19) STATUS VARCHAR2(7) TEMPORARY VARCHAR2(1) GE...
ORACLE: INIT.ORA GUIDE
- Get link
- X
- Other Apps
# # Copyright (c) 1991, 1997, 1998 by Oracle Corporation # ############################################################################## # Example INIT.ORA file # # This file is provided by Oracle Corporation to help you customize # your RDBMS installation for your site. Important system parameters # are discussed, and example settings given. # # Some parameter settings are generic to any size installation. # For parameters that require different values in different size # installations, three scenarios have been provided: SMALL, MEDIUM # and LARGE. Any parameter that needs to be tuned according to # installation size will have three settings, each one commented # according to installation size. # # Use the following table to approximate the SGA size needed for the # three scenarious provided in this file: # # -------Installation/Database Size------ # ...