To set up DB environment similar to my Office, I installed Oracle 9i on my Windows 7(64 Bit) in my laptop...But in office we have Windows XP..
For DB creation, I gave the SID as "primsri" and I was not prompted for any sys/system password while installation as Administrator. I find only empty folders pfile/udump/bdump etc in C:\oracle\ora92\admin\ora9i\. I see the PRIMSRI folder icon with a lock symbol on it...
I used the Oracle 9i(32 Bit) s/w installation kit having 3 CDs..
I was able to create a new SID ora9i as administrator and tnsping was successfull. When I tried to connect sqlpls "/as sysdba", it was futile..TNS-00516 Permission Denied error was thrown.
when I gave sys@sun9 as sysdba it prompts for password, irrespective whatever password typed right or wrong, the TNS-12500:TNS:Listener failed to start a dedicated server proces..
In listener log i can see the TNS-12500-> TNS-12546->TNS-12560->TNS-00516 Errors.
Also in C:\oracle\ora\92\database the sqlnet log also has the TNS Permission denied error.
Kindly assist ..
Pl identify which version of Win 7. The only database versions certified on Win 7 Professional or higher are 10.2.0.5 and 11gR2. You cannot install 9i on Win 7 and expect it to work without issues.
Hi Srini and sb92075
thanks for the reply. i have windows 7 basic home edition..I want to set up the environment same as my office ..but we have win xp at office..I am afraid of any downward compatibility issues if i install oracle 10g and develop my forms and try to run in my office...
You can go with
1. Download OEL 5.x version from e-delivery.
2. Create VM machine(make googling you can find many good site)
3. Use your OEL software and create Vm linux machine on your win7 laptop
4. Install 11g and use it for your purpose
Oracle Database on Unix AIX,HP-UX,Linux,Mac OS X,Solaris,Tru64 Unix Operating Systems Installation and Configuration Requirements Quick Reference (8.0.5 to 11.2) [ID 169706.1]
How to Install Oracle 10gR2 on MS Windows 7 / Windows 2008R2 [ID 1173433.1]
Is Microsoft Windows 7 certified to install/run Oracle Database Server/Client ? [ID 952302.1]
Statement of Direction: Oracle Database 11g Release 2 - Microsoft Windows 7 and Windows Server 2008 R2 [ID 867040.1]