| Newbie question regarding patchset installation [message #64378] |
Thu, 20 January 2005 05:09 |
voila
Messages: 1
Registered: January 2005
|
Junior Member |
|
|
Hello, Oracle 9i on Windows 2003 (9.2.0.1.0)
I am wishing to patch to 9.2.0.4.0
I install Oracle but only choose Software Only. I then attempt to patch, as per readme but fail to connect as no database has been created. Error ORA12560 - still occurs when attempting to connect as sysdba, even though I have configured a default listener named listener.
Drop the xmlconcat function by running the following commands:
C:> sqlplus / NOLOG
SQL> connect / AS SYSDBA *****I FAIL HERE******
So, my work around involves creating a new database named test.
Now I can run the following OK
**************************************************
Drop the xmlconcat function by running the following commands:
C:> sqlplus / NOLOG
SQL> connect / AS SYSDBA
SQL> drop public synonym XMLCONCAT;
SQL> drop function XMLCONCAT;
Cleanly shut down the existing Oracle database instances with normal or immediate priority.
SQL> SHUTDOWN IMMEDIATE
Stop all listener, agent, and other processes running in or against the Oracle home in which you are installing.
Install the patch set through either an interactive or a silent installation.
****************************************
My question occurs with the post installation notes of the read me,
**********
Perform the postinstallation tasks only if you have one or more databases associated to the upgraded Oracle home.
***********
Can I now safely delete my test database, which is the only database associated with the upgraded Oracle home and continue without performing the post installation tasks?
The post installation task seem quite lengthy. I would like to keep this simple.
Alternatively, can anyone explain how I install the patchset without creating a test database?
Or kindly explain to me how I am mis-interpreting this procedure.
Kind thanks.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
