local_listener="(ADDRESS = (PROTOCOL = TCP)(HOST = dbtest3)(PORT = 1523))"

Put a statement similar to the above in your init.ora file. This is required
when you use a non-standard port.


| Henry A.L. Wollman Rejoice and be glad!
|_____________________________________________________
| Moody Bible Institute, Database Administrator, [Email address protected]
| 820 N. LaSalle Blvd, Chicago, IL 60610 312-329-2291
|_____________________________________________________
-----Original Message-----
From: Salahuddin
[mailto:oracledba-ezmlmshield-x29636835.[Email address protected]
Sent: Friday, November 25, 2005 6:11 AM
To: LazyDBA Discussion
Subject: RE: problem with non-default port 1528


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



--------
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