HzqGhost's Blog

net manage服务命名：LISTENER_YIPARTS 第一步D:\oracle\11g\app\product\11.2.0\dbhome_1\NETWORK\ADMINtnsnames.oraLISTENER_YIPARTS =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL

lsnrctlset log_status offrename F:/ora/product/11.2.0/db_1/NETWORK/log/listener.log listener_bak_%date:~0,10%.loglsnrctl set log_status on

注意host文件 127.0.0.1 主机名127.0.0.1 localhost客户端配置目录D:\install\PLSQL\instantclient_11_2ORCALE配置目录D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMINlsnrctl stoplsnrctl startt...

查看DATA_PUMP_DIR 目录select * from dba_directoriesexp user/password@SID file=e:\file.dmp owner(user)imp user/password file=e:\file.dmp fromuser=user touser=user只导出结构exp username/pwd@orcl file=...

drop tablespace TMP_test including contents and datafiles;CREATE TABLESPACE test_2018_2nologgingDATAFILE'H:\2018_2\test01.dat' size 4096m autoextend off,'I:\2018_2\test02.dat' size 4096m autoext...

解决步骤第一步、sqlplus /NOLOG第二步、SQL>connect sys/change_on_install as sysdba提示：已成功(1,2)或者打开sqlplus请输入用户名: system/sys as sysdba第三步、SQL>shutdown normal或者 shutdown abort提示：数据库已经关闭已经卸载数据库...

查询存储过程与触发器删除select 'DROP TRIGGER '||owner||'."'||TRIGGER_NAME||'";' from dba_triggers whereTRIGGER_NAME like 'DBMS_%_INTERNAL% 'union allselect 'DROP PROCEDURE '||owner||'."'||a.object_name||'"...

重启oracleXXX服务