OraFAQ Forum: Client Tools

Home » Other » Client Tools » SQL Plus 8.0

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL Plus 8.0 [message #240317]

Thu, 24 May 2007 10:47

g.s1223
Messages: 17
Registered: May 2007

Junior Member

I'm a lil new to Oracle.Can someone tell me what to enter for the above fields.I have read a lot of answers and i havent got satisfactory results on this. Plz Tell what to enter for the following in SQL Plus 8.0.

Username:
Password:
Host String:

I'm also not sure if I got any request to enter host string while installing SQL Plus 8.0.I downloaded Oracle 6i and I got SQL Plus 8.0 along with the package.

Report message to a moderator

Re: SQL Plus 8.0 [message #240321 is a reply to message #240317]

Thu, 24 May 2007 10:51

sanka_yanka
Messages: 184
Registered: October 2005
Location: Kolkata

Senior Member

Hi ,

Username: is the name of the user, for example scott is schema/user in oracle 8 and you can use this schema.
Password: for the scott schema is tiger
Host String: if you using the same machine where the oracle is installed then it is not required to enter any hoststring otherwise you have to create a tns first for accessing the oracle from client pc. then default hoststring is orcl in server if you have not changed the defaut setting,.

Regards. Sanka..

Report message to a moderator

Re: SQL Plus 8.0 [message #240327 is a reply to message #240321]

Thu, 24 May 2007 11:06

g.s1223
Messages: 17
Registered: May 2007

Junior Member

Hi,

I'm using the same machine as the one in which I installed oracle.

I entered scott as username and tiger as password and orcl as host string(also tried leaving the host string blank). but i'm getting the error :

ORA 12154 : TNS could not resolve service name.

Plz Tell me how to Proceed?

Report message to a moderator