BR1001I BRSPACE 7.20 (42) BR1002I Start of BRSPACE processing: sfncermj.tse 2023-11-15 16.20.37 BR0484I BRSPACE log file: /oracle/EPP/sapreorg/sfncermj.tse BR0101I Parameters Name Value oracle_sid EPP oracle_home /oracle/EPP/112_64 oracle_profile /oracle/EPP/112_64/dbs/initEPP.ora sapdata_home /oracle/EPP sap_profile /oracle/EPP/112_64/dbs/initEPP.sap space_function tsextend space_copy_dir /oracle/EPP/sapreorg scroll_lines 20 system_info oraepp/oraepp epprda AIX 2 7 00C44AF14B00 oracle_info EPP 11.2.0.3.0 8192 26772 5501117403 epprda UTF8 UTF8 255849424 &EPP sap_info SAPSR3DB make_info rs6000_64 OCI_112 May 25 2015 722_EXT_REL command_line /usr/sap/EPP/SYS/exe/run/brspace -p initEPP.sap -s 20 -l E -u / -f tsextend br_env NLS_LANG=AMERICAN_AMERICA.UTF8, ORACLE_BASE=/oracle, ORACLE_SID=EPP, DB_SID=EPP, DIR_LIBRARY=/usr/sap/EPP/SYS/exe/run, BR_NNG=1, SAPEXE=/usr/sap/EPP/SYS/exe/run, SAPDATA_HOME=/oracle/EPP, ORACLE_HOME=/oracle/EPP/112_64, SAPSYSTEMNAME=EPP BR0280I BRSPACE time stamp: 2023-11-15 16.20.37 BR1009I Name of database instance: EPP BR1010I BRSPACE action ID: sfncermj BR1011I BRSPACE function ID: tse BR1012I BRSPACE function: tsextend BR0280I BRSPACE time stamp: 2023-11-15 16.20.37 BR0656I Choice menu 301 - please make a selection ------------------------------------------------------------------------------- Tablespace extension main menu 1 = Extend tablespace 2 - Show tablespaces 3 - Show data files 4 - Show disk volumes 5 * Exit program 6 - Reset program status Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------- BR0662I Enter your choice: BR0280I BRSPACE time stamp: 2023-11-15 16.20.38 BR0663I Your choice: '1' BR0280I BRSPACE time stamp: 2023-11-15 16.20.38 BR0658I List menu 302 - please select one entry ------------------------------------------------------------------------------- List of tablespaces for extension Pos. Tablespace Files/AuExt. Total[KB] Used[%] Free[KB] MaxSize[KB] 1 - PSAPSR3DB 2/2 12697600 58.52 5266944 20480000 2 - PSAPTEMP 1/1 1495040 0.68 1484800 10240000 3 - PSAPUNDO 1/1 1617920 0.06 1616896 10240000 4 - SYSAUX 1/1 1310720 93.75 81984 10240000 5 - SYSTEM 1/1 460800 64.69 162688 10240000 Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------- BR0662I Enter your selection: BR0280I BRSPACE time stamp: 2023-11-15 16.21.20 BR0663I Your selection: '4' BR0280I BRSPACE time stamp: 2023-11-15 16.21.20 BR0657I Input menu 303 - please enter/check input values ------------------------------------------------------------------------------- Options for extension of tablespace SYSAUX (1. file) 1 * Last added file name (lastfile) ....... [/oracle/EPP/sapdata1/sysaux_1/sysaux.data1] 2 * Last added file size in MB (lastsize) . [1280] 3 - New file to be added (file) ........... [/oracle/EPP/sapdata1/sysaux_2/sysaux.data2] 4 ~ Raw disk / link target (rawlink) ...... [] 5 - Size of the new file in MB (size) ..... [1280] 6 - File autoextend mode (autoextend) ..... [yes] 7 - Maximum file size in MB (maxsize) ..... [10000] 8 - File increment size in MB (incrsize) .. [20] 9 - SQL command (command) ................. [alter tablespace SYSAUX add datafile '/oracle/EPP/sapdata1/sysaux_2/sysaux.data2' size 1280M autoextend on next 20M maxsize 10000M] Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------- BR0662I Enter your choice: BR0280I BRSPACE time stamp: 2023-11-15 16.21.43 BR0663I Your choice: '7' BR0682I Enter integer value for "maxsize" (0-32767) [10000]: BR0280I BRSPACE time stamp: 2023-11-15 16.21.45 BR0683I New value for "maxsize": '1000' BR0280I BRSPACE time stamp: 2023-11-15 16.21.45 BR0657I Input menu 303 - please enter/check input values ------------------------------------------------------------------------------- Options for extension of tablespace SYSAUX (1. file) 1 * Last added file name (lastfile) ....... [/oracle/EPP/sapdata1/sysaux_1/sysaux.data1] 2 * Last added file size in MB (lastsize) . [1280] 3 - New file to be added (file) ........... [/oracle/EPP/sapdata1/sysaux_2/sysaux.data2] 4 ~ Raw disk / link target (rawlink) ...... [] 5 - Size of the new file in MB (size) ..... [1280] 6 - File autoextend mode (autoextend) ..... [yes] 7 - Maximum file size in MB (maxsize) ..... [1000] 8 - File increment size in MB (incrsize) .. [20] 9 - SQL command (command) ................. [alter tablespace SYSAUX add datafile '/oracle/EPP/sapdata1/sysaux_2/sysaux.data2' size 1280M autoextend on next 20M maxsize 1000M] Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------- BR0662I Enter your choice: BR0280I BRSPACE time stamp: 2023-11-15 16.21.50 BR0663I Your choice: 'c' BR0259I Program execution will be continued... BR1091I Next data file can be specified now BR0280I BRSPACE time stamp: 2023-11-15 16.21.50 BR0675I This is a optional action - do you want to execute it now? BR0676I Enter 'y[es]' to execute the action, 'n[o]/c[ont]' to skip it, 's[top]' to abort: BR0280I BRSPACE time stamp: 2023-11-15 16.21.51 BR0257I Your reply: 'c' BR0678I The action will be skipped... BR0259I Program execution will be continued... BR0370I Directory /oracle/EPP/sapreorg/sfncermj created BR0280I BRSPACE time stamp: 2023-11-15 16.21.51 BR0319I Control file copy created: /oracle/EPP/sapreorg/sfncermj/cntrlEPP.old 15286272 BR0370I Directory /oracle/EPP/sapdata1/sysaux_2 created BR0280I BRSPACE time stamp: 2023-11-15 16.21.51 BR1088I Extending tablespace SYSAUX ... BR0280I BRSPACE time stamp: 2023-11-15 16.21.51 BR0301E SQL error -2494 at location BrSqlExecute-1, SQL statement: '/* BRSPACE */ alter tablespace SYSAUX add datafile '/oracle/EPP/sapdata1/sysaux_2/sysaux.data2' size 1280M autoextend on next 20M maxsize 1000M' ORA-02494: invalid or missing maximum file size in MAXSIZE clause BR1017E Execution of SQL statement '/* BRSPACE */ alter tablespace SYSAUX add datafile '/oracle/EPP/sapdata1/sysaux_2/sysaux.data2' size 1280M autoextend on next 20M maxsize 1000M' failed BR0280I BRSPACE time stamp: 2023-11-15 16.21.51 BR0669I Cannot continue due to previous warnings or errors - you can go back and repeat the last action BR0671I Enter 'b[ack]' to go back, 's[top]' to abort: BR0280I BRSPACE time stamp: 2023-11-15 16.22.02 BR0257I Your reply: 'b' BR0673I Going back to the previous menu... BR0280I BRSPACE time stamp: 2023-11-15 16.22.02 BR0657I Input menu 303 - please enter/check input values ------------------------------------------------------------------------------- Options for extension of tablespace SYSAUX (1. file) 1 * Last added file name (lastfile) ....... [/oracle/EPP/sapdata1/sysaux_1/sysaux.data1] 2 * Last added file size in MB (lastsize) . [1280] 3 - New file to be added (file) ........... [/oracle/EPP/sapdata1/sysaux_2/sysaux.data2] 4 ~ Raw disk / link target (rawlink) ...... [] 5 - Size of the new file in MB (size) ..... [1280] 6 - File autoextend mode (autoextend) ..... [yes] 7 - Maximum file size in MB (maxsize) ..... [1000] 8 - File increment size in MB (incrsize) .. [20] 9 - SQL command (command) ................. [alter tablespace SYSAUX add datafile '/oracle/EPP/sapdata1/sysaux_2/sysaux.data2' size 1280M autoextend on next 20M maxsize 1000M] Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------- BR0662I Enter your choice: BR0280I BRSPACE time stamp: 2023-11-15 16.22.04 BR0663I Your choice: '7' BR0682I Enter integer value for "maxsize" (0-32767) [1000]: BR0280I BRSPACE time stamp: 2023-11-15 16.22.05 BR0683I New value for "maxsize": '1280' BR0280I BRSPACE time stamp: 2023-11-15 16.22.05 BR0657I Input menu 303 - please enter/check input values ------------------------------------------------------------------------------- Options for extension of tablespace SYSAUX (1. file) 1 * Last added file name (lastfile) ....... [/oracle/EPP/sapdata1/sysaux_1/sysaux.data1] 2 * Last added file size in MB (lastsize) . [1280] 3 - New file to be added (file) ........... [/oracle/EPP/sapdata1/sysaux_2/sysaux.data2] 4 ~ Raw disk / link target (rawlink) ...... [] 5 - Size of the new file in MB (size) ..... [1280] 6 - File autoextend mode (autoextend) ..... [yes] 7 - Maximum file size in MB (maxsize) ..... [1280] 8 - File increment size in MB (incrsize) .. [20] 9 - SQL command (command) ................. [alter tablespace SYSAUX add datafile '/oracle/EPP/sapdata1/sysaux_2/sysaux.data2' size 1280M autoextend on next 20M maxsize 1280M] Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------- BR0662I Enter your choice: BR0280I BRSPACE time stamp: 2023-11-15 16.22.06 BR0663I Your choice: 'c' BR0259I Program execution will be continued... BR1091I Next data file can be specified now BR0280I BRSPACE time stamp: 2023-11-15 16.22.06 BR0675I This is a optional action - do you want to execute it now? BR0676I Enter 'y[es]' to execute the action, 'n[o]/c[ont]' to skip it, 's[top]' to abort: BR0280I BRSPACE time stamp: 2023-11-15 16.22.07 BR0257I Your reply: 'c' BR0678I The action will be skipped... BR0259I Program execution will be continued... BR0280I BRSPACE time stamp: 2023-11-15 16.22.07 BR1088I Extending tablespace SYSAUX ... BR0280I BRSPACE time stamp: 2023-11-15 16.22.09 BR1016I SQL statement 'alter tablespace SYSAUX add datafile '/oracle/EPP/sapdata1/sysaux_2/sysaux.data2' size 1280M autoextend on next 20M maxsize 1280M' executed successfully BR1051I Tablespace SYSAUX extended successfully with file: /oracle/EPP/sapdata1/sysaux_2/sysaux.data2 1280M BR0280I BRSPACE time stamp: 2023-11-15 16.22.09 BR0340I Switching to the next online redolog file for database instance EPP ... BR0321I Switch to the next online redolog file for database instance EPP successful BR0280I BRSPACE time stamp: 2023-11-15 16.22.10 BR0319I Control file copy created: /oracle/EPP/sapreorg/sfncermj/cntrlEPP.new 15286272 BR0280I BRSPACE time stamp: 2023-11-15 16.22.10 BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRSPACE: BR0280I BRSPACE time stamp: 2023-11-15 16.22.12 BR0257I Your reply: 'c' BR0259I Program execution will be continued... BR0280I BRSPACE time stamp: 2023-11-15 16.22.12 BR0656I Choice menu 301 - please make a selection ------------------------------------------------------------------------------- Tablespace extension main menu 1 + Extend tablespace 2 - Show tablespaces 3 - Show data files 4 - Show disk volumes 5 = Exit program 6 - Reset program status Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------- BR0662I Enter your choice: BR0280I BRSPACE time stamp: 2023-11-15 16.22.12 BR0663I Your choice: '1' BR0280I BRSPACE time stamp: 2023-11-15 16.22.13 BR0658I List menu 302 - please select one entry ------------------------------------------------------------------------------- List of tablespaces for extension Pos. Tablespace Files/AuExt. Total[KB] Used[%] Free[KB] MaxSize[KB] 1 - PSAPSR3DB 2/2 12697600 58.52 5266944 20480000 2 - PSAPTEMP 1/1 1495040 0.68 1484800 10240000 3 - PSAPUNDO 1/1 1617920 0.06 1616896 10240000 4 - SYSAUX 2/2 2621440 46.91 1391680 11550720 5 - SYSTEM 1/1 460800 64.69 162688 10240000 Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------- BR0662I Enter your selection: BR0280I BRSPACE time stamp: 2023-11-15 16.23.09 BR0663I Your selection: 's' BR0679I Do you really want to cancel BRSPACE? Enter y[es]/n[o]: BR0280I BRSPACE time stamp: 2023-11-15 16.23.10 BR0257I Your reply: 'y' BR0260E BRSPACE cancelled by user BR1008I End of BRSPACE processing: sfncermj.tse 2023-11-15 16.23.10 BR0280I BRSPACE time stamp: 2023-11-15 16.23.10 BR1007I BRSPACE terminated with errors