Oracle 启动监听命令
发布日期:2025-04-29 13:23:42 浏览次数:16 分类:精选文章

本文共 1812 字,大约阅读时间需要 6 分钟。

Oracle??????????

Oracle?????????????????DBA????????????????????Oracle???????????????????????????????Oracle????

??SGA?Shared Memory Structure???

SGA?Oracle??????????????????????????????????SGA??????????????????????????

  • ??SGA??

    ????????SGA???

    ALTER SYSTEM SET shared_pool_size=64M;ALTER SYSTEM SET db_cache_size=64M;ALTER SYSTEM SET large_pool_size=64M;
  • ??SGA??

    SGA???????????

    • ????????????????SQL????
    • ????????????????????
    • ???????????????????????
    • ?????????Java????????????
  • ?????????

    ??????????????????????????

  • ?????

    ??????????

    startup nomountstartup mount dbnamestartup open dbname
    • startup nomount????SGA??????????
    • startup mount dbname?????????????????
    • startup open dbname???????????????
  • ?????

    ?????????????

    shutdown immediateshutdown normal
    • shutdown immediate????????????????
    • shutdown normal??????????????????
  • ??????

    ???????????????????????

    ALTER DATABASE ADD REDO LOG;ALTER DATABASE DROP REDO LOG;
  • ????

    ?Oracle???????????

    CREATE USER username IDENTIFIED BY password;ALTER USER username IDENTIFIED BY new_password;
  • ?????????

    Oracle???????????????????????????????????

  • ???????

    ??lsnrctl????????

    lsnrctl startlsnrctl statuslsnrctl stop
    • ??????lsnrctl start
    • ????????lsnrctl status
    • ??????lsnrctl stop
  • ????

    ??Oracle???????????

    net start OracleServiceOrcl
    • ???????sqlplus /@testdb as sysdba
  • ??????

    ??EMC?????????

    emctl start dbconsole
    • ??????http://localhost:1158/em/
  • ???????????

  • ???????

    ??????????

    SHOW ALLSET SERVEROUTPUT ON
  • ???????????

    • ??startup nomount????????????
    • ??startup mount dbname?????????
    • ??startup open dbname??????????
  • ???????

    ??????????????????????????

    ALTER DATABASE RECOVER;ALTER DATABASE RENAME FILE; -- ?????
  • ?????

    ???????????????

    CREATE TABLESPACE backup_table AS SELECT * FROM users;
  • ????

    ??????SGA??????????????????????????DBA??????Oracle???????????????????????????????????????????????????Oracle???????

    上一篇:Oracle 启动阶段 OPEN
    下一篇:oracle 可传输的表空间:rman

    发表评论

    最新留言

    第一次来,支持一个
    [***.219.124.196]2026年06月08日 22时52分22秒