| How to check the patch installation in Oracle Server [message #52339] |
Tue, 16 July 2002 10:31  |
Muthu
Messages: 58
Registered: August 2000
|
Member |
|
|
I installed Oracle 8.1.7.1 path for my Oracle 8.1.7.0 database server. All i did is copying some files and put in the respective directory. Is that the patch installation???? did i do it correct ???
How and where do i check for the correctness of patch installation.. because even now now sqlplus logs in as 8.1.7.0 can't see the patch version installed in my server????
|
|
|
|
| Re: How to check the patch installation in Oracle Server [message #52344 is a reply to message #52339] |
Tue, 16 July 2002 22:04  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
Start your Oracle Installer and check the installed products. Each product will have the current version number.
Usually, the patches are comming with Installation Notes, and include:
- shutdown the database;
- running the Oracle Installer to install and link new binaries;
- running catalog.sql and catpeoc.sql;
- running JAVA scripts if you have any;
- running utlrpl.sql.
Sounds like you miss all the steps here !!!
Hope that helps,
clio_usa
OCP DBA
Visit our Web Site
|
|
|
|
|
|
| Re: How to check the patch installation in Oracle Server [message #52376 is a reply to message #52339] |
Thu, 18 July 2002 05:48 |
Sanjay
Messages: 236
Registered: July 2000
|
Senior Member |
|
|
Just putting the files in the respective directory DOES NOT install the patch. You have to do the complete install, like the one you did for the base product (8.1.7).
To find the level of current oracle, query the following at the SQL prompt (login as system or sys)
SQL> select version from v$instance;
VERSION
-----------------
8.1.6.2.0
Good luck.
|
|
|
|
| Re: How to check the patch installation in Oracle Server [message #52383 is a reply to message #52376] |
Thu, 18 July 2002 08:32 |
Muthu
Messages: 58
Registered: August 2000
|
Member |
|
|
Hi. I did installed the patch and ran catalog.sql, catproc.sql, catexp.sql, utlrp.sql files. But when i tried to check the version with the select statement what you gave, i get these errors..please help
SQL*Plus: Release 8.1.7.0.0 - Production on Thu Jul 18 12:13:42 2002
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Error accessing package DBMS_APPLICATION_INFO
ERROR:
ORA-06509: PL/SQL: ICD vector missing for this package
ORA-06512: at "SYSTEM.DBMS_APPLICATION_INFO", line 37
ORA-06512: at line 1
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
SQL> select version from v$instance;
select version from v$instance
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL>
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
