Starting from server construction (4). installing and configuring oracle in Linux

Starting from server construction (4). installing and configuring oracle in Linux

Papayas

20070417

I. Sequencing

As early as the Virtual Machine redhatlinux9 installation oralce92 whole process "article, (link: http://blog.csdn.net/liwei_cmg/archive/2006/05/28/759286.aspx)
The Installation Process of Oracle in Linux is described in detail. However, I tried again to find many vulnerabilities and new problems,
I have to lament the complexity of installing and configuring oracle in Linux. Redhat Enterprise Edition 4 + Oracle 9.2.0.4
Server build series: http://blog.csdn.net/liwei_cmg/category/227512.aspx

Ii. Correcting Errors

In the article "full process of installing oralce92 in redhatlinux9 for virtual machines", we mentioned:

[Note]
1. It is best to extract the cpio file in windows. WinRAR supports the GZ format. Tested, run
The row gunzip speed is too slow.

This is very inappropriate! On the one hand, winrardecompression speed in windows, compared with PC Server scis
It's too slow. On the other hand, the extracted installation files may cause a lot of problems in Linux installation.
If the file is in full upper case, no operation permission is displayed. After decompression and installation in Linux, no problem occurred.

After analysis, I came to the conclusion that the reason was that the performance of the virtual machine was relatively low and it was just subjective.

Iii. New Problems in installation and configuration

Except for the above serious errors, other installation processes are free of any problems.
In this installation, only one Oracle user and corresponding group are created, and the group name is also oracle.

First question:
When accessing Windows shared resources, smbmount cannot open the port, that is, Mount-T smbfs is invalid.
The reason is that the firewall is enabled on Windows machines and the related ports are disabled.

Second question:
During the graphical installation process, the system prompts that the file cannot be created and there is no relevant permission. This is because
The GZ file is compressed, and then you can use Linux gunzip.

Third question:
For the first installation, set the orainventory directory, and the system prompts to use root to execute orainstroot. Sh. If
After the installation is terminated due to a problem, the orainventory directory cannot be changed after the installation is reinstalled. The reason is that/etc/orainst. Loc exists.
File. After deletion, you can change the settings.

Fourth question:

Exception thrown from Action: Make
Exception name: makefileexception
Exception string: Error in invoking target install of makefile/home/Oracle/ora9/Oracle/PLSQL/lib/ins_plsql.mk

Compile make-F ins_plsql.mk and prompt what cannot find the corresponding glic2.3...

This problem is due to the earlier version of GCC required for Oracle installation. The original version of GCC installed on the virtual machine is 3.2.2.
You can use this Enterprise Edition Linux GCC is 3.4.4, and later found that/usr/bin/gcc32
MV/usr/bin/GCC/usr/bin/gccnew
MV/usr/bin/gcc32/usr/bin/GCC
Install the SDK again. There is no problem, but you need to change it back to the original version after installation.


Fifth question:
When you create a database using dbca, an error occurs in the last step:
Home/Oracle/ora9/Oracle/bin/dbca: Line 124: 31614 segmentation fault $ jre_dir/bin/JRE-doracle_home = $ oh-djdbc_protocol = thin-mx64m-classpath $ classpath oracle. sysman. assistants. dbca. dbca $ arguments

Modify dbca and change the last line:
# Run dbca
$ Jre_dir/bin/JRE-native-doracle_home = $ oh-djdbc_protocol = thin-mx64m-classpath $ classpath oracle. sysman. assistants. dbca. dbca $ arguments
Fi

A native parameter is added.


Iv. Import and export Databases

Here, imp and exp are used to import and export targeted data.

1. Create a BAT file (expdata. BAT). For bat usage, run the HELP command to query help. The content is as follows:

Copy E:/backup/*. * E:/old_backup
Del/q e:/backup /*.*
Oracle_bakup.vbs

2. VB Script script oracle_bakup.vbs:

Option explicit
On Error resume next

Dim fname, cmd
Dim wshshell

Set wshshell = Createobject ("wscript. Shell ")

Fname = Date
Cmd = "exp log = E:/" & fname & ". Log File = E:/" & fname & "_. dmp parfile1_exp.txt"

Wshshell. Run cmd
Set wshshell = nothing
'Wscript. Echo cmd

3.exp.txt file content:

Userid = test/test @ zjyx68
Buffer= 209715200
Tables =
(
Cnt_info,
Cnt_operator
)
Compress = Yes
Consistent = No
Grants = Yes
Indexes = Yes
Rows = Yes
Constraints = Yes

The three files are in the same directory. Double-click to execute bat. Here, we need to note that:

A. Character Set consistency (character set's classical Article Oracle Character Set Problem summary http://blog.csdn.net/liwei_cmg/archive/2006/06/04/772674.aspx)

B. Compatibility between the client version and the server version of the import segment, for example, exporting the 9.2 database on the 9.0 Client
The following error occurs during re-import:

. Importing custom's objects into custom
Imp-00017: following statement failed with Oracle error 922:
"Create Table" liwei_test "(" name "varchar2 (10) pctfree 10 pctused 40 init"
"RANS 1 maxtrans 255 storage (initial 524288 freelists 1 freelist groups 1) t"
"Ablespace" Custom "nologging nocompress"
Imp-00003: Oracle error 922 encountered
ORA-00922: Missing or invalid option
Import terminated successfully with warnings.

Even if the relevant table structure is created, an error still occurs when the ignore parameter is used. Place the related statement in sqlplus for execution.
The message "nocompress" is invalid. It is estimated that the version is still compatible, that is, backward compatibility is ensured.

If you use the 9.2 client to export the 9.0 database, the following message is displayed:
EXP-00056: Oracle error 942 encountered
ORA-00942: Table or view does not exist
EXP-00000: Export terminated unsuccessfully

And then use the 9.0 client to import and export.

C. The buffer for import and export is very important. If the memory is large enough, set it as large as possible, especially when exporting
Otherwise, frequent disk Io will lead to very slow import and export.

D. For the export of Package function procedure sequence dblink
You can use PL/SQL to export the creation statement. You only need to execute the imported. SQL file during import.


V. Final description

This is the end of the related series of articles. In general, it seems very trivial, but it is usually a headache to solve the problem.
Therefore, a large number of records are used for reference.