Installing Grid control and 10G db on same machine questions
67465Apr 5 2007 — edited Apr 11 2007In prep for a migration of a prod database to 10G, I installed 10R2 on an XP pro workstation to use as a test bench. Since this same machine will likely be my new 10G management server, I decided to install Grid Control on it as well. This is a clean XP machine with no other Oracle installs.
This is the order I did things:
install 10R2 database, software only.
install Grid Control with repository db
install 10.2.0.3 patch to database home
create new database, not using templates
So far so good, no errors or issues. Except when I create a tnsnames entry and try connect via tns from local or remote (9i) machine. I can't connect at all via the listener, getting ora-12537, drop and recreate the listener, still getting TNS-12538,12560 and 00508 errors. I try using SID instead of service name, still can't connect. I can tnsping fine, local and remotely. I can connect fine by setting ORACLE_SID and bypassing listener. The listener is reporting version 9.0.1.4.1, so I create another one using the patched oracle database home\bin lsnrctl. The listener is created but wont start. I copy the tnsnames, sqlnet and listener.ora files to both oracle homes, to no avail.
Time is getting tight here as users want to test, so I uninstall the whole shebang, install db software only, patch it, create new database again and import data from prod database. I can now connect fine via tns from local and 9i client remote machines. The new server is ready so I do the same thing on it, install and patch db software only and create db and import.
So now I have my test box back and try to install grid control again. Installs with errors when the config assistants run and I can't get anything to work, so I completely blow all traces of oracle off the machine, including registry, and now I have a clean machine.
I want grid control on it, but I also want a place I can create test db's. As far as I know the GC and DB software should be able to co-exist fine, correct?
I am about to start the new install, should I do the same order as above, or try something different?