Re: Oracle woes

Top Page
Attachments:
Message as email
+ (text/plain)
Delete this message
Reply to this message
Author: Matt Alexander
Date:  
To: plug-discuss
Subject: Re: Oracle woes
On Sat, 28 Feb 2004, Mike wrote:

> The dbase I need to connect to is at school, so I do have to config the
> tnsname.. So I guess the answer is just the client although I would prefer to
> install everything, after all I did get it free from the OTN.


I've heard that 10g has some install problems on the non-supported Linux
distros (pretty much anything other than RH Enterprise), so you might try
going through that install guide I sent again for 9i and just blindly
following each command for now even if you don't understand the details of
what they're doing at this point.

Once you get it installed, here's the tnsnames.ora from the SCC DBA class
which you can modify as needed for your class. Following the OFA
guidelines, I have my tnsnames.ora installed here:
/u01/app/oracle/product/9.2.0.1.0/network/admin/tnsnames.ora


cis119dp =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = cisora.sc.maricopa.edu)
(Port = 1521)
)
)
(CONNECT_DATA = (SERVICE_NAME = cis119dp.cisora.sc.maricopa.edu)
(SRVR = DEDICATED))
)


Then, if this is the only database you connect to, you can make it the
default in sqlplus by adding this line to your .bash_profile:

export TWO_TASK=cis119dp

Good luck,
~M

---------------------------------------------------
PLUG-discuss mailing list -
To subscribe, unsubscribe, or to change you mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss