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.
