XE 11.2.0.2.0 DBSNMP.BSLN_INTERNAL, TABLESPACE "SYSAUX" (ORA-02236 )
hi,
i have installed XE 11.2.0.2 on Linux 3.1.10-1.9-desktop (Suse) with:
rpm -ivh oracle-xe-11.2.0-1.0.x86_64.rpm.
without errors in logfiles, but anyway i have two small problems:
1. Erros in file /u01/app/oracle/diag/rdbms/xe/XE/trace/alert_XE.log:
ORA-12012: error on auto execute of job "SYS"."BSLN_MAINTAIN_STATS_JOB"
ORA-06550: line 1, column 807:
PLS-00201: identifier 'DBSNMP.BSLN_INTERNAL' must be declared*
After installation, I have not found in the table dba_users the user dbsnmp and started for this reason from
$ORACLE_HOME/rdbms/admin two scripts (sqlplus sys / as sysdba ..) :
catnsnmp.sql and catsnmp.sql
Question: have i done it right?
2. I tested expdp und impdp with full=Y und impdp-logifile shows this error:
ORA-39083: Object type TABLESPACE failed to create with error:
ORA-02236: invalid file name
Failing sql is:
+CREATE TABLESPACE "SYSAUX" DATAFILE SIZE 10485760 AUTOEXTEND ON NEXT 10485760 MAXSIZE 32767M,'/u01/app/oracle/oradata/XE/sysaux.dbf'+
SIZE 10485760 AUTOEXTEND ON NEXT 10485760 MAXSIZE 32767M LOGGING ONLINE PERMANENT BLOCKSIZE 8192 EXTENT MANAGEMENT
LOCAL AUTOALLOCATE DEFAULT NOCOMPRESS SEGMENT SPACE MANAGEMENT AUTO
The CREATE TABLESPACE statement contains a syntax error, because the word "DATAFILE" contains the following string
SIZE 10485760 AUTOEXTEND ON NEXT 10485760 MAXSIZE 32767M,
I asked Metadata with:
select dbms_metadata.get_ddl('TABLESPACE','SYSAUX') from dual
and DD has the same syntax error:
DBMS_METADATA.GET_DDL('TABLESPACE','SYSAUX')
--------------------------------------------------------------------------------
CREATE TABLESPACE "SYSAUX" DATAFILE
SIZE 10485760 AUTOEXTEND ON NEXT 10485760 MAXSIZE 32767M,
'/u01/app/oracle/oradata/XE/sysaux.dbf' SIZE 10485760
AUTOEXTEND ON NEXT 10485760 MAXSIZE 32767M
LOGGING ONLINE PERMANENT BLOCKSIZE 8192
EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT NOCOMPRESS SEGMENT SPACE MANAGEMENT AUTO
Has someone the same effect with 11g XE? How can I fix it?
Best regards
Jan