Re: ARS 7 + Oracle 10gR2 = Can Not Install ARS

[Grooms, Frederick W]

Title: RE: ARS 7 + Oracle 10gR2 = Can Not Install ARS

**

Your error in the SQLNET.LOG is stating No Listener.  Are you installing this as a remote or local Oracle database?  What does the output of tnsping state?

 

Fred

---

From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen
Sent: Tuesday, August 29, 2006 6:56 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARS 7 + Oracle 10gR2 = Can Not Install ARS

**

 

I added the ORACLE_BASE environment variable and ARS 7 still will not install. I then tried uninstalling ARS 7 and Oracle several times but same error.

 

Because there is no Demo user (no users at all) in the ARS 7 system the installation program will not allow upgrading, only overwrite.  The installer first drops the ARSystem database and the ARAdmin user.  The ARAdmin Oracle user is created without DBA access.   So, I tried this: when the ARAdmin user is created in Oracle there is a two-minute period before the forms are imported and the Demo user is created.  At that instant I granted the ARAdmin Oracle user DBA access, thinking that the ARAdmin user may not be getting the access it needs... but ARS 7 still won't install.

 

Stephen

---

From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3
Sent: Monday, August 28, 2006 4:06 PM
To: arslist@ARSLIST.ORG
Subject: Re: ARS 7 + Oracle 10gR2 = Can Not Install ARS

**

Stephen:

ORACLE_BASE also should be set if you are working with the 10g clients.

James McKenzie
 

-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Heider, Stephen
Sent: Monday, August 28, 2006 11:12 AM
To: arslist@ARSLIST.ORG
Subject: FW: ARS 7 + Oracle 10gR2 = Can Not Install ARS

Sorry, had to fix a typo.  It's the type when you don't include the word "not" it changes the entire meaning.

I have been working today on getting ARS 7.0 patch 1 installed on my desktop computer.  The installation program has never completed successfully. I have attempted the installation about 20-25 times today.

I installed the Oracle instance on Friday with no errors.  I can login to SQL Plus without errors.

WinXP Pro
Oracle 10g R2
ARS 7.0

I think the problem has something to do with the ARAdmin user not able to connect to the Oracle instance.  Arcache will Not add a user.  The

message states that it cannot connect to ARS.   I have tried the install
with and without PortMapper. 

The last status window displayed is "Preparing to import forms and data...".  This is after the database is created and the Remedy service is started.  The message goes away and there is no message box on the screen for about 45 seconds.

Then the installation stops with "Failed to create a valid Admin user.
This installation cannot complete importing of forms and data. A valid Admin user will need to be created and forms and data manually imported."

After researching one of the errors I added the ORACLE_SID and ORACLE_HOME environment variables (and then rebooting).

The last time I programmed and installed Oracle databases was in 2003. I have done a lot of searching online and the List.  Could someone please point me in the right direction. It's probably one small setting that is causing all these errors.  Thanks.

ARERROR.LOG
-----------------------
Mon Aug 28 13:32:30 2006  390600 : This version of the Action Request
System(R) is ready for use or evaluation without purchasing or activating an authorization key.
For unlimited capabilities, contact your sales representative. (ARNOTE
27) Mon Aug 28 13:32:30 2006  390600 : Failure while trying to connect to the SQL database.
Please ensure the SQL database is running or contact the Database Administrator for help (ARERR 550)
Mon Aug 28 13:32:30 2006     ORA-12560: TNS:protocol adapter error
Mon Aug 28 13:32:30 2006  390600 : Cannot initialize contact with SQL database (ARERR 551)
Mon Aug 28 13:32:30 2006     Stop server
Mon Aug 28 13:32:30 2006  390600 : AR System server terminated -- fatal error encountered (ARNOTE 21)
-----------------------

CSS.LOG
-----------------------
2006-08-28 13:28:52.812: [  OCROSD][2472]utgdv:1:could not open registry key SOFTWARE\Oracle\ocr os error The system could not find the environment option that was entered.

2006-08-28 13:28:52.921: [  OCRRAW][2472]proprinit: Could not open raw device
2006-08-28 13:28:52.921: [ default][2472]a_init:7!: Backend init unsuccessful : [33]
2006-08-28 13:28:52.921: [ CSSCLNT][2472]clsssinit: error(33 ) in OCR initialization
------------------------

SQLNET.LOG
-----------------------
Fatal NI connect error 12541, connecting to:
 
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=TPA9PN0321.pbsj.com)(PORT=1521
))(CONNECT_DATA=(SID=tpa9pn03)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_
1\bin\emagent.exe)(HOST=TPA9PN0321)(USER=OraUser))))

  VERSION INFORMATION:
        TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
        Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows:
Version 10.2.0.1.0 - Production
  Time: 28-AUG-2006 13:26:39
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12541
    TNS-12541: TNS:no listener
    ns secondary err code: 12560
    nt main err code: 511
    TNS-00511: No listener
    nt secondary err code: 61
    nt OS err code: 0
-----------------------

Stephen

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

__20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___