473,396 Members | 1,996 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Oracle newbie

Hello

I install Oracle8 Enterprise Edition Release 8.0.4 for Windows NT and
I choose Typical in Starter Database.As I understand ORACLE create a
sample database for me (If that is wrong please inform me).Also the
installation create some services.Probably my starter database is
OracleServiceORCL and OracleStartORCL which they running.Also running
OracleTNSListener80 and OracleWebAssistant.

Then i try to connect with Oracle Enterprise Manager with username
internal and password oracle (i found this information in the
Internet).In the left upper pane none of the choices show me nothing.

How can i show my database in Oracle Enterprise Manager?
Can this done via SQL (I am interested more in connection howto no in
common SQL queries - but a full example it is OK for me)
Jun 27 '08 #1
3 1666
da******@freemail.gr (db_happy) wrote in message news:<b6*************************@posting.google.c om>...
Hello

I install Oracle8 Enterprise Edition Release 8.0.4 for Windows NT and
I choose Typical in Starter Database.As I understand ORACLE create a
sample database for me (If that is wrong please inform me).Also the
installation create some services.Probably my starter database is
OracleServiceORCL and OracleStartORCL which they running.Also running
OracleTNSListener80 and OracleWebAssistant.

Then i try to connect with Oracle Enterprise Manager with username
internal and password oracle (i found this information in the
Internet).In the left upper pane none of the choices show me nothing.

How can i show my database in Oracle Enterprise Manager?
Can this done via SQL (I am interested more in connection howto no in
common SQL queries - but a full example it is OK for me)
To see the sample database log in as SCOTT/TIGER
Jun 27 '08 #2
newbie,
On NT, check your services. Any oracle database will be listed in the
format OracleServiceTest (for a database named test)

If you have any there, you can try login in with the following
usernames & passwords
SCOTT TIGER
SYSTEM MANAGER
SYS CHANGE_ON_INSTALL

If you do not have a database, you can use the Database Assistant to
create one for you. If you are able to login to an existing database
with the above passwords, changed them to something else if the
database contains any real/sensitive data. There might be some other
usernames that will need passwords changed as well)

To see your database in Enterprise Manager, after logging in
(Standalone mode) then choose from the top navigation buttons
NAVIGATION--Add database to tree, then you can try to add it manually
by providing the info, or have it found in the tnsnames.ora file.
-Roger

da******@freemail.gr (db_happy) wrote in message news:<b6*************************@posting.google.c om>...
Hello

I install Oracle8 Enterprise Edition Release 8.0.4 for Windows NT and
I choose Typical in Starter Database.As I understand ORACLE create a
sample database for me (If that is wrong please inform me).Also the
installation create some services.Probably my starter database is
OracleServiceORCL and OracleStartORCL which they running.Also running
OracleTNSListener80 and OracleWebAssistant.

Then i try to connect with Oracle Enterprise Manager with username
internal and password oracle (i found this information in the
Internet).In the left upper pane none of the choices show me nothing.

How can i show my database in Oracle Enterprise Manager?
Can this done via SQL (I am interested more in connection howto no in
common SQL queries - but a full example it is OK for me)
Jun 27 '08 #3
db_happy wrote:
Hello

I install Oracle8 Enterprise Edition Release 8.0.4 for Windows NT and
I choose Typical in Starter Database.As I understand ORACLE create a
sample database for me (If that is wrong please inform me).Also the
installation create some services.Probably my starter database is
OracleServiceORCL and OracleStartORCL which they running.Also running
OracleTNSListener80 and OracleWebAssistant.

Then i try to connect with Oracle Enterprise Manager with username
internal and password oracle (i found this information in the
Internet).In the left upper pane none of the choices show me nothing.

How can i show my database in Oracle Enterprise Manager?
Can this done via SQL (I am interested more in connection howto no in
common SQL queries - but a full example it is OK for me)
I don't say this to dampen your enthusiasm and hope you continue to study
Oracle ... but 8.0.4 is so obsolete it will likely be impossible to find
books for it and support, even here in this group, will be difficult.

I would suggest that you go to http://store.oracle.com and purchase the
CD pack for 8.1.7.4 or, if hardware permits, 9.2.0.

If will be a far happier experience.
--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
da******@x.washington.edu
(replace 'x' with a 'u' to reply)
Jun 27 '08 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

11
by: Philip D Heady | last post by:
Ok I'm a newbie to using Oracle9i w/ PHP, been a MySQL guy... What is the proper sql statement to use insert tables, etc. as below.? I don't know much about how OciParse works. I can connect...
1
by: Jyrki H | last post by:
We have done a complex software with VB using SQL Server through ADO. Now our customer is planning to switch from SQL Server to Unix/Aix Oracle 8 DB. I'm a newbie both in Oracle and Unix and...
1
by: Orhan Aykut | last post by:
Hi, This may be a newbie question though but we're about to start a large s/w project (it will be a scalable "accounting and budget program" in a large scale) and we're planning to develop it in...
10
by: Andrea M. Segovia | last post by:
Hello, I am a newbie to Oracle databases.... We have a visualization front-end tool connected to an Oracle back-end database on a Tru64 UNIX server. We also have clients with MS access...
4
by: dhcomcast | last post by:
We're starting to use Oracle for the back-end instead of a separate Access .mdb file for the data and everything as gone surprisingly well so far. We are learning Oracle as we go; Yikes! But we...
12
by: Newbie | last post by:
how can i call an oracle function to get data without using a select statement or stored procedures? given a project_no, i need to call the function: ops$sqltime.pa_new_job_no_fn which will...
3
by: Newbie | last post by:
i'm getting the exception: Parameter 'p1': No size set for variable length data type: String. my code follows: OracleCommand cmd = new OracleCommand(); cmd.Connection = oraConn;...
1
by: Ove | last post by:
Hi, I'm a newbie when it comes to Oracle, but I was asked to check if an application could run with Oracle, so I installed Oracle XE. The application is an older VB6 app. I installed Oracle...
1
by: Ole Hansen | last post by:
Hi ! I am trying to learn how to use Oracle Discoverer. I have worked with databases, like Oracle for several years, but i am new to Discoverer. Does anybody know a place to download an...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.