Kako kreirati Oracle Designer Repository?

Wednesday, 11.03.2009 – Dejan

Oracle Designer je CASE razvojni alat i dolazi u sklopu Oracle Developer Suite.

Nakon ┼íto ste uspje┼íno obavili dva prethodna koraka (instalacija Oracle XE baze i Developer Suite), mo┼żete nastaviti sa kreiranjem Repositorya za Oracle Designer.

Oracle Designer Repository: Instalacija pomo─çu SQL skripta

Kompletan rezultat mo┼żete pogledati u ovoj datoteci: install_oracle_designer_repository.txt .

1. Otvorite prozor sa komandnom linijom: Start -> Run… -> cmd -> OK

2. Podesite Oracle Home za Developer Suite:

C:\>set ORACLE_HOME=C:\DevSuiteHome
C:\>cd C:\DevSuiteHome
C:\DevSuiteHome>cd repadm61\ADMIN

3. Sa SQL*Plus spojite se na bazu kao SYS korisnik:

C:\DevSuiteHome\repadm61\ADMIN>sqlplus sys@xe as sysdba

SQL*Plus: Release 10.1.0.4.2 - Production on So Mrz 9 11:53:43 2009

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

Kennwort eingeben:

Verbunden mit:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

SQL>

4. Potrebno je pokrenuti SQL skript ckqa i unijeti tra┼żene vrijednosti:

Prompt Response
Enter TNS connect string for server
XE
Enter password for SYS
Password za SYS korisnika
Enter the repository size you wish
to create...
S, M ili L za small, medium ili large repository
Dropping temporary table CKRAU_TEMP
Sve gre┼íke┬á“ORA-00942: table or view does not exist.” mogu biti ignorisane
Enter datafile location and name for
tablespace
Putanja do direktorija u kojem su smje┼ítene fizi─Źke┬áOracle datoteke i naziv datoteke
For ten or more subordinate users, we
recommend giving access using public
synonyms. Do you wish to grant create/drop
public synonym privilege to Repository
Owner?
Y
Hit enter to Continue with validation
process...
Stisnite ENTER
Please verify the above values. Edit
'ckparams.txt' to make any changes.
Then run ckparams.txt.
Ako ┼żelite ne┼íto promijeniti neka pode┼íavanja, onda naknadne izmjene obavite u ckparams.txt
SQL> @ckqa
Enter TNS connect String for server
Enter TNS : XE
Enter password for SYS ....'
Kennwort eingeben:
Connect durchgef┬│hrt.

Enter the Repository size you wish to create. Small(S),Medium(M),Large(L) ...
Enter S/M/L : S
Dropping temporary table CKRAU_TEMP

drop table CKRAU_TEMP
           *
FEHLER in Zeile 1:
ORA-00942: Tabelle oder View nicht vorhanden

Creating temporary table CKRAU_TEMP

Tabelle wurde angelegt.

Enter datafile location and name for CONSTANT_GROW_INDEXES...
Enter datafile : C:\ORACLEXE\ORADATA\XE\constant_grow_indexes.dbf

Enter datafile location and name for CONSTANT_GROW_TABLES...
Enter datafile : C:ORACLEXE\ORADATA\XE\constant_grow_tables.dbf

Enter datafile location and name for DEPENDENCY_INDEXES...
Enter datafile : C:\ORACLEXE\ORADATA\XE\dependency_indexes.dbf

Enter datafile location and name for DEPENDENCY_TABLES...
Enter datafile : C:\ORACLEXE\ORADATA\XE\dependency_tables.dbf

Enter datafile location and name for DIAGRAM_INDEXES...
Enter datafile : C:\ORACLEXE\ORADATA\XE\diagram_indexes.dbf

Enter datafile location and name for DIAGRAM_TABLES...
Enter datafile : C:\ORACLEXE\ORADATA\XE\diagram_tables.dbf

Enter datafile location and name for LOB_DATA...
Enter datafile : C:\ORACLEXE\ORADATA\XE\lob_data.dbf

Enter datafile location and name for RAPID_GROW_INDEXES...
Enter datafile : C:\ORACLEXE\ORADATA\XE\rapid_grow_indexes.dbf

Enter datafile location and name for RAPID_GROW_TABLES...
Enter datafile : C:\ORACLEXE\ORADATA\XE\rapid_grow_tables.dbf

Enter datafile location and name for SYSTEM_META_INDEXES...
Enter datafile : C:\ORACLEXE\ORADATA\XE\system_meta_indexes.dbf

Enter datafile location and name for SYSTEM_META_TABLES...
Enter datafile : C:\ORACLEXE\ORADATA\XE\system_meta_tables.dbf

Enter datafile location and name for TEMPORARY_INDEXES...
Enter datafile : C:\ORACLEXE\ORADATA\XE\temporary_indexes.dbf

Enter datafile location and name for TEMPORARY_TABLES...
Enter datafile : C:\ORACLEXE\ORADATA\XE\temporary_tables.dbf

Enter datafile location and name for VERSION_INDEXES...
Enter datafile : C:\ORACLEXE\ORADATA\XE\version_indexes.dbf

Enter datafile location and name for VERSION_TABLES...
Enter datafile : C:\ORACLEXE\ORADATA\XE\version_tables.dbf

Enter datafile location and name for REPOS_RBS tablespace...
Enter datafile : C:\ORACLEXE\ORADATA\XE\repos_rbs.dbf

Enter datafile location and name for REPOS_TEMP tablespace...
Enter datafile : C:\ORACLEXE\ORADATA\XE\repos_temp.dbf

For ten or more subordinate users, we recommend giving access using public synonyms.
Do you wish to grant create/drop public synonym privilege to Repository Owner ?
Enter Choice (Y/N) : Y
...
"  **********************************************************
* "
"  *           Please verify the above values.
* "
"  *        Edit 'ckparams.txt' to make any changes. Then run ckparams.txt
* "
"  **********************************************************
* "

5. Nakon toga treba pokrenuti novokreirani skript ckparams.txt:

SQL>@ckparams.txt

6. Pošto nama treba podrška za naše znakove, a koristimo i Oracle bazu sa Unicode podrškom, moramo umjesto ckcreate pokrenuti skript ckcreate_mb:

SQL>@ckcreate_mb

Dropping role CK_ORACLE_REPOS_OWNER if it already exists
DROP ROLE CK_ORACLE_REPOS_OWNER
          *
FEHLER in Zeile 1:
ORA-01919: Rolle 'CK_ORACLE_REPOS_OWNER' nicht vorhanden

Creating role CK_ORACLE_REPOS_OWNER

Rolle wurde angelegt.

Granting privileges to CK_ORACLE_REPOS_OWNER

Benutzerzugriff (Grant) wurde erteilt.

Granting EXECUTE privilege on STANDARD to CK_ORACLE_REPOS_OWNER

Benutzerzugriff (Grant) wurde erteilt.

************************************************
*         Creating database Objects            *
************************************************

Creating tablespaces ..............
...
End of Grant privilege on database objects to REPOS_MANAGER

End of 'Create database Objects'  process
************************************************

7. Na kraju mo┼żemo pomo─çu skripta ckreport generisati izvje┼ítaj o kreiranim objektima u bazi tokom instalacije (izvje┼ítaj je snimljen u datoteku CKREPORT.LST u istom direktoriju gdje i SQL skript):

SQL> @ckreport
Connect durchgef┬│hrt.
****************************************************
Report on the missing database objects
****************************************************
...
The following Roles were granted to REPOS_MANAGER
------------------------------------------------

CK_ORACLE_REPOS_OWNER
CONNECT
RESOURCE

8. Promijenite šifru/lozinku za REPOS_MANAGER korisnika, da ne bude standardna MANAGER:

SQL> alter user repos_manager identified by r3p0man;
Benutzer wurde ge├Ándert.

9. Dodijelite EXECUTE privilegiju nad paketom UTL_FILE korisniku REPOS_MANAGER, kako ne bi do┼ílo do problema prilikom instalacije (vi┼íe o doti─Źnom problemu kasnije):

SQL> grant execute on utl_file to repos_manager;
Benutzerzugriff (Grant) wurde erteilt.

 

Repository Administration Utility

10. Pokrenite Repository Administration Utility: Start -> All Programs -> Oracle Developer Suite – DevSuiteHome -> Designer -> Repository Administration Utility

start repadmin utility

11. Unesite ┼íifru/lozinku za korisnika REPOS_MANAGER i odgovaraju─çi konektor za bazu. “OK”.

login repository

12. Kada se otvori panel za administraciju,┬ákliknite na┬á“Check requirements” i provjerite, da li su sva pode┼íavanja i privilegije ispravni.

repadmin utility panel check requirements check settings and privileges

13. Ako jesu, kliknite na “Install” kako biste zapo─Źeli sa instalacijom

install designer repository

14. Odaberite opcije za instalaciju

support designer objects

15. Omogu─çite kreiranje PUBLIC sinonima

grant create public synonym

16. Nastavite instalaciju bez podrške za poboljšavanje performansi

no performance

17. Dodijelite odgovaraju─çe Tablespaces pripadaju─çim objektima

reassign tablespaces

18. Nastavite sa instalacijom

proceed with installation

19. Instalacija je u toku

create repository running

20. Ukoliko se ne pojavi nijedna greška, instalacija bi trebala biti gotova nakon 20-30 minuta

create repository operation complete

 

To bi bilo to. Oracle Designer Repository je spreman za korištenje.

 

Troubleshooting

Da se osvrnem na mogući problem spomenut u koraku 9. Ukoliko korisniku REPOS_MANAGER ne dodijelimo privilegiju EXECUTE nad paketom UTL_FILE, doći će do greške prilikom instalacije:
ORA-04603: package body “REPOS_MANAGER.JR_REG_IO” has errors
ORA-06508: PL/SQL: could not find program unit being called: “REPOS_MANAGER.JR_REG_IO”

failed on cksysfol  failed on cksysfol detailed

Ukoliko zaboravite dodijeliti tu privilegiju prije po─Źetka instalacije, poku┼íajte taj problem ovako rije┼íiti (napomena: NE zatvarajte instalacijski prozor!!!):

1. Otvorite prozor sa komandnom linijom (Start -> Run … -> cmd) i pokrenite sqlplus:

C:\DevSuiteHome\repadm61\ADMIN>sqlplus sys@xe as sysdba

SQL*Plus: Release 10.1.0.4.2 - Production on So Mrz 9 11:53:43 2009

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

Kennwort eingeben:

Verbunden mit:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

2. Otkucajte slijede─çe naredbe:

SQL> grant execute on utl_file to repos_manager;

Benutzerzugriff (Grant) wurde erteilt.

SQL> conn repos_manager/r3p0man@xe
Connect durchgef┬│hrt.

SQL> alter package jr_reg_io compile body;

Paketrumpf wurde ge├Ándert.

3. Nakon toga u instalacijskom prozoru kliknite na zeleno “Retry” dugme i sa─Źekajte da se instalacija zavr┼íi.

 

Ugodan rad sa Oracle Designerom!

  1. 4 Responses to “Kako kreirati Oracle Designer Repository?”

  2. Eh da… Moj “instant” Designer uz pomoc tvog tutorijala zaista radi posao! Jos jednom hvala na dobroj volji i izdvojenom vremenu. Siguran sam da nisam jedini kojem ce ovo pomoci.

    By Bozha on Mar 25, 2009

  3. Sjecam se moje prve instalacije repozitorijuma ­čÖé

    Tek sam poceo uciti raditi sa Oracle-om i trebao mi je Dev Suite, a nisam imao nikakvo uputstvo. Oracle je za mene bio potpuno novi svijet.

    Najgore je bilo sto nisam imao ni internet pa da pronadjem odgovor, jer sam bio u novom dijelu firme gdje nisu bili provuceni kablovi jos … A nisam htio nikoga da pitam vec sam odlucio sve sam da saznam.

    Kako sam “provalio” sta sve da uradim – pojma nemam! ­čÖé

    I nije samo u pitanju repozitorijum vec i mnoge druge stvari. Sjecam se da je bilo gomila nestandarnih , nelogicnih i neobjasnjenih stvari u samom dizajneru i drugim oracle-ovim alatima…
    Ali nije to tako lose. Ono do cega sam ( i na tezi nacin ) dodjes – vjecito ostaje u glavi…

    By Darko on Mar 30, 2009

  4. Najljepsa hvala na ovom uputstvu! Blog vam je odlican. Samo tako nastavite. Pozdrav!

    By Ognjen on Apr 23, 2009

  5. Zdravo…. do┼íla sam do koraka 7 i javlja mi gre┼íku da nijesam konektovana. kada sam poku┼íala da se konektujem javlja mi gre┼íku- ora-12560:tns protocol adapter error. kucala sam:
    connect
    user name sys
    pasword manager…

    By ana on Jan 12, 2013

Post a Comment