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前的创建目录和赋权的步骤都可以省略