Check that the DATABASE is connected to the tnsping database and listens to lsnrctl to view SIDSQL> SELECT * from v $ INSTANCE; SQL> SELECT * FROM V $ DATABASE; SQL>/execute the previous operation command SQL> edit read command cache view language configuration SQL> show parameters nlsSQL> select * from V $ NLS_PARAMETERS view startup parameter file SQL> show parameters spfile; view the data block configuration size SQL> show parameters db; view the oracle version SQL> SELECT * from v $ VERSION display all the build versions SQL> select * from product_component_version; configure the output log SQL> spool c: \ testora. logSQL> spool off SWITCH to archive log SQL> alter system archive log current; SQL> ALTER SYSTEM SWITCH LOGFILE; view database object structure SQL> desc v $ dbfile view DatafileSQL> SELECT * from v $ DBFILE; SQL> SELECT * FROM V $ DATAFILE; view all user SQL> select username from DBA_USERS view control file SQL> select * from v $ controlfile; set the output row width SQL> set linesize 20000 view REDOLOG file SQL> SELECT * from v $ LOGFILE; view tablespace SQL> SELECT * FROM V $ tablespace; after manually deleting archived logs, synchronize CATALOGSQL> crosscheck archivelog allsql> CHANGE ARCHIVELOG ALL CROSSCHECK
