User export failed with error EXP-00008/ORA-00904: "MAXSIZE"/"OLEVEL": invalid identifier

User export failed with error EXP-00008/ORA-00904: "MAXSIZE"/"OLEVEL": invalid identifier

EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table DMI_DIST_COMP_RECORD_R

EXP-00008: ORACLE error 904 encountered
ORA-00904: "MAXSIZE": invalid identifier
. . exporting table DMI_DIST_COMP_RECORD_S

EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table DMI_DUMP_OBJECT_RECORD_S

EXP-00008: ORACLE error 904 encountered
ORA-00904: "MAXSIZE": invalid identifier
. . exporting table DMI_EXPR_CODE_S

EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table DMI_INDEX_R

Cause:
Depends upon the version mismatch.
like if you trying to take a export from 11.x.x.x.x home to 10.x.x.x.x dump file, you will get this error.

Solution:
If you want to take exp from db version 10.x.x.x.x serious, try it from some other database with same version.


example:
cd /opt/oracle/product/11.1.0.7/db_1/bin
./exp system/password@10gdb(tnshostname) full=y file=/oradata/export/prod007.dmp log==/oradata/export/prod007.log

you will get below error...
User export failed with error EXP-00008/ORA-00904: "MAXSIZE": invalid identifier




see Metalink ID :-741984.1

RMAN-03002, RMAN-06403, ORA-01034, ORA-27101: shared memory realm does not exist

using target database control file instead of recovery catalog

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of allocate command at 01/04/2012 13:25:07
RMAN-06403: could not obtain a fully authorized session
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist

Check your database is running or down by

$ps -ef | grep pmon

sekiazubck05.rman06> ps -ef | grep pmon
oracle 352464           1 0     Jun 16 - 42:56 ora_pmon_dbname
oracle 688150 962658 0 18:17:10 pts/0 0:00 grep pmon

it shows like this, your db is running. otherwise check your instance

ORA-00059: maximum number of DB_FILES exceeded

SQL> create tablespace 0362_363 DATAFILE '/oradata/rman/data/0362_01.dbf' SIZE 100M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 150M
*
ERROR at line 1:
ORA-00059: maximum number of DB_FILES exceeded

SQL> show parameter db_files
db_file_name_convert                string                             0
db_files                                      integer                          200

Cause: You are trying add more datafile then limit. the limit is 200 only.
Solution:
SQL>alter system set db_files = 256 scope = spfile;
 
SQL>shutdown immediate;
 
SQL> startup
 
SQL> sho parameter db_files
 db_files                               integer                             256

now ...
SQL>create spfile from pfile [path];

ORA-01092, ORA-01501, ORA-00450, ORA-00444, ORA-00020: maximum number of processes () exceeded

CREATE DATABASE D0308W

*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-01501: CREATE DATABASE failed
ORA-00450: background process 'QMNC' did not start
ORA-00444: background process "QMNC" failed while starting
ORA-00020: maximum number of processes () exceeded
Process ID: 2192
Session ID: 27 Serial number: 3

Cause : Minimum default process required.
Solutiion: Increase process values to 150(default)

ORA-12560: TNS Protocol adapter error on Windows

ORA-12560: TNS Protocol adapter error

if you tried you connect database, it seems to be create a service,
open command prompt and run "oradim"

if you are going to create new db, service should be in started.
orelse
create new service like
C:\> oradim   -NEW -SID [dbname]-SYSPWD [syspassword] -STARTMODE auto
Instance started.


Now you can connect.