停止空想

OUI-10058: The OUI Inventory on this system does not exits or is not writable .
1-The /opt/oracle/oraInventory/orainstRoot.sh script was not executed with root privileges,
or an error occurred during execution;
2-You are not a member of the specified installer group

阅读全文 »

Popularity: 28% [?]

来自iutpub

oracledata(DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))

connect internal/oracle (bequeath protocol)
connect internel/oracle@mydb (net8 功能）

I always think of bequeath as IPC (interprocess communication) so it has to be on the same server. The name bequeath may have some historical reason.

Popularity: 18% [?]

alter index XX  rebulid  online  或者create index  XXX on  tableXX (ID) online

与不加online的相比，加了online的不阻塞DML。在大的系统中，如果不加online， index 是加不上去的，

并且会造成整个系统的问题。

阅读全文 »

Popularity: 24% [?]