Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 1 down vote favorite

I have the following oracle homes installed on my Windows machine

  • Oracle Developer Suite
  • Oracle Discoverer
  • Oracle 10G Client.

I installed Oracle 10G database manually by following the following steps

  • Created the necessary directories
  • Setup pfile
  • Created a new database (using the "create database" command)
  • Setup listener

I am now running the admin scripts (catalog, standard, catproc etc).

The problem i have is i can connect to the database using sqlplus / as sysdba but i cant startup the listener. The problem i think is that the registry is showing that the Oracle 10G database is not the default home for Oracle. The registry is showing that Discoverer is the default home.

How do i change the registry so that the 10G database is the default home? Presumabely these are set if you install using dbca or some other automated process?

The environment variables are already set to point to the 10G database. When installing manually how do i setup the registry to updated the oracle homes.

share|improve this question
What behavior/error do you get when you try to start the listener? – Leigh Riffel May 23 '11 at 13:57

migrated from stackoverflow.com May 23 '11 at 12:59

1 Answer

up vote 1 down vote

Have you set up listener.ora?

please provide the output of the following commands:

  • lsnrctl status
  • lsnrctl services
  • lsnrctl start
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.