i am trying to install the Serena server on my computer running oracle 12c. But during the installation of my serena server i am getting bellow error for creating schema:
"C:\Program Files\Serena\Dimensions 14.2\CM\install\oracle_pre_install.cmd" "C:\Program Files\Serena\Dimensions 14.2\CM" serena PCMS_SYS XYZ system XYZ
.
Generating Oracle pre-installation script ...
.
Creating "C:\Program Files\Serena\Dimensions 14.2\CM"\InstallTemp\create_oracle_database.sql ...
Using Oracle Administration Account system...
.
Finished creating create_oracle_database.sql ...
SQL*Plus: Release 12.1.0.2.0 Production on Tue Dec 1 17:48:53 2015
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Last Successful login time: Tue Dec 01 2015 17:40:09 +05:30
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
create user PCMS_SYS identified by XYZ default tablespace PCMS_DATA temporary tablespace PCMS_TEMP QUOTA UNLIMITED ON PCMS_DATA QUOTA UNLIMITED ON PCMS_IDX
*
ERROR at line 1:
ORA-65096: invalid common user or role name
grant connect, resource, create view to PCMS_SYS
*
ERROR at line 1:
ORA-01917: user or role 'PCMS_SYS' does not exist
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
"C:\Program Files\Serena\Dimensions 14.2\CM\install\install_oracle.cmd" system XYZ XYZ cm_typical_stream "C:\Program Files\Serena\Dimensions 14.2\CM" "C:\PROGRA~1\Serena\DIMENS~1.2\CM\demo" "C:\Serena_Workareas" serena cm_typical_stream dmsys "dmsys" "XYZ" dmsys dmsys
.
. Dimensions 10.2.0 Server installation parameters.
. --------------------------------------------------.
.
.
Dimensions location:
"""C:\Program Files\Serena\Dimensions 14.2\CM"""
Dimensions Base Database Name: cm_typical_stream
ODBC datasource name of the Dimensions physical database: serena
DBS Pool Proxy name: dmsys
Oracle Administrator Account: system
.
Load Process Model from:
"""C:\Program Files\Serena\Dimensions 14.2\CM"""\dbms\exportimport\cm_typical_stream_basedb.sql
.
Tool Manager: dmsys
Server Machine: ANKITA-PC
.
*************************************************************
There are no further Installation Questions. Work in progress
*************************************************************
.
Creating pcms_sys database ...
"""C:\Program Files\Serena\Dimensions 14.2\CM"""\prog\dmdba.exe --noschemacheck pcms_sys/*****@serena @setup_dm_sys 10.2 ANKITA-PC serena
Dimensions CM DMDBA 14.2.0.1 Build 9.69 (Production) at 17:48:59 Tuesday 01 December 2015
Copyright (c) 1988-2015 Serena Software, Inc. All rights reserved.
DBC-IM002:0-[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
DBC-IM002:0-[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Error: unable to connect to the specified DBMS.
.
Creating cm_typical_stream/cm_typical_stream database ...
"""C:\Program Files\Serena\Dimensions 14.2\CM"""\prog\dmdba.exe system/*****@serena setup_base_database cm_typical cm_typical_basedb /CREATE_USER /PASSWORD=XYZ
Dimensions CM DMDBA 14.2.0.1 Build 9.69 (Production) at 17:48:59 Tuesday 01 December 2015
Copyright (c) 1988-2015 Serena Software, Inc. All rights reserved.
DBC-IM002:0-[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
DBC-IM002:0-[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Error: unable to connect to the specified DBMS.
.
Register the basedatabase ...
"""C:\Program Files\Serena\Dimensions 14.2\CM"""\prog\dmdba.exe pcms_sys/*****@serena @register_basedb cm_typical ANKITA-PC serena
Dimensions CM DMDBA 14.2.0.1 Build 9.69 (Production) at 17:48:59 Tuesday 01 December 2015
Copyright (c) 1988-2015 Serena Software, Inc. All rights reserved.
DBC-IM002:0-[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
DBC-IM002:0-[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Error: unable to connect to the specified DBMS.
.
Set project type ...
"""C:\Program Files\Serena\Dimensions 14.2\CM"""\prog\dmdba.exe cm_typical/cm_typical@serena set_project_type STREAMS /project=QLARIUS:MAINLINE_JAVA_STR /SCHEMA=cm_typical
Dimensions CM DMDBA 14.2.0.1 Build 9.69 (Production) at 17:48:59 Tuesday 01 December 2015
Copyright (c) 1988-2015 Serena Software, Inc. All rights reserved.
DBC-IM002:0-[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
DBC-IM002:0-[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Error: unable to connect to the specified DBMS.
.
Adjusting user profiles ...
"""C:\Program Files\Serena\Dimensions 14.2\CM"""\prog\dmdba.exe cm_typical/cm_typical@serena @adjust_users_profile cm_typical ##!& dmsys
Dimensions CM DMDBA 14.2.0.1 Build 9.69 (Production) at 17:48:59 Tuesday 01 December 2015
Copyright (c) 1988-2015 Serena Software, Inc. All rights reserved.
DBC-IM002:0-[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
DBC-IM002:0-[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Error: unable to connect to the specified DBMS.
.
Renaming operating system users ...
"""C:\Program Files\Serena\Dimensions 14.2\CM"""\prog\dmdba.exe cm_typical/cm_typical@serena @rename_os_user ##!& dmsys
Dimensions CM DMDBA 14.2.0.1 Build 9.69 (Production) at 17:48:59 Tuesday 01 December 2015
Copyright (c) 1988-2015 Serena Software, Inc. All rights reserved.
DBC-IM002:0-[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
DBC-IM002:0-[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Error: unable to connect to the specified DBMS.
.
Adjusting rm roles ...
"""C:\Program Files\Serena\Dimensions 14.2\CM"""\prog\dmdba.exe cm_typical/cm_typical@serena @adjust_rm_roles ##!& dmsys
Dimensions CM DMDBA 14.2.0.1 Build 9.69 (Production) at 17:48:59 Tuesday 01 December 2015
Copyright (c) 1988-2015 Serena Software, Inc. All rights reserved.
DBC-IM002:0-[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
DBC-IM002:0-[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Error: unable to connect to the specified DBMS.
Updating product workareas ...
"""C:\Program Files\Serena\Dimensions 14.2\CM"""\prog\dmdba.exe cm_typical/cm_typical@serena @adjust_workarea_nt """C:\Serena_Workareas"""
Dimensions CM DMDBA 14.2.0.1 Build 9.69 (Production) at 17:49:00 Tuesday 01 December 2015
Copyright (c) 1988-2015 Serena Software, Inc. All rights reserved.
DBC-IM002:0-[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
DBC-IM002:0-[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Error: unable to connect to the specified DBMS.
"""C:\Program Files\Serena\Dimensions 14.2\CM"""\prog\dmdba.exe cm_typical/cm_typical@serena upcred DEPLOY_USER "dmsys" ***** dmsys
Dimensions CM DMDBA 14.2.0.1 Build 9.69 (Production) at 17:49:00 Tuesday 01 December 2015
Copyright (c) 1988-2015 Serena Software, Inc. All rights reserved.
DBC-IM002:0-[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
DBC-IM002:0-[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Error: unable to connect to the specified DBMS.
.
Updating product libraries ...
"""C:\Program Files\Serena\Dimensions 14.2\CM"""\prog\dmdba.exe cm_typical/cm_typical@serena @adjust_libraries_nt """C:\PROGRA~1\Serena\DIMENS~1.2\CM\demo""" ANKITA-PC
Dimensions CM DMDBA 14.2.0.1 Build 9.69 (Production) at 17:49:00 Tuesday 01 December 2015
Copyright (c) 1988-2015 Serena Software, Inc. All rights reserved.
DBC-IM002:0-[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
DBC-IM002:0-[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Error: unable to connect to the specified DBMS.
.
Running Command Center setup ...
"""C:\Program Files\Serena\Dimensions 14.2\CM"""\prog\dmdba.exe system/*****@serena insv cm_typical
Dimensions CM DMDBA 14.2.0.1 Build 9.69 (Production) at 17:49:00 Tuesday 01 December 2015
Copyright (c) 1988-2015 Serena Software, Inc. All rights reserved.
DBC-IM002:0-[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
DBC-IM002:0-[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Error: unable to connect to the specified DBMS.
"""C:\Program Files\Serena\Dimensions 14.2\CM"""\prog\dmdba.exe system/*****@serena grtv cm_typical cm_typical_rept
Dimensions CM DMDBA 14.2.0.1 Build 9.69 (Production) at 17:49:00 Tuesday 01 December 2015
Copyright (c) 1988-2015 Serena Software, Inc. All rights reserved.
DBC-IM002:0-[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
DBC-IM002:0-[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Error: unable to connect to the specified DBMS.
"C:\Program Files\Serena\Dimensions 14.2\CM\install\pulse_oracle_pre_install.cmd" serena system ***** PCMS_DATA PCMS_TEMP pulse *****
The system cannot find the file specified.
Generating Oracle pre-installation script ...
Creating C:\Users\ankita\AppData\Local\Temp\create_oracle_pulse_db.sql ...
Using Oracle Administration Account system...
Finished creating C:\Users\ankita\AppData\Local\Temp\create_oracle_pulse_db.sql ...
SQL*Plus: Release 12.1.0.2.0 Production on Tue Dec 1 17:49:08 2015
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Last Successful login time: Tue Dec 01 2015 17:48:53 +05:30
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
CREATE USER pulse IDENTIFIED BY pulse DEFAULT TABLESPACE PCMS_DATA TEMPORARY TABLESPACE PCMS_TEMP QUOTA UNLIMITED ON PCMS_DATA
*
ERROR at line 1:
ORA-65096: invalid common user or role name
GRANT CONNECT, RESOURCE, CREATE VIEW TO pulse
*
ERROR at line 1:
ORA-01917: user or role 'PULSE' does not exist
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options