Re: Oracle 9i/10G client, ARS 7.0.1p2 installation failure...
oh, you can also modify your root.cshrc to match the proper config to use the client with the db. two_task etc. On 5/4/07, patrick zandi [EMAIL PROTECTED] wrote: Rick, Well looking at your configuration, I am a little curious to know why you have a 10i client connecting to a 9i DB. 10 Does work differently than 9, and ARS 7.01 is expecting 10i client I know, but it might be expecting a 10db too. login as oracle on the solaris box. sqlplus as oracle -- login as aradmin AR#ADMIN# if this works.. great su to ROOT on the solaris box. sqlplus put in aradmin AR#ADMIN# does that work ? if not... check your 10i client /network/admin/ * tnsnames.ora / etc.. Are they the exact same as the 9i DB / network/admin * if not.. then you are going to have connection issues. Hope this helps some.. 8-) On 5/3/07, Rick Phillips [EMAIL PROTECTED] wrote: Hello all, I'm having a problem with a brand new ARS 7.0.1 p2 installation. Win2003 R2, Ora9i with 10G client. When installing ARS 7.0.1p2, I'm receiving the error: 22:26:16 -[ERROR]: Couldn't create the Demo user. 22:26:24 -[ERROR]: Failed to create a valid Admin user. This installation cannot complete importing of forms or data. A valid Admin user will need to be created and forms and data manually imported. This error occurred after the installation of the AR System was completed. To correct this error, import the sample applications from the samples subdirectory. 22:46:29 Done importing forms. 22:46:29 -[ERROR]: Failed to complete AR Server installation. I know that I can correct this by following the instructions listed, but I am creating documention for an installation process; what I really need is an error free installation. I can connect to the db via SQLPlus as ARAdmin, and by using OEM I can view the contents of the arschema table (User and Group are notably missing). Any clues where I should begin looking? tia, Rick ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are -- Patrick Zandi -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Oracle 9i/10G client, ARS 7.0.1p2 installation failure...
10g client with 9i db should be fine. This is how our environment is set up. Axton On 5/4/07, patrick zandi [EMAIL PROTECTED] wrote: ** Rick, Well looking at your configuration, I am a little curious to know why you have a 10i client connecting to a 9i DB. 10 Does work differently than 9, and ARS 7.01 is expecting 10i client I know, but it might be expecting a 10db too. login as oracle on the solaris box. sqlplus as oracle -- login as aradmin AR#ADMIN# if this works.. great su to ROOT on the solaris box. sqlplus put in aradmin AR#ADMIN# does that work ? if not... check your 10i client /network/admin/ * tnsnames.ora / etc.. Are they the exact same as the 9i DB / network/admin * if not.. then you are going to have connection issues. Hope this helps some.. 8-) On 5/3/07, Rick Phillips [EMAIL PROTECTED] wrote: Hello all, I'm having a problem with a brand new ARS 7.0.1 p2 installation. Win2003 R2, Ora9i with 10G client. When installing ARS 7.0.1p2, I'm receiving the error: 22:26:16 -[ERROR]: Couldn't create the Demo user. 22:26:24 -[ERROR]: Failed to create a valid Admin user. This installation cannot complete importing of forms or data. A valid Admin user will need to be created and forms and data manually imported. This error occurred after the installation of the AR System was completed. To correct this error, import the sample applications from the samples subdirectory. 22:46:29 Done importing forms. 22:46:29 -[ERROR]: Failed to complete AR Server installation. I know that I can correct this by following the instructions listed, but I am creating documention for an installation process; what I really need is an error free installation. I can connect to the db via SQLPlus as ARAdmin, and by using OEM I can view the contents of the arschema table (User and Group are notably missing). Any clues where I should begin looking? tia, Rick ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are -- Patrick Zandi __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Oracle 9i/10G client, ARS 7.0.1p2 installation failure...
This is what concerns me: 22:19:29 == Query Request == select tablespace_name from user_tablespaces where tablespace_name = 'ARSYSTEM'; 22:19:29 == Query Results == ORA-01017: invalid username/password; logon denied ERROR: Cannot open the database ... exiting It would appear that there is a mismatch between what the db user has as a password and what remedy is trying to use. Does the aradmin account exist before you run the installer? If so, is the password the default value (ar#admin#)? If not, reset the password to the default or drop the account before running the installer. I know there were issues in versions past when performing an install if the user exists before the install and the password is not the default. This seemed to only impact new installs if my memory serves me correctly. Axton Grams On 5/4/07, Rick Phillips [EMAIL PROTECTED] wrote: Found this in the dbquery.log 22:19:29 == Query Request == select tablespace_name from user_tablespaces where tablespace_name = 'ARSYSTEM'; 22:19:29 == Query Results == ORA-01017: invalid username/password; logon denied ERROR: Cannot open the database ... exiting and this in the arerror.log Thu May 03 22:24:50 2007 390695 : The RPC port specified is not one of the legal values (0, 1 - 65535) : 70100 (ARERR 8202) Thu May 03 22:25:49 2007 Dispatch : Authentication failed () ARERR - 623 Thu May 03 22:25:49 2007 Dispatch : AR System Application server terminated -- fatal error encountered (ARAPPNOTE 4501) Thu May 03 22:25:49 2007 Dispatch : Authentication failed () ARERR - 623 Thu May 03 22:25:49 2007 Dispatch : AR System Application server terminated -- fatal error encountered (ARAPPNOTE 4501) Thu May 03 22:25:49 2007 Dispatch : Authentication failed () ARERR - 623 Thu May 03 22:25:49 2007 Dispatch : AR System Application server terminated -- fatal error encountered (ARAPPNOTE 4501) Thu May 03 22:25:49 2007 Dispatch : Authentication failed () ARERR - 623 Thu May 03 22:25:49 2007 Dispatch : AR System Application server terminated -- fatal error encountered (ARAPPNOTE 4501) Thu May 03 22:25:49 2007 Dispatch : Authentication failed () ARERR - 623 Thu May 03 22:25:49 2007 Dispatch : AR System Application server terminated -- fatal error encountered (ARAPPNOTE 4501) Thu May 03 23:54:22 2007 390695 : The RPC port specified is not one of the legal values (0, 1 - 65535) : 70100 (ARERR 8202) Thu May 03 23:54:23 2007 390695 : The RPC port specified is not one of the legal values (0, 1 - 65535) : 70100 (ARERR 8202) Thu May 03 23:54:25 2007 390695 : The RPC port specified is not one of the legal values (0, 1 - 65535) : 70100 (ARERR 8202) Thu May 03 23:54:25 2007 390695 : The RPC port specified is not one of the legal values (0, 1 - 65535) : 70100 (ARERR 8202) rp On May 4, 12:26 am, Susan Palmer [EMAIL PROTECTED] wrote: Having spent some intimate time with these files in this similar setting in the last few weeks (upgrade ... well an attempt at it) several install logs are in C:\Documents and Settings\RemAdmin\Local Settings\Temp\1 Not exactly an intuitive place to look. Of course you can look in program files/ar system/arserver/db for the usual arerror.log. Support really likes you to import the samples. I didn't want to do that either but they appeared to insist in order to attempt to help. We actually gave up on the server upgrade because Windows would not recognize the AR System as a win32 application and the service would not connect. No particular resolution to that issue. So we took a brand new server and are building it from scratch ... in fact the database is being installed today/tomorrow. Then I get the server Monday to do a clean v7.0.1P2 install. I'm not exactly sure if you'd classify it as a brand new AR install because we are copying the production database to that server, but AR has never been installed there. So in my case I would expect the users to be recognized and I do have a Demo user created because as I learned in this whole process, is that the new installs really like to be done by Demo. Keep us posted please. Thanks, Susan On 5/3/07, Axton [EMAIL PROTECTED] wrote: On unix, an arerror.log, arsql.log, among others are created /var/tmp during an install. Not sure, but I would imagine these are in the TEMP directory on your windows box. Look at the env vars (right click my computer, properties, advanced tab, environment variables) to see what TEMP and TMP are set to, the look there for some logs. These are typicall pretty revealing for the installation process. Axton Grams On 5/3/07, Rick Phillips [EMAIL PROTECTED] wrote: Hello all, I'm having a problem with a brand new ARS 7.0.1 p2 installation. Win2003 R2, Ora9i with 10G client. When installing ARS 7.0.1p2, I'm receiving the error: 22:26:16 -[ERROR]: Couldn't create
Re: Oracle 9i/10G client, ARS 7.0.1p2 installation failure...
Thanks, Axton, was not 100% on the undo tables issue. On 5/4/07, Axton [EMAIL PROTECTED] wrote: 10g client with 9i db should be fine. This is how our environment is set up. Axton On 5/4/07, patrick zandi [EMAIL PROTECTED] wrote: ** Rick, Well looking at your configuration, I am a little curious to know why you have a 10i client connecting to a 9i DB. 10 Does work differently than 9, and ARS 7.01 is expecting 10i client I know, but it might be expecting a 10db too. login as oracle on the solaris box. sqlplus as oracle -- login as aradmin AR#ADMIN# if this works.. great su to ROOT on the solaris box. sqlplus put in aradmin AR#ADMIN# does that work ? if not... check your 10i client /network/admin/ * tnsnames.ora / etc.. Are they the exact same as the 9i DB / network/admin * if not.. then you are going to have connection issues. Hope this helps some.. 8-) On 5/3/07, Rick Phillips [EMAIL PROTECTED] wrote: Hello all, I'm having a problem with a brand new ARS 7.0.1 p2 installation. Win2003 R2, Ora9i with 10G client. When installing ARS 7.0.1p2, I'm receiving the error: 22:26:16 -[ERROR]: Couldn't create the Demo user. 22:26:24 -[ERROR]: Failed to create a valid Admin user. This installation cannot complete importing of forms or data. A valid Admin user will need to be created and forms and data manually imported. This error occurred after the installation of the AR System was completed. To correct this error, import the sample applications from the samples subdirectory. 22:46:29 Done importing forms. 22:46:29 -[ERROR]: Failed to complete AR Server installation. I know that I can correct this by following the instructions listed, but I am creating documention for an installation process; what I really need is an error free installation. I can connect to the db via SQLPlus as ARAdmin, and by using OEM I can view the contents of the arschema table (User and Group are notably missing). Any clues where I should begin looking? tia, Rick ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.orgARSlist:Where the Answers Are -- Patrick Zandi __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Oracle 9i/10G client, ARS 7.0.1p2 installation failure...
Final word from support: after reproducing, they will submit as a bug. On May 4, 2:43 pm, Rick Phillips [EMAIL PROTECTED] wrote: Here was the problem: as I mentioned, I'm working on documentation for installations. The previous 5.1.2 install doc had the person performing the install select register with portmapper and define a port. MANY installations have been performed this way successfully. My 7.0.1 doc is built on the earlier doc. But with 7.0.1, registering with portmapper and defining a TCP port produces the errors detailed earlier in this post. Registering with portmapper ony lead to a successful installation. Thanks, rp On May 4, 12:18 pm, patrick zandi [EMAIL PROTECTED] wrote: Thanks, Axton, was not 100% on the undo tables issue. On 5/4/07, Axton [EMAIL PROTECTED] wrote: 10g client with 9i db should be fine. This is how our environment is set up. Axton On 5/4/07, patrick zandi [EMAIL PROTECTED] wrote: ** Rick, Well looking at your configuration, I am a little curious to know why you have a 10i client connecting to a 9i DB. 10 Does work differently than 9, and ARS 7.01 is expecting 10i client I know, but it might be expecting a 10db too. login as oracle on the solaris box. sqlplus as oracle -- login as aradmin AR#ADMIN# if this works.. great su to ROOT on the solaris box. sqlplus put in aradmin AR#ADMIN# does that work ? if not... check your 10i client /network/admin/ * tnsnames.ora / etc.. Are they the exact same as the 9i DB / network/admin * if not.. then you are going to have connection issues. Hope this helps some.. 8-) On 5/3/07, Rick Phillips [EMAIL PROTECTED] wrote: Hello all, I'm having a problem with a brand new ARS 7.0.1 p2 installation. Win2003 R2, Ora9i with 10G client. When installing ARS 7.0.1p2, I'm receiving the error: 22:26:16 -[ERROR]: Couldn't create the Demo user. 22:26:24 -[ERROR]: Failed to create a valid Admin user. This installation cannot complete importing of forms or data. A valid Admin user will need to be created and forms and data manually imported. This error occurred after the installation of the AR System was completed. To correct this error, import the sample applications from the samples subdirectory. 22:46:29 Done importing forms. 22:46:29 -[ERROR]: Failed to complete AR Server installation. I know that I can correct this by following the instructions listed, but I am creating documention for an installation process; what I really need is an error free installation. I can connect to the db via SQLPlus as ARAdmin, and by using OEM I can view the contents of the arschema table (User and Group are notably missing). Any clues where I should begin looking? tia, Rick ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:Where the Answers Are -- Patrick Zandi __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:Where the Answers Are -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:Where the Answers Are- Hide quoted text - - Show quoted text - ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:Where the Answers Are- Hide quoted text - - Show quoted text - ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Oracle 9i/10G client, ARS 7.0.1p2 installation failure...
On unix, an arerror.log, arsql.log, among others are created /var/tmp during an install. Not sure, but I would imagine these are in the TEMP directory on your windows box. Look at the env vars (right click my computer, properties, advanced tab, environment variables) to see what TEMP and TMP are set to, the look there for some logs. These are typicall pretty revealing for the installation process. Axton Grams On 5/3/07, Rick Phillips [EMAIL PROTECTED] wrote: Hello all, I'm having a problem with a brand new ARS 7.0.1 p2 installation. Win2003 R2, Ora9i with 10G client. When installing ARS 7.0.1p2, I'm receiving the error: 22:26:16 -[ERROR]: Couldn't create the Demo user. 22:26:24 -[ERROR]: Failed to create a valid Admin user. This installation cannot complete importing of forms or data. A valid Admin user will need to be created and forms and data manually imported. This error occurred after the installation of the AR System was completed. To correct this error, import the sample applications from the samples subdirectory. 22:46:29 Done importing forms. 22:46:29 -[ERROR]: Failed to complete AR Server installation. I know that I can correct this by following the instructions listed, but I am creating documention for an installation process; what I really need is an error free installation. I can connect to the db via SQLPlus as ARAdmin, and by using OEM I can view the contents of the arschema table (User and Group are notably missing). Any clues where I should begin looking? tia, Rick ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Oracle 9i/10G client, ARS 7.0.1p2 installation failure...
Having spent some intimate time with these files in this similar setting in the last few weeks (upgrade ... well an attempt at it) several install logs are in C:\Documents and Settings\RemAdmin\Local Settings\Temp\1 Not exactly an intuitive place to look. Of course you can look in program files/ar system/arserver/db for the usual arerror.log. Support really likes you to import the samples. I didn't want to do that either but they appeared to insist in order to attempt to help. We actually gave up on the server upgrade because Windows would not recognize the AR System as a win32 application and the service would not connect. No particular resolution to that issue. So we took a brand new server and are building it from scratch ... in fact the database is being installed today/tomorrow. Then I get the server Monday to do a clean v7.0.1P2 install. I'm not exactly sure if you'd classify it as a brand new AR install because we are copying the production database to that server, but AR has never been installed there. So in my case I would expect the users to be recognized and I do have a Demo user created because as I learned in this whole process, is that the new installs really like to be done by Demo. Keep us posted please. Thanks, Susan On 5/3/07, Axton [EMAIL PROTECTED] wrote: On unix, an arerror.log, arsql.log, among others are created /var/tmp during an install. Not sure, but I would imagine these are in the TEMP directory on your windows box. Look at the env vars (right click my computer, properties, advanced tab, environment variables) to see what TEMP and TMP are set to, the look there for some logs. These are typicall pretty revealing for the installation process. Axton Grams On 5/3/07, Rick Phillips [EMAIL PROTECTED] wrote: Hello all, I'm having a problem with a brand new ARS 7.0.1 p2 installation. Win2003 R2, Ora9i with 10G client. When installing ARS 7.0.1p2, I'm receiving the error: 22:26:16 -[ERROR]: Couldn't create the Demo user. 22:26:24 -[ERROR]: Failed to create a valid Admin user. This installation cannot complete importing of forms or data. A valid Admin user will need to be created and forms and data manually imported. This error occurred after the installation of the AR System was completed. To correct this error, import the sample applications from the samples subdirectory. 22:46:29 Done importing forms. 22:46:29 -[ERROR]: Failed to complete AR Server installation. I know that I can correct this by following the instructions listed, but I am creating documention for an installation process; what I really need is an error free installation. I can connect to the db via SQLPlus as ARAdmin, and by using OEM I can view the contents of the arschema table (User and Group are notably missing). Any clues where I should begin looking? tia, Rick ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
