[ GORSHTAK @ 17.09.2010. 18:55 ] @
U oraclu (10G enterprise, na RedHatu) su mi podignute 2 instance (baza1 i baza2), jedna je pobrljavila sama od sebe (ma kolko god to nemoguće zvučalo) i sad ne mogu da joj priđem. Smatram da je problem zato što je demountovana. Cilj mi je da podignem preko sqlplus-a sa komandom startup. Evo podataka o bazi2: kreirana komadom > dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbname baza2 -sid baza2 -characterSet AL32UTF8 -sysPassword lozinka -systemPassword lozinka -responseFile NO_VALUE -memoryPercentage 60 Oracle SID > echo $ORACLE_SID baza1 Listener status gde se vidi da je samo baza1 podignuta >lsnrctl status LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 17-SEP-2010 19:08:51 Copyright (c) 1991, 2005, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=serverDB)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production Start Date 17-SEP-2010 17:23:36 Uptime 0 days 1 hr. 45 min. 14 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/oracle/product/10.1.0/db_1/network/admin/listener.ora Listener Log File /u01/app/oracle/product/10.1.0/db_1/network/log/listener.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=serverDB)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=serverDB)(PORT=1526))) Services Summary... Service "PLSExtProc" has 1 instance(s). Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... Service "baza1" has 1 instance(s). Instance "baza1", status READY, has 1 handler(s) for this service... Service "baza1XDB" has 1 instance(s). Instance "baza1", status READY, has 1 handler(s) for this service... Service "baza1_XPT" has 1 instance(s). Instance "baza1", status READY, has 1 handler(s) for this service... The command completed successfully Fajlovi listener i tnsnames >cat /u01/app/oracle/product/10.1.0/db_1/network/admin/listener.ora # listener.ora Network Configuration File: /u01/app/oracle/product/10.1.0/db_1/network/admin/listener.ora # Generated by Oracle configuration tools. SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /u01/app/oracle/product/10.1.0/db_1) (PROGRAM = extproc) ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = serverDB)(PORT = 1521)) ) (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = serverDB)(PORT = 1526)) ) ) #LISTENER = # (DESCRIPTION_LIST = # (DESCRIPTION = # (ADDRESS = (PROTOCOL = TCP)(HOST = serverDB)(PORT = 1521)) # (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) # ) # ) > > > >cat /u01/app/oracle/product/10.1.0/db_1/network/admin/tnsnames.ora # tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.1.0/db_1/network/admin/tnsnames.ora # Generated by Oracle configuration tools. BAZA2 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = serverDB)(PORT = 1526)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = baza2) ) ) #BAZA1 = # (DESCRIPTION = # (ADDRESS = (PROTOCOL = TCP)(HOST = serverDB)(PORT = 1521)) # (CONNECT_DATA = # (SERVER = DEDICATED) # (SERVICE_NAME = baza1) # ) # ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) Bazu1 sam privremeno zakomentarisao, u slučaju da uspem da se povežem na bazu2 A sad prelazak na akciju: pre nego što se stigne do connect / as sysdba, nego jel postoji neka alternativa ovoj komandi ali da nije connect as sys/loz@baza2 ? >sqlplus /nolog SQL*Plus: Release 10.2.0.1.0 - Production on Fri Sep 17 19:13:46 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. SQL> set instance baza2 ERROR: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor > set instance baza1 ERROR: ORA-12154: TNS:could not resolve the connect identifier specified > set instance baza1 Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options SQL> set instance baza2 ERROR: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor U prvom koraku je izbacio navedenu grešku, greška drugog koraka je zato što sam bazu1 zakomentarisao u tnsnames, pa se u trećem koraku vidi uspešno povezivanje, a u četvrtom naravno opet greška. Menjanje oracle_sid u baza2 takođe nije pomoglo. Ako bih pokušao alter database baza2 mount prijavi mi da je baza već mountovana. Ali i za kraj: >sqlplus /nolog SQL*Plus: Release 10.2.0.1.0 - Production on Fri Sep 17 19:43:50 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. SQL> set instance baza1 Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production SQL> connect / as sysdba ERROR: ORA-01031: insufficient privileges Po ovome opet ne bih uspeo da se nakačim. Jel zna neko šta je potrebno da se namesti, šta sam izostavio u podešavanjima? [Ovu poruku je menjao GORSHTAK dana 18.09.2010. u 21:12 GMT+1] |