Oracle Database

You get a shortcut  on your desktop after installation :
"Get Started With Oracle Database 11g Express Edition ".
That links to :
http://127.0.0.1:8080/apex/f?p=4950:1:2839050805982268

Go to Storage



The online help
( http://docs.oracle.com/cd/E17781_01/admin.112/e18585/toc.htm#BJFCGCAA )
tells you :

  1. Connect as the SYSTEM user:

    • Type: connect

    • Enter user-name: system

    • Enter password: <password-for-system>

so you do :

.
and you get :

_________________________________________________________________________

Vrml...........................

______________________________________________________________________

Sommaire................

Intro

______________________________________________________________________

Oracle Database
http://outside.revemonde.net/csadmin/doc/wwhelp/js/html/frames.htm#reference/dbref4.html
http://outside.revemonde.net/csadmin/doc/reference/dbref5.html

Oracle SQL Developer for 32-bit Windows (This zip does not include a JDK)
(171 M) 

sqldeveloper-3.1.07.42-no-jre.zip

To install and run:
   - Ensure you have a JDK installed, if not, download here
       (click the Download for JDK 6 Update <xx>, where <xx> is the latest update)
   - Download the file above
   - Extract sqldeveloper.zip into any folder, using folder names
   - Within that folder, open the sqldeveloper folder
   - Double-click sqldeveloper.exe

   

Oracle SQL Developer for 32-bit Windows (This zip file includes the JDK1.6.0_11)







so ...JDK needed :

http://www.oracle.com/technetwork/java/javaee/downloads/java-ee-sdk-6u3-jdk-6u29-downloads-523388.html

Then you instal the oracle developer and you have it :






You can open  ...\blaxxun\CommServ\etc\sqserver.sql


.
and you must "Execute it"

Btw I have probs to connect and I see that http://localhost:4848
doenst work for me , so I changed for
http//127.0.0.1:4848
that opens that :

.
so that shows that :



You install platform 7 from      cs-7-0-win-full.exe



for Deactivate the fcserver you need to add # to the fcserver with port 4004 and restart
... if still not working you need to add to all the fcservers #
and of the orserver you need to delete the # in the chstart file.

OF course run Oracle !



Change :

 "Your_ORACLE_HOME"
 "Your_ORACLE_DATABASE"
 "Your_ORACLE_db_userid"
 "Your_ORACLE_db_userpassword"

answer found on a forum :

  • ORACLE_HOME should be set to a directory path one level above the bin directory where your sqlplus executable file is found
  • There should be a couple of .msb files under $ORACLE_HOME/sqlplus/msg
  • There should be hundreds (not sure of the number with XE) of .msb files under $ORACLE_HOME (find $ORACLE_HOME -name "*.msb" -print ...should show them)
  • Your PATH should include $ORACLE_HOME/bin
  • All files under ORACLE_HOME should be owned by user:group oracle:dba
??????????????????????????????
%ORACLE_HOME%\bin

Btw I found the sqlPlus


_________________________________________________________________________

Vrml...........................

______________________________________________________________________

Contents....................

Intro

_______________________________________________________________________