I am trying to upgrade our production OEM from 126.96.36.199 to 188.8.131.52 using the 2-system method. When I try to continue from the Database Connections Details page after specifying the connection details for the copy of the repository on the new host, this error pops up:
ERROR:ORA-00942: table or view does not exist
Unable to connect to the database and validate whether it is a supported database due to one of the following reasons:
(1) Incorrect credentials
(2) Listener may be down
(3) Database may be down.
Check the credentials, the status of the listener and the database, and retry.
This error did not occur when we used the same procedure to upgrade a test 184.108.40.206 installation. Additionally, I tried changing the connection details to connect to original production repository and got the same error. This seems to indicate that the problem is specific to this repository.
I turned on sql trace for another try and found this error in the trace file:
The following statement encountered a error during parse:
select count(1) from mgmt_targets where target_type='host' and target_name='oem12c.gfcsap.com'
Error encountered: ORA-00942
This error makes no sense to me as mgmt_targets is present in the sysman schema.
Any suggestions on how to get past this would be appreciated.
While explaining the issue to a colleague, it occurred to me that I had not considered that sys might be executing the query instead of sysman, in which case a synonym would be needed. I checked the test repository and it had a public synonym for sysman.mgmt_targets. The production repository was missing the synonym. After creating the synonym in the production repository, I got past this step.