Environment: RHEL 5.4x86, Oracle 11.2
1. Set Environment Variables
Edit in/home/Oracle
#. Bash_profile
# Get the aliases and functions
If [-f ~ /. Bashrc]; then
.~ /. Bashrc
Fi
# User specific environment and startup programs
#11g r2
Export ORACLE_HOME =/APP/Oracle/product/11.2.0/dbhome_1
Export Path = $ path: $ home/bin: $ ORACLE_HOME/bin
Export LD_LIBRARY_PATH = $ ORACLE_HOME/lib
Export nls_lang = american_america.utf8
Export oracle_sid = orcl
Umask 022
2. Disable SELinux
If SELinux is enabled when RHEL is installed
Use the root user setenforce 0
Otherwise, the following error occurs: sqlplus: Error while loading shared libraries.
3. Log On As an oracle user and edit init. ora.
Only 1 line
Db_name = orcl
4. log on to sqlplus/As sysdba
Create spfile = 'spfileorcl. ora 'from pfile ='/home/Oracle/init. ora'
Startup nomount
Create Database orcl;
Wait until the database is created successfully.
Select sysdate from dual;
You can check the date.
5. Run the script to create the system view and package.
@? /Rdbms/admin/CATALOG
@? /Rdbms/admin/catproc
run as a system user
@? /Sqlplus/admin/pupbld
You Can See V $ datafile and V $ controlfile
at $ ORACLE_HOME/DBS, the file names are respectively dbs1orcl dbx1orcl dbu1orcl cntrlorcl
several questions:
1. in this document, at least three parameters are required for pfile. Others have default values, and I only write one parameter.
2. Only the system sysaux sys_undots table space is used to create a database. There is no temporary table space and the database operation is normal.
I wonder if this is a new feature of Oracle 11.2?
3. once in. the following statements are written in the SQL file, however, the execution fails.
Create Database orcl
user SYS identified by sys
User system identified by sys
extent management local
default temporary tablespace temp
undo tablespace undotbs1
default tablespace users;
4. the document does not indicate that the System user needs to execute pupbld. I use sys to execute the command.
the result is that Error accessing product_user_profile is prompted when the new user oo logs on.