| need help to setup oracle for my course practice.. [message #568944] |
Wed, 17 October 2012 22:28  |
 |
zealousguest
Messages: 2
Registered: October 2012
|
Junior Member |
|
|
Hello,
First of all, let me tell you that I am an absolute beginner and have no clue about Oracle...But I just got my new coursei n uni that has Oracle...so for practicising at home..I decided to download it and practice at home..but I really am confused and spent the last 24 hours trying to figure out hwo to work...as far as reading forums, faqs and documentation is concerned..i have read most of it..but still no idea...
all i need to do right now is...check the queries and access the predefined tables that can be accessed by scott/tiger username/password..(thats what we have been doing in our uni) after installing oracle 11g and developer tools...when in the console I wrote CONNECT scott/tiger it gave me some memory error at first and then network adapter or something like that......can anyone help?
thanks.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: need help to setup oracle for my course practice.. [message #569121 is a reply to message #569018] |
Sat, 20 October 2012 15:24  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
John Watson wrote on Thu, 18 October 2012 20:05Quote:Oracle can't run on any MS Windows Home edition. well, it will run: I run 11.2.0.3 on my 32bit Vista Home Premium no problem. I used to run 10.x on XP home something, too. Not supported, of course.
Lucky me, I didn't have to go through such a combination (Windows Home + Oracle). However, I remember Barbara Boehmer shared her experience, here.
BBLike you, I tried to install it on Windows Home, as I had done with earlier versions of Oracle and Windows, enabling most features, but it didn't work. I ended up stopping all the Oracle services, running the uninstall twice, re-starting the computer, checking for leftover pieces in the registry, then upgrading to Windows professional and starting over with the Oracle installation process.
|
|
|
|
|
|
|
|
|
|
| Re: need help to setup oracle for my course practice.. [message #569133 is a reply to message #569129] |
Sun, 21 October 2012 03:00 |
 |
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
I also have mine as I have no TEMP and USERS tablespaces, I don't want to grant RESOURCE to SCOTT and the script is wrong for my NLS settings:
INSERT INTO EMP VALUES (7788,'SCOTT','ANALYST',7566,to_date('13-JUL-87')-85,3000,NULL,20);
Regards
Michel
[Updated on: Sun, 21 October 2012 03:01] Report message to a moderator |
|
|
|
| Re: need help to setup oracle for my course practice.. [message #569134 is a reply to message #569133] |
Sun, 21 October 2012 04:04 |
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
Every release I remember (I have never installed XE) has come with $ORACLE_HOME/rdbms/admin/utlsampl.sql. The version I have right now (11.2.0.3, Win32) creates SCOTT after dropping him (it drops a couple of other people, too) and will then create his objects in the default permanent tablespace, with a format for the date strings. But it ain't perfect: it grants him CONNECT, RESOURCE, and most bizarrely UNLIMITED TABLESPACE.
I run that script every day.
|
|
|
|
| Re: need help to setup oracle for my course practice.. [message #569262 is a reply to message #569134] |
Tue, 23 October 2012 14:23 |
 |
Barbara Boehmer
Messages: 9104
Registered: November 2002
Location: California, USA
|
Senior Member |
|
|
On my system (Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit) on Windows 7 Professional, the script that creates and populates the emp and dept and other tables is <oracle_home>/sqlplus/demo/demobld.sql. It is on this Windows 7 system that I was unable to complete the installation without upgrading to Windows 7 Professional.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
