问题描述
Oracle详细信息:-
Oracle Details:-
-
Oracle 10g企业版
Oracle 10g Enterprise Edition
运行XP x32的主机
Host running XP x32
我使用scott tiger通过SQL * Plus进行日志记录. 我没有提供任何主机名.如何设置Oracle接受主机字符串?我问这个问题是因为我想问题与此有关
I use scott tiger for logging with SQL* Plus . I dont provide any HOST STRING. How can i setup Oracle to accept Host String ? i am asking this because i guess the problem is related to this
IP:192.168.17.132，主机名:vmxp1
IP : 192.168.17.132 , Hostname : vmxp1
tnsnames.ora文件:-
tnsnames.ora file:-
GLOBALDB = (说明= (地址=(协议= TCP)(主机= vmxp1)(端口= 1521)) (CONNECT_DATA = (服务器=专用) (SERVICE_NAME = globaldb) ) )
GLOBALDB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = vmxp1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = globaldb) ) )
EXTPROC_CONNECTION_DATA = (说明= (ADDRESS_LIST = (地址=(协议= IPC)(密钥= EXTPROC)) ) (CONNECT_DATA = (SID = PLSExtProc) (表示= RO) ) )
EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) )
-侦听器
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = D:\ oracle \ product \ 10.1.0 \ db_3) (程序= extproc) ) )
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = D:\oracle\product\10.1.0\db_3) (PROGRAM = extproc) ) )
LISTENER = (DESCRIPTION_LIST = (说明= (ADDRESS_LIST = (地址=(协议= TCP)(主机= 192.168.17.132)(端口= 1521)) ) ) )
LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.17.132)(PORT = 1521)) ) ) )
Informatica详细信息:
Informatica details:
- 我已使用以下配置成功设置了Informatica Powercenter 8.6的客户端和服务器部分
http://img88.imageshack.us/img88/655/imagest.png
- 从管理控制台创建存储库时，我无法连接到Oracle
http://img163.imageshack.us/img163/2152/262926281d2dcd78baa445d.png
在主机字符串字段中尝试了不同的操作.还尝试了系统帐户.
tried different things in the host string field . also tried system account.
如何为inf信息库服务配置Oracle数据库.
How to configure Oracle database for inf repository service.
推荐答案
之所以会这样，是因为您至少需要 两个数据库帐户来托管此存储库:
That happens because you need at least two database accounts to host this repository :
存储库数据库的Power_Repository-
Power_Repository for the repository DB -
用于域配置数据库的Power_Domain-
Power_Domain for the domain Configuration DB -
对于Oracle，您必须执行以下指令:
For Oracle, you MUST perform the following instruction:
连接到数据库:
转到开始"->运行"->键入"cmd"->然后执行下面列出的相同步骤:
Go to Start-> Run-> Type 'cmd'->Then put the same steps listed below:
Microsoft Windows XP [Versión 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:\Documents and Settings\Voislav>cd\
C:\>sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on Dom Jul 10 23:50:07 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Introduzca el nombre de usuario: system
Introduzca la contrase±a:
Conectado a:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
SQL> CREATE USER Power_Repository IDENTIFIED BY Power_Repository
2 DEFAULT tablespace users
3 TEMPORARY tablespace temp
4 quota unlimited ON users;
Usuario creado.
然后确认连接:
GRANT CONNECT, resource, CREATE VIEW TO Power_Repository;
现在对Power_Domain执行相同的步骤.
Now the same steps for Power_Domain., and is done.
这篇关于使用Oracle 10g配置Informatica存储库[Oracle未连接]的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！