Re: Connect to oracle oin redhat9

From: Thana <yim_cm_at_hotmail.com>
Date: 10 Jul 2003 18:38:31 -0700
Message-ID: <cc349e63.0307101738.4d29b43a@posting.google.com>

tom.best_at_bentley.com (Tom Best) wrote in message news:<c2da7c0a.0307100501.33b660bc_at_posting.google.com>...
> When you start up RH, login as the "oracle" user. I suppose that is
> the user that oracle was installed under.
>
> Then, bring up a terminal session and type this literally, including
> the double quotes:
>
> sqlplus "/ as sysdba"
>
> You will get a prompt. Then type "startup".
>
> After a minute or 2, you should see that the database has beenm
> started up.
>
> The "shared memory" message you are seeing is just saying that the
> oracle instance is not started yet... i.e. it has not allocated it's
> memory structures.
>
> Tom Best

Hello Everybody

   Thanks for your reply.
   Mr.Brian from your question that asked me how to connect to oracle?    I connect as this statement.
   connect / as sysdba
   And for variable environment, oraenv and everthings. I followed this guide.

--> http://www.puschitz.com/InstallingOracle9i.shtml

And set viriable environment as followed

   ############################################################

# !!! Set the following environment variable only for Red Hat 9 !!! # Use the "Linuxthreads with floating stacks" implementation instead of NPTL:
export LD_ASSUME_KERNEL=2.4.1

# Oracle Environment

export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=/opt/oracle/product/9.2.0
export ORACLE_SID=test
export ORACLE_TERM=xterm

# export TNS_ADMIN= Set if sqlnet.ora, tnsnames.ora, etc. are not in $ORACLE_HOME/network/admin

export NLS_LANG=AMERICAN;
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib

export LD_LIBRARY_PATH

# Set shell search paths
export PATH=$PATH:$ORACLE_HOME/bin

And from Mr.Tom Best
I login as oracle, cause I use oracle user to run Installer. And I can connect via this statement to startup db with option(mount,nomount,normal).
And I saw How many bytes to allocated to SGA. I use ps-ef |grep oracle. I saw many oracle process eg. pmon, smon, logwriter, dbwriter,..... Then Oracle instance and processes are start. Do you have and things to recommend me ? Regards Thana Received on Thu Jul 10 2003 - 20:38:31 CDT