• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1614
  • Last Modified:

Oracle patch -- p6810189_10204_Win32 fails ?

I get no errors during my Oracle patch p6810189_10204_Win32 install, but get below when trying to connect to local "HR" or "SYS" via Oracle SQL Developer.

listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor.

I tried alot of fixes, but nothing seems to work.

My only solution is to uninstall everything and reinstall Oracle 10g without installing the p6810189_10204_Win32 patch.

How can I fix so the p6810189_10204_Win32 patch install works on my WinXP Pro machine ?
0
finance_teacher
Asked:
finance_teacher
  • 2
1 Solution
 
slightwv (䄆 Netminder) Commented:
Is the instance on the database server registered with the listener?

log into the database server and from a command prompt: lsnrctl status

If you do not see your instance, log into the database and issue: alter system register;

Then recheck the listener.
0
 
finance_teacherAuthor Commented:
Ok, I will test.

Also, is there anything I need to do after running the patch to get my HR schema upgraded or should it automatically work ?
0
 
slightwv (䄆 Netminder) Commented:
I'm not familiar with that exact patch.  There should be a readme of some form that gives you step by step install process.  If a specific schema needs some task performed, it will tell you.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now