12cR1 Upgrade : Upgrade of 11.2.0.4 Database to 12.1.0.2 fails with ERRORS PLS-00103: Encountered the symbol “/” & [ORA-00936: missing expression] (Doc ID 1964334.1)

Last updated on MARCH 23, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

Upgrade from 11gR2 to 12c,fails while running prvtjob.plb Script with the below Error -

Session altered.

Elapsed: 00:00:00.00
21:02:06 SQL>     declare
21:02:06   2        cnt number := 0;
21:02:06   3      begin
21:02:06   4        select count(*) into cnt
21:02:06   5        from obj$ o, seq$ s
21:02:06   6        where o.obj# = s.obj# and o.name = ‘JOBSEQLSBY’;
21:02:06   7
21:02:06   8        if cnt = 0 then
21:02:06   9
21:02:06  10          execute immediate ‘create sequence jobseqlsby ‘ ||
21:02:06  11            ‘start with 1000000000 increment by 1 ‘ ||
21:02:06  12            ‘minvalue 1000000000 maxvalue 1999999999 ‘ ||
21:02:06  13            ‘cache 20 noorder cycle’;
21:02:06  14        end if;
21:02:06  15      end;
21:02:06  16      /
21:02:06  17  CREATE OR REPLACE PACKAGE BODY dbms_job wrapped
21:02:06  18  a000000
21:02:06  19  1
21:02:06  20  abcd
21:02:06  21  abcd
21:02:06  22  abcd
21:02:06  23  abcd
21:02:06  24  abcd
21:02:06  25  abcd
21:02:06  26  abcd
21:02:06  27  abcd
21:02:06  28  abcd
21:02:06  29  abcd
21:02:06  30  abcd
21:02:06  31  abcd
21:02:06  32  abcd
21:02:06  33  abcd
21:02:06  34  abcd
21:02:06  35  b
21:02:06  36  2128 9ff
21:02:06  37  EQrfIbS1PWeU3Owg539S/p6uProwg5WTkyBo3y+59uTVtLyKnswfYbdh3jzfDtbV1afbsmyt
21:02:06  38  GUmo3mgHPKGpV/ujyiS8ahOJFjvPoEzOUBhqWO5HeJyg8PFtFmoWGynL7ar+7mH4huvaibFb
21:02:06  39  W+OqI7VoZLry025hjoxtbepTRXFR6hRgQgIGNBh94tkKORd1UXBieEtizCtg4ztQLolwoFnm
21:02:06  40  vv1NFLXuD4AJbmMMzukaeSPxXw68dj45YT6rGwzkBIt58N4HZGFG31p2OSK4HDNSbAKSomqu
21:02:06  41  vgxRUXD4dUCc8y7/7yN2fArh/W5DlJpu1AFVQ8qRAfRMFf5pfI8YBsVM9ukSJBNh8uxuw91T
21:02:06  42  1nlk85UuDK+SRo5X5Ro0Vs3f6YmBEJub0rjNTQt02SnWDXztXSa7jLuus2sJLqGH+LMG+LCN
21:02:06  43  GV1cg2PMHS+Ph0VfU/pfvhqR3BXQZiKhDEONEmbWLaBi2VUURKUvUa2/x50V6vBUj6qHQVHl
21:02:06  44  Yp4NSH6VOC01YLurXBru202txo1Eyx7x3stWvpoesZUYflI9r9fsVOU+fz9vA50RqAXjPDD6
21:02:06  45  kQcRUhIQx3MFH/X4/s34xA/i7tQ2GEPBBXiv1eX7GtflZpEKc5Td/D/LmdL4wa4sUPhkICBv
21:02:06  46  a8zYGOzk0wW++8oyjY9igMb9S2ZmcAyj/mLly8QK2lk+a9WrQyrJmv1xGLrZLNBPANqSlMvO
21:02:06  47  aqyQZ9qe4u6n1V6itN24PjlGBtGo6borJamAazfcfBKxUhH72VXU9ycL4Q/uGnlGajOzSLi3
21:02:06  48  br+JNCYQXRjyTSWvKbp6etSKADOoYN+UNmjKpdiO5u9XQI9/G61/YO1PCk8sLDNMntNHkPm/
21:02:06  49  WJOgOSfpaq5e3N0vSg7Qy97IRAN6gbQ+YH4ha1dNl8vYgR1NZqoB3ypfW3rZl2mvGW6A8JDD
21:02:06  50  zI/XGhK2Jk/d1wcDwhOWYvDJyOkYt2as7y2nkWm8ULOrYujTUAZVwa6qh6p3Qy9hIaCV+J8Q
21:02:06  51  NPkeDMYljOL7pnifOo42m+/HORGJaspMZZY2eoHnKNEVKe35ildbhChEfJKWL377zt2aQEMy
21:02:06  52  /ZxCauP1Hxv9LTFMBAe8GejhcODW+oB+HZh1yjxEle5KyviAebOm47wZaFboRvdKgKl6iaJN
21:02:06  53  g7z0nlQlLaO5U7JA86bEAjgBDstqd0ZNfCkJyEBoeitgKIH05jsT0greXvZoSzQleefNGm2n
21:02:06  54  ccRpuD2yCgVNe+IqQTJx2n5DtUyxJ17ZtPmqTKQcXyBPVEKbXb2l2BNN8kuWe6DIasjrrJoE
21:02:06  55  qOxQouDiaFx5Kdf4RBNcyGFqm1hNNLq1zcDBnzF8tMhhJ3ppi2paq0kaaKz6g2VvBgme8qPP
21:02:06  56  0D/LcVSZfrv8jak+TlyUlEw1wkWhhlXF9u/sn/qt3NE8ydaOGpeUgL+rv4obXVVXlpvJSYVC
21:02:06  57  8V3bST+D4Z1X5vORAENNY5+9E4kva9SAflmp86+hZE4jMQ8/nsyEe0gda64OOSFxd2D6A+tY
21:02:06  58  o3sYQXrsQdjBKyPFnzdZFJ/efPJlxe4s7ahdZ7KRa3A7ZhM7wwSTe6EwN/2BfN7JtlzA9SQU
21:02:06  59  /EsKbTdGZ0vW5z8MUMe0alEN7I7gWGRPbmeuob8XF/IBAtKC9fUwMDAXhCIkIjOT8IDWjAsV
21:02:06  60  u4hevfFeoKnnhbaFo0caL+eZsBpOzj9CJ7RLdL1gCgu9EqaUGQx6w1C5582GGJuo1S/BH563
21:02:06  61  QBW5fE2VFPYelVqhZU2UOgmNlqYmzv3YgGOXUZR5pu8vPAw+hxEDJcrNf2kooKIbwy0bnPh5
21:02:06  62  byDCJZ/ZOehKw8hACc9DM2lbPGqoy3SlUUXPnjvYh3JahC9bt99kU3CV8SDhAtK3qK5OolKh
21:02:06  63  0X+Dmnpr9EkJesqYYteW9q+RUHTnfzwGdSLImeV0JBqcTrESIbyvXrvG9ID8+HdAiGychLdc
21:02:06  64  VTrpsc77BlRZSPnG8mi9R1tf4/1cNkZJC1fHMyKf7AmbinL4ANT4QT/evBhpws0BffvqCucu
21:02:06  65  x5RG7ApWHFpcKG2+4529yKvjADPbUk8WgmwMfKQ2D3IIGN0/niSItzm2/iTiSYW0wTWhAY43
21:02:06  66  Ec58aKsflJG5Qqcmqcl/2PJyaFpBQuTdsZ5SotDhI3emxQJVmpDv3mkoa2+Rw3iqHywTzdzE
21:02:06  67  ydsj2O7Xq+vdSj6+3T1qBrSlS+TkDimbODWo0vfJLw+LYDl51SGCO1V5Z5Gkjb39eb0AxCYN
21:02:06  68  4l+0giezwVQem/dgmvHPpJPQ33eifYy2k1VhKWhrSIOSv0/Vu1c+noJtsPfQIZ65WDaziasG
21:02:06  69  3rcCIGGFfq/B6gwkxilKWIIxkR501HMKEicsqzn4EKIMEyY4xAiGbSbVMrETzohoK8+LpjNm
21:02:06  70  wyufiefYgFhFIFLUoQqASFy0nrq6Jm1c9PTEcgzShSBPsL9L6zoZ6oxYltj3gdSD6LYUkC8O
21:02:06  71  FjENt9uB1e5X8tFlnrxZ2kiNRRlO8gV6McHKn23xG9YBOkEjPirDcWwCIxMAiXJ6lXfkuSxi
21:02:06  72  mnAv
21:02:06  73
21:02:06  74  /
/
*
ERROR at line 16:
ORA-06550: line 16, column 3:
PLS-00103: Encountered the symbol “/”

 

Also,during catuppst following errors are seen -

catuppst.sql unable to run in Database: hdmo91 Id: 0
ERRORS FOUND: during upgrade CATCTL ERROR COUNT=7
——————————————————
Identifier CATPROC 14-11-02 01:58:45 Script = /u00/app/oracle/product/12.1.0.2/dbhome_
ERROR = [ORA-00936: missing expression]
STATEMENT = [create or replace view “_ALL_REPCOLUMN_GROUP”
(sname, oname, group_name, group_comment) as
select /*+ ALL_ROWS */ distinct cg.sname, cg.oname, cg.group_name,
cg.group_comment
from all_repcolumn_group cg, “_ALL_REPGROUPED_COLUMN” rcgcol
where cg.group_name = rcgcol.group_name
and cg.sname = rcgcol.sname

If the utlrp Script is run,then only the following INVALID SYS Objects remain-

OWNER                OBJECT_NAME          OBJECT_TYPE
——————– ——————– ———————–
SYS                  PRVTPARENTCHILD      PACKAGE
SYS                  DBMS_FEATURE_ZMAP    PROCEDURE

Post Upgrade Output in the catupgrd0.log,shows as below -

Oracle Database 12.1 Post-Upgrade Status Tool 11-02-2014 14:07:13

Component Current Version  Elapsed Time
Name Status Number HH:MM:SS

Oracle Server
ORA-00936: missing expression
ORA-06550: line 16, column 3: PLS-00103: Encountered the symbol “/”

PLS-00103: Encountered the symbol “/”
ORA-06550: line 5, column 5: PLS-00103: Encountered the symbol “/”

PLS-00103: Encountered the symbol “/”
SP2-0556: Invalid file name.
Oracle Server INVALID      12.1.0.2.0  00:10:17
Oracle XML Database
ORA-06575: Package or function PRVTPARENTCHILD is in an invalid state
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist ORA-06512: at “SYS.CDBVIEW”, line 49

ORA-06512: at line 1

ORA-06512: at “SYS.CDBVIEW”, line 49 ORA-06512: at line 1

ORA-06512: at line 1
ORA-00942: table or view does not exist
ORA-06575: Package or function PRVTPARENTCHILD is in an invalid state
ORA-00942: table or view does not exist
ORA-01775: looping chain of synonyms
ORA-00942: table or view does not exist
Oracle XML Database  VALID      12.1.0.2.0  00:00:41
Final Actions 00:02:31

Total Upgrade Time: 00:13:31

PL/SQL procedure successfully completed.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms