|
|
TO:coolflash:
我估计你建库的过程有问题，
1，SQLPLUS>@<PS_HOME>\scripts\nt\psroles.sql
2，SQLPLUS>@<PS_HOME>\scripts\nt\psadmin.sql
3，grant select on PSSTATUS to <CONNECT_ID>;
grant select on PSOPRDEFN to <CONNECT_ID>;
grant select on PSACCESSPRFL to <CONNECT_ID>;
4，SQLPLUS>@<PS_HOME>\scripts\nt\connect.sql
5，update the connection information in TNSNAMES.ORA
on your client to reflect your Database Name, Oracle SID, and Server Name.
6，Add the new SID name and $ORACLE_HOME location to the LISTENER.ORA on the database server.
7，Stop and start (or reload) the NET8i/NET9i listener.
以上动作做了没有，中间有什么问题？这些是应该在Data Mover之前做的。如果都搞定了，应该连DB是不会有问题的了。
1，Check PSSTATUS
SELECT OWNERID, TOOLSREL,
LASTREFRESHDTTM, LASTCHANGEDTTM
FROMPSSTATUS
2，Validate the User ID and Password
SELECT VERSION, OPERPSWD, ENCRYPTED,
SYMBOLICID, ACCTLOCK FROM PSOPRDEFN
WHERE OPRID = :1
3，Get the Access ID and Password
SELECT ACCESSID, ACCESSPSWD, ENCRYPTED
FROMPSACCESSPRFL WHERE SYMBOLICID = :1
最后，你的Application Release version 和Application DB Version是否匹配，总之，升比较高的版本总是没错了！
下面附是否需要升级的对照表。你自己检查一下。
Application Release Application Database Version Requires Update to 8.44?
CIS 8.8 8.42 Yes
CRM8.8 SP1 8.43 Yes
ELS 8.81 8.43 Yes
EPM8.8 SP1 8.43 Yes
Fin/SCM8.4 SP2 8.44 No
Fin/SCM8.8 8.44 No
Financials - ESA 8.4 8.41 Yes
HRMS 8.8 SP1 8.43 Yes
Portal 8.8 8.42 Yes
Supply Chain Planning (EPM) 8.8 8.43 Yes
有问题再联系，最近比较忙。呵呵 |
|
楼主: coolflash
IP卡
狗仔卡
楼主
显身卡
发表于 2006-4-23 18:09
发表于 2006-5-13 01:50
