Oracle-L: RE: 8.1.7 Instance not creating an SGADEF file

From: Nelson, Allan <anelson_at_midf.com>
Date: Tue, 18 Feb 2003 06:54:26 -0800
Message-ID: <F001.00550230.20030218065426@fatcity.com>

This file is an Oracle 7 artifact AFAIK. I have looked through our 8.1.7 instances to be sure and I don't have that file anywhere. You might want to start checking your TNS setup. Can you tnsping the instance from the client? On the server can you say sqlplus system/passwd_at_instance and connect? How about on the client? What does lsnrctl status <listener> report about your instance?

Hope this helps
Allan

-----Original Message-----
Sent: Tuesday, February 18, 2003 8:14 AM To: Multiple recipients of list ORACLE-L

I have an 8.1.7 Oracle instance on a server that does not create an SGADEF file when it is started up. There are no errors in the log or trace files. As a result of this file not being created, I cannot connect to the database from a remote client. I get an error that says the instance is not running. I can connect to the instance from SVRMGRL on while logged onto the server. Any ideas why the file would not get created?

Thanks!
Ron Smith
If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you.
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Smith, Ron L.
INET: rlsmith_at_kmg.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216]

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Nelson, Allan
INET: anelson_at_midf.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------