Re: using sqlplus nolog

No Spam wrote:

> Hi
>
> On installing oracle 9i standard edition on redhat linux 9, it installed the
> dbca, the database, and the client.
>
> My problem is I do not have an internet connection, and I mainly would like
> to use sqlplus to learn sql. My main username to logon on to oracle is the
> user name for oracle which I use to logon to linux for oracle purposes the
> name I use is oracle but it keeps saying no such realm in shared segment. I
> am only able to use sql with the command
> sqlplus /nolog I assume this creates a relational database with no file
> saved?
>
> I have a password for SYS
> and a password for SYSTEM
> and a global variable name
>
> ..._at_domain
>
>
> and a SID: ...
>
> I apologise if this seems a very silly but what do I put down for username
> at the username prompt when I type in sqlplus. I normally use the main user
> which is oracle, but I get the no realm segment error as mentioned earlier.
>
> I also do not have an internet connection with this comp so I am unable to
> get a network service, I am told I could use something called a loop back
> adapter with a physical address of 127.0.0.1 which would make the comp think
> I am connected to the internet so I could have the client and server at the
> same comp, I have been unable to find such software, would you know how I
> could do this?

 From what I can glean from your email you may or may not have a database but you most likely did not read and follow the installation instructions. It is almost impossible to help you since you didn't post the actual error message but my guess is one of the following that you didn't:

1. set the kernel parameters
2. set ORACLE_SID
3. set ORACLE_HOME
4. start the listener and database

Start with ps -ef | grep ora

and see if anything Oracle is actually running. Then report back with actual error messages.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)