Navigacija
Lista poslednjih: 16, 32, 64, 128 poruka.

oracle 9i - kreiranje repository-a - KAKO???

[es] :: Oracle :: oracle 9i - kreiranje repository-a - KAKO???

[ Pregleda: 5034 | Odgovora: 7 ] > FB > Twit

Postavi temu Odgovori

Autor

Pretraga teme: Traži
Markiranje Štampanje RSS

tibor
NS

Član broj: 20891
Poruke: 75
212.200.107.*

Sajt: tibor.fotopic.net


Profil

icon oracle 9i - kreiranje repository-a - KAKO???10.03.2005. u 14:04 - pre 231 meseci
ukratko, imam problem sa instalacijom repository-a tj. konkretno sa pravljenjem tablespace-ova. Imam instaliranu bazu 9.2.0.1.0 i Developer Suite Rel 2 (9.0.2). Podesavanje parametara baze je podesio admin pa baza radi kako treba. Podesavanje tablespace-ova sam radio (nazalost) ja na osnovu repository installation guide-a prvo skript metodom, pa onda i manuelnom. U nastavku cete naci logove i greske, nadam se da mi mozete pomoci. Admin mi je rekao da mi ne treba undo i rollback ali ja to ne znam da izbacim iz skript metode a ne poznajem oracle toliko da koristim rucnu metodu.
=============


Dropping role CK_ORACLE_REPOS_OWNER if it already exists

Creating role CK_ORACLE_REPOS_OWNER

Granting privileges to CK_ORACLE_REPOS_OWNER

Granting EXECUTE privilege on STANDARD to CK_ORACLE_REPOS_OWNER
************************************************
* Creating database Objects *
************************************************

Creating tablespaces ..............


Creating CONSTANT_GROW_INDEXES tablespace ....

Tablespace created.


Creating CONSTANT_GROW_TABLES tablespace ....

Tablespace created.


Creating DEPENDENCY_INDEXES tablespace ....

Tablespace created.


Creating DEPENDENCY_TABLES tablespace ....

Tablespace created.


Creating DIAGRAM_INDEXES tablespace ....

Tablespace created.


Creating DIAGRAM_TABLES tablespace ....

Tablespace created.


Creating LOB_DATA tablespace ....

Tablespace created.


Creating RAPID_GROW_INDEXES tablespace ....

Tablespace created.


Creating RAPID_GROW_TABLES tablespace ....

Tablespace created.


Creating SYSTEM_META_INDEXES tablespace ....

Tablespace created.


Creating SYSTEM_META_TABLES tablespace ....

Tablespace created.


Creating TEMPORARY_INDEXES tablespace ....

Tablespace created.


Creating TEMPORARY_TABLES tablespace ....

Tablespace created.


Creating VERSION_INDEXES tablespace ....

Tablespace created.


Creating VERSION_TABLES tablespace ....

Tablespace created.


Creating REPOS_RBS tablespace ....

Tablespace created.


Creating REPOS_TEMP tablespace ....
create tablespace REPOS_TEMP
*
ERROR at line 1:
ORA-12913: Cannot create dictionary managed tablespace



End of tablespace creation process.

****************************************************
Following tablespaces were created
****************************************************

CONSTANT_GROW_INDEXES ONLINE
CONSTANT_GROW_TABLES ONLINE
DEPENDENCY_INDEXES ONLINE
DEPENDENCY_TABLES ONLINE
DIAGRAM_INDEXES ONLINE
DIAGRAM_TABLES ONLINE
LOB_DATA ONLINE
RAPID_GROW_INDEXES ONLINE
RAPID_GROW_TABLES ONLINE
REPOS_RBS ONLINE
SYSTEM_META_INDEXES ONLINE
SYSTEM_META_TABLES ONLINE
TEMPORARY_INDEXES ONLINE
TEMPORARY_TABLES ONLINE
VERSION_INDEXES ONLINE
VERSION_TABLES ONLINE

Creating rollback segment REPOS_RBS_SEGMENT .....
create rollback segment REPOS_RBS_SEGMENT tablespace REPOS_RBS
*
ERROR at line 1:
ORA-30019: Illegal rollback Segment operation in Automatic Undo mode


Bring the rollback segment online .....
alter rollback segment REPOS_RBS_SEGMENT online
*
ERROR at line 1:
ORA-30019: Illegal rollback Segment operation in Automatic Undo mode


Name and Status of the rollback segment

State of non-system rollback segments

_SYSSMU1$ ONLINE
_SYSSMU2$ ONLINE
_SYSSMU3$ ONLINE
_SYSSMU4$ ONLINE
_SYSSMU5$ ONLINE
_SYSSMU6$ ONLINE
_SYSSMU7$ ONLINE
_SYSSMU8$ ONLINE
_SYSSMU9$ ONLINE
_SYSSMU10$ ONLINE


The repository packages, procedures and views are stored in the SYSTEM tablespace, and need 140Mb of free space
****************************************************************************************************************

Current datafile size(in MB) of SYSTEM tablespace

G:\ORACLE\ORADATA\ITCDB\SYSTEM01.DBF SYSTEM 546

Current Free space(in MB) available in SYSTEM tablespace

SYSTEM 150.0625

Sufficient free space available. No resizing necessary ..

Free space(in MB) available in system tablespace ...
******************************************************

SYSTEM 150.0625


Creating Repository User : REPOS_MANAGER having Password : MANAGER

create user REPOS_MANAGER identified by MANAGER
*
ERROR at line 1:
ORA-00959: tablespace 'REPOS_TEMP' does not exist



Granting privilege on database objects to REPOS_MANAGER
*****************************************************

Granting EXECUTE on dbms_lock to REPOS_MANAGER ....
grant execute on dbms_lock to REPOS_MANAGER
*
ERROR at line 1:
ORA-01917: user or role 'REPOS_MANAGER' does not exist



Granting EXECUTE on dbms_pipe to REPOS_MANAGER ....
grant execute on dbms_pipe to REPOS_MANAGER
*
ERROR at line 1:
ORA-01917: user or role 'REPOS_MANAGER' does not exist



Granting CREATE TABLE to REPOS_MANAGER ....
grant create table to REPOS_MANAGER
*
ERROR at line 1:
ORA-01917: user or role 'REPOS_MANAGER' does not exist



Granting CREATE VIEW to REPOS_MANAGER ....
grant create view to REPOS_MANAGER
*
ERROR at line 1:
ORA-01917: user or role 'REPOS_MANAGER' does not exist



Granting CREATE PROCEDURE to REPOS_MANAGER ....
grant create procedure to REPOS_MANAGER
*
ERROR at line 1:
ORA-01917: user or role 'REPOS_MANAGER' does not exist



Granting CREATE SYNONYM to REPOS_MANAGER ....
grant create synonym to REPOS_MANAGER
*
ERROR at line 1:
ORA-01917: user or role 'REPOS_MANAGER' does not exist



Granting CREATE SEQUENCE to REPOS_MANAGER ....
grant create sequence to REPOS_MANAGER
*
ERROR at line 1:
ORA-01917: user or role 'REPOS_MANAGER' does not exist



Granting SELECT on sys.v_$nls_parameters to REPOS_MANAGER ....
grant select on sys.v_$nls_parameters to REPOS_MANAGER with grant option
*
ERROR at line 1:
ORA-01917: user or role 'REPOS_MANAGER' does not exist



Granting SELECT on sys.v_$parameter to REPOS_MANAGER ....
grant select on sys.v_$parameter to REPOS_MANAGER
*
ERROR at line 1:
ORA-01917: user or role 'REPOS_MANAGER' does not exist



Granting SELECT on dba_rollback_segs to REPOS_MANAGER ....
grant select on dba_rollback_segs to REPOS_MANAGER
*
ERROR at line 1:
ORA-01917: user or role 'REPOS_MANAGER' does not exist



Granting SELECT on dba_segments to REPOS_MANAGER ....
grant select on dba_segments to REPOS_MANAGER
*
ERROR at line 1:
ORA-01917: user or role 'REPOS_MANAGER' does not exist



Granting CREATE ANY SYNONYM to REPOS_MANAGER ....
grant create any synonym to REPOS_MANAGER
*
ERROR at line 1:
ORA-01917: user or role 'REPOS_MANAGER' does not exist



Granting DROP ANY SYNONYM to REPOS_MANAGER ....
grant drop any synonym to REPOS_MANAGER
*
ERROR at line 1:
ORA-01917: user or role 'REPOS_MANAGER' does not exist



Granting CK_ORACLE_REPOS_OWNER to REPOS_MANAGER ....
grant ck_oracle_repos_owner to REPOS_MANAGER
*
ERROR at line 1:
ORA-01917: user or role 'REPOS_MANAGER' does not exist



Granting CONNECT,RESOURCE to REPOS_MANAGER ....
grant connect,resource to REPOS_MANAGER
*
ERROR at line 1:
ORA-01917: user or role 'REPOS_MANAGER' does not exist



Granting ALL on CKRAU_TEMP to REPOS_MANAGER ....
grant ALL on sys.CKRAU_TEMP to REPOS_MANAGER
*
ERROR at line 1:
ORA-01917: user or role 'REPOS_MANAGER' does not exist



Creating Synonym CKRAU_TEMP ....
create synonym "REPOS_MANAGER".ckrau_temp for sys.ckrau_temp
*
ERROR at line 1:
ORA-01917: user or role '' does not exist


declare
*
ERROR at line 1:
ORA-01917: user or role 'REPOS_MANAGER' does not exist
ORA-06512: at line 6



End of Grant privilege on database objects to REPOS_MANAGER

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

gde sam popeo?
 
Odgovor na temu

Dejan Topalovic
Dejan Topalović
Senior Oracle DBA & Senior PL/SQL
Developer, Erste Sparinvest (Erste
Bank), Vienna, Austria
Vienna

Član broj: 635
Poruke: 1374
*.1.14.vie.surfer.at.

Sajt: www.baze-podataka.net


+2 Profil

icon Re: oracle 9i - kreiranje repository-a - KAKO???10.03.2005. u 18:56 - pre 231 meseci
Imao sam i ja slicnih problema s time. Gnjavio sam se danima, pitajuci se u cemu je greska. Uspio sam rijesiti taj problem - jedva! :)

Otidji u direktorij gdje si instalirao DeveloperSuite, zatim nadji direktorij repadm61. U tom direktoriju ces naci direktorij admin i u njemu file ckcreate.sql. Otvori taj file i pronadji nesto slicno ovome:

Code:
create temporary tablespace &TEMPTBLSPACE
            tempfile '&TEMPFILENAME' size &TEMPFILESIZE EXTENT MANAGEMENT LOCAL;

Ako ne pise tako, onda zamijeni da bude tako.

Ako ni to ne proradi, onda pokusaj ovako:
Code:
CREATE TEMPORARY TABLESPACE &TEMPTBLSPACE TEMPFILE '&TEMPFILENAME'  SIZE &TEMPFILESIZE REUSE 
AUTOEXTEND ON NEXT 1M UNIFORM SIZE 1M;


Trebalo bi nakon toga da proradi.
Blog - baze podataka
---------------------
Oracle OCP DBA (9i & 10g)
Oracle Database: SQL Certified Expert
Oracle OCP Developer
Certified MySQL DBA
 
Odgovor na temu

tibor
NS

Član broj: 20891
Poruke: 75
212.200.107.*

Sajt: tibor.fotopic.net


Profil

icon Re: oracle 9i - kreiranje repository-a - KAKO???11.03.2005. u 13:01 - pre 231 meseci
Promenio sam "create tablespace &TEMPTBLSPACE datafile '&TEMPFILENAME' size &TEMPFILESIZE temporary;" sa prvim predlogom i skript je prosao bez greske. Sledeci problem se pojavio kada sam pokusao da pokrenem repository administration utilty. U login prozor sam ukucao default user i pass (REPOS_MANAGER i MANAGER) a za connect string "itcdb" jer mi se tako zove baza. U sledecem prozoru sam dobio gresku ORA-12154 TNS:could not resolve service name, a kao razlog pise "the service name specified is not defined correctly in the TNSNAMES.ORA file. Potrazio sam taj fajl i on izgleda ovako:

Code:

# TNSNAMES.ORA Network Configuration File: G:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

INST1_HTTP =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = TIBERIUS)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = SHARED)
      (SERVICE_NAME = MODOSE)
      (PRESENTATION = http://HRService)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

ITCDB =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = TIBERIUS)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = itcdb)
    )
  )

kako da popunim prazna polja da to proradi?
gde sam popeo?
 
Odgovor na temu

Dejan Topalovic
Dejan Topalović
Senior Oracle DBA & Senior PL/SQL
Developer, Erste Sparinvest (Erste
Bank), Vienna, Austria
Vienna

Član broj: 635
Poruke: 1374
*.1.14.vie.surfer.at.

Sajt: www.baze-podataka.net


+2 Profil

icon Re: oracle 9i - kreiranje repository-a - KAKO???11.03.2005. u 14:57 - pre 231 meseci
Sta ti ispise kad otkucas:

C:\> tnsping itcdb
Blog - baze podataka
---------------------
Oracle OCP DBA (9i & 10g)
Oracle Database: SQL Certified Expert
Oracle OCP Developer
Certified MySQL DBA
 
Odgovor na temu

tibor
NS

Član broj: 20891
Poruke: 75
212.200.107.*

Sajt: tibor.fotopic.net


Profil

icon Re: oracle 9i - kreiranje repository-a - KAKO???11.03.2005. u 17:42 - pre 231 meseci
Za "C:\>tnsping itcdb" dobijem sledece :

Code:
TNS Ping Utility for 32-bit Windows: Version 9.0.1.3.1 - Production on 11-MAR-20
05 18:21:22

Copyright (c) 1997 Oracle Corporation.  All rights reserved.

Used parameter files:

TNS-03505: Failed to resolve name


Pre nedelju dana sam jednom vec instalirao oracle
ali sam ubrzo i deinstalirao sve preko oracle-ovog installera. Proces
OracleServiceTIBERIUS (tiberius je prethodni naziv za bazu) mi je jos
uvek u listi procesa ali nije pokrenut. Iz radoznalosti sam ukucao
"C:\>tnsping tiberius" i pojavilo se sledece :

Code:
Used parameter files:

Used HOSTNAME adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SID=*)(SERVICE_NAME=tiberius))
(ADDRESS=(PROTOCOL=TCP)(HOST=tiberius)(PORT=1521)))
OK (10 msec)


Ocigledno uninstall nije pobrisao sve za sobom.

gde sam popeo?
 
Odgovor na temu

Dejan Topalovic
Dejan Topalović
Senior Oracle DBA & Senior PL/SQL
Developer, Erste Sparinvest (Erste
Bank), Vienna, Austria
Vienna

Član broj: 635
Poruke: 1374
*.1.14.vie.surfer.at.

Sajt: www.baze-podataka.net


+2 Profil

icon Re: oracle 9i - kreiranje repository-a - KAKO???11.03.2005. u 20:24 - pre 231 meseci
Izgleda da si nesto poremetio prilikom (de)instalacije.
Ocisti prethodnu instalaciju i instaliraj ponovo sve, pa ce onda raditi.

Prije toga, da pogledamo jos nesto ...

Cini mi se da imas dvije razlicite instalacije Oracle Servera. Jedna verzija je 9.0.1, a druga je 9.2.0. Imas podesene Enviroment varijable, tako da ti putanja ukazuje na oba direktorija u kojem se nalaze te instalacije Oraclea.

To se nalazi u enviroment varijabli PATH. Dakle, obrisi putanju do stare instalacije i ostavi samo za novu. Restartuj kompjuter za svaki slucaj, provjeri koji su servisi pokrenuti i pokreni opet Repository Manager.

Koji su rezultati toga?
Blog - baze podataka
---------------------
Oracle OCP DBA (9i & 10g)
Oracle Database: SQL Certified Expert
Oracle OCP Developer
Certified MySQL DBA
 
Odgovor na temu

tibor
NS

Član broj: 20891
Poruke: 75
212.200.107.*

Sajt: tibor.fotopic.net


Profil

icon Re: oracle 9i - kreiranje repository-a - KAKO???14.03.2005. u 22:18 - pre 231 meseci
izvini ali vec sam bio formatirao particiju sa oracle-om, dok sam procitao tvoju poruku. Danas sam ponovio instalaciju. Bazu sam digao bez problema, tnsping mi je ispisao da je sve OK. Posle sam instalirao DS i kada sam posle probao tnsping dobio sam gresku kao i pre "failed to resolve name". Izmedju instalacije Baze i DS nisam nista menjao. Zasto posle instalacije DS-a ne nalazi instancu baze?
gde sam popeo?
 
Odgovor na temu

Dejan Topalovic
Dejan Topalović
Senior Oracle DBA & Senior PL/SQL
Developer, Erste Sparinvest (Erste
Bank), Vienna, Austria
Vienna

Član broj: 635
Poruke: 1374
*.1.14.vie.surfer.at.

Sajt: www.baze-podataka.net


+2 Profil

icon Re: oracle 9i - kreiranje repository-a - KAKO???14.03.2005. u 22:46 - pre 231 meseci
Jesi li pogledao ono u vezi enviroment varijabli?

Nisam odavno vec instaliravao DS, ali mi se cini da DS moras instalirati u drugi ORACLE_HOME od onog koji je definisan za bazu. Naravno, to sve imas u dokumentaciji i INSTALL uputstvima.
Blog - baze podataka
---------------------
Oracle OCP DBA (9i & 10g)
Oracle Database: SQL Certified Expert
Oracle OCP Developer
Certified MySQL DBA
 
Odgovor na temu

[es] :: Oracle :: oracle 9i - kreiranje repository-a - KAKO???

[ Pregleda: 5034 | Odgovora: 7 ] > FB > Twit

Postavi temu Odgovori

Navigacija
Lista poslednjih: 16, 32, 64, 128 poruka.