-
编辑 删除
10g drop database
SQL> connect / as sysdbaSQL> shutdown abort;SQL> startup nomount;SQL> alter database mount exclusive;SQL> alter system enable restricted session;SQL> drop database;[@more@]
-
编辑 删除
自我总结
好几个月没发帖了，好几个月没看书了，颓废了。[@more@]z
-
编辑 删除
linux学习点滴
＃Redhat 4安装oracle的设置cat >> /etc/sysctl.conf <<EOFkernel.shmall = 2097152kernel.shmmax = 2147483648kernel.shmmni = 4096kernel.sem = 250 32000 100 128fs.file-max = 65536net.ipv4.ip_local_port_ran...
-
编辑 删除
oracle rac
mkdir ~/.sshchmod 700 ~/.sshssh-keygen -t rsaocfs2-2.6.9-55.ELsmpocfs2-2.6.9-55.ELsmphttp://oss.oracle.com/projects/ocfs2/files/RedHat/RHEL4/i386/1.2.5-2/ srvctl stop service -d <database name> -s ...
-
编辑 删除
erp clone record
cp -R /u01/oratest/testdata /u02/oraprod/proddatacp -R /u01/oratest/testdb /u02/oraprod/proddb/dev/fslv01 135.00 93.40 31...
-
编辑 删除
asm 小结
ORA-15000: command disallowed by current instance typeexport ORACLE_SID=+ASMselect name,state from v$asm_diskgroup;ALTER DISKGROUP dgroup1 MOUNTALTER DISKGROUP dgroup1 DISMOUNT;create diskgroup dgr...
-
编辑 删除
erp concurrent process can not start
Concurrent Managers Fail to Start, Verify that findev has been registered for concurrent processingSymptomsAfter migration of the Applications tier the concurrent managers do not start. Only a single...
-
编辑 删除
ORACLE ORA-12514
tnsping service_name 返回状态正常！sqlplus userid/passwd@service_name 出现ORA-12514错误.前几天11g中也碰到了这个问题，今天的版本是Release 10.2.0.1.0也遭错误.解决办法是修改listener.ora中SID_LIST_LISTEN...
-
编辑 删除
ora-12514
SQL> host oerr ora 1251412514, 00000, "TNS:listener does not currently know of service requested in connect descriptor"// *Cause: The listener received a request to establish a connection to a// database or other service. The connect descriptor received by the listener// specified a service name for a service (usually a database service)// that either has not yet dynamically registered with the listener or has// not been statically configured for the listener. This may be a tempor
-
编辑 删除
Lock Escalation
Lock EscalationThe creation of additional Interested Transaction Lists (ITL) slots is subject to free space in the datablock because each ITL takes approximately 24 bytes of free space in the variabl...
-
编辑 删除
08年
新的一年到了，希望自己不要荒废，革命尚未成功，自励一下。[@more@]
