How to start Oracle
One of the services in Windows system Services is called: "Oracleservice[sid]" SID is your instance name when you install Oracle XE, and if you do not change the default is "XE",
Oracleservicexe and Oraclexetnslistener automatically start by default, find the "Oracleservicexe" this service, start it OK.
Navicat for Oracle connection settings
Log in using Sqlplus (password set yourself):
cmd command Line input Sqlplus/nolog
User name: Sys as SYSDBA
Password: root
User name: System
Password: root
SQL SYS Connection:
Sql>connect Sys/root as SYSDBA;
Or
Sql>connect as SYSDBA;
Create user-assigned password:
Create user root identified by root;
Change Password:
Alert user root identified by 12345;
To create a temporary tablespace:
Create temporary tablespace test_temp
Tempfile ' D:\test_temp01.dbf '
Size 32m
Autoextend on
Next 32m MaxSize 2048m
Extent management Local;
To create a data table space:
Create Tablespace Test
Logging
DataFile ' D:\test01.dbf '
Size 32m
Autoextend on
Next 32m MaxSize 2048m
Extent management Local;
To specify a table space for the user:
Alert User root default tablespace test;
To authorize the user:
Grant Connect,create table,resource,dba to root;
To view User rights:
SELECT * from user_sys_privs;//View all permissions for the current user
SELECT * from user_tab_privs;//View the user's permissions on the table
PHP Connect Oracle Database 11g Express Edition
Modify PHP.ini
Extension=extension=php_oci8.dll
Test code:
<?php
$user = ' System ';
$pwd = ' root ';
$c =oci_connect ($user, $pwd);
if ($c) {
echo "Oracle connected!";
}
?>
Oracle Database 11g Express Edition Usage Summary (Windows)