MythColor的专栏

在一台陌生主机上，怎样定位识别各种配置？1. 首先确定ORACLE运行的宿主OS用户。可用pe -ef 以查看 ora_smon_xxx 进程跑在哪个用户下的bash-3.00$ ps -ef |grep ora_smon oslubj0 23581     1   0 00:36:58 ?           0:28 ora_smon_lubj0 oslucs0 25770     1   0 00:40:04 ?           1:01 ora_smon_lucs0 osluqd0 20482 

http://topic.youkuaiyun.com/u/20090108/10/bab15d7a-337d-4cfc-8182-c3b6279bdb2f.html

<br />不添加 tnsnames.ora 项，直接建 DBLink：<br /> <br />CREATE DATABASE LINK "TEST_TRS.WORLD"<br /> CONNECT TO TRSDATA<br /> IDENTIFIED BY paic1234<br /> USING '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.21.100.90)(PORT = 1595)))<br />(CON

<br />select tc.column_id, cc.column_name, cc.comments<br />from dba_col_comments cc, dba_tab_columns tc<br />where cc.table_name = 'TMPLOGLIST_INFO'<br />and tc.table_name = 'TMPLOGLIST_INFO'<br />and cc.column_name = tc.column_name<br />order by tc.colum

alter tablespace TEMP add tempfile '/paic/s2cs5010/dev/bank1/oradata/b7dev1/temp01.dbf' size 5G;

<br /><br /> <br />--创建2个新的日志组<br />alter database add logfile group 4 ('D:/ORACLE/ORADATA/ORADB/REDO04_1.LOG') size 1024k;<br />alter database add logfile group 5 ('D:/ORACLE/ORADATA/ORADB/REDO05_1.LOG') size 1024k;<br /> <br />--切换当前日志到新的日志组，目的使得修改的日志组非A

<br />select uc.constraint_name, uc.owner child_owner, uc.table_name child_table, ucc.column_name child_column<br />,ucp.owner parent_owner, ucp.table_name parent_table, ucp.column_name parent_column<br />from dba_constraints uc, dba_cons_columns ucc, dba_