Home » SQL & PL/SQL » Client Tools » SQL Plus 8.0
SQL Plus 8.0 [message #240317] Thu, 24 May 2007 10:47 Go to next message
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.
icon14.gif  Re: SQL Plus 8.0 [message #240321 is a reply to message #240317] Thu, 24 May 2007 10:51 Go to previous messageGo to next message
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..
Re: SQL Plus 8.0 [message #240327 is a reply to message #240321] Thu, 24 May 2007 11:06 Go to previous messageGo to next message
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?
Re: SQL Plus 8.0 [message #240328 is a reply to message #240327] Thu, 24 May 2007 11:09 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
check your tnsnames.ora for service.
Re: SQL Plus 8.0 [message #242916 is a reply to message #240328] Tue, 05 June 2007 09:03 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Closed. Continue in your other topic.

MHE
Previous Topic: date display in report
Next Topic: insert & in table
Goto Forum:
  


Current Time: Thu Dec 08 20:10:39 CST 2016

Total time taken to generate the page: 0.14523 seconds