摘要: cannot drop a user that is currently connectedSQL> SELECT SID,SERIAL# FROM V$SESSION WHERE USERNAME='用户名';SQL> ALTER SYSTEM KILL SESSION 'SID值,SERIAL#值'; //语句尽量使用大写 阅读全文
posted @ 2013-04-02 14:47 凉风微雨 阅读(118) 评论(0) 推荐(0) 编辑
摘要: [oracle@localhost ~]$ emctl status提示Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name.处理方法:$sqlplus /nologsql>connect sys/密码 as sysdbasql>alter user dbsnmp identified by admin (更改dbsnmp密码为admin)sql>drop role MGMT_USER;sql>drop user MGMT_VI 阅读全文
posted @ 2013-04-02 14:45 凉风微雨 阅读(450) 评论(0) 推荐(0) 编辑
摘要: 1.如果是重新安装系统,建议在定制时: Desktop Environments选上GNOME Desktop Environment和KDE Application选上Graphical Internet选上 Text-base InternetOffice/Productivity、Engineering and Scientific Development选上Development Tools(全选) Server选上DNS NAME Server(全选)、Web Server(全选)、Server Configuration Tools(全选)、 Windows File Se... 阅读全文
posted @ 2013-04-02 14:43 凉风微雨 阅读(104) 评论(0) 推荐(0) 编辑