My background is in SQL Server, I decided to learn dba tasks about Oracle.
Having problems similarly with Install plus creating a database and managing a database created.
If it was SQL Server, very easy. Here, there is a problem around the corner.
See below, my steps :--
Please advice what I am doing wrong :-
Any help greatly appreciated .
Create a database
Manage a database
--> without any hassle !
Windows 2003 Server (Standard Edition)
Partition c:\ e:\data
Downloaded and unzipped to e:\Oracle Downloads\
Development Server and PDC
Oracle 10g Standard Edition
1.Click install.exe (Oracle Universal Installer)
3.Select Standard Edition
4.Select General Purpose Starter Database
Global Database Name - orcl.wwlProductionPD.com
SID - orcl
Ticked Create database with sample schemas
6.Ticked (default) Use Database Control for Database Management
8.Do not enable Automated Backups
9.Use the same password for all accounts
10.Within Active Directory - created a group ORA_DBA, added name of computer
The following J2EE Applications have been deployed and are accessible at the URLs listed below.
Your database configuration files have been installed in E:\oracle\product\10.1.0 while other components selected for installation have been installed in E:\oracle\product\10.1.0\d
b_1. Be cautious not to accidentally delete these configuration files.
Ultra Search URL:
Ultra Search Administration Tool URL:
Enteprise Manager 10g Database Control URL:
--> tooo long
13.Select Create a database
go threw selection
at the end
Instance created. DIM-00019: create service error o/s-error (os 1376) the specified
local group does not exist
Click " ok"
ORA-12560 TNS protocal adapter error
Then click either "ignore" or "ok".
Enterprise manager configuration file failed due to the following error :-
"job_queue_process' must be greater than or equal to 1. fix the errors and run em con assistant again in standalone mode.
you can retry config this database with em later by manually running
14.Configure a db
select db created
it asks for a user --> sysdba
it asks for a pwd ==> pwd
ORA-01031: insufficent privileges