How to install ORACLE10GR2 on windows2008 domain

Source: Internet
Author: User
Tags mkdir

The automatic library will produce the TNS protocol error, require DBCA to generate the library SQL, and add the net start oracleservicexxxx (SID) line to the bat below Oradim.

Monitor cannot find service (prompt SID error or cannot find) need to increase in listening file

(Sid_desc =

(Global_dbname = XXXX (SID))

(Oracle_home = Y:\XXXX\XXXX\oradbs (oracle_home path))

(Sid_name = XXXX (SID))

)

The need to add ORACLE_SID=RLZYORCL to Windows System environment variables after the service starts or prompts TNS protocol errors

mkdir C:\ClusterStorage\Volume1\oradata\xxxx

mkdir Xxxx\admin\rlzyorcl\adump

mkdir Xxxx\admin\rlzyorcl\bdump

mkdir Xxxx\admin\rlzyorcl\cdump

mkdir Xxxx\admin\rlzyorcl\dpdump

mkdir Xxxx\admin\rlzyorcl\pfile

mkdir Xxxx\admin\rlzyorcl\udump

mkdir Xxxx\flash_recovery_area

mkdir XXXX\ORADBS\CFGTOOLLOGS\DBCA\RLZYORCL

mkdir Xxxx\oradbs\database

Set Oracle_sid=xxxxx

Xxxx\oradbs\bin\oradim.exe-new-sid Xxxx-startmode Manual-spfile

Xxxx\oradbs\bin\oradim.exe-edit-sid Xxxxx-startmode Auto-srvcstart System

net start oracleservicexxxxx plus this sentence

Xxxx\oradbs\bin\sqlplus/nolog

@d:\xxxxxx\scripts\xxxxx.sql

This column more highlights: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.