#Free oracle db client for mac install

Localhost is a network alias for 127.0.0.1 which is an IP address that maps to the ‘local’ machine, or the machine you are reading this blog post on. These default settings CAN work, but ONLY if you have installed Oracle Database Express Edition (XE). Basically you need to know the following: where is this database, what’s it called, and what port is the listener running on? The Default Connection properties in SQL Developer

#Free oracle db client for mac install

So you’re going to need to install Oracle and create a database, or connect to a database that is already up and running somewhere. Installing SQL Developer does not give you a database. You see this ‘Connection’ dialog, and… Where am I connecting to, and who as? You NEED a database If you’re running that copy of SQL Developer, please take a second to upgrade now, as it is WAY out of date.īut I’m here to talk to the folks that have downloaded SQL Developer and want to know what to do next. If you install Oracle database, it includes a copy of SQL Developer. You’ll need about 30 minutes to set everything up…and about 5 years to become proficient with Oracle 😉 Oracle Database come with SQL Developer but SQL Developer doesn’t include a database I’ll show you what you need to get up and going so you can finish your homework, teach yourself Oracle database, or get ready for that job interview.

If you’re here because you downloaded a copy of Oracle SQL Developer and now you need help connecting to a database, then you’re in the right place.