Effie_Zheng的博客

---ORA-28001: The password has expired1.Connect as sysdba to the database. C:\Users\Siry>sqlplus / as sysdba2.Run the query to set the password’s life time to unlimited. SQL> ALTER PROFILE DEF

---sql mornintor grant select on v_$sqltext_with_newlines to ;grant select on v_$session to ;grant select on v_$locked_object to ;grant select on v_$lock to ;

select TABLESPACE_NAME, BYTES_USED/1024/1024/1024 as GB_USED , BYTES_FREE/1024/1024/1024  GB_FREE from V$TEMP_SPACE_HEADER;ALTER TABLESPACE TEMP ADD TEMPFILE '/u20/oradata/CCIRPAT/DATAFILES/temp

Enter user-name: /as sysdbaERROR:ORA-09817: Write to audit file failed.Linux-x86_64 Error: 28: No space left on deviceAdditional information: 12ORA-09945: Unable to initialize the audit trai

--ORA-00604: error occurred at recursive SQL level 1--ORA-01654: unable to extend index SYS.I_PLSCOPE_SIG_ACTION$ by 128 in tablespace SYSAUX--00604. 00000 -  "error occurred at recursive SQL

CREATE TABLE "GRANT_PRIVS_INFO"    ( "GRANT_REVOKE" VARCHAR2(1000 BYTE),  "PRIVS" VARCHAR2(100 BYTE),  "TABLE_NAME" VARCHAR2(64 BYTE),  "GRANTEE" VARCHAR2(100 BYTE)   )   ;create or re

CREATE   DATABASE LINK  LINK_NAME CONNECT TO schema IDENTIFIED BY abc123 USING '';

select name,log_mode from v$database;-----------PATH: /optware/arch/

pbrun - rootsu - oracle1. Create all required directories as below.mkdir -p /u20/oracle/admin/PROJECT/adumpmkdir -p /u20/oracle/admin/PROJECT/dpdumpmkdir -p /u20/oracle/admin/PROJECT/p

exec DBMS_STATS.gather_table_stats(ownname=>'', tabname=>'');

--------------------1 change NLS_NCHAR_CHARACTERSET SHUTDOWN IMMEDIATE; STARTUP MOUNT exclusive RESTRICT;ALTER SYSTEM ENABLE RESTRICTED SESSION; ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0; A

---sql tuninggrant advisor to ;grant administer sql tuning set to ;--CHECK CURRENT DB SETselect b.tablespace_name, tbs_size SizeMb, a.free_space FreeMb from  (select tablespace_name, r