configurationoracleoracle-11g-r2tablespaceswindows
Good evening,
I'm trying to figure out how to create a database+tablespace+user in Oracle 11g.
I've tried some tutorials, but nothing seems to work.
I cannot find Database Configuration Assistant either.
I'm running Windows 8 x64 with Oracle 11g R2, please tell me how I can do this task.
Thanks for all suggestions,
Alec Taylor
you must edit bash-profile then install oracle database . in that you can set oracle_home and oracle_sid and etc . i have similar mistake and resolve it with edit bash-profile in oracle user to real and correct values at the end , you can refer to this article , it is useful
http://www.oracle-base.com/articles/11g/oracle-db-11gr2-installation-on-oracle-linux-6.php
In a command line, run:
attrib C:\Users\Pierpaolo\Documents
If you see a capital R in the output, then the read-only attribute is set for that folder (which is the default setting for the Documents folder).
Either remove the read-only attribute from the folder (I do not know what this will mess up in Windows), or specify a different folder for diagnostic dest.
For the latter, on this screen, go to All Initialization Parameters..., and set the value of diagnostic_dest to a directory that has no read-only attribute set.
Best Answer
I had no problems with a VirtualBox 4.14 Windows 8 preview VM and x64 Oracle 11gR2.
My VM uses 40 GB Hard Disk. While installing it downloaded .Net Framework 3.51 I started with a fresh Windows 8 VM in VirtualBox 4.14 and installed guest additions and run Windows update once. Afterwards I installed Oracle and got the items below on my Start page.
I find the databasefiles of my new database Bk_W8 in C:\app\berndk\oradata\Bk_W8. That is the location I would use for additional tablespaces.
The rest can be done by scripts which can be executed by sqlplus from this machine or from another client and is not Windows 8 specific.
Edit:
By right-clicking on the item on the start page, via advanced | open file location I found the path to the start menu:
I guess you will find
the other is specific for a German Oracle installation.
To get access to the hidden C:\ProgramData folder see this link showing how to access folder options in Windows 8
Final hint: My VM currently uses 23 GB for the virtual hard disk.
OK I'm going to retry this with the Oracle Database Express Edition 11g Release 2 (September 2011). But that takes some time.
Installation done: The is the Web interface of Oracle 11g XE in Windows 8
For the question of creating addition databaseinstances: from this question on SO we learn, that it is not possible.
Creating tablespaces and users can be done using sqlplus. Which I found at C:\oraclexe\app\oracle\product\11.2.0\server\bin\sqlplus.exe.
Now going to remove that Virtual machine. I think there are better ways to learn Oracle.