Oracle 10g Xe Installation notes Linuxora-01033oracle initialization or shutdown in progress

Centos for Linux6.3OS VMware Workstation9.0.0Build-812388Oracle Installation File Path: G: \ Program Files \ Red Hat Enterprise Linux4\ Exchange data \ oracle-XE-10.2.0.1-1.0. I386.rpm
 

1 down load RPM from following location

HTTP://Www.oracle.com/Technetwork/Products/Express-Edition/Downloads/Index. Html
 

 

2 installing Oracle RPM package

 
Rpm-IVH Oracle-XE-10.2.0.1-1.0. I386.rpm
 

3 Logging ing ORACLE DB

# Su root #/Etc/Init. d/Oracle-Xe configure
 

 

Set up as following (set up port listener and so on)

Oracle Database  10g express edition Configuration  --  ----------------------------------------------- This will configure On  - Boot Properties Of Oracle Database 10g expressedition. The following questions will determine whether  Database  Shouldbe starting upon system boot, the ports it will  Use , And  The passwords thatwill be used  For   Database Accounts. Press < Enter >   To  Accept the defaults. CTRL  - C will abort. Specify the http port that will be used  For Oracle Application Express [  8080  ] : 7070  Specify a port that will be used  For The Database Listener [  1521  ]  : Specify a password To Be used For   Database  Accounts. Note that the samepassword will be used  For Sys And System. Oracle recommends Use   Of  Different passwords  For Each Database  Account. This can be done afterinitial configuration: password can  ' T be null. enter Password: confirm the password: Do you want Oracle Database 10g express edition to be started on boot (y/n) [y]: Starting Oracle Net Listener... doneappsing database... donestarting Oracle Database 10g express edition instance... doneinstallation completed successfully. to access the database home page go to "http: // 127.0.0.1: 7070/apex" 

 

Oracle basic info:

Oracle_base =/ USR / Lib / Oracle / XE / App /  Oracle; ORACLE_HOME = $ Oracle_base / Product /  10.2 . 0  / Server;
--------------------------------------------
Data File Location
/Usr/lib/Oracle/Xe/oradata/XE

-RW-r ----- 1 Oracle DBA 7061504 Feb 16 control. DBF
-RW-r ----- 1 Oracle DBA 230694912 Feb 16 sysaux. DBF
-RW-r ----- 1 Oracle DBA 356524032 Feb 16 system. DBF
-RW-r ----- 1 Oracle DBA 20979712 Feb 16 temp. DBF
-RW-r ----- 1 Oracle DBA 220209152 Feb 16 undo. DBF
-RW-r ----- 1 Oracle DBA 104865792 Feb 16 users. DBF

Copy. bashrc and. bash_profile under the Home Directory of an individual user to the oracle_base directory.

 
CP/Root/. Bashrc/USR/Lib/Oracle/XE/App/Oracle/. Bashrc
 

CP/Root/. Bash_profile/USR/Lib/Oracle/XE/App/Oracle/. Bash_profile
 

Change File Ownership

 
# Chown oracle. bash_profile # chown oracle. bashrc # chmod755. Bash_profile # chmod755. Bashrc
 

Set Environment Variables

# Vi / Etc / Profile # Oracle settingstmp  =/  TMP; export tmptmpdir  =  $ TMP; export tmpdiroracle_base  =/ USR / Lib / Oracle / XE / App /  Oracle; export oracle_baseoracle_home  = $ Oracle_base / Product/  10.2 . 0  / Server / Bin /  Oracle; export oracle_homeoracle_sid  =  Xe; export oracle_sidoracle_term  =  Xterm; export oracle_termpath  =/ USR /  Sbin: $ path; export pathpath = $ ORACLE_HOME /  Bin: $ path; export pathtns_admin  = $ ORACLE_HOME / Network /  Adminld_library_path  = $ ORACLE_HOME / Lib: / Lib: / USR /  LIB; export ld_library_pathclasspath  = $ ORACLE_HOME/ Jlib: $ ORACLE_HOME / RDBMS /  Jlib; export classpath  If   [  $ User = "oracle"  ] ; Then    If   [  $ Shell = "/bin/KSh"  ] ; Then  Ulimit  - P 16384  Ulimit  - N 65536    Else  Ulimit  - U 16384   - N 65536  Fifi 

 

Initialize the database:

# Su oraclecd/USR/Lib/Oracle/XE/App/Oracle/Product/10.2.0/Server/DBS/CP init. ora initxe. oravi initxe. ora
 

 Db_name  =  '  XE  ' Memory_target  =  1 gprocesses  =   150  Audit_file_dest  =  '  /Usr/lib/Oracle/Xe/APP/Oracle/admin/Xe/adump  '  Audit_trail  =  '  DB  '  Db_block_size =  8192  Db_domain  =  ''  # Db_recovery_file_dest  =  '  /U01/APP/Oracle/fast_recovery_area  '  # Db_recovery_file_dest_size  =  2gdiagnostic_dest  =  '  /Usr/lib/Oracle/Xe/APP/Oracle '  Dispatchers  =  '  (Protocol = TCP) (Service = orclxdb)  '  Open_cursors  =  300  Remote_login_passwordfile  =  '  Exclusive  '  Undo_tablespace  = '  Undotbs1  '  # You may want  To Ensure that control files are created On  Separate physical # devicescontrol_files  = ( '  /Usr/lib/Oracle/Xe/oradata  ' , '  /Usr/lib/Oracle/Xe/oradata  '  ) Compatible =  '  10.2.0  ' 

 
# Su oraclesqlplus/Nolog
SQL> connect sys/cici123love as sysdba
SQL> startup Mount
 

 

The 10g Xe version has a built-in set database XE, so you are not allowed to manually create a database, but you need to initialize the database structure

Run the following two lines:Code:

SQL > @ / USR / Lib / Oracle / XE/ App / Oracle / Product /  10.2 . 0  / Server / RDBMS / Admin /  Catalog. sqlsql  > @ / USR / Lib/ Oracle / XE / App / Oracle / Product /  10.2 . 0  / Server / RDBMS / Admin / Catproc. SQL

 

Next, create a user. The users table should already exist in the initial database, so you can directly Insert the data:

SQL> Create UserCici identifiedBy"XXXX"; SQL> GrantDBAToCici;
 

Log On As this user

 
SQL>Existsql>Conn Cici/Cici123love
 

Insert tables and data and test:

SQL> Create TableTest_table (txtVarchar2(100)Not Null); SQL> Insert IntoTest_tableValues('Hello world!'); SQL> Select * FromTest_table;
 

 

================================== Potential issue ===================== ==========

1 database didn't open

Restart and load the database.

See http://www.cnblogs.com/cici-new/archive/2013/02/16/2913697.html

2 ora-01033 Oracle initialization or shutdown in progressreferences

Http://www.cnblogs.com/cici-new/archive/2013/02/16/2913689.html

 

=============================== ReferenceArticle========================================

Http://blog.csdn.net/reda0821/article/details/7816562