- 博客(22)
- 收藏
- 关注
RSS订阅转载 向SQLPlus传入参数
向SQLPlus传入参数2008-10-31 22:48向sqlplus传递参数的语法为：sqlplus username/password @cmdfile.sql var1 var2 var3参数var1，var2依次将被传递到SQL*Pl
2011-08-10 15:39:24
1117
转载 Event Reference
Event Reference10013 - Monitor Transaction Recovery10015 - Dump Undo Segment Headers10032 - Dump Sort Statistics10033 - Dump Sort In
2011-08-10 15:27:04
647
原创 ORA-01008: not all variables bound
在做impdp时，发现job无法成功导入。因为job_id重复。就改从pl/sql developer复制脚本出来执行 ORA-01008: not all variables bound没定义变量解决办法，声明变量，再执行脚本SQL> var job num
2011-08-09 10:23:36
11323
原创 查询oracle权限
关键字：oracle privelege role 1.role角色select * from dba_role_privs;----select * from user_role_privs;role的进一步细化：1)role所包含的roleselect * from role
2011-07-20 11:12:05
452
转载 ORA-22913: must specify table name for nested table column or attribute
ORA-22913: must specify table name for nested table column or attribute Always check out the original article at http://www.oraclequirks.com
2011-07-15 12:41:48
3369
转载 crontab
Crontab – Quick ReferenceSetting up cron jobs in Unix and Solariscron is a unix, solaris utility that allows tasks to be automatically run i
2011-07-12 11:31:04
667
原创 恢复rman参数parallelism为默认
RMAN> show all; RMAN configuration parameters are:CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # defaultCONFIGURE BACKUP OPTIMIZATION OFF; #
2011-07-07 10:32:43
1424
转载 nohup scp password
$ nohup scp file_to_copy user@server:/path/to/copy/the/file > nohup.out 2>&1
2011-07-05 13:23:06
1043
转载 How Relative File Numbers Are Generated. [ID 262384.1]
How Relative File Numbers Are Generated. [ID 262384.1] Modified 13-JUL-2004 Type HOWTO Status PUBLISHED Applies ToOracle Server - Enterprise Edition - Versi
2011-06-24 14:30:00
886
转载 ORA-38856: Cannot mark instance UNNAMED_INSTANCE_2 (redo thread 2) as enabled
ORA-38856: Cannot mark instance UNNAMED_INSTANCE_2 (redo thread 2) as enabledExample:In the example below the error Occurred while performing an open resetlogs on a 10.2.0.3 Oracle Single Instanc
2011-06-09 09:15:00
2685
转载 Binary Cloning 安装ORACLE
Oracle installation: Oracle Binary Cloning Oracle installation: Oracle Binary Cloning<br /><br />Clone the oracle software between two server.<br /><br />Please check the OS compatibility are same between source & destination server.<br /><br /><br />Sourc
2011-05-30 12:13:00
534
转载 Create a shared disk for VMware ESX guests
Create a shared disk for VMware ESX guestsPosted on October 11, 2010, 10:24, by rmichel, under HowTo, Linux, Work.<br />To create a shared disk between two or more VMs, login into one of your ESX hosts and create a disk image.View Raw Code?cd /vmfs/volumes
2011-05-19 11:35:00
623
转载 Create shared disk for Oracle RAC on VMWare
原文地址：http://d-h-n.de/blog/?p=430Create shared disk for Oracle RAC on VMWare<br />Juni 15th, 2009 . by admin<br />For Oracle RAC installation we need share storage for OCR, Voting Disk, ASM..<br />Shared DisksNoSizeUsage11 GBPlace OCR, Voting Disk and mirro
2011-05-19 11:02:00
1148
原创 linux增加swap大小
<br /> <br />1.检查swap的大小<br />/sbin/swapon -s<br />2.检查有几个swap文件<br />grep swap /etc/fstab<br />3.如何添加swap文件<br />mkdir /swap ------目录名可根据实际需要取，不重要<br />4.-------bs是块的大小，bs=1024即块等于1KB<br />dd if=/dev/zero of=/swap/swapfile1 bs=1024 count=2019022<b
2011-05-18 11:10:00
379
原创 Expdp学习笔记
--------------不要以sysdba来调用expdp，为什么呢？还没搞清楚！！Note: Do not invoke Export as SYSDBA, except at the request of Oracle technical support. SYSDBA is used internally and has specialized functions; its behavior is not the same as for general users.--------------不支
2011-05-15 16:40:00
1016
转载 linux kill process
Kill a Process<br />Linux Tips by Burleson Consulting<br />When good processes go bad it is often necessary to terminate them. The kill command is used to send a termination signal to the specified process or group. The default termination signal is a SIG
2011-05-13 14:03:00
2420
原创 oracle手动建库脚本
-------------mkdir -p /opt/oracle/admin/vobpod/utilsmkdir -p /opt/oracle/admin/vobpod/auditmkdir -p /opt/oracle/admin/vobpod/cdumpmkdir -p /opt/oracle/admin/vobpod/createmkdir -p /opt/oracle/admin/vobpod/changemkdir -p /opt/oracle/admin/vobpod/logmkdir -p
2011-05-13 11:34:00
2688
原创 解决startup pfile LRM-00116错误
<br />SQL>startup nomount pfile'/opt/oracle/pfile.ora'<br />LRM-00116: syntax error at 'global_names' following '='<br /> <br />问题所在：pfile.ora里面的参数包含空值。如db_domain=<br />将其去掉，或改为db_domain=""<br />OK了
2011-05-13 10:27:00
9246
转载 dbms_metadata role
set pages 0 line 132 rimspool onspool cre8rolesexec dbms_metadata.set_transform_param( - dbms_metadata.session_transform, 'SQLTERMINATOR', true);-- Create the rolesSELECT DBMS_METADATA.GET_DDL('ROLE', role)||';' FROM dba_roles/
2011-05-09 22:40:00
472
原创 dbms_metadata导出role语句的定义
<br />以下以查“DBA ”为例<br />-- Create the roles<br />SELECT DBMS_METADATA.GET_DDL('ROLE', 'DBA') from dual;<br />-- Roles which are granted to roles<br />SELECT DBMS_METADATA.GET_GRANTED_DDL('ROLE_GRANT', 'DBA') from dual;<br />-- System privileges granted to
2011-05-09 22:38:00
572
原创 Oracle SQL no parse
parsing is something controlled by your programmers.Oracle, when told to parse, will (must, cannot deny you) parse. The parse will be one of three kinds:a) hard (bad)b) soft (bad)c) softer soft (still bad)the only good parse is NO parse -- and your applic
2011-02-14 12:22:00
789
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人