Oracle 8i在P4上的安装 2002-4-22 动网先锋 方法一: 1、将ORACLE软件拷贝到硬盘。 2、将 硬盘目录文件\stage\Components\oracle.swd.jre\1.1.7.30/1 \DataFiles\Expanded\jre\win32\bin\symcjit.dll 的文件改名为 symcjit.old 3.从\install\win32 目录下运行SETUP.exe 文件进行安装。 前提是：机器上没有装过Oracle产品。如有的话请先卸载，再将注册表中Oracle项删除。 方法二、（此方法斑竹成功安装，但较麻烦,方法的核心是加 -nojit) .. Copy only the install directory from the CD to the hard disk ,say, e:\temp. b. Open oraparam.ini and make the following modifications (Assuming CD drive is f:) * Change the "SOURCE=" line to use the full path to the CD instead of a relative path. (i.e., SOURCE=f:\stage\products.jar) * Change the "JRE_LOCATION" line to use the full path to the CD instead of a relative path. (i.e., JRE_LOCATION=f:\stage\Components\oracle\swd\jre\1.1.7\1\DataFiles\Expanded) * Change the "OUI_LOCATION" line to use the full path to the CD instead of a relative path. (i.e., OUI_LOCATION=f:\stage\Components\oracle\swd\oui\1.6.0.9.0\1\DataFiles\Expanded * Change the "JRE_MEMORY_OPTIONS" line to add "-nojit" as the first argument. (i.e., JRE_MEMORY_OPTIONS=-nojit -ms16m -mx32m) ^^^^^^ * Other entries should remain the same c. Launch setup.exe from the temporary location on your hard drive (i.e. e:\temp\install\win32\setup.exe). This will use the modified oraparam.ini and pick up the information from the CD since the absolute locations are specified. Choose a Custom install and choose not to create a database during the install. This way, the Database Configuration Assistant will not be launched during installation. The Net8 Configuration Assistant will still be launched, and there is no way to suppress it. You will need to kill the Net8 Configuration Assistant if it hangs due to the bug. The installation still will have been successful, and you can run the DBCA and NetCA after installation. To kill NetCA if it hangs during installation: In the "Configuration Tools" window, highlight the "Net8 Configuration Assistant" and click "Stop". If that does not work, look for the most recent JRE process using the Task Manager, and kill it manually. NOTE: the OUI itself will also have a jre process. Be sure to kill the one with the most recent date, which should be the jre process being used for Net8CA, not the one for OUI itself. After killing the configuration tools and continuing through the installation to the "End of Installation" screen, you should modify the configuration tools to use "-nojit", then call the appropriate tools from the Start Menu. Once installation is complete, each of the following files in the ORACLE_HOME needs to be modified: assistants\dbca\dbassist.cl assistants\dbma\dbmig.cl assistants\ifa\ifa.cl bin\elogin.cl bin\owm.cl ldap\oidamdin\oidadmin.cl network\tools\netasst.cl network\tools\netca.cl owm\install\instelogin.cl owm\install\instowm.cl Edit the contents of the above files to add "-nojit" as shown below: Command=("C:\Program Files\Oracle\jre\1.1.7\BIN\JREW" -nojit -classpath .... this is the only thing you need to add --> ^^^^^^ 方法三： 升级oracle带的jre。
其实TNS的配置最好用收工配置：编辑$oracle/network/admin/tnsnames.ora文件，例如： name you like = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = IP address of you ORACLE server)(PORT = 1521)) ) (CONNECT_DATA = (SID = YOUR ORACLE SID) ) ) 注意其中的括号一定要成对。之后，用sqlplus进行验证即可!
如果不是的话，你就重启一下，有可能解决，oracle有时候就是有这些问题
2002-4-22 动网先锋 方法一: 1、将ORACLE软件拷贝到硬盘。
2、将 硬盘目录文件\stage\Components\oracle.swd.jre\1.1.7.30/1
\DataFiles\Expanded\jre\win32\bin\symcjit.dll 的文件改名为
symcjit.old
3.从\install\win32 目录下运行SETUP.exe 文件进行安装。 前提是：机器上没有装过Oracle产品。如有的话请先卸载，再将注册表中Oracle项删除。
方法二、（此方法斑竹成功安装，但较麻烦,方法的核心是加 -nojit)
.. Copy only the install directory from the CD to the hard disk ,say, e:\temp. b. Open oraparam.ini and make the following modifications (Assuming CD
drive is f:) * Change the "SOURCE=" line to use the full path to the CD instead of a
relative path. (i.e., SOURCE=f:\stage\products.jar) * Change the "JRE_LOCATION" line to use the full path to the CD instead of a
relative path. (i.e.,
JRE_LOCATION=f:\stage\Components\oracle\swd\jre\1.1.7\1\DataFiles\Expanded) * Change the "OUI_LOCATION" line to use the full path to the CD instead of a
relative path. (i.e.,
OUI_LOCATION=f:\stage\Components\oracle\swd\oui\1.6.0.9.0\1\DataFiles\Expanded * Change the "JRE_MEMORY_OPTIONS" line to add "-nojit" as the first argument.
(i.e., JRE_MEMORY_OPTIONS=-nojit -ms16m -mx32m)
^^^^^^
* Other entries should remain the same c. Launch setup.exe from the temporary location on your hard drive (i.e.
e:\temp\install\win32\setup.exe). This will use the modified
oraparam.ini and pick up the information from the CD since the absolute
locations are specified. Choose a Custom install and choose not to create a database during the
install. This way, the Database Configuration Assistant will not be launched
during installation. The Net8 Configuration Assistant will still be launched, and there is no way
to suppress it. You will need to kill the Net8 Configuration Assistant if it
hangs due to the bug. The installation still will have been successful, and
you can run the DBCA and NetCA after installation. To kill NetCA if it hangs during installation:
In the "Configuration Tools" window, highlight the "Net8 Configuration
Assistant" and click "Stop". If that does not work, look for the most recent
JRE process using the Task Manager, and kill it manually. NOTE: the OUI
itself will also have a jre process. Be sure to kill the one with the most
recent date, which should be the jre process being used for Net8CA, not the
one for OUI itself. After killing the configuration tools and continuing through the installation
to the "End of Installation" screen, you should modify the configuration tools
to use "-nojit", then call the appropriate tools from the Start Menu. Once installation is complete, each of the following files in the ORACLE_HOME
needs to be modified: assistants\dbca\dbassist.cl
assistants\dbma\dbmig.cl
assistants\ifa\ifa.cl
bin\elogin.cl
bin\owm.cl
ldap\oidamdin\oidadmin.cl
network\tools\netasst.cl
network\tools\netca.cl
owm\install\instelogin.cl
owm\install\instowm.cl Edit the contents of the above files to add "-nojit" as shown below:
Command=("C:\Program Files\Oracle\jre\1.1.7\BIN\JREW" -nojit -classpath ....
this is the only thing you need to add --> ^^^^^^ 方法三：
升级oracle带的jre。
ODBC配置后、报 ODBC-CALL FAILED #12543 TNS:连接失败。
该如何处理?
name you like =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = IP address of you ORACLE server)(PORT = 1521))
)
(CONNECT_DATA =
(SID = YOUR ORACLE SID)
)
)
注意其中的括号一定要成对。之后，用sqlplus进行验证即可!
LSNRCTL
SHUTDOWN ABORT
STARTUP