Hello,
We are facing oracle database error when we install remedy ARS 7.1
Here is the environment
OS : SuSE linux 10.1 enerprise server
database : oracle 9i release 2
Oralce client in the OS is : ora10gR2
Remey server : 7.1
The current data base is having in a sun solaris box and already have
one instance, underthat we are haivng aradmin schecma. AR system 6.3
on solaris box is tied with that schema and we are using that one as a
dev server, We are going to switch over the new enviorment.
So we are using existing database, under the same database instance,
we created new schema. we are trying to use this new schema for our
new ARS 7.1 installation in a differnet enviornment.
here is the part of my installation log
Is the ORACLE database on a remote machine? [n] y
What is the ORACLE home directory? [/opt/oracle/product/10.2/db_1]
What is the remote system ID (TWO_TASK) connect string variable?
[aferemqa01]
What is your AR User Name? [helpqa]
For security reasons, your password will not be displayed.
What is your AR User Password for helpqa? [*****]
Found existing tablespaces (arsystem) for owner helpqa.
You can either choose an existing tablespace
or, if you have DBA access, create a new tablespace.
1) Choose an existing tablespace
2) Create a new tablespace for this user
3) Quit this installation
Select the operation do you want to perform [1, 2 or 3]: [1] 1
What is the AR System Tablespace Name? (arsystem) [arsystem]
The arsystem tablespace exists for owner helpqa
*** It is a good idea to have a backup of your database before
*** attempting an upgrade or overwrite operation. If you do not
*** have a recent backup, you may want to pause here or quit the
*** installation to make a backup before continuing.
At this point, you will be prompted for the action to take.
You must choose from the following actions:
o - Overwrite the existing arsystem tablespace for helpqa.
All existing AR System data will be lost and a new arsystem
tablespace
installed.
u - Upgrade the existing arsystem tablespace for helpqa.
The current AR System tablespace will be upgraded to the new
release. All
current data will be preserved and the tablespace restructured.
q - Quit the installation at this point.
Action? [u] u
Your existing AR System tablespace will be upgraded
*** Passwords are now required for the proper functioning of
*** some applications. To change the passwords after the
*** installation you must use BMC Remedy Administrator.
*** Please set your initial passwords:
when it try to install the logs shows that
Running DB upgrade.....
Cannot open catalog; Message number = 550 (ARERR 550)
ORA-01017: invalid username/password; logon denied
SQL tracing initiated to file /usr/tmp/arsql.log
And my dbquery.log and arsql.log shows that the following
******************* Query Input *******************
select dbVersion from control;
******************* Query Output ******************
select dbVersion from control
ERROR: SQL operation failed
ORA-00942: table or view does not exist
******************* Query Input *******************
select dbVersion from control;
******************* Query Output ******************
select dbVersion from control
ERROR: SQL operation failed
ORA-00942: table or view does not exist
******************* Query Input *******************
quit
******************* Query Output ******************
Running DB upgrade.....
Cannot open catalog; Message number = 550 (ARERR 550)
ORA-01017: invalid username/password; logon denied
SQL tracing initiated to file /usr/tmp/arsql.log
Cannot open catalog; Message number = 550 (ARERR 550)
ORA-01017: invalid username/password; logon denied
******************* Query Input *******************
Running Oracle DB Upgrade
******************* Query Output ******************
/* Wed Dec 12 15:49:38 2007 */ SQL Trace Log -- ON
/* Wed Dec 12 15:49:38 2007 */ CONNECT helpqa
/* Wed Dec 12 15:49:39 2007 */ *** ERROR *** ORA-01017: invalid
username/password; logon denied
/* Wed Dec 12 15:49:39 2007 */ COMMIT WORK RELEASE
/* Wed Dec 12 15:49:39 2007 */ SQL Trace Log -- OFF
Major thing is i am able to connect the database via sqlplus. tnsping
and oraload.
My question is,
Can we use the same database , existing tablespace and a new schema
name for another version of remedy from another box? or should we need
a new one?
Please help me on this where i am in wrong
Thanks,
Meenakshinathan
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
