摘要： 过程：alter system switch logfile;alter database backup controlfile to trace;shutdown immediate;拷贝相关文件到移动硬盘，参数口令控制数据和日志文件，监听文件不拷贝cd /oracle/app/ora11g2/product/11.2.0/dbhome_1/dbscp /mnt/jimmydb/dbs/initjimmydb.ora initjimmydb.oracp /mnt/jimmydb/dbs/orapwjimmydb orapwjimmydbcp /mnt/jimmydb/dbs/spfileji 阅读全文

摘要： 1.ls -m1|grep jimmdb2>j.txt2.cat j.txt|while read line;do mv "$line" bak;done这里bak是当前备份文件夹 阅读全文

摘要： Copy and Rename an Oracle Database - (without export/import)by Jeff Hunter, Sr. Database AdministratorYou may find it necessary to duplicate (clone) an Oracle database. One method is to use import/export. This method can work fine, but what if your database is too big? Another method is to make a co 阅读全文

摘要： 1.groupadd dbauseradd -g oinstall -G dba -d /home/ora11g2 ora11g2passwd ora11g22.system-config-securitylevel-tui 关闭防火墙，或者开启1521端口，否则监听启动后无法连接3.修改内核参数4.安装rpm包5.启动runinstaller安装数据库6.打补丁p86705797.修改.bash_profile设置oracle_base,oracle_home和oracle_sidORACLE_BASE=/oracle/app/ora11g2 export ORACLE_BASE ORACL 阅读全文

摘要： 客户装好了Oracle，安装成功了，但是运行dbca和netca都出现错误。 [oracle@db1 ~]$ netcaOracle Net Services Configuration: # # An unexpected error has been detected by HotSpot Virtual Machine: # # SIGSEGV (0xb) at pc=0xa44b13a8, pid=2973, tid=3086891216 # # Java VM: Java HotSpot(TM) Client VM (1.5.0_17-b02 mixed mode) # Proble 阅读全文

摘要： oracledb的主机名不能有下划线，使用以下命令手动配置dbcontrolemca -config dbcontrol db 阅读全文