Hi Nicky, Responses inlined below.
Thanks, Lyle From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Nicky Madjarov Sent: Sunday, March 29, 2009 10:31 AM To: [email protected] Subject: Re: 75 Install and Database Administrator username/password ** Hi, Just a few extra questions. What's your oracle installation - remote or local? LRT: Remote Do you have other remedy instances running on same oracle? LRT: Yes Is it real server with static IP or a pc using DHCP? LRT: Real servers with static IPs (RAC) I noticed few things that rise concerns: 1. dba has created the schema manually. The installer is looking for schemata owned by ARAdmin, so, if the dba has not made proper changes, the installer will not know which shema has (or will have) the AR System objects, also, in this case ARAdmin oracle user has to be created manually and given proper credentials. It may be one of the reasons the installer is asking for system/password. LRT: There are multiple schemas on this server. The installer looks for the schema associated with the login ID specified during installation. This is ARAdmin by default, but we have specified ARAdmin7 for this schema. According to the documentation, when installing onto an Oracle database on a RAC instance, it is necessary to create the tablespaces beforehand. However, it appears that the issue so far is that it simply can't connect to the database, period. 2. the tnsnames.ora should be edited rather than created, there is one there already. LRT: We don't use tnsnames; we use LDAP, so there was no tnsnames.ora file. Check the following: the tnsnames.ora should be in ....\oracle\product\10.2.0\server\NETWORK\ADMIN\ LRT: The file is in the correct location for our Oracle install. Here is sample entry, in that case I enter XE in the installer when it asks for SID: XE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = nickym-PC)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) ) LRT: I created an entry similar to this based on the output of the tnsping command. I also created an entry in /etc/hosts for XE (a036 in our case) so that it could resolve that, and tried to use that as the server name in the installer. I also tried specifying one of the actual hosts in the RAC for the server name, and that made no difference. Basically, it seems to connect to something, but the connect descriptor it generates and tries to pass to the server process doesn't seem to be valid. 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<mailto:[email protected]> Newsgroups: public.remedy.arsystem.general To: [email protected]<mailto:[email protected]> Sent: Friday, March 27, 2009 7:30 PM Subject: Re: 75 Install and Database Administrator username/password ** I took a look at the installation log files, and it looks like it's actually not able to connect to the database to start with, so it probably thinks it needs to create a new schema, and that's why it's asking for the db administrator username/password. This is what I'm seeing in the log file: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor The Connection descriptor used by the client was A036:1601:A036 I can tnsping A036 fine. I've also created a tnsnames.ora file for it, just in case it doesn't like ldap, but based on what I see here, it kind of looks like it's not even trying to actually look up the service in ldap or tnsnames. It looks like it's just going straight to the server and port and passing it this connect string, or something like that. The connect string appears to be in this format: <server>:<port>:<db instance> Any ideas? Thanks, Lyle From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Nicky Madjarov Sent: Friday, March 27, 2009 12:20 PM To: [email protected] Subject: Re: 75 Install and Database Administrator username/password ** 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<mailto:[email protected]> Newsgroups: public.remedy.arsystem.general To: [email protected]<mailto:[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___ __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ __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"
