Check default temp tablespace
col PROPERTY_NAME format a50 col PROPERTY_VALUE format a50 col DESCRIPTION format a50 set lin 300 SELECT PROPERTY_NAME,PROPERTY_VALUE,DESCRIPTION FROM DATABASE_PROPERTIES where PROPERTY_NAME=’DEFAULT_TEMP_TABLESPACE’;
Check default temp tablespace
col PROPERTY_NAME format a50 col PROPERTY_VALUE format a50 col DESCRIPTION format a50 set lin 300 SELECT PROPERTY_NAME,PROPERTY_VALUE,DESCRIPTION FROM DATABASE_PROPERTIES where PROPERTY_NAME=’DEFAULT_TEMP_TABLESPACE’;
Login as sysdba for ORA-00020: maximum number of processes 0 exceeded
sqlplus -prelim “/as sysdba”
Get the list of patches
set lin 600 col action format a10 col namespace format a7 col version format a10 col bundle_series format a30 col comments format a30 select id,action,namespace,version,bundle_series,comments from registry$history; Another solution: cat /u01/app/oracle/product/11.2.0.3/.patch_storage/record_inventory.txt