Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

XE 11.2.0.2.0 DBSNMP.BSLN_INTERNAL, TABLESPACE "SYSAUX" (ORA-02236 )

user9024577Jun 6 2012 — edited Jun 13 2012
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 11 2012
Added on Jun 6 2012
4 comments
1,111 views