Re: Trying to use SQL*Plus for the first time.... Help Please!!

use the net8 asst. to fix your tnsnames.ora and sqlnet.ora files so that they reference the database on your home computer. Log in to server manager (svrmgrl in your $ORACLE_HOME/bin directory) using sys/change_on_install or system/manager or scott/tiger as your default user/password. That's a start. If that doesn't work, then post here again with the new error messages, Oracle version (eg. 8.1.7), and what you have done to date to fix the problem. I'd suggest also reading the concepts and net8 administrators guides to start (or at least using them as reference) at http://tahiti.oracle.com . You'll need to sign up for a technet account at the www.oracle.com site.

hth

Bricklen

Cheryl Smith wrote:
>
> Hi
>
> I have been using SQL*Plus at uni for a few weeks and have an
> assignment to do using it. I have now installed it at home and i am
> having problems logging in. When asked for my User Name, Password and
> Host String i use the same details i use at uni to connect to the
> server there. Is this the right thing to do??
>
> If so, then can anyone tell me why i always get the following error
> message after i log in...
>
> ERROR:
> ORA-12154: TNS:could not resolve service name
>
> After this message i am prompted for my User Name again and then the
> Password, i enter the same username and password as i use at uni and
> then i get this error message....
>
> ERROR:
> ORA-01034: ORACLE not available
> ORA-09243: smsget: error attaching to SGA
> OSD-04101: invalid SGA: SGA not initialized
>
> If anybody could help i would appreciate it sooo much!
>
> Thanx
>
> Cheryl
 

-- 
 -----------------------------
* http://pipers.hypermart.net *
 -----------------------------