Shulou(Shulou.com)06/01 Report--

There are two errors in the test environment after the successful installation. In fact, there is only one reason. Record it first, and this article will be expanded irregularly in the future:

[oracle@oatest ~] $sqlplus'/ as sysdba'

-bash: sqlplus: command not found

[oracle@oatest ~] $lsnrctl status

-bash: lsnrctl: command not found

The solution is as follows: http://soulful.blog.51cto.com/468033/450237

-

[oracle@oatest ~] $sqlplus / as sysdba

SQL > startup

ORA-01078: failure in processing system parameters

LRM-00109: could not open parameter file'/ oracle/product/10g/dbs/initkids.ora'

The solution is as follows:

Cp $ORACLE_BASE/admin/$ORACLE_SID/pfile/init.ora.59201419500 / app/oracle/product/11.2.0/dbhome_1/dbs/initkids.ora

-

Download a jdk-6u18-linux-x64.bin on the official website. After installation, run java-version or the old version, and set it in the following ways:

There are two options for configuration:

1. Edit / etc/profile file directly (edit at the end of the file).

2. Create a new file in / etc/profile.d directory.

1. Setting the environment variable is as follows:

# set java

JAVA_HOME=/usr/jdk1.6.0_18

PATH=$PATH:/$JAVA_HOME/bin

CLASSPATH=.:$JAVA_HOME/lib

JRE_HOME=$JAVA_HOME/jre

Export JAVA_HOME PATH CLASSPATH JRE_HOME

Note: / usr/jdk1.6.0_18 is the path where JDK is located after installing. / jdk-6u18-linux-x64.bin, which can be copied to the appropriate folder by yourself.

Second, set the symbolic connection between java and javac:

Cd / usr/bin

Ln-s-f / usr/java/jdk1.6.0_18/jre/bin/java

Ln-s-f / usr/java/jdk1.6.0_18/jre/bin/javac

After rebooting, you will see the newly installed JDK version number after executing java-version.

-

Modify database SID

There are many methods on the Internet, which are very complicated. in fact, I have only changed two places. As it is a test environment, I have not found any problems for the time being.

1. Modify

[oracle@oatest pfile] $vi ~ / .bash_profile

ORACLE_SID=kids

2. Change the file with the old name in the dbs directory to the new name.

Cd / app/oracle/product/11.2.0/dbhome_1/dbs/

-

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.