Re: Logging into SQL*Plus (Oracle 8i)

On Mon, 04 Jul 2005 14:06:07 -0700, Water Cooler v2 interested us by writing:

> I just installed Oracle 8i and am having a tough time just logging into
> SQL*Plus. I've given scott for the User Name and tiger for the
> Password. But heck, what do I give in as the host string?

Did you record any of the values you entered during install, or did you just point-click-and-ignore?

If the former, you may want to look up the Oracle Service information you entered.

If the later, you may be able to retrieve it from the client-to-instance connectivity descriptor/index (left side of = sign) shown in

	$ORACLE_HOME/network/admin/tnsnames.ora (*nix)or
	%ORACLE_HOME%\network/admin/tnsnames.ora (windows)

Often the default database/instance name is 'orcl' and the connection would be

sqlplus scott/tiger_at_orcl OR
sqlplus scott/tiger_at_orcl.mydomain.com

In anticipation of the next set of questions - http://docs.oracle.com and 'Effective Oracle by Design' by Tom Kyte.

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***