From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W
Sent: Tuesday, August 29, 2006 9:00 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARS 7 + Oracle 10gR2 = Can Not Install ARS
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
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