December 21, 2010 at 8:34 am
Hello,
In the past 3 years, since graduation college, my carreer as a dba/programmer has been complety focused on working with SQL Server.
My current job includes a 6 month training to become a full fledged dba, which would include working with Oracle databases.
I need help in understanding how to start working with this, currently I have no oracle software on my computer.
I do however have the install files for Oracle 11g client and database for both 32 as 64 bit systems.
I'll need to work with the 32 bits since our customers have 32 bits databases (Another reason is found here.)
How do I start on this what do I install and in what order and what configs to use.
Any help would be appreciated, also any advice on book to buy to study would also be handy.
December 21, 2010 at 9:19 am
Oracle documentation library is the best place to start from:
http://www.oracle.com/pls/db112/portal.portal_db?selected=11&frame=
You can find a detailed installation guide, both PDF and HTML.
-- Gianluca Sartori
December 21, 2010 at 9:22 am
Resender (12/21/2010)
Any help would be appreciated, also any advice on book to buy to study would also be handy.
I bought this book from Amazon and I found it very useful:
http://www.amazon.com/gp/product/0470395141/ref=oss_product
Hope this helps
Gianluca
-- Gianluca Sartori
December 22, 2010 at 3:50 am
Ok I ordered the book
Not much luck getting it to work, I'm now in process of first reading the library and then install the software.
Which software should I install the client or the database.
December 22, 2010 at 3:54 am
It depends on what you want to set up. I suppose you want to play with the database, so you'd better install the database server.
Which OS are you installing to?
-- Gianluca Sartori
December 22, 2010 at 4:29 am
Windows 7 Ultimate 64 bit version (laptop from work)
Windows 7 64 bit version (Home PC)
My previous XP computer still works and is hooked up in my home network,
a new use for it I haven't discovered, but I'm leaning to using it for data-Storage and Server programs.
Atm I want indeed to play around with the database, create new ones, create tables learn to manage them.
December 22, 2010 at 4:37 am
If you have enough RAM, I wuold suggest installing VirtualBox, some flavour of linux and play with Oracle on that machine.
Oracle-Base has great guides on how to install. For instance:
http://www.oracle-base.com/articles/11g/OracleDB11gR2InstallationOnFedora14.php
-- Gianluca Sartori
December 23, 2010 at 2:13 am
On my windows machine I got 4 gig's of RAM, the only reason I decommissioned it was because of it being to expensive to upgrade it for dual or triple monitor use (Its age 5+ in may of this year) and the fact that for some odd reason any kind of portable hard memory (flash drives, external hard disc's) on a usb port were not recognised and hence refused to work.
I got a 64 bit version 11g database to work on my works laptop, going to install a 32 bits version today instead.
Main questions are:
How do I create a new database (I used the dbca yesterday)
How do I create a new user on that database and what are the prerequisites.
How do I login to that database
December 23, 2010 at 2:24 am
Resender (12/23/2010)
On my windows machine I got 4 gig's of RAM, the only reason I decommissioned it was because of it being to expensive to upgrade it for dual or triple monitor use (Its age 5+ in may of this year) and the fact that for some odd reason any kind of portable hard memory (flash drives, external hard disc's) on a usb port were not recognised and hence refused to work.I got a 64 bit version 11g database to work on my works laptop, going to install a 32 bits version today instead.
I would find it very surprising if your company had an Oracle server running on Windows. It's quite unusual.
I would suggest you to stick to the OS type you will be working on. I found out (the hard way) that being an Oracle DBA also means being a full system administrator. Many tasks in Oracle are not accomplished via SQL commands, but have to be performed working with external tools or tweaking files on the server.
How do I create a new database (I used the dbca yesterday)
DBCA is the tool for this.
How do I create a new user on that database and what are the prerequisites.
Through Enterprise Manager if you prefer using a GUi tool or SQL*Plus issuing a CREATE USER statement.
How do I login to that database
Using SQL*Plus, conn user/password.
-- Gianluca Sartori
December 23, 2010 at 3:08 am
I'm not finding Enterprise Manager in my Oracle instalation,
if i log into sql*plus how can i determine on what database I am.
December 23, 2010 at 3:14 am
Enterprise Manager (or DBConsole) is the web application that controls and administers the database.
If you created a database with DBCA, you probably created the DBConsole as well.
Try opening https://localhost:1158/em
If i log into sql*plus how can i determine on what database I am.
From SQL*Plus issue:
SELECT name FROM v$database
-- Gianluca Sartori
December 23, 2010 at 3:19 am
Thank you,
as for installing Oracle on Windows, the company I work for is quite young (founded in april-may 2010) and our primary office won't be up to speed yet. (We were forced to use the ISP of the building we rent in and they cancelled several months on us, so we only have a working internet since beginning of December). So little to no setups have been made so far.
December 23, 2010 at 5:40 am
Gianluca Sartori (12/23/2010)
Enterprise Manager (or DBConsole) is the web application that controls and administers the database.If you created a database with DBCA, you probably created the DBConsole as well.
Try opening https://localhost:1158/em
If i log into sql*plus how can i determine on what database I am.
From SQL*Plus issue:
SELECT name FROM v$database
.ORA-00942: Table or view does not exist
December 23, 2010 at 6:19 am
The view exists, but you don't have permissions.
Which user is connected to SQL*Plus?
SELECT USERNAME FROM V$SESSION WHERE AUDSID=userenv('sessionid');
-- Gianluca Sartori
December 23, 2010 at 7:11 am
I got bigger problems I can no longer login on the enterprise manager due to internal error ( Ignore this)Where do I find the log for the enterprise manager cause I can't seem able to login into it on one of my databases.
Okay, I can login but every time I create a new database and want to access it through enterprise manager I have to close my browser.
I created a database Test, I added user Resender to it using enterprise manager
Resender cannot see both views,user system can see them both
(Is their a way to increase the SQL Plus window size)
Added role SELECT_CATALOG_ROLE to Resender now he can see the views.
Next question is something i did earlier today which seemed to corrupt my database (sort of)
Create database T1 and T2
Add user U1 password password on both
login with SQL Plus, on which database did i log in
Trying to login between databases not working
Viewing 15 posts - 1 through 15 (of 43 total)
You must be logged in to reply to this topic. Login to reply