Skip to content

Instantly share code, notes, and snippets.

@goutham27
Created August 22, 2016 16:20
Show Gist options
  • Save goutham27/767672a7c4be44adc7acf59e3c3e6f32 to your computer and use it in GitHub Desktop.
Save goutham27/767672a7c4be44adc7acf59e3c3e6f32 to your computer and use it in GitHub Desktop.
==> ve_oracle_centos7: Error: Execution of 'su - oracle -c "export ORACLE_SID=A0
01;export ORAENV_ASK=NO;. oraenv; sqlplus -S /nolog @/tmp/command20160822-18988
-5dgody.sql"' returned 41: The Oracle base remains unchanged with value /u01/app
/oracle
==> ve_oracle_centos7: ORACLE instance started.
==> ve_oracle_centos7: Total System Global Area,2.0267E+10,bytes
==> ve_oracle_centos7: Fixed Size , 2934840,bytes
==> ve_oracle_centos7: Variable Size ,2818574280,bytes
==> ve_oracle_centos7: Database Buffers ,1.7381E+10,bytes
==> ve_oracle_centos7: Redo Buffers , 64172032,bytes
==> ve_oracle_centos7: create database A001 user system identified by system use
r sys identified by system maxdatafiles 100 maxinstances 8 character set AL32UTF
8 national character set AL16UTF16 maxlogfiles 16 maxlogmembers 3 maxloghistory
1 noarchivelog extent management local logfile group 1 '/data/oradata/A001/redo
01.log' size 500M , group 2 '/data/oradata/A001/redo02.log' size 500M , group 3
'/data/oradata/A001/redo03.log' size 500M datafile '/data/oradata/A001/system01
.dbf' size 2000M reuse autoextend on maxsize unlimited sysaux datafile '/data/or
adata/A001/sysaux01.dbf' size 2000M reuse autoextend on maxsize unlimited defau
lt temporary tablespace TEMP tempfile '/data/oradata/A001/temp01.dbf' size 1000M
reuse
==> ve_oracle_centos7: *
==> ve_oracle_centos7: ERROR at line 1:
==> ve_oracle_centos7: ORA-03113: end-of-file on communication channel
==> ve_oracle_centos7: Process ID: 32626
==> ve_oracle_centos7: Session ID: 773 Serial number: 53686
==> ve_oracle_centos7: Error: /Stage[main]/Ve_oracle::Database/Ora_database[A001
]/ensure: change from absent to present failed: Execution of 'su - oracle -c "ex
port ORACLE_SID=A001;export ORAENV_ASK=NO;. oraenv; sqlplus -S /nolog @/tmp/com
mand20160822-18988-5dgody.sql"' returned 41: The Oracle base remains unchanged w
ith value /u01/app/oracle
==> ve_oracle_centos7: ORACLE instance started.
==> ve_oracle_centos7: Total System Global Area,2.0267E+10,bytes
==> ve_oracle_centos7: Fixed Size , 2934840,bytes
==> ve_oracle_centos7: Variable Size ,2818574280,bytes
==> ve_oracle_centos7: Database Buffers ,1.7381E+10,bytes
==> ve_oracle_centos7: Redo Buffers , 64172032,bytes
==> ve_oracle_centos7: create database A001 user system identified by system use
r sys identified by system maxdatafiles 100 maxinstances 8 character set AL32UTF
8 national character set AL16UTF16 maxlogfiles 16 maxlogmembers 3 maxloghistory
1 noarchivelog extent management local logfile group 1 '/data/oradata/A001/redo
01.log' size 500M , group 2 '/data/oradata/A001/redo02.log' size 500M , group 3
'/data/oradata/A001/redo03.log' size 500M datafile '/data/oradata/A001/system01
.dbf' size 2000M reuse autoextend on maxsize unlimited sysaux datafile '/data/or
adata/A001/sysaux01.dbf' size 2000M reuse autoextend on maxsize unlimited defau
lt temporary tablespace TEMP tempfile '/data/oradata/A001/temp01.dbf' size 1000M
reuse
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment