Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Create development database on local workstation 1

Status
Not open for further replies.

evergrean100

Technical User
Dec 1, 2006
115
US
I have an Oracle 9i local database on my local Windows XP workstation that is for local development only.
Now I am trying to create a database and using OEM Database Configuration Assistant.
I put in FirstDB for the Global Database Name and put in FirstDB for the SID.

I completed the wizard and set up my tnsnames.ora file with the SID and hostname. Then I tried to connect using OEM and it says:
ORA-12545:Connect failed because target host or object does not exist.

Should I put in localhost or 127.0.0.1 for my Global Database Name?

I assume I connect as Sys or System and the password I created after right after creating the database.
I also dont know how or where to manipulate listener or do I even have to do anything with listener?

Please advise how I can get this to work?
 
Did you check the listener is up and running (Check the services in Control panel-> Administrative options)?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top