Skip to Main Content

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!

What determines the "Hostname" for a oracle instance?

Rodney ChanJan 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 17 2012
Added on Jan 20 2012
3 comments
2,980 views