Windows – Unable to start Oracle Database Server : Get an error as I try to start it

oracleoracle-11goracle-11g-r2windows

I just installed Oracle Database Express Edition 11g Release 2 for windows.It created a short cut icon on the desktop :

enter image description here

but as I click this icon I see this dialog box :

enter image description here

What is it ? How do I start my Oracle Database Server ?

Best Answer

Here are the instructions on how to start the database: Starting Oracle Database XE

Normally you first need to start the database and then you can access it with that link. I don't remember if the database is started after you do the installation.

Related Solutions

Oracle 10g express database link to Oracle 8i

Metalink 207303.1 is the Client/ Server Interoperability Matrix which will be the definitive documentation. Since the express edition of 10g is based on Oracle 10.2, a database link to an 8.1.7 database should be supported. Database links to earlier versions of 8i (8.1.5 or 8.1.6) are not supported from a 10.2 database. For general sanity, I'd strongly suggest that the 8i side be running at least the 8.1.7.4 patchset but that isn't strictly required.

Windows – STARTUP command fails : Why is that

To restart Oracle, connect via SQL-PLUS as SYSDBA as you did previously, and type in the commands

shutdown normal;
startup mount;
alter database open;
exit;

Oracle SQL Developer can help you graphically administer the Oracle Database.

Most Oracle metadata are stored in special tables. For example,

To show all tables: select * from cat;
To show all users/schemas: select * from dab_users;
To change schemas: alter session set current_schema=NEW_SCHEMA_NAME;

Are there any other specific Oracle commands you were looking for?

Best Answer

Related Solutions

Oracle 10g express database link to Oracle 8i

Windows – STARTUP command fails : Why is that

Related Question