oracle92 sql*plus 连不上oracle7.3,怎么办？？

blue_prince10

Connect as user system, drop the PRODUCT_PRIVS view and rerun the   PUPBLD.SQL script.

fansll

运行sqlplus 后出现一个win窗口。

jlandzpa

oracle92 sql*plus 是可以连上oracle7.3的.

fansll

SQL> drop view PRODUCT_PRIVS ;
View dropped.
SQL>
SQL> host find /oracle/oracle -name pupbld.sql -ls
    1136    4 -rw-r--r--  1 oracle   dba          3989 Nov 18  1997 /oracle/oracle/app/oracle/product/7.3.4/sqlplus/admin/pupbld.sql
SQL> SQL> @ /oracle/oracle/app/oracle/product/7.3.4/sqlplus/admin/pupbld.sql
Synonym dropped.
  date_value from product_user_profile
                 *
ERROR at line 3:
ORA-00942: table or view does not exist
drop table product_user_profile
           *
ERROR at line 1:
ORA-00942: table or view does not exist
alter table product_profile add (long_value long)
                                 *
ERROR at line 1:
ORA-01430: column being added already exists in table
create table product_profile
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object
View created.
Grant succeeded.
create public synonym product_profile for system.product_privs
                     *
ERROR at line 1:
ORA-00955: name is already used by an existing object
Synonym created.
create public synonym product_user_profile for system.product_privs
                      *
ERROR at line 1:
ORA-00955: name is already used by an existing object
create table user_profile
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object
Grant succeeded.
create view user_privs as
            *
ERROR at line 1:
ORA-00955: name is already used by an existing object
Grant succeeded.
create public synonym user_profile for system.user_privs
                     *
ERROR at line 1:
ORA-00955: name is already used by an existing object
0 rows updated.
然后用sqlplus 92l连接：报错多了一行（SP2-0642: SQL*Plus internal error state 2091, context 0:0:0   Unsafe to proceed）

>sqlplus scott/tiger@ora9
SQL*Plus: Release 9.2.0.1.0 - Production on Fri Dec 24 17:52:03 2004
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
SP2-0642: SQL*Plus internal error state 2091, context 0:0:0
Unsafe to proceed
Error accessing PRODUCT_USER_PROFILE
Warning:  Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM

blue_prince10

是不是以system用户连进去执行的?
select owner from dba_objects where lower(object_name)='product_user_profile';

fansll

SQL> select owner from dba_objects where lower(object_name)='product_user_profile';

OWNER
------------------------------
PUBLIC
SYSTEM

Bigtree

最初由 jlandzpa 发布
[B]oracle92 sql*plus 是可以连上oracle7.3的. [/B]

Oracle92的版本不是已经不能够连接到Oracle 7.3的版本了吗？我有看到Metalink上说Oracle92已经不再支持连接到Oracle 7.3的版本了。

fansll

哎，看来我只好用golden管理oracle734 server了，谢谢各位了！！

fansll

从9201 patch 到9204报很多错，最后服务启不来，运行sqlplus也报错，干脆在这个烂摊子上打9206的patch,成功了！！！oracleservice和sqlplus都可以运行，但是sqlplus9206l和第三方工具连oracle734都
不行，都是报ora-24439的错！！！例如：
SQL> conn scott/tiger@ora7
ERROR:
ORA-24439: Connections to Oracle7 server are no longer supported
Warning: You are no longer connected to ORACLE.

致此，终于知道sqlplus92不能连oracle7 server了。
metalink上说9.0.1可以连接oracle 734 server的
Server Version
Client Version 10.1.0 9.2.0 9.0.1 8.1.7 8.1.6 8.1.5 8.0.6 8.0.5 7.3.4
10.1.0(#4) Yes Yes Was Yes #2 No #3 No #3 No #3 No #3 No #3
9.2.0 Yes Yes Was Yes No No Was No No #1
9.0.1 Was Was Was Was Was No Was No Was
8.1.7 Yes Yes Was Yes Was Was Was Was Was
8.1.6 No No Was Was Was Was Was Was Was
8.1.5 No No No Was Was Was Was Was Was
8.0.6 No Was Was Was Was Was Was Was Was
8.0.5 No No No Was Was Was Was Was Was
7.3.4 No Was Was Was Was Was Was Was Was

哎，看样子，还要装ora817 client