ar
one:svrmgrl move to sqlplus at oracle 10g
two:more instance can use same listener
three:a dictionary managed tablesoace is one whose free space management is
done in data dictionary that resides in system tablespace.
where as a locally managed tablespace means the free space for the tablespace is managed with in the tablespace using bitmaps.
locally managed tablespaces gives better performance in comparison to dmt.
but if ur system tablespace is locally managed then other tablespaces r also locally managed.
and in near future oracle may stop supporting dictionary managed tablespaces.
four:emctl start/stop dbconsole;isqlplus start/stop;
five:find port of em or isqlplus:$ORACLE_HOME/install/portlist.ini
six:modify sys user password when it's password was lost
alter user sys identified by sys;
seven:支持中文字符的数据库,NLS_LANG为 SIMPLIFIED CHINESE_CHINA.ZHS16GBK
eight:--archive
show parameter db_recovery;
select * from V$FLASH_RECOVERY_AREA_USAGE;
archive log list;
show parameter log_archive_start
alter database archivelog;
alter database noarchivelog;
startup nomount;
alter database mount;
alter database open;