Re: SID Blues...

Did you add the sid description to your listener.ora file on the server, then stop and restart the listener service?

• Alton

Greg wrote:

> I'm having awful trouble with 8.04.00 on the client side.
>
> I've installed a new DB (called "app2") on the NT server, running 8.04
> also. I installed the client side from the same CD on one of my 98
> machines on the same LAN as the server.
>
> I used Oracle's "database assistant" to create the DB. No problem.
>
> Now I cannot connect to this DB in any form or fashion. Even from the
> server. I'm asked by Oracle's tools the user id, password and either one
> of the following depending on which tool I'm using (I.e. : SQL Plus, Ent
> Manager etc):
> - Service
> - SID
> - Host String
> - Connect String
> - Server
>
> I've tried about everything and every combination of "app2" I can think
> of. There is no "ORACLE_SID" env var in either my NT server or my 98
> machine. I give up.
>
> What command, or tool will show me all DB's installed on that server?
> How do I display what remotes' expect for a connect string for a
> particular DB?
>
> Greg
> --
> Advertisers using spambots, please don't send to the following addresses:
> president_at_whitehouse.gov vice.president_at_whitehouse.gov first.lady_at_whitehouse.gov consumerline_at_ftc.gov crc_at_ftc.gov fraud_at_uspis.gov uce_at_ftc.gov rhunt_at_fcc.gov jquello_at_fcc.gov sness_at_fcc.gov rchong_at_fcc.gov customer_at_usps.gov admin_at_HARRIS-MARKETING.COM postmaster_at_HARRIS-MARKETING.COM jmorton_at_SAVOYNET.COM postmaster_at_agis.net abuse_at_agis.net root_at_agis.net dns-admin_at_AGIS.NET noc_at_AGIS.NET hostmaster_at_agis.net pat.connally_at_state.co.us phil_at_agis.net webmaster_at_agis.net
> postmaster_at_localhost info_at_tsf-industries.com protect_at_atg.wa.gov lemon_at_atg.wa.gov monopoly_at_atg.wa.gov utility_at_atg.wa.gov c4enviro_at_atg.wa.gov emailago_at_atg.wa.gov kea_at_cognigen.com
> document_at_agis.net ip-request_at_agis.net routing_at_agis.net news_at_agis.net accounting_at_agis.net info_at_agis.net aapp_at_agis.net hr_at_agis.net emailer_at_qlink2info.com simrem_at_answerme.com hostmaster_at_INREACH.COM ap_at_INREACH.COM postmaster_at_EMAILDIRECT.NET abuse_at_EMAILDIRECT.NET root_at_EMAILDIRECT.NET postmaster_at_e-bizness.com abuse_at_e-bizness.com root_at_e-bizness.com comics_at_IAW.ON.CA maxemail_at_UNITED-CBE.ORG domreg_at_EMAILDIRECT.NET domreg_at_HOSTING.NETCOM.COM bobgalena_at_EARTHLINK.NET
> sales_at_marketingmasters.com bizpro_at_SOFTCOM.NET domreg_at_HOSTING.NETCOM.COM aral_at_ADDITIONALBENEFITS.COM
Received on Thu May 27 1999 - 13:01:14 CDT