dm11g礦機
❶ ORACLE 11G R2怎麼啟動CSS服務
工作空間
管理器（工作空間管理窗口）中，選中數據源圖標，單擊滑鼠右鍵，從彈出的
快捷菜單
中選擇「新建數據源…」。
SuperMap支持以下幾種資料庫：
SDB（文件型資料庫，類似Access）
Oracle
MS
SQL
Server
Sybase
ASE
DB2
DM
Kingbase
ES
不用感謝我也是復制別人的！
❷ oracle expdp導出的時候進程DM00掉不起來
你沒有ORACLE賬戶吧，你公司要是買了付費ORACLE會給賬號的，你去要一個，
我把裡面關於這個的文章粘給你，不給你翻譯了挺長的。
你看看Symptoms應該是你這個問題，在你的11.2.0.1.0是可以發生的。
後面有Solution
Symptoms
All of a sudden, your data pump export jobs all fail with the following bunch of errors:
Export: Release 11.2.0.3.0 - Proction on Sunday, Apr 28, 22:00:26 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Proction
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORA-31626: Job does not exist
ORA-31638: cannot attach to job Your_JOBNAME for user SYSTEM
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT_INT", line 428
ORA-39077: unable to subscribe agent KUPC$A_4_220050709685000 to queue "KUPC$C_4_20130428220032"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPC$QUE_INT", line 250
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
Solution
Initially, Oracle Development built a fix under Patch 16473783.
We found out that the fix was incomplete and needed to be re-written.
This is under progress and monitored via unpublished Bug 16928674.
After encountering this symptom, this is not resolved unless recreating of datapump like followings.
@$ORACLE_HOME/rdbms/admin/catdph.sql
@$ORACLE_HOME/rdbms/admin/prvtdtde.plb
@$ORACLE_HOME/rdbms/admin/catdpb.sql
@$ORACLE_HOME/rdbms/admin/dbmspump.sql
@$ORACLE_HOME/rdbms/admin/utlrp.sql
Generally speaking, we can recreate the datapump objects in 11g by calling;
1. Catproc.sql
SQL> @$ORACLE_HOME/rdbms/admin/catproc.sql
2. To recompile invalid objects, if any
SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql
This is described in Note 430221.1 How To Reload Datapump Utility EXPDP/IMPDP
❸ 我的磁碟空間還有11G，為什麼不能新建和合並
已經分好卷還怎麼合並？要刪除之後才能進行這個操作！
當然有DM PQ等可以直接調整分區大小的！
如果有一個未分區的卷或單獨的磁碟。不妨把硬碟轉換成動態盤！
想加大就使用擴展卷功能即！
如果有兩塊以上的硬碟，還可以建議磁碟陳列或RAID等
❹ 使命召喚9下載地址.經過測試可玩在發.3DM .遊民星空都已經下載過.3DM的是11G左右的.
樓主你好
畢竟使命9這游戲剛出破解版本的 好多問題都沒有得到解決
建議等兩個月 那時候完整破解版的就出來了
好游戲不在乎一時 不是么？
❺ 如何查看dm資料庫環境變數配置是否成功
1.檢查系統包安裝情況
rpm -qa|grep binutils
rpm -ivh sysstat-7.0.2.rpm
rpm -ivh binutils-2.17.50.0.6-14.el5.*.rpm
rpm -ivh compat-libstdc++-33-3.2.3-61.*.rpm
rpm -ivh elfutils-libelf-0.137-3.el5.*.rpm
rpm -ivh elfutils-libelf-devel-0.137-3.el5.i386.rpm elfutils-libelf-devel-static-0.137-3.el5.i386.rpm
rpm -ivh elfutils-libelf-devel-0.137-3.el5.x86_64.rpm elfutils-libelf-devel-static-0.137-3.el5.x86_64.rpm
rpm -ivh gcc-4.1.2-48.el5.*.rpm
rpm -ivh gcc-c++-4.1.2-48.el5.*.rpm
rpm -ivh glibc-2.5-49.*.rpm
rpm -ivh glibc-common-2.5-49.*.rpm
rpm -ivh glibc-devel-2.5-49.*.rpm
rpm -ivh lio-0.3.106-5.*.rpm
rpm -ivh lio-devel-0.3.106-5.*.rpm
rpm -ivh libgcc-4.1.2-48.el5.*.rpm
rpm -ivh libstdc++-4.1.2-48.el5.*.rpm
rpm -ivh libstdc++-devel-4.1.2-48.el5.*.rpm
rpm -ivh make-3.81-3.el5.*.rpm
rpm -ivh sysstat-7.0.2-3.el5.*.rpm
rpm -ivh unixODBC-2.2.11-7.1.*.rpm
rpm -ivh unixODBC-devel-2.2.11-7.1.*.rpm
rpm -ivh libXp-1.0.0-8.1.el5.*.rpm
rpm -ivh libXau-devel-1.0.1-3.1.*.rpm
rpm -ivh libXp-devel-1.0.0-8.1.el5.*.rpm
2.修改網路配置
vi /etc/sysconfig/network-scripts/ifcfg-eth0
----------------------------
DEVICE=eth0
BOOTPROTO=none
HWADDR=00:0c:29:d4:f5:b4
ONBOOT=yes
TYPE=Ethernet
USERCTL=yes
IPV6INIT=no
PEERDNS=yes
NETMASK=255.255.255.0
IPADDR=192.168.91.100
GATEWAY=192.168.91.1
----------------------------
vi /etc/hosts
-----------------------------
127.0.0.1 localhost.localdomain localhost
192.168.91.100 RHL5
-----------------------------
3.添加oracle用戶
groupadd oinstall
groupadd dba
useradd -g oinstall -G dba oracle
passwd oracle
4.添加初始化參數
vi /etc/sysctl.conf
sysctl -p
-----------------------------
fs.aio-max-nr = 1048576
fs.file-max = 6815744
#kernel.shmall = 2097152
#kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
-----------------------------
5.關閉強制訪問控制，避免路由訪問失敗
vi /etc/selinux/config
-----------------------
SELINUX=disabled
-----------------------
6.設置oracle軟硬體進程數
vi /etc/security/limits.conf
-----------------------
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
-----------------------
7.全局進程，線程配置
vi /etc/profile
----------------------
if [$USER = 'oracle']; then
ulimit -u 16384
ulimit -n 65536
fi
----------------------
8.創建oracle根目錄，並設置目錄許可權
mkdir /u01/app/oracle -p
chown -R oracle:oinstall /u01
chmod -R 755 /u01
9.設置oracle用戶環境變數
su - oracle
vi .bash_profile
----------------------
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/proct/11.2/db_1
export ORACLE_SID=oracle11g
export NLS_LANG=american_america.zhs16gbk
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
export PATH=$PATH:$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/X11R6/bin
umask 022
----------------------
讓其生效
. ./.bash_profile
檢驗是否設置成功
echo $ORACLE_HOME
❻ ORACLE 11G R2怎麼啟動CSS服務
工作空間管理器（工作空間管理窗口）中，選中數據源圖標，單擊滑鼠右鍵，從彈出的快捷菜單中選擇「新建數據源…」。
SuperMap支持以下幾種資料庫：
SDB（文件型資料庫，類似Access）
Oracle
MS SQL Server
Sybase ASE
DB2
DM
Kingbase ES
不用感謝我也是復制別人的！
❼ 如何導出oracle 11g中的資料庫的數據字典
-- 查詢某表的數據字典
SELECT A.TABLE_NAME AS 表名,A.COLUMN_NAME AS 欄位名,
DECODE(A.CHAR_LENGTH,0,DECODE(A.DATA_SCALE,NULL,A.DATA_TYPE,A.DATA_TYPE||'('||A.DATA_PRECISION||','||A.DATA_SCALE||')'),
A.DATA_TYPE||'('||A.CHAR_LENGTH||')') as 欄位類型1,A.DATA_TYPE AS 欄位類型,A.DATA_PRECISION AS 有效位,A.DATA_SCALE AS 精度值,
A.CHAR_LENGTH AS 欄位長度,A.NULLABLE AS 能否為空
FROM sys.user_tab_columns A where A.table_name = 'TAM_ADDRESS'
-- 具有dba許可權用戶導出數據字典
SELECT A.TABLE_NAME AS 表名,A.COLUMN_NAME AS 欄位名,
DECODE(A.CHAR_LENGTH,0,DECODE(A.DATA_SCALE,NULL,A.DATA_TYPE,A.DATA_TYPE||'('||A.DATA_PRECISION||','||A.DATA_SCALE||')'),
A.DATA_TYPE||'('||A.CHAR_LENGTH||')') as 欄位類型,A.DATA_DEFAULT AS 默認值,
A.NULLABLE AS 能否為空,B.comments AS 備注
FROM sys.all_tab_columns A,sys.DBA_COL_COMMENTS B
WHERE A.owner=B.owner AND A.table_name=B.table_name AND A.COLUMN_NAME=B.COLUMN_NAME AND A.owner='guoqiang' AND
A.TABLE_NAME IN (
'TB_SUBJECT', 'TB_SUBJECT_BALANCE', 'TB_VOUCHER', 'TB_VOUCHER_DETAILS',
'TB_CUSTOMER', 'TB_VOUCHER_CLASSIFY_MODE', 'TB_VOUCHER_TYPE', 'TB_ASSET',
'TB_ASSET_CATALOG', 'TB_M_DM_ASSETS_LIABI_RPT', 'TB_M_DM_PROFIT_RPT',
'TB_M_DM_REVENUE_RPT', 'TB_M_DM_COST_RPT')ORDER BY A.TABLE_NAME
SELECT A.TABLE_NAME AS 表名,A.COLUMN_NAME AS 欄位名,
DECODE(A.CHAR_LENGTH,0,DECODE(A.DATA_SCALE,NULL,A.DATA_TYPE,A.DATA_TYPE||'('||A.DATA_PRECISION||','||A.DATA_SCALE||')'),
A.DATA_TYPE||'('||A.CHAR_LENGTH||')') as 欄位類型,A.DATA_DEFAULT AS 默認值,
A.NULLABLE AS 能否為空,B.comments AS 備注
FROM sys.user_tab_columns A,sys.user_col_comments B
WHERE A.table_name=B.table_name AND A.COLUMN_NAME=B.COLUMN_NAME AND
A.TABLE_NAME IN (
'TB_SUBJECT', 'TB_SUBJECT_BALANCE', 'TB_VOUCHER', 'TB_VOUCHER_DETAILS',
'TB_CUSTOMER', 'TB_VOUCHER_CLASSIFY_MODE', 'TB_VOUCHER_TYPE', 'TB_ASSET',
❽ oracle 11g 導入數據都不成功
oracle11g用exp導出資料庫的時候，空表是導不出來的，所以必須用數據泵導入導出oracle資料庫。
1、expdp
SQL> create directory 目錄名（如：dmpbx）as 存儲地址（如：'/root/usr/……'）;
目錄已創建。
SQL> grant read,write on directory 目錄名to public;
授權成功。
SQL> exit
expdp 用戶名1/密碼@實例mpfile=備份文件名（ecology.dmp）directory= 目錄名（dmpbx）
2、impdp
SQL> create directory 目錄名（如：dmpbx）as 存儲地址（如：'/root/usr/……'）;
目錄已創建。
SQL> grant read,write on directory 目錄名to public;
授權成功。
SQL> exit
impdp 用戶名2/密碼@實例directory=目錄名mpfile=備份文件名.dmp logfile=日誌名.log REMAP_SCHEMA=用戶名1:用戶名2
如果impdp是在同一台機器上操作的，則impdp前的創建目錄和賦權的步驟都可以省略