Hi, If you can tnsping your instance you may be in good shape. Since ARAdmin has been (historically) the only dbo for ARSystem, I'd consider using different db user name for the 7.5. When you dba created a new schema did he/she changed the ownership to ARAdmin? I'd totally let the installer create schema and user, and then, if your dba is not happy, he/she can make changes. Regards,
Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com ----- Original Message ----- From: Lyle Taylor Newsgroups: public.remedy.arsystem.general To: [email protected] Sent: Friday, March 27, 2009 1:21 PM Subject: 75 Install and Database Administrator username/password ** Hi again all, My experience with past installers was that if you were creating a new schema (for Oracle at least) from within the installer, it would prompt your for the database administrator username and password, but if you already had a schema, it would instead ask you if you want to overwrite, upgrade or share the database. For 7.5, our DBA has created a new schema for us to install into, and in the 7.5 installer, I have entered the server, port and schema login information and then moved forward. A couple screens later, it then asks me for the database administrator username and password. Does the 7.5 installer _always_ ask for this, or does this mean that it may not be able to connect to the database using the information previously provided, causing it to think that we're creating a fresh new schema? Note that one thing we did not do was create a tnsnames entry for the database, as we are using LDAP. We did, however, create a DNS alias in /etc/hosts that cause our database name to resolve to the first host in our RAC. Is a TNSNAMES entry absolutely essential? Let me know if you need any further information. Thanks, Lyle NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
