Counterpart to MS Enterprise Manager?
Siegfried Heintze
called Enterprise Manager.
Does Oracle supply a similar program with their freebie version of the
database that will allow me enuermate the databases and their logins, views,
stored procedures and tables?
I see they supply a java program call Oracle SQL Developer but that requires
a connection string that I don't know.
I believe I used the database configuration assistant to create a new
database with 4 usersnames (that I don't remember). I think I remember the
password.
I can use the Oracle Administration assistant for windows and I see my new
database in there. I was hoping to use this tool to create a simple table
and populate it with some sample data. I cannot see where in the GUI I
create a table, however. Can this program create tables or do I need a
different program?
Thanks,
Siegfried
Noons
> Microsoft supplies a general purpose client with their SQL Server product
> called Enterprise Manager.
Yes, they do. So does Oracle.
> Does Oracle supply a similar program with their freebie version of the
> database that will allow me enuermate the databases and their logins, views,
> stored procedures and tables?
Yes. Quite a few in fact.
>
> I see they supply a java program call Oracle SQL Developer but that requires
> a connection string that I don't know.
Even Microsoft's Enterprise Manager requires a connection string. You might not
see it but it's there. Hidden behind all those dialogue boxes.
> I believe I used the database configuration assistant to create a new
> database with 4 usersnames (that I don't remember). I think I remember the
> password.
There are always two users created for you: SYS and SYSTEM.
But I suggest you don't touch them until you know a bit more
about Oracle.
Try SYSMAN. The default password is usually "oracle".
> I can use the Oracle Administration assistant for windows and I see my new
> database in there. I was hoping to use this tool to create a simple table
> and populate it with some sample data. I cannot see where in the GUI I
> create a table, however. Can this program create tables or do I need a
> different program?
There should be a "SQL" window in there somewhere.
That's where you can type SQL to do whatever you want.
Very similar to the "script" window in Microsoft's EM.
If you want assistance in typing the SQL itself, then
SQL Developer is the tool to use. Read on the help
about the connection string, it's really not very hard.
You'll need "netmgr" as well to create the connection
string.
Siegfried Heintze
> That's where you can type SQL to do whatever you want.
> Very similar to the "script" window in Microsoft's EM.
Hmmm... I'm looking all over and I cannot find this script window. It would
be logical to have one!
How about sqlplus? That should do the job? How do I specify my newly created
database called SQLPOCKETGUIDE? Thru google searching I have learned how use
the connect statement to switch users but I just cannot figure out how to
switch databases. The MySQL command line client has a "use" command to
specify the database and a "show database" command to show which database
you are connected to.
Does SQLPlus have similar commands? I've been searching and cannot find
them.
> If you want assistance in typing the SQL itself, then
> SQL Developer is the tool to use. Read on the help
> about the connection string, it's really not very hard.
Help where? Interenet google search? I clicked help on the Oracle
Administration Assistant for Windows\Oracle Managed objects and searched for
"connection strings" and it said "no topics found".
> You'll need "netmgr" as well to create the connection
> string.
Huh? What is netmgr?
Yeah but there are all flavers of connection strings! OLEDB, .NET and JDBC
are just a few. For the SQL Developer do I use java connection string? Do I
have to download the oracle JDBC drivers and set up the class path first?
Which JDBC driver do I want? I think I want the KPRB driver but I'm not
sure. There are several thin and thick JDBC drivers to pick from!
And what tool would I use to experiment with stored procedures?
Will SQLPlus execute PL/SQL statements?
I'm studying http://www.orafaq.com/wiki/JDBC and I'm surprised I cannot find
the explanation on how to specify the database in the connection string. I
want to connect to my newly created databases and execute the script at
http://examples.oreilly.com/9780596526887/ so I can play with the SQL
examples in the book SQL Pocket Guide
(http://oreilly.com/catalog/9780596526887/)
Thanks,
Siegfried
Charles Hooper
> the explanation on how to specify the database in the connection string. I
> examples in the book SQL Pocket Guide
> (http://oreilly.com/catalog/9780596526887/)
>
> Thanks,
> Siegfried
I have not experimented with the free version of Oracle's database
product, but I believe that it is limited to a single database per
computer. That might make it easy for you. When you open a Windows
command prompt in preparation for starting SQL*Plus, you are able to
specify the database name to connect to by setting the ORACLE_SID
environment variable (this may be permanently set using the System
Control Panel in Windows). For instance:
C:\> SET ORACLE_SID=SQLPOCKETGUIDE
Now when you connect to the database in SQL*PLus it will connect to
the database (you will actually be connecting to the database
instance) that you created (C:\> is the Windows command line prompt,
SQL> is the SQL*Plus command line prompt):
C:\> SQLPLUS /NOLOG
SQL> CONNECT MyUserName/MyPassword
There is another method, which might work without using the SET
ORACLE_SID syntax:
C:\> SQLPLUS /NOLOG
SQL> CONNECT MyUserName/MyPassword@SQLPOCKETGUIDE
You could manually type the examples from the link that you provided,
or process the whole script in a single command. For instance, assume
that you unzipped the files from O'Reilly into the folder C:\Sample.
A file named db2_sample_data.sql is included in the download from
O'Reilly. To execute that script, enter the following in SQL*Plus:
SQL> @C:\Sample\db2_sample_data.sql
Yes, SQL*Plus allows executing PL/SQL code blocks. You might also
want to browse through this link:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/toc.htm
The Oracle documentation also contains a reference for SQL*Plus.
I was impressed with the "Mastering Oracle SQL and SQL*Plus" book,
which might be everything that you need to get started once you are
able to make it into SQL*Plus:
http://www.amazon.com/Mastering-Oracle-SQL-Plus/dp/1590594487
A couple hints. Do not create objects while connected to the database
as the SYS, SYSTEM, or internal users. Instead, create a user
account, connect to that database, and create objects while logged in
as that user.
Charles Hooper
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc.
John Hurley
snip
One option is to get an OTN login and download the real Enterprise
Edition database. It is not crippled in any way nor does it stop
working after a certain time.
It is just subject to a licensing agreement that basically says "I am
not developing a commercial product with this download" ... just
experimenting.
That version has a fully fledged GUI based console.
You could then get familiar with that version and then eventually see
if you like that better than the totally free version.
Siegfried Heintze
>One option is to get an OTN login and download the real Enterprise
>Edition database. It is not crippled in any way nor does it stop
>working after a certain time.
John: do you have a URL for that? I did a google search and found
http://www.oracle.com/technology/index.html. Is this the page I want?
>That version has a fully fledged GUI based console.
That sounds good to me! What words am I looking for so I don't download the
brain damaged freebie again?
Thanks,
Siegfried
John Hurley
snip
> >One option is to get an OTN login and download the real Enterprise
> >Edition database. It is not crippled in any way nor does it stop
> >working after a certain time.
>
> John: do you have a URL for that? I did a google search and foundhttp://www.oracle.com/technology/index.html. Is this the page I want?
Yup ... you will need a login etc to download stuff ... pretty
straightorward registration process.
>
> >That version has a fully fledged GUI based console.
>
> That sounds good to me! What words am I looking for so I don't download the
> brain damaged freebie again?
Well Enterprise Edition ( which costs the most if you license it
eventually ) has the most but Standard Edition also has a GUI that has
"most of" the features of Enterprise Edition.
After you register you should be able to get to a download page ( use
download tab then the database option ) that has this stuff ...( below
in a copy and paste ).
If you are just experimenting right now 11.1 release is out for all
platforms ( well most platforms anyway ) and 11.2 is out for linux
only at this point.
*******************************************************
Oracle Database Software Downloads
You must accept the OTN License Agreement to download this software.
Accept License Agreement | Decline License Agreement
Thank you for accepting the OTN License Agreement; you may now
download this software.
Oracle Database 11g Release 2
Standard Edition, Standard Edition One, and Enterprise Edition
(11.2.0.1.0)
Download Linux x86 | Disk 1, Disk 2 (2.1 GB) | See All
(Including Client, Gateways, Grid Infrastructure, more)
Download Linux x86-64 | Disk 1, Disk 2 (2.2 GB) | See All (Including
Client, Gateways, Grid Infrastructure, more)
Oracle Database 11g Release 1
Standard Edition, Standard Edition One, and Enterprise Edition
(11.1.0.7.0)
Download Microsoft Windows Server 2008 (32-bit) (1.9 GB) | See All
(Including Client, Clusterware)
Download Microsoft Windows Server 2008 x64 (1.9 GB) | See All
(Including Client, Clusterware)
(11.1.0.6.0)
Download Microsoft Windows (32-bit) (1.7 GB) | See All (Including
Client, Examples, Gateways, Clusterware)
Download Microsoft Windows (x64) (1.7 GB) | See All (Including Client,
Examples, Clusterware)
Download Linux x86 (1.7 GB) | See All (Including Client, Examples,
Gateways, Clusterware)
Download Linux x86-64 (1.8 GB) | See All (Including Client, Examples,
Gateways, Clusterware)
Download Solaris (SPARC) (64-bit) (1.9 GB) | See All (Including
Client, Examples, Gateways, Clusterware)
Download AIX (PPC64) Disk 1, Disk 2 (2.3 GB) | See All (Including
Client, Examples, Gateways, Clusterware)
Download HP-UX Itanium Disk 1, Disk 2 (2.3 GB) | See All (Including
Client, Examples, Gateways, Clusterware)
Download HP-UX PA-RISC (64-bit) Disk 1, Disk 2 (2.3 GB) | See All
(Including Client, Examples, Gateways, Clusterware)
Shakespeare
The license is more restricted than you suggest. The product may only be
used by ONE person on ONE server. And even non-commercial products are
not allowed. So no "internal company" systems either.
Shakespeare