hast du schon in der doku zu deinem "samson-tool" nachgelesen? oft benötigen 3rd-party-tools eigene schemata und/oder user, damit sie ihre eigenen packages, views, etc. anlegen können.

Die Anleitung des Tools ist leider zum vergessen. Es stimmt ich habe für das Tool User angelegt, deren Kennwörter habe ich aber auch schon alle ausprobiert. Ich werd versuchen das Script zu suchen.

Danke für eure Hilfe!

hier der inhalt des script. wird wer von euch schlau daraus?

Danke!!!

teil1:

/*
************************************************** *************
** [CR37179] Cancel script if a major error occurs. **
** Exits with SQL.SQLCODE or OSERROR (if an OS error occurs).**
************************************************** *************/
WHENEVER SQLERROR EXIT SQL.SQLCODE
WHENEVER OSERROR EXIT OSERROR

set echo off
set termout off
/*
************************************************** *****
** DB setup for the Samson-Database **
** **
** paramters: &1 working directory **
** : &2 logfile directory **
** : &3 SAMSON <passwd@connect> **
** : &4 SAM_IMP <passwd@connect> **
** : &5 SAM_PDM <passwd@connect> **
** : &6 SYSTEM <passwd@connect> **
** : &7 SAMSON_TRANSFER <passwd@connect> **
** : &8 SAM_RR2 <passwd@connect> **
** : &9 file postfix (onsite) **
************************************************** ****/
set termout on

--------------------------------
-- define variables for parameters
--------------------------------
define wkd='&1'
define log='&2'
define sam='&3'
define imp='&4'
define pdm='&5'
define sys='&6'
define tra='&7'
define rr2='&8'
define pos='&9'


--------------------------------
-- connect as samson schema owner
--------------------------------
connect samson/&sam
--------------------------------
-- create the samson-roles
--------------------------------
spool &log/01_role_samson.log
@samson/role_samson
spool off
--------------------------------
-- create the links
--------------------------------
spool &log/02_links_samson.log
@samson/links_samson
spool off
--------------------------------
-- create the tables
--------------------------------
spool &log/03_tabs_samson.log
@samson/tabs_samson
spool off
--------------------------------
-- create the views
--------------------------------
spool &log/04_view_samson.log
@samson/view_samson
spool off
--------------------------------
-- create the sequences
--------------------------------
spool &log/05_seq_samson.log
@samson/seq_samson
spool off
--------------------------------
-- create the functions
--------------------------------
spool &log/06_func_samson.log
@samson/func_samson
spool off
--------------------------------
-- create the procedures
--------------------------------
spool &log/07_proc_samson.log
@samson/proc_samson
spool off
--------------------------------
-- create the packages
--------------------------------
spool &log/08_pck_samson.log
@samson/pck_samson
spool off
--------------------------------
-- create public synonyms
--------------------------------
spool &log/09_syn_public.log
@samson/syn_public&pos
spool off
--------------------------------
-- create private synonyms
--------------------------------
spool &log/10_syn_private.log
@samson/syn_private
spool off
--------------------------------
-- create triggers
--------------------------------
spool &log/11_trg_samson.log
@samson/trg_samson
spool off
--------------------------------
-- fill the tables with values
--------------------------------
spool &log/12_sam_interface_info.log
@samson/tab_values/sam_interface_info
spool off

spool &log/13_sam_search.log
@samson/tab_values/sam_search&pos
spool off

spool &log/14_sam_def.log
@samson/tab_values/sam_def
@samson/tab_values/sam_def_printer
spool off
--------------------------------
-- grant rights on samson object to sam_pdm
--------------------------------
spool &log/15_grant_to_sam_pdm.log
@samson/grant_to_sam_pdm &wkd &log
spool off

--------------------------------
-- start the spooling for samson_transfer-objects
--------------------------------
--------------------------------
-- connect as samson_transfer schema owner
--------------------------------
connect samson_transfer/&tra
--------------------------------
-- create the samson_transfer-tables
--------------------------------
spool &log/16_samson_transferdbsetup.log
@samson_transfer/tabs_samtrans
spool off
--------------------------------
-- create the samson_transfer-sequences
--------------------------------
spool &log/17_seq_samtrans.log
@samson_transfer/seq_samtrans
spool off
--------------------------------
-- create the samson_transfer-views
--------------------------------
spool &log/18_view_samtrans.log
@samson_transfer/view_samtrans
spool off
--------------------------------
-- create the samson_transfer-packages
--------------------------------
spool &log/19_pck_samtrans.log
@samson_transfer/pck_samtrans
spool off

spool &log/20_pck_samtrans.log
@samson_transfer/grant_to_public
spool off

teil2:


--------------------------------
-- connect as sam_imp schema owner
--------------------------------
connect sam_imp/&imp
--------------------------------
-- create the import-tables
--------------------------------
spool &log/21_tabs_imp.log
@sam_imp/tabs_imp
spool off
--------------------------------
-- create the import-procedures
--------------------------------
spool &log/22_proc_imp.log
@sam_imp/proc_imp
spool off
--------------------------------
-- create the import-functions
--------------------------------
spool &log/23_func_imp.log
@sam_imp/func_imp
spool off
--------------------------------
-- connect as sam_pdm schema owner
--------------------------------
connect sam_pdm/&pdm
--------------------------------
-- create the samsonv2-tables
--------------------------------
spool &log/24_tabs_pdm.log
@sam_pdm/tabs_pdm
spool off
--------------------------------
-- create the samsonv2-sequences
--------------------------------
spool &log/25_seq_pdm.log
@sam_pdm/seq_pdm
spool off
--------------------------------
-- create the samsonv2-synonyms
--------------------------------
spool &log/26_syn_pdm.log
@sam_pdm/syn_pdm
spool off
--------------------------------
-- create the samsonv2-views
--------------------------------
spool &log/27_view_pdm.log
@sam_pdm/view_pdm
spool off
--------------------------------
-- create the samsonv2-procedures
--------------------------------
spool &log/28_proc_pdm.log
@sam_pdm/proc_pdm
spool off
--------------------------------
-- create the samsonv2-functions
--------------------------------
spool &log/29_func_pdm.log
@sam_pdm/func_pdm
spool off
--------------------------------
-- create the samsonv2-packages
--------------------------------
spool &log/30_pck_pdm.log
@sam_pdm/pck_pdm
spool off
--------------------------------
--grant access of sam_pdm objects to samson
--------------------------------
spool &log/31_grant_to_samson.log
@sam_pdm/grant_to_samson
spool off

--------------------------------
-- grant access on sam_imp-objects to sam_pdm
--------------------------------
connect sam_imp/&imp
spool &log/32_grant_to_sam_pdm.log
@sam_imp/grant_to_sam_pdm &wkd &log
spool off

--------------------------------
-- grant rights on samson object to sam_rr2
--------------------------------
connect samson/&sam
spool &log/33_grant_to_sam_rr2.log
@samson/grant_to_samrr2&pos
spool off

--------------------------------
-- create the SAM_RR2 tables
-- connect as SAM_RR2 schema owner
--------------------------------
spool &log/34_tabs_rr2.log
@sam_rr2/tabs_rr2&pos &rr2
spool off

--------------------------------
-- create the SAM_RR2 sequences
--------------------------------
spool &log/35_seq_rr2.log
@sam_rr2/seq_rr2&pos &rr2
spool off

--------------------------------
-- create the SAM_RR2 objects
--------------------------------
@sam_rr2/objects_rr2&pos &rr2

--------------------------------
-- create the SAM_RR2 private synonyms
--------------------------------
spool &log/40_syn_rr2_private.log
@sam_rr2/syn_rr2_private&pos &rr2
spool off
--------------------------------
-- grant privileges to roles
--------------------------------
spool &log/41_grant_to_samson_roles.log
@sam_rr2/grant_to_roles&pos &rr2
@sam_rr2/grant_to_samson_dyn&pos &rr2
spool off

--------------------------------
-- connect as system and recompile invalid objects
--------------------------------
connect system/&sys
--------------------------------
-- compile the invalid objects
--------------------------------
@recomp &wkd
@recomp &wkd
@recomp &wkd
@recomp &wkd
@recomp &wkd
@recomp &wkd

--------------------------------
-- connect as samson schema owner
--------------------------------
connect samson/&sam
@recomp &wkd
@recomp &wkd
@recomp &wkd
@recomp &wkd
@recomp &wkd

--------------------------------
-- grant access on samson-objects to user and roles
--------------------------------
spool &log/42_grant_samson.log
@samson/grant_samson
spool off
spool &log/43_grant_to_invkeeper.log
@samson/grant_to_invkeeper
spool off
spool &log/44_grant_to_projectowner.log
@samson/grant_to_projectowner
spool off
spool &log/45_grant_to_systemadmin.log
@samson/grant_to_systemadmin
spool off
spool &log/46_grant_to_accessall.log
@samson/grant_to_accessall
spool off
spool &log/47_grant_to_sam_user.log
@samson/grant_to_sam_user&pos &wkd &log
spool off
spool &log/48_grant_to_info.log
@samson/grant_to_info&pos &wkd &log
spool off
spool &log/49_grant_to_sem.log
@samson/grant_to_sem_user
@samson/grant_to_semservice
spool off

--------------------------------
-- connect as sam_pdm schema owner
--------------------------------
connect sam_pdm/&pdm
--------------------------------
-- grant access on sam_pdm views
-- and functions to samson_user
--------------------------------
spool &log/50_grant_to_samson_user.log
@sam_pdm/grant_to_samson_user
spool off

--------------------------------
-- grant access on SAMSON objects
-- to sem_to_im_transfer user (TSC3)
--------------------------------
connect samson/&sam
spool &log/51_grant_to_sem_im_transfer.log
@samson/grant_to_sem_im_transfer
spool off

teil3:

--------------------------------
-- connect as system and recompile invalid objects
--------------------------------
connect system/&sys
@recomp &wkd
@recomp &wkd

connect samson/&sam
@recomp &wkd
@recomp &wkd
@recomp &wkd
@recomp &wkd

---------------------------------
-- defensively compile special
-- SAMSON objects
---------------------------------
spool &log/52_samson_comp.log
@samson/recomp
spool off

---------------------------------
-- defensively compile special
-- SAM_RR2 objects
-- connect as SAM_RR2 schema owner
---------------------------------
spool &log/53_sam_rr2_comp.log
@sam_rr2/recomp&pos &rr2
spool off

--------------------------------
-- exit sqlplus
--------------------------------
connect samson/&sam

@log/compare &log &sam &pdm &imp
exit

naja so auf den 1. blick sieht man mal dass da ein haufen connects gemacht werden und dass eigentlich alles mitgeloggt wird.
setz mal die commands set echo off und set termout off unter kommentar und führ das script dann durch, vielleicht sieht man dann mehr

Das wird ein Problem das script ist auf der install cd.

cd auf platte kopieren?

ich nehme mal an du weisst auch nicht mit welchen parametern das script aufgerufen wird oder? offenbar werden die passwörter als parameter an das script übergeben.

werd mal probieren ob man auch von der platte direkt installieren kann. von den übergebenen parameter hab ich keine ahnung.

oder du machst es so wie von ruprecht69 vorgeschlagen, du meldest dich mit sys an und setzt für alle samson user (die kennst du ja, stehen auch alle in dem script) das passwort neu. irgendeins von denen scheint ja falsch gesetzt zu sein.