Oracle newbie - Oracle Database

db_happy

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.Probab ly my starter database is
OracleServiceOR CL and OracleStartORCL which they running.Also running
OracleTNSListen er80 and OracleWebAssist ant.

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

Subscribe Reply

1679

Stephen_CA

da******@freema il.gr (db_happy) wrote in message news:<b6******* *************** ***@posting.goo gle.com>...

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.Probab ly my starter database is
OracleServiceOR CL and OracleStartORCL which they running.Also running
OracleTNSListen er80 and OracleWebAssist ant.

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

OakRogbak_erPine

newbie,
On NT, check your services. Any oracle database will be listed in the
format OracleServiceTe st (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_INSTA LL

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******@freema il.gr (db_happy) wrote in message news:<b6******* *************** ***@posting.goo gle.com>...

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.Probab ly my starter database is
OracleServiceOR CL and OracleStartORCL which they running.Also running
OracleTNSListen er80 and OracleWebAssist ant.

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

Daniel Morgan

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.Probab ly my starter database is
OracleServiceOR CL and OracleStartORCL which they running.Also running
OracleTNSListen er80 and OracleWebAssist ant.

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.wash ington.edu
(replace 'x' with a 'u' to reply)

Jun 27 '08 #4

Similar topics

4235

PHP/Oracle SQL statements, OciParse

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 successfuly, just my sql syntax is pretty bad. $conn = OCILogon($username,$passwd,$db); if ($conn) { $sql = "

PHP

2159

Help: ADO with Unix and Oracle

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 wonder how this will affect our software. Would changing the connection string be enough (I quess not). Any help would be appreciated ! Jyrki Hamalainen Laukaa, Finland

Microsoft SQL Server

2772

.NET vs. Oracle Developer

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 C#, while our customer is leaning towards Oracle Developer because their IT dept.'s past experience has on it. They have also mentioned to us in a meeting to benefit from Oracle's Finance Tools. Would you please give me strong arguments to...

.NET Framework

3519

Accessing data from an MS access db from an Oracle UNIX server

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 databases who would like to share their data using this visualization tool but do not want to import their data into the Oracle server back-end.

Microsoft Access / VBA

3328

Update an Oracle table, get 3167 error on faked Autonumber ID field

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 have very patient DBA's at the main office to answer newbie questions. Using Access 2002 with linked ODBC tables to Oracle 9 (9i? not sure), ODBC driver is SQORA32.DLL, verson 9.02.00.00. My "Error 3167: Record is deleted" comes when I use...

Microsoft Access / VBA

9510

how to call an oracle function

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 return the next job_no thanks in advance.

C# / C Sharp

6439

exception when calling an oracle function

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; cmd.CommandText = "ops$sqltime.pa_new_job_no_fn"; cmd.CommandType = CommandType.StoredProcedure;

C# / C Sharp

6847

OLEDB and Oracle XE ?

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 XE and Client XE on the same XP machine as my application and checked that the database engine is running. I fail to point out the database with the PromptNew dialog in

Oracle Database

4354

Oracle Discoverer Newbie...

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 "Oracle Discoverer for Dummies ...", or some other good tutorial for a newbie like me.

Oracle Database

8443

What is ONU?

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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8356

Changing the language in Windows 10

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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

8781

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8639

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

6192

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5663

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4198

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4366

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1772

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General