0

Hi guys, I'm a student and need to practice Oracle SQL queries since we have Advance SQL in our syllabus. I have Intel-based MacBook Pro running Mac OS X Snow Leopard 10.6.8. I just downloaded the SQLDeveloper for Mac and unzipped it. The application executed and started well. But I'm not able to create any connections. I get the following error "Status: Failure -Test Failed:IO Error: The network adapter could not establish the connection." when I key in the following parameters:

Connection name: hr
Username: hr
Password: hr

Connection type: Basic
Role: default

Hostname: localhost
Port: 1521
SID: orcl

Am I doing anything wrong? Do I need to install anything else? I'm newbie so please co-operate with me if I have ignored anything. I also Googled this error, found lot of search results but couldn't solve my problem. Any help would be highly appreciated. Thanks!

2
Contributors
7
Replies
10
Views
5 Years
Discussion Span
Last Post by debasisdas
0

No, actually I didn't find Oracle 10g Express Edition setup for Intel Mac. Some sites say Oracle 10g or 11g is not compatible with Intel Mac for now. If you know where I can find it, could you please tell me?

0

If oracle is not atll installed your application SQLDeveloper is pointing to what ?

You need to understand that you must have a database to connect. Using any tool like SQLDeveloper is always secondary.

Edited by debasisdas

0

Okay. Fine, I got it. But then where can I find Oracle database for Mac OS? Oracle site doesn't provide one. Oracle 10g links are discontinued while 11g is still not compatible with Mac OS they say. What's the use of SQLDeveloper then?

0

Okay. Fine. But could you please guide me step by step? I tried Googling a lot but all in vain. Please help me out.

0

Have you stalled Oracle Client.

Do you have oracle server database available to you, to be used by your oracle client from your system.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.