sash_targets.sid column size

[kunajn]

Hi,

orasash ver 2.3 repo_schema.sql creates table:

create table sash_targets (
...
        sid varchar2(8),
...

and this is problem with RAC DB and 8 chars DB name:

For example:

DB NAME: przepior
instance1 name: przepior1

we try to add this to the repo and... ...

BEGIN sash_repo.add_db('hostname1', 1521, 's3cr3tP4ss', 'przepior', 'przepior1',1, '11.2.0.2', 8); END;
*
ERROR at line 1:
ORA-12899: value too large for column "SASH"."SASH_TARGETS"."SID" (actual: 9, maximum: 8)
ORA-06512: at "SASH.SASH_REPO", line 353
ORA-06512: at line 1

of course it works after this change:

diff repo_schema.sql repo_schema.sql.orig
400c400
<       sid varchar2(9),
---
>       sid varchar2(8),

"------------------------------------------------------------------------------------"
Configuration completed. Exiting.
You can now connect using user name and password specified above
"------------------------------------------------------------------------------------"

pzdr, Kamil