punyadimas.com

1. Start TNS

lsnrctl start

2. set OracleSID

set ORCL

3. Start Service

sc start OracleSERVICE$ORACLE_SID

4. Start Service using oradim

oradim -startup -sid $ORACLE_SID

5. SQLPLUS “/ as sysdba”

6. startup

SQPLUS “/ as sysdba”

CREATE USER dimas IDENTIFIED BY alamanda;
ALTER USER dimas IDENTIFIED BY alamanda ACCOUNT UNLOCK;
GRANT CREATE ANY DIRECTORY TO dimas;

CREATE OR REPLACE DIRECTORY test_dir AS ‘/u01/app/oracle/oradata/’;
GRANT READ, WRITE ON DIRECTORY test_dir TO dimas;