Great Question: db was confused:: default was arsystem, but the tablespace
was arsys,
I renamed the tablespace to arsystem and ensured the user account is
correct for default..
One more time..
On Thu, Nov 3, 2011 at 5:16 PM, Grooms, Frederick W <
frederick.w.gro...@xo.com> wrote:
> **
>
> I don’t see in your log where the SQL is referencing ARSYSTEM (almost like
> it is trying to use the default for that Oracle user). ****
>
> ** **
>
> Can you double check to make sure that the aradmin user’s default
> tablespace is not ARSYSTEM (assuming that your db user is aradmin)****
>
> ** **
>
> Select * from SYS.USER_USERS Where username = ‘ARADMIN’****
>
> ** **
>
> Fred****
>
> ** **
>
> ** **
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] *On Behalf Of *patrick zandi
> *Sent:* Thursday, November 03, 2011 3:57 PM
>
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: 7.6.04 -SP02 Windows:: got a question****
>
> ** **
>
> ** OK::: I know this for sure:::: you MUST use ARSYSTEM int he oracle
> database.. they HARD CODED calls to it, Rather than asking for what it is,
> and returning and using what was returned::: here is #1 Error on my failed
> upgrade.
>
> OURS was installed as ARSYS not ARSYSTEM...
> It might still work:: not positive.. yet..
> .
> LOG EVENT {Description=[[SQLERROR] [DESCRIPTION] Failed to upgrade the
> database schema],Detail=[[SQLERRORCODE]=0 [SQLMESSAGE]=Failed to run SQL
> statement [CREATE TABLE ARADMIN.hgcontrol ( schemaId NUMBER(15) NOT NULL,
> entryId VARCHAR2(15), uniq VARCHAR2(31) )] Due to [ORA-00959: tablespace '
> *ARSYSTEM' does not exist*
> #2
> Throwable=[java.sql.SQLException: Failed to run SQL statement [CREATE
> TABLE ARADMIN.hgcontrol ( schemaId NUMBER(15) NOT NULL, entryId
> VARCHAR2(15), uniq VARCHAR2(31) )] Due to [ORA-00959*: tablespace
> 'ARSYSTEM' does not exist*
> ]
>
> com.bmc.install.utility.database.io.DatabaseModelJDBCWriter.writeStatements(DatabaseModelJDBCWriter.java:245)
>
> com.bmc.install.utility.database.io.DatabaseModelJDBCWriter.writeStatements(DatabaseModelJDBCWriter.java:130)
>
> com.bmc.install.product.arsuitekit.platforms.arsystemservers.arserver.ARServerManageUpgradeDatabaseBusinessTask.processDBVendorTablesXMLFile(ARServerManageUpgradeDatabaseBusinessTask.java:425)
>
> com.bmc.install.product.arsuitekit.platforms.arsystemservers.arserver.ARServerManageUpgradeDatabaseBusinessTask.execute(ARServerManageUpgradeDatabaseBusinessTask.java:98)
>
> com.bmc.install.product.arsuitekit.platforms.arsystemservers.arserver.ARServerOracleManageUpgradeDatabaseTask.execute(ARServerOracleManageUpgradeDatabaseTask.java:85)
> com.bmc.install.task.InstallationTask.run(InstallationTask.java:80)
> java.lang.Thread.run(Unknown Source)]
>
> --
> Patrick Zandi
>
> ****
>
> ** **
> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_
--
Patrick Zandi
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
