SEO

When I installed oracle 9.2i on redhat linux 9 I created usergroups for user
oracle as stated in the manuals
# groupadd dba
# useradd oracle
# mkdir /opt/oracle
# mkdir /opt/oracle/product/9.2.0/
# chown -R oracle:dba /opt/oracle

Now whatever I type at the sqlplus I get shared realm does not exist
even logging in as sysdba
sqlplus /nolog
connect as sysdba

I get connected to an idle instance

trying sqlplus oracle/oraclepassword@thenameofmydatabase I created with dbca
gets me the shared realm does not exist
I am at loggerheads what could be wrong, everything seemed to have installed
ok

No Spam wrote:
>
> When I installed oracle 9.2i on redhat linux 9 I created usergroups for user
> oracle as stated in the manuals
> # groupadd dba
> # useradd oracle
> # mkdir /opt/oracle
> # mkdir /opt/oracle/product/9.2.0/
> # chown -R oracle:dba /opt/oracle
>
> Now whatever I type at the sqlplus I get shared realm does not exist
> even logging in as sysdba
> sqlplus /nolog
> connect as sysdba
>
> I get connected to an idle instance
>
> trying sqlplus oracle/oraclepassword@thenameofmydatabase I created with dbca
> gets me the shared realm does not exist
> I am at loggerheads what could be wrong, everything seemed to have installed
> ok

You have read the Dizwell document (you referenced that in an earlier
post).

What are the current shared segment and semaphore settings? (as
discussed in the document as well as the pre-install steps of the
installation manual)

Hans Forbrich wrote:
>
> No Spam wrote:
> >
> > When I installed oracle 9.2i on redhat linux 9 I created usergroups for user
> > oracle as stated in the manuals
> > # groupadd dba
> > # useradd oracle
> > # mkdir /opt/oracle
> > # mkdir /opt/oracle/product/9.2.0/
> > # chown -R oracle:dba /opt/oracle
> >
> > Now whatever I type at the sqlplus I get shared realm does not exist
> > even logging in as sysdba
> > sqlplus /nolog
> > connect as sysdba
> >
> > I get connected to an idle instance
> >
> > trying sqlplus oracle/oraclepassword@thenameofmydatabase I created with dbca
> > gets me the shared realm does not exist
> > I am at loggerheads what could be wrong, everything seemed to have installed
> > ok
>
> You have read the Dizwell document (you referenced that in an earlier
> post).
>
> What are the current shared segment and semaphore settings? (as
> discussed in the document as well as the pre-install steps of the
> installation manual)

And how does your "@thenameofmydatabase" relate to any database instance
on your system?

Here is my sqlnet.ora, tnsnames.ora and listerner.ora file in the
/network/admin directory

# LISTENER.ORA Network Configuration File:
/opt/oracle/product/9.2.0/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.akan.com)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL DBNAME = test.akan.com)
(SID_NAME = test)
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/oracle/product/9.2.0)

(PROGRAM = extproc)

)
)

# SQLNET.ORA Network Configuration File:
/opt/oracle/product/9.2.0/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DEFAULT DOMAIN = akan.com

NAMES.DIRECTORY_PATH= (TNSNAMES)

# TNSNAMES.ORA Network Configuration File:
/opt/oracle/product/9.2.0/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

AKAN.LOCALDOMAIN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = akan.com)
)
)




"No Spam" <nospam@home.com> wrote in message
news:kmVMb.3361$1q3.224@news-binary.blueyonder.co.uk...
> When I installed oracle 9.2i on redhat linux 9 I created usergroups for
user
> oracle as stated in the manuals
> # groupadd dba
> # useradd oracle
> # mkdir /opt/oracle
> # mkdir /opt/oracle/product/9.2.0/
> # chown -R oracle:dba /opt/oracle
>
> Now whatever I type at the sqlplus I get shared realm does not exist
> even logging in as sysdba
> sqlplus /nolog
> connect as sysdba
>
> I get connected to an idle instance
>
> trying sqlplus oracle/oraclepassword@thenameofmydatabase I created with
dbca
> gets me the shared realm does not exist
> I am at loggerheads what could be wrong, everything seemed to have install
ed
> ok
>
>

I have already downgraded the glib, increased memory segment, and amended
the .bashrc file along the lines of the dizwell document, like I said
everything installed, I had already read a similar document from
pushcitz.org that looked like it was a straight rip from the dizwell
document, like I said everything installed, I have posted my listener.ora,
tnsnames.ora, and sqlnet.ora above to look at

"Hans Forbrich" <hforbric@yahoo.net> wrote in message
news:40042DFE.A840467F@yahoo.net...
> No Spam wrote:
> >
> > When I installed oracle 9.2i on redhat linux 9 I created usergroups for
user
> > oracle as stated in the manuals
> > # groupadd dba
> > # useradd oracle
> > # mkdir /opt/oracle
> > # mkdir /opt/oracle/product/9.2.0/
> > # chown -R oracle:dba /opt/oracle
> >
> > Now whatever I type at the sqlplus I get shared realm does not exist
> > even logging in as sysdba
> > sqlplus /nolog
> > connect as sysdba
> >
> > I get connected to an idle instance
> >
> > trying sqlplus oracle/oraclepassword@thenameofmydatabase I created with
dbca
> > gets me the shared realm does not exist
> > I am at loggerheads what could be wrong, everything seemed to have
installed
> > ok
>
> You have read the Dizwell document (you referenced that in an earlier
> post).
>
> What are the current shared segment and semaphore settings? (as
> discussed in the document as well as the pre-install steps of the
> installation manual)

No Spam wrote:
>
> I have already downgraded the glib, increased memory segment, and amended
> the .bashrc file along the lines of the dizwell document, like I said
> everything installed, I had already read a similar document from
> pushcitz.org that looked like it was a straight rip from the dizwell
> document, like I said everything installed, I have posted my listener.ora,
> tnsnames.ora, and sqlnet.ora above to look at
>

"Shared Realm does not exist" means "No shared memory has been set up
for the instance". The rest of your stuff is useless if you don't have
an instance (of that name) available.

Suggest you erase everything related to Oracle on your system and start
from scratch. You've missed a step - the one about shmmax and sem.

OR ... If you didn't miss it, you are trying to put too many instances
(or other things that use shared memory) on your machine and you need to
read the INSTALL Guide to learn the calculations for these kernel parms.

Finally, a client (such as SQL Plus, ODBC, etc) uses TNSNAMES.ora and
does not need or care about LISTENER.ora

No Spam wrote:

> I have already downgraded the glib, increased memory segment, and amended
> the .bashrc file along the lines of the dizwell document, like I said
> everything installed, I had already read a similar document from
> pushcitz.org that looked like it was a straight rip from the dizwell
> document, like I said everything installed, I have posted my listener.ora,
> tnsnames.ora, and sqlnet.ora above to look at
>
<snip>

Are your environment variables set correctly? type env and check that
the ORACLE_SID etc are set (as the oracle user)

Hans Forbrich wrote:
>
> No Spam wrote:
> >
> > I have already downgraded the glib, increased memory segment, and amended
> > the .bashrc file along the lines of the dizwell document, like I said
> > everything installed, I had already read a similar document from
> > pushcitz.org that looked like it was a straight rip from the dizwell
> > document, like I said everything installed, I have posted my listener.ora,
> > tnsnames.ora, and sqlnet.ora above to look at
> >
>
> "Shared Realm does not exist" means "No shared memory has been set up
> for the instance". The rest of your stuff is useless if you don't have
> an instance (of that name) available.
>

BTW - "an instance (of that name)" also implies you have the environment
variable set up vorrectly for the user trying ot run the client. (for
example - $ORACLE_HOME.) There is a great list in the Dizwell doc, but
since you read it you already know that.

> Suggest you erase everything related to Oracle on your system and start
> from scratch. You've missed a step - the one about shmmax and sem.
>
> OR ... If you didn't miss it, you are trying to put too many instances
> (or other things that use shared memory) on your machine and you need to
> read the INSTALL Guide to learn the calculations for these kernel parms.
>
> Finally, a client (such as SQL Plus, ODBC, etc) uses TNSNAMES.ora and
> does not need or care about LISTENER.ora

No Spam wrote:
> When I installed oracle 9.2i on redhat linux 9 I created usergroups for user
> oracle as stated in the manuals
> # groupadd dba
> # useradd oracle
> # mkdir /opt/oracle
> # mkdir /opt/oracle/product/9.2.0/
> # chown -R oracle:dba /opt/oracle
>
> Now whatever I type at the sqlplus I get shared realm does not exist
> even logging in as sysdba
> sqlplus /nolog
> connect as sysdba
>
> I get connected to an idle instance
>

Are you sure, that your instance is actually started? Just
type startup when connected as sysdba and see if it gives
you any error messages.

HTH

Holger

"No Spam" <nospam@home.com> wrote in message news:<VHZMb.15$YU5.2@news-binary.blueyonder.co.uk>...
SNIP...
> everything installed, I had already read a similar document from
> pushcitz.org that looked like it was a straight rip from the dizwell
> document, like I said everything installed, I have posted my listener.ora,

In all fairness to the author of Dizwell, puschitz has had the paper
out there for well over a year, if not two.

Try

env | grep ORACLE

....making sure you have ORACLE_SID and ORACLE_HOME set.

Regards,

Steve