The GUI and screenshot during installation differ from Book to books, version to version, so here is the my story of downloading and installing Oracle 10g this computer. (Back to XP-Apache) You try at your risk.
Step 1: chose a common password"Manas5" for all the tables
Step 2: Moment of silence please
Step 3: confirmation about all OK at the Oracle profecies.Checking operating system requirements ...
Expected result: One of 4.0,4.1,5.0,5.1,5.2
Actual Result: 5.1
Check complete. The overall result of this check is: Passed
=======================================================================
Checking service pack requirements ...
Expected result: 1
Actual Result: 2
Check complete. The overall result of this check is: Passed
=======================================================================
Checking physical memory requirements ...
Expected result: 256MB
Actual Result: 1022MB
Check complete. The overall result of this check is: Passed
=======================================================================
Checking Network Configuration requirements ...
Check complete. The overall result of this check is: Passed
=======================================================================
Validating ORACLE_BASE location (if set) ...
Check complete. The overall result of this check is: Passed
=======================================================================
Checking Oracle Home path for spaces...
Check complete. The overall result of this check is: Passed
=======================================================================
Checking Oracle Home path for location ...
Check complete. The overall result of this check is: Passed
=======================================================================
Checking for proper system clean-up....
Check complete. The overall result of this check is: Passed
=======================================================================
Checking for Oracle Home incompatibilities ....
Actual Result: NEW_HOME
Check complete. The overall result of this check is: Passed
=======================================================================
Step 4. At this step, if you have ORACLE_HOME is set at the environmental string, you may get a message that the setting will have some effect down the road, I followed the direction remove that string if you are just installing fresh. (disclaimer: it is your call, if you are trying, try at your risk)
Step 5: Settings and path of installed APIs.
Step 6: Installation in Progerss.
Step: 7 ...installation in progress; note the message about 10g-Grid system (worth of reading and venturing ).
Step 8:...installation in progress. special notes on the features like Flashback and others, as shown below.
Step 9: ...installation in progress.
Step10:..installation in progress.
Step: 11 ..installation is in progress.
Step 12: ..installation is in progress.
Step 13: ..installation is in progress.
Step 14. ..installation is in progress and info about few APIs as shown below.
Step 15: ..installation is in progress.
Step 16: ..installation is in progress.
17. Here you have two options, you can unlock other accounts/user now or you can log-in as system/Manas5 ( as we set the password in the beginning.
Step: 18
Step 19: The step showing the url and how to use iSQL Plus over a closed intranet network.Enterprise Manager Database Control URL - (orcl) :
http://MANAS5:1158/em
Your database configuration files have been installed in C: while other components selected for installation have been installed in C:\Oracle. Be cautious not to accidentally delete these configuration files.
The iSQL*Plus URL is:
http://MANAS5:5560/isqlplus
The iSQL*Plus DBA URL is:
http://MANAS5:5560/isqlplus/dba
20: Password for this workstation was Manas5XP; designated to test with ASP.Net in contrast to the other unit where I am testing with PHP.
21
22 Now click On Host Manas5
23 The screenshot shows that TCP/IP I used as Microsoft's LoopBack Networking.
Step: 24 Below was the listener.ora, as operable on the port 1521.# listener.ora Network Configuration File: C:\Oracle\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\Oracle)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = MANAS5)(PORT = 1521))
)
)
Step: 25# tnsnames.ora Network Configuration File: C:\Oracle\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = MANAS5)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
Step 26:# sqlnet.ora Network Configuration File: C:\Oracle\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
Step 27. However our old good fellow soctt/password is locked.
Step: 28 Never fear system/Manas5 is there, to bail scott out
alter user scott account unlock;
grant connect, resource to scott;
Step 29. Scopus will ask you to reset your password, for this machine I chose "Manas5"
Step 30 However to use the famous emp table, you need to again log-in as DBA to create a new user or allowing scott to use emp.
Step: 31. " Give the floor to Scott, Mr. coach"
32. Coach says: " let me try, I would tell emp, that 'scott' is with me."
33. " Coach!, you can't be Shakespeare that whatever you write, becomes English or Oracle !"
Coach says: "pardon me", "oracle error alert is working.", "here you go Scott, Bye".
34. iSQl and SQL+ they talk to each other. Visit Oracle's site, for code and other documents to get going, I would be adding more later.
