Saturday, September 27, 2008

Create a New Instance on the PC

1) SQL> Shutdown
2) SQL> EXIT
3) Windows Start
Control Panel
Administrative Tools
Services
- Stop all Oracle Services
4) Start
All Programs
Oracle - OraDB10gHome
Configuration & Migration Tools
Database Configuration Assistant

5) Delete database (PC only supports one instance)
6) Create database
Ignore
OK
Yes
Database Name (no underscores allowed)
SID (same as database name)
Password
-File System

[x] Enable Archiving

Oracle charges clients for the number of processes running

Password Management
Change SYS password to SYS
Change System password to SYSTEM
Change SCOTT password to TIGER

Show Parameter db_name;

No comments:

Post a Comment