Login as OS user which you have used to install oracle and do the following
on server.

$ sqlplus / as sysdba
SQL> startup



Regards,
Salahuddin Choudhari
Sr. Consultant
IndusInd Information Technology Ltd,
DID : +91 22 56412261
Mobile : +91 9819225292

-----Original Message-----
From: ravikiranr
[mailto:oracledba-ezmlmshield-x48656893.[Email address protected]
Sent: Friday, November 25, 2005 16:41
To: LazyDBA Discussion
Subject: problem with non-default port 1528

Hi all

I have oracle 9i on solaris 8. I have configured a listener on port 1528
(non-default), it is starting properly and configured service for tnsnames
also which is working. but while connecting to database using service name
it is giving the following error.

$ sqlplus system/[Email Address Removed]
SQL*Plus: Release 9.2.0.1.0 - Production on Fri Nov 25 16:18:11 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist Linux Error: 2: No such file
or directory

Can anyone help me out.

regards,

Ravi Kiran


-----------------------------------DISCLAIMER-------------------------------
---------------------------------

This Message and any attachments (the "message") is intended solely for the
addressees and is confidential. If you receive this message in error, please
delete it and immediately notify the sender. Any use not in accord with its
purpose, any dissemination or disclosure, either whole or partial, is
prohibited except formal approval. The internet cannot guarantee the
integrity of this message. INGVysya Bank (and its subsidiaries) shall (will)
not therefore be liable for the message if modified.


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe: see
http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree to
these terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page