Hello all
I'm trying to install Oracle BRM but when running pin_setup.bat I have the output below.
I tried on Win 7 Pro x64 and on Windows XP Pro.
I also tried to see if there were any connection attempt when the errors "pcmdd: bad connect for PCWORK, errno 9" is shown, using Wireshark, but it seems that there is no connection attempt when this message is printed to the output.
As the error is exactly the same on Win 7 Pro and Win XP Pro, I think that this is not an operating system problem.
Do you know what I am doing wrong ?
Thanks
pin_setup.bat output :_
#===========================================================
# Installation started at Mon Sep 5 21:04:15 2011.
#===========================================================
cm: Generating pin.conf file
pin.conf is generated under C:/BRM/Portal/sys/cm/pin.conf
pin.conf is generated under C:/BRM/Portal/apps/pin_remit/pin.conf
dm_oracle: Generating pin.conf file
pin.conf is generated under C:/BRM/Portal/setup/scripts/pin.conf
pin.conf is generated under C:/BRM/Portal/sys/dm_oracle/pin.conf
dm_oracle: Configuring database
Creating Portal tablespaces ... this may take a few minutes
Creating main tablespace 'pin00'
Creating index tablespace 'pinx00'
Creating temporary tablespace 'PINTEMP'
Creating 'pin' user
Granting 'pin' correct permissions
Altering 'pin' user default tablespace
Altering 'pin' user temporary tablespace
Finished creating the Portal tablespaces
Continuing to Configure the database
Execute SQL statement from file C:/BRM/Portal/sys/dm_oracle/data/create_dd_UTF8.
source
Loading objects from file
pcmdd: bad connect for PCWORK, errno 9
errno=<PIN_ERR_DM_CONNECT_FAILED:26> location=<Unknown pin location:0> class=<UN
KNOWN:0> field num=<0:0,0> recid=<0> reserved=<9>
pcmdd: bad connect for PCWORK, errno 9
errno=<PIN_ERR_DM_CONNECT_FAILED:26> location=<Unknown pin location:0> class=<UN
KNOWN:0> field num=<0:0,0> recid=<0> reserved=<9>
pcmdd: bad connect for PCWORK, errno 9
errno=<PIN_ERR_DM_CONNECT_FAILED:26> location=<Unknown pin location:0> class=<UN
KNOWN:0> field num=<0:0,0> recid=<0> reserved=<9>
pcmdd: bad connect for PCWORK, errno 9
errno=<PIN_ERR_DM_CONNECT_FAILED:26> location=<Unknown pin location:0> class=<UN
KNOWN:0> field num=<0:0,0> recid=<0> reserved=<9>
pcmdd: bad connect for PCWORK, errno 9
errno=<PIN_ERR_DM_CONNECT_FAILED:26> location=<Unknown pin location:0> class=<UN
KNOWN:0> field num=<0:0,0> recid=<0> reserved=<9>
pcmdd: bad connect for PCWORK, errno 9
errno=<PIN_ERR_DM_CONNECT_FAILED:26> location=<Unknown pin location:0> class=<UN
KNOWN:0> field num=<0:0,0> recid=<0> reserved=<9>
pcmdd: bad connect for PCWORK, errno 9
errno=<PIN_ERR_DM_CONNECT_FAILED:26> location=<Unknown pin location:0> class=<UN
KNOWN:0> field num=<0:0,0> recid=<0> reserved=<9>
pcmdd: bad connect for PCWORK, errno 9
errno=<PIN_ERR_DM_CONNECT_FAILED:26> location=<Unknown pin location:0> class=<UN
KNOWN:0> field num=<0:0,0> recid=<0> reserved=<9>
pcmdd: bad connect for PCWORK, errno 9
errno=<PIN_ERR_DM_CONNECT_FAILED:26> location=<Unknown pin location:0> class=<UN
KNOWN:0> field num=<0:0,0> recid=<0> reserved=<9>
pcmdd: bad connect for PCWORK, errno 9
errno=<PIN_ERR_DM_CONNECT_FAILED:26> location=<Unknown pin location:0> class=<UN
KNOWN:0> field num=<0:0,0> recid=<0> reserved=<9>
pcmdd: bad connect for PCWORK, errno 9
errno=<PIN_ERR_DM_CONNECT_FAILED:26> location=<Unknown pin location:0> class=<UN
KNOWN:0> field num=<0:0,0> recid=<0> reserved=<9>
pcmdd: bad connect for PCWORK, errno 9
errno=<PIN_ERR_DM_CONNECT_FAILED:26> location=<Unknown pin location:0> class=<UN
KNOWN:0> field num=<0:0,0> recid=<0> reserved=<9>
pcmdd: bad connect for PCWORK, errno 9
errno=<PIN_ERR_DM_CONNECT_FAILED:26> location=<Unknown pin location:0> class=<UN
KNOWN:0> field num=<0:0,0> recid=<0> reserved=<9>
pcmdd: bad connect for PCWORK, errno 9
errno=<PIN_ERR_DM_CONNECT_FAILED:26> location=<Unknown pin location:0> class=<UN
KNOWN:0> field num=<0:0,0> recid=<0> reserved=<9>
pcmdd: bad connect for PCWORK, errno 9
errno=<PIN_ERR_DM_CONNECT_FAILED:26> location=<Unknown pin location:0> class=<UN
KNOWN:0> field num=<0:0,0> recid=<0> reserved=<9>
pcmdd: bad connect for PCWORK, errno 9
errno=<PIN_ERR_DM_CONNECT_FAILED:26> location=<Unknown pin location:0> class=<UN
KNOWN:0> field num=<0:0,0> recid=<0> reserved=<9>
pcmdd: bad connect for PCWORK, errno 9
errno=<PIN_ERR_DM_CONNECT_FAILED:26> location=<Unknown pin location:0> class=<UN
KNOWN:0> field num=<0:0,0> recid=<0> reserved=<9>
pcmdd: bad connect for PCWORK, errno 9
errno=<PIN_ERR_DM_CONNECT_FAILED:26> location=<Unknown pin location:0> class=<UN
KNOWN:0> field num=<0:0,0> recid=<0> reserved=<9>
pcmdd: bad connect for PCWORK, errno 9
errno=<PIN_ERR_DM_CONNECT_FAILED:26> location=<Unknown pin location:0> class=<UN
KNOWN:0> field num=<0:0,0> recid=<0> reserved=<9>
pcmdd: bad connect for PCWORK, errno 9
errno=<PIN_ERR_DM_CONNECT_FAILED:26> location=<Unknown pin location:0> class=<UN
KNOWN:0> field num=<0:0,0> recid=<0> reserved=<9>
pcmdd: bad connect for PCWORK, errno 9
errno=<PIN_ERR_DM_CONNECT_FAILED:26> location=<Unknown pin location:0> class=<UN
KNOWN:0> field num=<0:0,0> recid=<0> reserved=<9>
pcmdd: bad connect for PCWORK, errno 9
errno=<PIN_ERR_DM_CONNECT_FAILED:26> location=<Unknown pin location:0> class=<UN
KNOWN:0> field num=<0:0,0> recid=<0> reserved=<9>
pcmdd: bad connect for PCWORK, errno 9
errno=<PIN_ERR_DM_CONNECT_FAILED:26> location=<Unknown pin location:0> class=<UN
KNOWN:0> field num=<0:0,0> recid=<0> reserved=<9>
pcmdd: bad connect for PCWORK, errno 9
errno=<PIN_ERR_DM_CONNECT_FAILED:26> location=<Unknown pin location:0> class=<UN
KNOWN:0> field num=<0:0,0> recid=<0> reserved=<9>
pcmdd: bad connect for PCWORK, errno 9
errno=<PIN_ERR_DM_CONNECT_FAILED:26> location=<Unknown pin location:0> class=<UN
KNOWN:0> field num=<0:0,0> recid=<0> reserved=<9>
pcmdd: bad connect for PCWORK, errno 9
errno=<PIN_ERR_DM_CONNECT_FAILED:26> location=<Unknown pin location:0> class=<UN
KNOWN:0> field num=<0:0,0> recid=<0> reserved=<9>
pcmdd: bad connect for PCWORK, errno 9
errno=<PIN_ERR_DM_CONNECT_FAILED:26> location=<Unknown pin location:0> class=<UN
KNOWN:0> field num=<0:0,0> recid=<0> reserved=<9>
pcmdd: bad connect for PCWORK, errno 9
errno=<PIN_ERR_DM_CONNECT_FAILED:26> location=<Unknown pin location:0> class=<UN
KNOWN:0> field num=<0:0,0> recid=<0> reserved=<9>
pcmdd: bad connect for PCWORK, errno 9
errno=<PIN_ERR_DM_CONNECT_FAILED:26> location=<Unknown pin location:0> class=<UN
KNOWN:0> field num=<0:0,0> recid=<0> reserved=<9>
pcmdd: bad connect for PCWORK, errno 9
errno=<PIN_ERR_DM_CONNECT_FAILED:26> location=<Unknown pin location:0> class=<UN
KNOWN:0> field num=<0:0,0> recid=<0> reserved=<9>
*** Error: Unable to update the Portal Base database.
Exiting from the install without finishing successfully.
Please check for errors in C:/BRM/Portal/setup/pin_setup.log
and then rerun this program.
Press enter to continue
content of pin_setup.log_
#===========================================================
# Log for installation started at Mon Sep 5 21:04:15 2011.
#===========================================================
cm: Generating pin.conf file
pin.conf is generated under C:/BRM/Portal/sys/cm/pin.conf
pin.conf is generated under C:/BRM/Portal/apps/pin_remit/pin.conf
dm_oracle: Generating pin.conf file
pin.conf is generated under C:/BRM/Portal/setup/scripts/pin.conf
pin.conf is generated under C:/BRM/Portal/sys/dm_oracle/pin.conf
dm_oracle: Configuring database
#--- Executing SQL statement:
set heading off;
set feedback off;
select FILE_NAME from dba_data_files where TABLESPACE_NAME = 'SYSTEM';
#------------- SQL Results:
Executing sqlplus -s system/oracle@ORCL < "C:/BRM/Portal/tmp/tmp.sql"
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF
#-------------
#--- Executing SQL statement:
create tablespace pin00 datafile 'C:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/pin00.dbf' size 600M reuse autoextend on next 100M extent management local segment space management manual;
#------------- SQL Results:
Executing sqlplus -s system/oracle@ORCL < "C:/BRM/Portal/tmp/tmp.sql"
Tablespace created.
#-------------
#--- Executing SQL statement:
create tablespace pinx00 datafile 'C:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/pinx00.dbf' size 400M reuse autoextend on next 100M extent management local segment space management manual;
#------------- SQL Results:
Executing sqlplus -s system/oracle@ORCL < "C:/BRM/Portal/tmp/tmp.sql"
Tablespace created.
#-------------
#--- Executing SQL statement:
create tablespace PINTEMP datafile 'C:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/PINTEMP.dbf' size 100M reuse autoextend on next 100M extent management local segment space management manual;
#------------- SQL Results:
Executing sqlplus -s system/oracle@ORCL < "C:/BRM/Portal/tmp/tmp.sql"
Tablespace created.
#-------------
#--- Executing SQL statement:
create user pin identified by pin;
#------------- SQL Results:
Executing sqlplus -s system/oracle@ORCL < "C:/BRM/Portal/tmp/tmp.sql"
User created.
#-------------
#--- Executing SQL statement:
grant resource, connect to pin;
#------------- SQL Results:
Executing sqlplus -s system/oracle@ORCL < "C:/BRM/Portal/tmp/tmp.sql"
Grant succeeded.
#-------------
#--- Executing SQL statement:
alter user pin default tablespace pin00;
#------------- SQL Results:
Executing sqlplus -s system/oracle@ORCL < "C:/BRM/Portal/tmp/tmp.sql"
User altered.
#-------------
#--- Executing SQL statement:
set heading off;
set feedback off;
select FILE_NAME from dba_data_files where TABLESPACE_NAME = 'SYSTEM';
#------------- SQL Results:
Executing sqlplus -s system/oracle@ORCL < "C:/BRM/Portal/tmp/tmp.sql"
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF
#-------------
#--- Executing SQL statement:
--
-- @(#)%Portal Version: create_dd.source:BillingVelocityInt:4:2006-Sep-14 18:49:48 %
--
-- Copyright (c) 1996 - 2006 Oracle. All rights reserved.
--
-- This material is the confidential property of Oracle Corporation or its
-- licensors and may be used, reproduced, stored or transmitted only in
-- accordance with a valid Oracle license or sublicense agreement.
--
--
-- Create sequences
create sequence obj_ids start with 1000;
create sequence poid_ids2 start with 10000;
-- /dd/fields ARRAY PIN_FLD_FIELD
create table dd_fields_t (
obj_id0 int,
rec_id int,
----
field_name varchar2(255), -- PIN_FLD_FIELD_NAME
field_num int, -- PIN_FLD_FIELD_NUM
field_type int, -- PIN_FLD_FIELD_TYPE
descr varchar2(1023), -- PIN_FLD_DESCR
status int -- PIN_FLD_DESCR
) tablespace pin00 storage (initial 100k next 100k maxextents unlimited pctincrease 0 ) ;
-- /dd/objects ARRAY PIN_FLD_OBJ_DESC
create table dd_objects_t (
obj_id0 int,
name varchar2(255), -- PIN_FLD_NAME
mod_t number, -- PIN_FLD_MOD_T
state int, -- PIN_FLD_STATE
permission int, -- PIN_FLD_PERMISSION
label varchar2(255), -- PIN_FLD_LABEL
descr varchar2(1023), -- PIN_FLD_DESCR
sm_info varchar2(1023), -- PIN_FLD_SM_INFO
seq_start int, -- PIN_FLD_SEQ_START
read_access varchar2(1), -- PIN_FLD_READ_ACCESS
write_access varchar2(1), -- PIN_FLD_WRITE_ACCESS
create_access varchar2(1), -- PIN_FLD_CREATE_ACCESS
audit_flag int, -- PIN_FLD_AUDIT_FLAG
audit_scheme int, -- PIN_FLD_AUDIT_SCHEME
au_sm_info varchar2(1023), -- PIN_FLD_AU_SM_INFO
is_partitioned int, -- PIN_FLD_IS_PARTITIONED
partition_mode int, -- PIN_FLD_PARTITION_MODE
residency_type int -- PIN_FLD_RESIDENCY_TYPE
) tablespace pin00 storage (initial 100k next 100k maxextents unlimited pctincrease 0 ) ;
-- /dd/objects ARRAY PIN_FLD_OBJ_ELEM
create table dd_objects_fields_t (
obj_id0 int,
rec_id int,
----
parent_element_id int, -- PIN_FLD_PARENT_ELEMENT_ID
field_name varchar2(255), -- PIN_FLD_FIELD_NAME
field_type int, -- PIN_FLD_FIELD_TYPE
label varchar2(255), -- PIN_FLD_LABEL
descr varchar2(1023), -- PIN_FLD_DESCR
state int, -- PIN_FLD_STATE
permission int, -- PIN_FLD_PERMISSION
field_order int, -- PIN_FLD_ORDER
length int, -- PIN_FLD_LENGTH
sm_item_name varchar2(255), -- PIN_FLD_SM_ITEM_NAME
sm_item_vw_name varchar2(255), -- PIN_FLD_SM_ITEM_VW_NAME
sm_info varchar2(1023), -- PIN_FLD_SM_INFO
auditable int, -- PIN_FLD_AUDIT
queryable_on_audit int, -- PIN_FLD_QUERYABLE_ON_AUDIT
ignore_on_audit int, -- PIN_FLD_IGNORE_ON_AUDIT
encryptable int, -- PIN_FLD_ENCRYPT
serializable int -- PIN_FLD_SERIALIZABLE
) tablespace pin00 storage (initial 200k next 200k maxextents unlimited pctincrease 0 ) ;
-- New table for storing encrypted-Aes keys
-- cryptkey_t
create table cryptkey_t (
crypt_scheme varchar2(10), -- to store scheme name
crypt_key_id int, -- to store key_id
crypt_key varchar2(255) -- to store actual key
) tablespace pin00 storage (initial 100k next 100k maxextents unlimited pctincrease 0 ) ;
-- New table for storing the converted table information
create table aes_crypt_details_t (
table_name varchar2(32),
field_name varchar2(32),
old_size int,
new_size int
) tablespace pin00 storage (initial 100k next 100k maxextents unlimited pctincrease 0 ) ;
-- /dd
create unique index i_dd_objects__id on dd_objects_t ( obj_id0 )
tablespace pinx00 storage (initial 100k next 100k maxextents unlimited pctincrease 0 );
create unique index i_dd_objects_fields__id on dd_objects_fields_t ( obj_id0, rec_id, parent_element_id, field_name)
tablespace pinx00 storage (initial 200k next 200k maxextents unlimited pctincrease 0 );
create unique index i_dd_fields__id on dd_fields_t ( obj_id0, rec_id )
tablespace pinx00 storage (initial 100k next 100k maxextents unlimited pctincrease 0 );
-- crypt
create unique index i_cryptkey__scheme on cryptkey_t ( crypt_scheme, crypt_key_id )
tablespace pinx00 storage (initial 100k next 100k maxextents unlimited pctincrease 0 );
create unique index i_aes_crypt_details__dtls on aes_crypt_details_t ( table_name, field_name )
tablespace pinx00 storage (initial 100k next 100k maxextents unlimited pctincrease 0 );
#------------- SQL Results:
Executing sqlplus -s pin/pin@ORCL < "C:/BRM/Portal/tmp/tmp.sql"
Sequence created.
Sequence created.
Table created.
Table created.
Table created.
Table created.
Table created.
Index created.
Index created.
Index created.
Index created.
Index created.
#-------------
EBUF: errno=<PIN_ERR_DM_CONNECT_FAILED:26> location=<Unknown pin location:0> class=<UNKNOWN:0> field num=<0:0,0> recid=<0> reserved=<9>
#===========================================================
# Log for installation started at Mon Sep 5 21:13:05 2011.
#===========================================================
cm: Generating pin.conf file
pin.conf is generated under C:/BRM/Portal/sys/cm/pin.conf
pin.conf is generated under C:/BRM/Portal/apps/pin_remit/pin.conf
dm_oracle: Generating pin.conf file
pin.conf is generated under C:/BRM/Portal/setup/scripts/pin.conf
pin.conf is generated under C:/BRM/Portal/sys/dm_oracle/pin.conf
dm_oracle: Configuring database
#--- Executing SQL statement:
set heading off;
set feedback off;
select FILE_NAME from dba_data_files where TABLESPACE_NAME = 'SYSTEM';
#------------- SQL Results:
Executing sqlplus -s system/oracle@ORCL < "C:/BRM/Portal/tmp/tmp.sql"
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF
#-------------
#--- Executing SQL statement:
create tablespace pin00 datafile 'C:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/pin00.dbf' size 600M reuse autoextend on next 100M extent management local segment space management manual;
#------------- SQL Results:
Executing sqlplus -s system/oracle@ORCL < "C:/BRM/Portal/tmp/tmp.sql"
create tablespace pin00 datafile 'C:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/pin00.dbf' size 600M reuse autoextend on next 100M extent management local segment space management manual
*
ERROR at line 1:
ORA-01543: tablespace 'PIN00' already exists
#-------------
#--- Executing SQL statement:
create tablespace pinx00 datafile 'C:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/pinx00.dbf' size 400M reuse autoextend on next 100M extent management local segment space management manual;
#------------- SQL Results:
Executing sqlplus -s system/oracle@ORCL < "C:/BRM/Portal/tmp/tmp.sql"
create tablespace pinx00 datafile 'C:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/pinx00.dbf' size 400M reuse autoextend on next 100M extent management local segment space management manual
*
ERROR at line 1:
ORA-01543: tablespace 'PINX00' already exists
#-------------
#--- Executing SQL statement:
create tablespace PINTEMP datafile 'C:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/PINTEMP.dbf' size 100M reuse autoextend on next 100M extent management local segment space management manual;
#------------- SQL Results:
Executing sqlplus -s system/oracle@ORCL < "C:/BRM/Portal/tmp/tmp.sql"
create tablespace PINTEMP datafile 'C:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/PINTEMP.dbf' size 100M reuse autoextend on next 100M extent management local segment space management manual
*
ERROR at line 1:
ORA-01543: tablespace 'PINTEMP' already exists
#-------------
#--- Executing SQL statement:
create user pin identified by pin;
#------------- SQL Results:
Executing sqlplus -s system/oracle@ORCL < "C:/BRM/Portal/tmp/tmp.sql"
create user pin identified by pin
*
ERROR at line 1:
ORA-01920: user name 'PIN' conflicts with another user or role name
#-------------
#--- Executing SQL statement:
grant resource, connect to pin;
#------------- SQL Results:
Executing sqlplus -s system/oracle@ORCL < "C:/BRM/Portal/tmp/tmp.sql"
Grant succeeded.
#-------------
#--- Executing SQL statement:
alter user pin default tablespace pin00;
#------------- SQL Results:
Executing sqlplus -s system/oracle@ORCL < "C:/BRM/Portal/tmp/tmp.sql"
User altered.
#-------------
#--- Executing SQL statement:
set heading off;
set feedback off;
select FILE_NAME from dba_data_files where TABLESPACE_NAME = 'SYSTEM';
#------------- SQL Results:
Executing sqlplus -s system/oracle@ORCL < "C:/BRM/Portal/tmp/tmp.sql"
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF
#-------------
#--- Executing SQL statement:
--
-- @(#) % %
--
-- Copyright (c) 1996 - 2006 Oracle. All rights reserved.
--
-- This material is the confidential property of Oracle Corporation or its
-- licensors and may be used, reproduced, stored or transmitted only in
-- accordance with a valid Oracle license or sublicense agreement.
--
--
-- sql file to drop Infranet Snapshots;
set serveroutput on;
DECLARE
tname varchar2(40);
tcount number;
cid int;
BEGIN
select count(*) into tcount from user_tables where table_name like
'DD_OBJECTS_FIELDS_T';
if tcount = 0 then
cid := DBMS_SQL.OPEN_CURSOR;
DBMS_SQL.PARSE (cid,
'CREATE TABLE DD_OBJECTS_FIELDS_T ' ||
'(PARENT_ELEMENT_ID int, SM_ITEM_NAME VARCHAR2(255))',
dbms_sql.v7);
DBMS_SQL.CLOSE_CURSOR(cid);
end if;
END;
/
--------------------------------------------------------------------------
-- DROP THE SNAPSHOT LOGS
--------------------------------------------------------------------------
DECLARE
cursor c1 is
SELECT distinct master
FROM dd_objects_fields_t, USER_SNAPSHOTS where
UPPER(sm_item_name ) like '%' || master || '%';
cursor c2 is
SELECT distinct master
FROM dd_objects_fields_t, USER_SNAPSHOT_LOGS where
UPPER(sm_item_name ) like '%' || master || '%';
tname c1%ROWTYPE;
lname c2%ROWTYPE;
t_name varchar2(255);
l_name varchar2(255);
snapshot_count number(38) := 0;
cid int :=0;
BEGIN
-- drop existing multi-dB snapshot LOGS
--
FOR lname in c2
LOOP
dbms_output.enable(10000);
dbms_output.put_line(lname.master);
l_name := lname.master;
select count(*) into snapshot_count from
user_snapshot_LOGS where master LIKE '%' || UPPER(l_name) || '%';
if snapshot_count > 0 then
dbms_output.put_line('dropping SNAPSHOT LOG on ' ||
l_name || '...');
cid := DBMS_SQL.OPEN_CURSOR;
DBMS_SQL.PARSE (cid,
'DROP SNAPSHOT LOG ON ' ||
l_name,
dbms_sql.v7);
DBMS_SQL.CLOSE_CURSOR(cid);
else
dbms_output.put_line('No snapshot logs Found');
end if;
END LOOP;
-- drop existing multi-dB snapshots
--
FOR tname in c1
LOOP
dbms_output.enable(10000);
dbms_output.put_line(tname.master);
t_name := tname.master;
select count(*) into snapshot_count from
user_snapshots where master LIKE '%' || UPPER(t_name) || '%';
if snapshot_count > 0 then
dbms_output.put_line('dropping SNAPSHOT ' ||
t_name || '...');
cid := DBMS_SQL.OPEN_CURSOR;
DBMS_SQL.PARSE (cid,
'DROP SNAPSHOT ' ||
t_name,
dbms_sql.v7);
DBMS_SQL.CLOSE_CURSOR(cid);
else
dbms_output.put_line('No snapshots Found');
end if;
END LOOP;
END;
/
DECLARE
tcount number;
cid int;
BEGIN
select count(*) into tcount from user_tab_columns where table_name like
'DD_OBJECTS_FIELDS_T';
if tcount = 2 then
cid := DBMS_SQL.OPEN_CURSOR;
DBMS_SQL.PARSE (cid,
'DROP TABLE DD_OBJECTS_FIELDS_T ',
dbms_sql.v7);
DBMS_SQL.CLOSE_CURSOR(cid);
end if;
END;
/
#------------- SQL Results:
Executing sqlplus -s pin/pin@ORCL < "C:/BRM/Portal/tmp/tmp.sql"
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
#-------------
#--- Executing SQL statement:
--
-- Copyright (c) 2007 Oracle. All rights reserved.
--
-- This material is the confidential property of Oracle Corporation or its
-- licensors and may be used, reproduced, stored or transmitted only in
-- accordance with a valid Oracle license or sublicense agreement.
--
--
-- This file has been generated automatically at build time
-- from object specifications on Wed Sep 12 13:10:56 2007.
--
-- USE THIS FILE WITH CAUTION: NOT FOR USE IN PRODUCTION ENVIRONMENTS
--
declare
cursor c1 is select sm_item_name from dd_objects_fields_t where sm_item_name not like ':%';
tname c1%ROWTYPE;
cid int;
cnt int;
thename varchar(80);
begin
for tname in c1
loop
cid := DBMS_SQL.OPEN_CURSOR;
if tname.sm_item_name not like 'C%' then
select count(*) into cnt from user_tables where table_name = upper(tname.sm_item_name);
if (cnt > 0) then
DBMS_SQL.PARSE(cid, 'DROP TABLE ' || tname.sm_item_name, dbms_sql.v7);
end if;
else
cnt := instr(tname.sm_item_name, 'T=');
thename := substr(tname.sm_item_name, cnt + 2);
select count(*) into cnt from user_tables where table_name = upper(thename);
if (cnt > 0) then
DBMS_SQL.PARSE(cid, 'DROP TABLE ' || thename, dbms_sql.v7);
end if;
end if;
DBMS_SQL.CLOSE_CURSOR(cid);
end loop;
end;
/
drop table dd_objects_t;
drop table dd_objects_fields_t;
drop table dd_fields_t;
drop sequence obj_ids;
drop sequence poid_ids2;
drop table cryptkey_t;
drop table aes_crypt_details_t;
drop synonym event_v;
drop synonym event_bal_impacts_v;
drop synonym event_total_v;
drop synonym event_tax_jurisdictions_v;
#------------- SQL Results:
Executing sqlplus -s pin/pin@ORCL < "C:/BRM/Portal/tmp/tmp.sql"
PL/SQL procedure successfully completed.
Table dropped.
Table dropped.
Table dropped.
Sequence dropped.
Sequence dropped.
Table dropped.
Table dropped.
drop synonym event_v
*
ERROR at line 1:
ORA-01434: private synonym to be dropped does not exist
drop synonym event_bal_impacts_v
*
ERROR at line 1:
ORA-01434: private synonym to be dropped does not exist
drop synonym event_total_v
*
ERROR at line 1:
ORA-01434: private synonym to be dropped does not exist
drop synonym event_tax_jurisdictions_v
*
ERROR at line 1:
ORA-01434: private synonym to be dropped does not exist
#-------------
#--- Executing SQL statement:
drop package PIN_PARTITION;
#------------- SQL Results:
Executing sqlplus -s pin/pin@ORCL < "C:/BRM/Portal/tmp/tmp.sql"
drop package PIN_PARTITION
*
ERROR at line 1:
ORA-04043: object PIN_PARTITION does not exist
#-------------
#--- Executing SQL statement:
--
-- @(#)%Portal Version: create_dd.source:BillingVelocityInt:4:2006-Sep-14 18:49:48 %
--
-- Copyright (c) 1996 - 2006 Oracle. All rights reserved.
--
-- This material is the confidential property of Oracle Corporation or its
-- licensors and may be used, reproduced, stored or transmitted only in
-- accordance with a valid Oracle license or sublicense agreement.
--
--
-- Create sequences
create sequence obj_ids start with 1000;
create sequence poid_ids2 start with 10000;
-- /dd/fields ARRAY PIN_FLD_FIELD
create table dd_fields_t (
obj_id0 int,
rec_id int,
----
field_name varchar2(255), -- PIN_FLD_FIELD_NAME
field_num int, -- PIN_FLD_FIELD_NUM
field_type int, -- PIN_FLD_FIELD_TYPE
descr varchar2(1023), -- PIN_FLD_DESCR
status int -- PIN_FLD_DESCR
) tablespace pin00 storage (initial 100k next 100k maxextents unlimited pctincrease 0 ) ;
-- /dd/objects ARRAY PIN_FLD_OBJ_DESC
create table dd_objects_t (
obj_id0 int,
name varchar2(255), -- PIN_FLD_NAME
mod_t number, -- PIN_FLD_MOD_T
state int, -- PIN_FLD_STATE
permission int, -- PIN_FLD_PERMISSION
label varchar2(255), -- PIN_FLD_LABEL
descr varchar2(1023), -- PIN_FLD_DESCR
sm_info varchar2(1023), -- PIN_FLD_SM_INFO
seq_start int, -- PIN_FLD_SEQ_START
read_access varchar2(1), -- PIN_FLD_READ_ACCESS
write_access varchar2(1), -- PIN_FLD_WRITE_ACCESS
create_access varchar2(1), -- PIN_FLD_CREATE_ACCESS
audit_flag int, -- PIN_FLD_AUDIT_FLAG
audit_scheme int, -- PIN_FLD_AUDIT_SCHEME
au_sm_info varchar2(1023), -- PIN_FLD_AU_SM_INFO
is_partitioned int, -- PIN_FLD_IS_PARTITIONED
partition_mode int, -- PIN_FLD_PARTITION_MODE
residency_type int -- PIN_FLD_RESIDENCY_TYPE
) tablespace pin00 storage (initial 100k next 100k maxextents unlimited pctincrease 0 ) ;
-- /dd/objects ARRAY PIN_FLD_OBJ_ELEM
create table dd_objects_fields_t (
obj_id0 int,
rec_id int,
----
parent_element_id int, -- PIN_FLD_PARENT_ELEMENT_ID
field_name varchar2(255), -- PIN_FLD_FIELD_NAME
field_type int, -- PIN_FLD_FIELD_TYPE
label varchar2(255), -- PIN_FLD_LABEL
descr varchar2(1023), -- PIN_FLD_DESCR
state int, -- PIN_FLD_STATE
permission int, -- PIN_FLD_PERMISSION
field_order int, -- PIN_FLD_ORDER
length int, -- PIN_FLD_LENGTH
sm_item_name varchar2(255), -- PIN_FLD_SM_ITEM_NAME
sm_item_vw_name varchar2(255), -- PIN_FLD_SM_ITEM_VW_NAME
sm_info varchar2(1023), -- PIN_FLD_SM_INFO
auditable int, -- PIN_FLD_AUDIT
queryable_on_audit int, -- PIN_FLD_QUERYABLE_ON_AUDIT
ignore_on_audit int, -- PIN_FLD_IGNORE_ON_AUDIT
encryptable int, -- PIN_FLD_ENCRYPT
serializable int -- PIN_FLD_SERIALIZABLE
) tablespace pin00 storage (initial 200k next 200k maxextents unlimited pctincrease 0 ) ;
-- New table for storing encrypted-Aes keys
-- cryptkey_t
create table cryptkey_t (
crypt_scheme varchar2(10), -- to store scheme name
crypt_key_id int, -- to store key_id
crypt_key varchar2(255) -- to store actual key
) tablespace pin00 storage (initial 100k next 100k maxextents unlimited pctincrease 0 ) ;
-- New table for storing the converted table information
create table aes_crypt_details_t (
table_name varchar2(32),
field_name varchar2(32),
old_size int,
new_size int
) tablespace pin00 storage (initial 100k next 100k maxextents unlimited pctincrease 0 ) ;
-- /dd
create unique index i_dd_objects__id on dd_objects_t ( obj_id0 )
tablespace pinx00 storage (initial 100k next 100k maxextents unlimited pctincrease 0 );
create unique index i_dd_objects_fields__id on dd_objects_fields_t ( obj_id0, rec_id, parent_element_id, field_name)
tablespace pinx00 storage (initial 200k next 200k maxextents unlimited pctincrease 0 );
create unique index i_dd_fields__id on dd_fields_t ( obj_id0, rec_id )
tablespace pinx00 storage (initial 100k next 100k maxextents unlimited pctincrease 0 );
-- crypt
create unique index i_cryptkey__scheme on cryptkey_t ( crypt_scheme, crypt_key_id )
tablespace pinx00 storage (initial 100k next 100k maxextents unlimited pctincrease 0 );
create unique index i_aes_crypt_details__dtls on aes_crypt_details_t ( table_name, field_name )
tablespace pinx00 storage (initial 100k next 100k maxextents unlimited pctincrease 0 );
#------------- SQL Results:
Executing sqlplus -s pin/pin@ORCL < "C:/BRM/Portal/tmp/tmp.sql"
Sequence created.
Sequence created.
Table created.
Table created.
Table created.
Table created.
Table created.
Index created.
Index created.
Index created.
Index created.
Index created.
#-------------
EBUF: errno=<PIN_ERR_DM_CONNECT_FAILED:26> location=<Unknown pin location:0> class=<UNKNOWN:0> field num=<0:0,0> recid=<0> reserved=<9>
Edited by: oracledigger on 5 sept. 2011 10:32