Oracle 9I Installation Use notes

oracle| notes
Oracle 9I Installation Use notes
Author:tansf
Date:2004-11-10

First, installation
Oracle 9I altogether three discs
1
Global database name: Tan.eyesomdb
Sid:tan
---need to manually enter

2 Database file directory
C:\oracle\oradata

3 Database Information
Global database name: Tan.eyesomdb
Sid:tan
Global database name: Tan.eyesomdb
Sid:tan
SYS password: change_on_install--Change to: sys123456
System Password: Manager--Change to: system123456


Second, the use
1. Create a database
1) Open the program
Oracle-orahome90--> Configuration and Migration Tools--> Database Configuration Assistant
2 Select a template to create a database
Template name: Data Warehouse
3) Specify Database information
Global database name: Ticket.mishi
Sid:ticket
4 Select the default mode to use for the database
5 Initialization parameters
6) Database Storage
7) Create options
8) Overview
Creating a database is like 1G of space, so you cancel the creation of the database

2. Enterprise Manager Console Management
1) Open the management program
Oracle-orahome90--> Enterprise Manager Console
2)
(1) If you choose "Standalone Startup"
A When you enter the database, you are prompted to enter the following information
User name:
Password:
Service: tan.adserver1--This is the default, and can not be changed
--Installed Active Directory before, then deleted Active Directory, then joined Domain adserver1.
--The system exits the domain Adserver1, that's not the problem.
Connection identity: (with several options)

b When you add a database to a tree
Host name used IP address, port 1521. Error ' Ora-12541:tns: No monitor ' on connection
You need to start Oracleorahome90tnslistener from the service, or you can start with the command "net start Oracleorahome90tnslistener"
Tip Oracleorahome90tnslistener started successfully,
But there is still such a mistake, Oracleorahome90tnslistener has reverted to the state of not being started

Through net Configuration Assistant to remove the original monitor listener, add the monitor listener again, when there is a protocol option, all the protocols are added
Log in to the database when prompted Ora-01017:invalid Username/password,
User: Sysman Password: system123456 (System password) or sys123456 (sys password) connection identity: SYSDBA-Login Succeeded

File C:\oracle\ora90\network\ADMIN\tnsnames.ora Save the database in the tree .... The relevant information


(2) If you choose "Log on to Oracle Management Server"
Default admin: Sysman initial Password: oem_temp
Error tip: VTK-1000: Unable to connect to Management Server, viewed on the Internet, should be not installed Management Server