Two problems with installing Oracle 10g on RedHat Linux 5.5X64

I. How to expand the linux swap space
A) Login as the root user

B) Type following command to create 512 MB swap file (1024*512 MB = 524288 block size ):
# Dd if =/dev/zero of =/swapfile1 bs = 1024 count = 524288

C) Set up a Linux swap area:
# Mkswap/swapfile1

D) Activate/swapfile1 swap space immediately:
# Swapon/swapfile1

E) To activate/swapfile1 after Linux system reboot, add entry to/etc/fstab file. Open this file using text editor such as vi:
# Vi/etc/fstab

Append following line:
/Swapfile1 swap defaults 0 0

So next time Linux comes up after reboot, it enables the new swap file for you automatically.

Ii. cocould not open parameter file initOrcl. ora

Today, the development server suddenly fails to connect. After the sqlplus/nolog, conn/as sysdba, and startup commands are displayed

SQL> startup

ORA-01078: failure in processing system parameters

LRM-00109: cocould not open parameter file '/opt/Oracle10g/product/10.2/db_1/dbs/initORA10G. ora'

The file does not exist. It is estimated that the shutdown is caused by illegal shutdown.

This is because in oracle9i and oracle10g, oracle uses spfile by default to start the database. If spfile does not exist, the above error will occur.

Solution 1 (verified ):

Copy the file in the form of init. ora.012009233838 in the $ ORACLE_BASE/admin/database name/pfile directory to the initoracle. ora directory in the $ ORACLE_HOME/dbs directory. (Note: oracle in initoracle. ora is your instance name ORACLE_SID)

Solution 2:

Use the oraenv command to change the SID of the previous environment, and then use pfile to re-generate the spfile, so that the dynamic data volume can be changed.

Change SID:

[Oracle @ willie root] $ source oraenv (this command is used to modify SID)

ORACLE_SID = [oracle]? Test1

Bash:/root/. bashrc: Permission denied

Re-generate spfile:

SQL> create spfile from pfile;

(When I did this, the SID changed, but the parameter file was not found because my SID is PDBQZ. if Orcl cannot be found at the beginning, I will. copy an ora.012009233838 file to the $ ORACLE_HOME/dbs directory and rename it as initPDBQZ. ora. I am using two methods in combination, and the situation is a bit special. SID reconstruction by yourself)

File created.

SQL> startup

ORACLE instance started.

 

Appendix: oracle operation commands in Linux

Restart oracle
Lsnrctl stop
Sqlplus/nolog
Conn/as sysdba
Shutdown (startup)
Exit
Lsnrctl start

Start oracle
Sqlplus/nolog
Conn/as sysdba
Startup
Exit
Lsnrctl start

Disable oracle
Lsnrctl stop
Sqlplus/nolog
Conn/as sysdba
Shutdown
Exit