Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

What determines the "Hostname" for a oracle instance?

612702Jan 20 2012 — edited Jan 20 2012

I recently installed Oracle 11g on my desktop to play with and wanted to connect using SQL developer

Installing Oracle 11g i basically left everything default while installing.

I enabled the scott/tiger account

In SQL Developer i input the following

Connection name: Test
Username: scott
Password: tiger

Oracle connection type: Basic
Role: default
Hostname: 192.168.X.XXX
Port: 1523
SID: orcl

The port i can some what understand that during installation it will find a default/open port for me to connect through. What i dont understand is the "Hostname".

What determines the "Hostname"?

Can i change this to for example "localhost"?

I know when i installed the express edition of Oracle i was able to leave the hostname as "localhost"

Just wondering why I cant do the same for the Oracle 11g installation? As I installed both SQL developer and the Oracle 11g on my desktop and i would have thought i could have just used "local host" as host name?

Thanks

Edited by: rodneyc8063 on Jan 19, 2012 10:00 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 17 2012

Added on Jan 20 2012

#11g, #developer, #general-database-discussions, #installation, #sql, #time

3 comments

2,806 views