topic Re: Creating Host names??? in Operating System - HP-UX

Creating Host names???

Kev_8 — Wed, 22 Oct 2003 07:47:07 GMT

Could someone please tell me How do i create a host name so that i can run SQL*PLUS on my PC (locally)? I am using Oracle client version???

Thanx

Re: Creating Host names???

Graham Cameron_1 — Wed, 22 Oct 2003 07:54:25 GMT

Not sure what you want to do.

Without a database somewhere, SQLPLUS won't do very much at all.

You can start it up connectionless with "sqlplus /nolog", and then use "connect" to connect to a database.

Do you have a database on your PC, or on a server?
If not, you need one.
-- Graham

Re: Creating Host names???

Michael Schulte zur Sur — Wed, 22 Oct 2003 10:51:30 GMT

Hi,

you need to give sqlplus a hostname, so it knows, which host to contact for a connect to a database. This host must be configured for example by netmgr or metasst. Then you can try tnsping to check the communication and sqlplus user@host for connect.

Does that give you an idea?

Michael

Re: Creating Host names???

Yogeeraj_1 — Wed, 22 Oct 2003 13:06:11 GMT

hi,
Do you mean a tnsname entry? so that you can connect to a database?
-
please clarify.
-
thanks
Yogeeraj

Re: Creating Host names???

R. Allan Hicks — Thu, 23 Oct 2003 12:39:10 GMT

I assume from your other question about using oracle locally that you want to name and/or determine the hostname for your pc.

Assuming that you are running windows 2000....

Right click my computer.
Select properties
Select Network Identification

Leave the host string blank and sqlplus will connect if you are in the correct oracle home.

If should default to the local machine and go through the bequeth adapter (I know bequeth still works on HPUX).

If you insist on connecting through oracle*Net, don't forget to start the listener from your control panel>administrative tools>services