Kako videti šta ima od Oracle-a na lokalnoj mašini (WIN 7) (1)

• Videti čega ima pod My Computer/Manage/Services

• Koristiti SQL upit da se vide detalji.  

Napomena : Paziti da lokalni nalog koji se koristi bude u ove dve grupe : Administrators i ORA_DBA (Control Panel/User Accounts/Manage User Accounts/Properties/Advanced i tu željenom nalogu dodati sve potrebne grupe.

Otvoriti CLI i logovati se sa podešenim nalogom, obavezno kao sysdba :

C:\>sqlplus

SQL*Plus: Release 11.2.0.2.0 Production on Thu Aug 30 13:13:45 2018

Copyright (c) 1982, 2014, Oracle. All rights reserved.

Enter user-name: moj.nalog / as sysdba
Enter password:

Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 – 64bit Production

• Kako videti gde je Oracle home (Rt-Click on Computer/Properties/Advanced system settings/Advanced Tab/Environment Variables/ then check Path Option in the System variables to see Oracle client HOME dir.) :

• Kako videti podatke o Oracle DB

SQL> select name from V$database;

DBNAME

XE

SQL>

Pošto ja imam default instalaciju, mogu postupati po ovom linku, i omogućiti nalog “hr” sa kojim ću nadalje da radim :

SQL> alter user hr identified by hr account unlock;

User altered.