Oracle Newbie

[jino]

Hi there,

I am completely new to Oracle technology. One of my colleagues suggested that I use Oracle lite for my web application. I downloaded and installed the software on my machine. But I cannot find any sample databases on any of the folders. How do I create a new database? Can i use SQL Plus to do this? How do I logon using SQL Plus?

Any help is appreciated.

Thanks

Jino

 

[Thargy]

Jino,

It sounds as though you are familiar with windows based RDBMS such as Access and SQL Server. With access for example, you can find the .mdb file, and hey presto, there's your database.

Oracle is not like that. It consists of many files, all of which combine to make a database. It is significantly more complex than Access, for example.

Ok, to find your database, you will have to look for Oracle folders and they will contain files similar to the following directory listing. By the way, I am assuming that you are using windows. Below is a dir list of what's in my home Oracle database folder. Search your HDD for files such as "CONTROL01.CTL" OR "REDO01.LOG" and you should be in the right spot.

               4 Dir(s)  81,587,367,936 bytes free
              13 File(s)  1,000,637,952 bytes
 Directory of C:\oracle\10g\oradata\homeone
 Volume in drive C has no label.
 Volume Serial Number is C8C8-B9BF
13/12/2005  10:06        20,979,712 TEMP01.DBF
13/12/2005  18:03         5,251,072 USERS01.DBF
13/12/2005  18:03        10,486,272 REDO01.LOG
13/12/2005  18:03        10,486,272 REDO02.LOG
13/12/2005  18:03        10,486,272 REDO03.LOG
13/12/2005  18:03        31,465,472 UNDOTBS01.DBF
13/12/2005  18:03       157,294,592 EXAMPLE01.DBF
13/12/2005  18:03       272,637,952 SYSAUX01.DBF
13/12/2005  18:03       471,867,392 SYSTEM01.DBF
13/12/2005  19:00         3,227,648 CONTROL01.CTL
13/12/2005  19:00         3,227,648 CONTROL02.CTL
13/12/2005  19:00         3,227,648 CONTROL03.CTL
13/12/2005  21:04    <DIR>          .
13/12/2005  21:04    <DIR>          ..
13/12/2005  21:05                 0 dirlist.txt
25/11/2005  18:43    <DIR>          Archive
25/11/2005  18:43    <DIR>          RMAN Backup

My database is called 'homeone' and when I created it, using the standard Oracle tools provided on the CD's (or DVD's depending) I chose to have a standard schema created. This is the immortal scott/tiger schema, which is known throughout the Oracle universe. (Scott/tiger is as bog standard as fish and chips, bacon and eggs etc.) You log on to the database from sql plus using the userid scott, password tiger. You have to give the SID of the database. You should have been asked to specify and take note of this during database creation. Also, Oracle usually locks all accounts except sys and system, so the scott account may be locked. If it is, you will have to log on as sys, and unlock it. You should also have been prompted to take note of the sys and system passwords, during creation.

I'll stop there, and let you have a browse around your hard disk. Until I know whether or not you have access to sys and system, or can even locate the database, I can't usefully say more.

I would post screen shots of how to log on via sqlplusw, but I don't think tek-tips has this facility.

regards

Tharg

Grinding away at things Oracular

 

[sem]

Tharg, I think that Oracle Lite has far more simple structure

Regards, Dima

http://seminihin.narod.ru

 

[Thargy]

Dima,



I will read the question thoroughly,
I will read the question thoroughly,
I will read the question thoroughly,
I will read the question thoroughly,
I will .........

Regards

Mr. Nobody

N.B. This was posted anonymously, and has nothing whatsoever to do with Tharg.

Grinding away at things Oracular

 

[sem]

Does your task require interaction (replication) with other ("adult") Oracles and you're very short on resources? If the answer is yes for both answers then we may continue (of course after you've read at least installation guide), but if at least 1 of them is not yes, then I'd suggest you considering alternatives like Oracle XE (your harware is OK), MySQL (you don't need replication from Oracle) or if you're ocasionally a Java-guy (suspect you aren't) - Hypersonic.

Regards, Dima

http://seminihin.narod.ru