пропозиції роботи
Wypowiedzi
-
zacząłem instalacje z starszej wersji 10g
dołożyłem drugi listener:
# listener.ora Network Configuration File:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC=
(SID_NAME=XE)
(ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server)
)
(SID_DESC=
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /usr/lib/oracle/xe/app/oracle/product/10.2.0/server)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
)
DEFAULT_SERVICE_LISTENER = (XE)
po odpaleniu: lsnrctl start , status mam oba
rafal@rafal-laptop:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin$ lsnrctl status
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 20-MAR-2012 22:48:01
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 20-MAR-2012 22:43:56
Uptime 0 days 0 hr. 4 min. 5 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
Listener Log File /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "XE" has 1 instance(s).
Instance "XE", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
ale o dziwo mogę się połączyć przez sqldevelopera;] jako SYSDBA
dziwne to czy nie?Rafał Dąbrowski edytował(a) ten post dnia 20.03.12 o godzinie 22:49 -
Wypakowałem rpm, szukane skrypty postinstall powinny znajdować się w /usr/share/insserv/
jednak w wypakowanym rpm nie ma takiego folderu
rafal@rafal-laptop:~/Pobrane/Disk1/usr/share$ ls
applications desktop-menu-files doc gnome pixmaps
więc tych skryptów nie ma tam wcale
Z innej beczki, wywaliłem wszystko i jadę teraz z innej instrukcji, z innego instalatora:
http://blog.stelmisoft.pl/2010/instalacja-bazy-danych-...
i od tego wyjdźmy:
Teraz wygląda to tak:
rafal@rafal-laptop:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs$ lsnrctl status
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 20-MAR-2012 22:22:24
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 20-MAR-2012 22:11:19
Uptime 0 days 0 hr. 11 min. 4 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
Listener Log File /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
i w sqldeveloperze wpisuje:
host 127.0.0.1
port 1521
sid PLSExtProc
i dostaję Status : Failure -Test failed: Nie ma więcej danych do odczytu z gniazdaRafał Dąbrowski edytował(a) ten post dnia 20.03.12 o godzinie 22:24 -
No to od nowa,
wywaliłem oracle-xe, usunąłem ORACLE_HOME (katalogi)
i przy instalacji mam takie coś:
rafal@rafal-laptop:~/Pobrane/Disk1$ sudo dpkg -i oracle-xe_11.2.0-2_amd64.deb
Zaznaczenie poprzednio niezaznaczonego pakietu oracle-xe.
(Odczytywanie bazy danych ... 274228 plików i katalogów obecnie zainstalowanych.)
Rozpakowanie oracle-xe (z oracle-xe_11.2.0-2_amd64.deb) ...
Konfigurowanie oracle-xe (11.2.0-2) ...
Executing post-install steps...
insserv: warning: script 'K07smfpd' missing LSB tags and overrides
insserv: warning: script 'K20acpi-support' missing LSB tags and overrides
insserv: warning: script 'oracle-xe' missing LSB tags and overrides
insserv: warning: script 'udev-finish' missing LSB tags and overrides
insserv: warning: script 'cron' missing LSB tags and overrides
insserv: warning: current start runlevel(s) (6) of script `reboot' overwrites defaults (empty).
insserv: warning: script 'avahi-daemon' missing LSB tags and overrides
insserv: warning: script 'atd' missing LSB tags and overrides
insserv: warning: script 'network-interface-security' missing LSB tags and overrides
insserv: warning: script 'network-interface' missing LSB tags and overrides
insserv: warning: script 'udev' missing LSB tags and overrides
insserv: warning: current start runlevel(s) (0 6) of script `networking' overwrites defaults (empty).
insserv: warning: script 'alsa-mixer-save' missing LSB tags and overrides
insserv: warning: script 'dbus' missing LSB tags and overrides
insserv: warning: script 'plymouth-stop' missing LSB tags and overrides
insserv: warning: script 'rsyslog' missing LSB tags and overrides
insserv: warning: script 'anacron' missing LSB tags and overrides
insserv: warning: script 'network-manager' missing LSB tags and overrides
insserv: warning: script 'ufw' missing LSB tags and overrides
insserv: warning: script 'procps' missing LSB tags and overrides
insserv: warning: script 'hwclock' missing LSB tags and overrides
insserv: warning: script 'plymouth-log' missing LSB tags and overrides
insserv: warning: script 'plymouth-splash' missing LSB tags and overrides
insserv: warning: script 'smfpd' missing LSB tags and overrides
insserv: warning: current start runlevel(s) (0 6) of script `umountnfs.sh' overwrites defaults (empty).
insserv: warning: current start runlevel(s) (0 6) of script `umountfs' overwrites defaults (empty).
insserv: warning: script 'acpid' missing LSB tags and overrides
insserv: warning: current start runlevel(s) (0 6) of script `sendsigs' overwrites defaults (empty).
insserv: warning: script 'hwclock-save' missing LSB tags and overrides
insserv: warning: script 'gdm' missing LSB tags and overrides
insserv: warning: script 'udevmonitor' missing LSB tags and overrides
insserv: warning: script 'failsafe-x' missing LSB tags and overrides
insserv: warning: current start runlevel(s) (0) of script `halt' overwrites defaults (empty).
insserv: warning: script 'udevtrigger' missing LSB tags and overrideshis will print one error message ("error: incorrect format: unknown tag"), but it's insignificant.
insserv: warning: script 'hostname' missing LSB tags and overrides
insserv: warning: script 'acpi-support' missing LSB tags and overrides
insserv: warning: current start runlevel(s) (0 6) of script `wpa-ifupdown' overwrites defaults (empty).
insserv: warning: script 'plymouth' missing LSB tags and overrides
insserv: warning: script 'screen-cleanup' missing LSB tags and overrides
insserv: warning: script 'irqbalance' missing LSB tags and overrides
insserv: warning: current start runlevel(s) (0 6) of script `umountroot' overwrites defaults (empty).
insserv: warning: script 'console-setup' missing LSB tags and overrides
insserv: warning: script 'apport' missing LSB tags and overrides
insserv: warning: script 'module-init-tools' missing LSB tags and overrides
insserv: warning: script 'dmesg' missing LSB tags and overrides
insserv: There is a loop between service rsyslog and pulseaudio if stopped
insserv: loop involving service pulseaudio at depth 3
insserv: loop involving service rsyslog at depth 2
insserv: loop involving service udev at depth 1
insserv: There is a loop between service rsyslog and pulseaudio if stopped
insserv: loop involving service hwclock at depth 2
insserv: exiting now without changing boot order!
/sbin/insserv failed, exit code 1
oracle-xe 0:off 1:off 2:off 3:off 4:off 5:off 6:off
You must run '/etc/init.d/oracle-xe configure' as the root user to configure the database.
Przetwarzanie wyzwalaczy dla desktop-file-utils...
Przetwarzanie wyzwalaczy dla python-gmenu...
Rebuilding /usr/share/applications/desktop.pl_PL.utf8.cache...
Przetwarzanie wyzwalaczy dla ureadahead...
Przetwarzanie wyzwalaczy dla libc-bin...
ldconfig deferred processing now taking place
Przetwarzanie wyzwalaczy dla python-support...
może problem jest w paczce którą robię z rpm:
root@rafal-laptop:/home/rafal/Pobrane/Disk1# sudo alien -k --scripts oracle-xe-11.2.0-1.0.x86_64.rpm
error: incorrect format: unknown tag
oracle-xe_11.2.0-1.0_amd64.deb generated
bo tutaj dostaję error.
(chciaż google mówi: this will print one error message ("error: incorrect format: unknown tag"), but it's insignificant.) więc już nie wiem co, napewno informcje o insserv są pewnie ważne.Rafał Dąbrowski edytował(a) ten post dnia 19.03.12 o godzinie 21:02 -
zaciagnąłem z oracla:
http://www.oracle.com/technetwork/products/express-edi...
wersje linux x64
stawiam na ubuntu 10.04 -
$ sudo /etc/init.d/oracle-xe configure
Oracle Database 11g Express Edition is already configured
Nie podoba ci się ta linijka? :]
"control_files = (ora_control1, ora_control2)"
$ sudo find /u01 -name '*control*' -print
nie zwraca mi nic....
generalnie nie ma takiego pliku, więc nie ma jak uzupełnić
może powinienem stworzyć te pliki i tyle, czy może
$ sudo /etc/init.d/oracle-xe configure powinno je wygenerować?
jeśli tak, to jak wywołać ponowną próbę konfigurację/reset (czy coś podobnego) -
Znalazłem ten plik, wkleiłem poniżej, sam widzę coś niepokojącego
"ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/product/11.2.0/xe/dbs/ora_control2'"
nie może otworzyć tego pliku (no bo go nie ma! sprawdziłem)
powinienem go stworzyć sam, czy sam powinien się wygenerować? Jak ma wyglądać? Może jest inny problem?
Fri Mar 16 21:32:53 2012
LGWR started with pid=11, OS id=19202
Fri Mar 16 21:32:53 2012
CKPT started with pid=12, OS id=19204
Fri Mar 16 21:32:54 2012
SMON started with pid=13, OS id=19206
Fri Mar 16 21:32:54 2012
RECO started with pid=14, OS id=19208
Fri Mar 16 21:32:54 2012
MMON started with pid=15, OS id=19210
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Fri Mar 16 21:32:54 2012
MMNL started with pid=16, OS id=19212
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /u01/app/oracle
Fri Mar 16 21:32:54 2012
ALTER DATABASE MOUNT
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/product/11.2.0/xe/dbs/ora_control2'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/product/11.2.0/xe/dbs/ora_control1'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-205 signalled during: ALTER DATABASE MOUNT...
Fri Mar 16 21:32:54 2012
Checker run found 2 new persistent data failures
Fri Mar 16 21:38:11 2012
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 1
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Fri Mar 16 21:38:13 2012
Stopping background process VKTM
Fri Mar 16 21:38:15 2012
Instance shutdown complete
Fri Mar 16 21:38:16 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production.
Using parameter settings in server-side pfile /u01/app/oracle/product/11.2.0/xe/dbs/initXE.ora
System parameters with non-default values:
processes = 150
memory_target = 1G
control_files = "/u01/app/oracle/product/11.2.0/xe/dbs/ora_control1"
control_files = "/u01/app/oracle/product/11.2.0/xe/dbs/ora_control2"
db_block_size = 8192
compatible = "11.2.0"
db_recovery_file_dest = "/u01/app/oracle/db_recovery/"
db_recovery_file_dest_size= 2G
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=ORCLXDB)"
audit_file_dest = "/u01/app/oracle/admin/orcl/adump"
audit_trail = "DB"
db_name = "ORCL"
open_cursors = 300
diagnostic_dest = "/u01/app/oracle/"
Fri Mar 16 21:38:16 2012
PMON started with pid=2, OS id=19813
Fri Mar 16 21:38:16 2012
PSP0 started with pid=3, OS id=19815
Fri Mar 16 21:38:17 2012
VKTM started with pid=4, OS id=19817
VKTM running at (100ms) precision
Fri Mar 16 21:38:17 2012
GEN0 started with pid=5, OS id=19821
Fri Mar 16 21:38:18 2012
DIAG started with pid=6, OS id=19823
Fri Mar 16 21:38:18 2012
DBRM started with pid=7, OS id=19825
Fri Mar 16 21:38:18 2012
DIA0 started with pid=8, OS id=19827
Fri Mar 16 21:38:18 2012
MMAN started with pid=9, OS id=19829
Fri Mar 16 21:38:18 2012
DBW0 started with pid=10, OS id=19831
Fri Mar 16 21:38:18 2012
LGWR started with pid=11, OS id=19833
Fri Mar 16 21:38:18 2012
CKPT started with pid=12, OS id=19835
Fri Mar 16 21:38:18 2012
SMON started with pid=13, OS id=19837
Fri Mar 16 21:38:18 2012
RECO started with pid=14, OS id=19839
Fri Mar 16 21:38:18 2012
MMON started with pid=15, OS id=19841
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Fri Mar 16 21:38:18 2012
MMNL started with pid=16, OS id=19843
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /u01/app/oracle
Fri Mar 16 21:38:18 2012
ALTER DATABASE MOUNT
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/product/11.2.0/xe/dbs/ora_control2'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/product/11.2.0/xe/dbs/ora_control1'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-205 signalled during: ALTER DATABASE MOUNT...
Fri Mar 16 21:47:08 2012
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 1
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Fri Mar 16 21:47:10 2012
Stopping background process VKTM
Fri Mar 16 21:47:12 2012
Instance shutdown complete
Fri Mar 16 21:47:13 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production.
Using parameter settings in server-side pfile /u01/app/oracle/product/11.2.0/xe/dbs/initXE.ora
System parameters with non-default values:
processes = 150
memory_target = 1G
control_files = "/u01/app/oracle/product/11.2.0/xe/dbs/ora_control1"
control_files = "/u01/app/oracle/product/11.2.0/xe/dbs/ora_control2"
db_block_size = 8192
compatible = "11.2.0"
db_recovery_file_dest = "/u01/app/oracle/db_recovery/"
db_recovery_file_dest_size= 2G
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=ORCLXDB)"
audit_file_dest = "/u01/app/oracle/admin/orcl/adump"
audit_trail = "DB"
db_name = "ORCL"
open_cursors = 300
diagnostic_dest = "/u01/app/oracle/"
Fri Mar 16 21:47:13 2012
PMON started with pid=2, OS id=20495
Fri Mar 16 21:47:13 2012
PSP0 started with pid=3, OS id=20497
Fri Mar 16 21:47:14 2012
VKTM started with pid=4, OS id=20499
VKTM running at (100ms) precision
Fri Mar 16 21:47:14 2012
GEN0 started with pid=5, OS id=20503
Fri Mar 16 21:47:14 2012
DIAG started with pid=6, OS id=20505
Fri Mar 16 21:47:14 2012
DBRM started with pid=7, OS id=20507
Fri Mar 16 21:47:15 2012
DIA0 started with pid=8, OS id=20509
Fri Mar 16 21:47:15 2012
MMAN started with pid=9, OS id=20511
Fri Mar 16 21:47:15 2012
DBW0 started with pid=10, OS id=20513
Fri Mar 16 21:47:15 2012
LGWR started with pid=11, OS id=20515
Fri Mar 16 21:47:15 2012
CKPT started with pid=12, OS id=20517
Fri Mar 16 21:47:15 2012
SMON started with pid=13, OS id=20519
Fri Mar 16 21:47:15 2012
RECO started with pid=14, OS id=20521
Fri Mar 16 21:47:15 2012
MMON started with pid=15, OS id=20523
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Fri Mar 16 21:47:15 2012
MMNL started with pid=16, OS id=20525
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /u01/app/oracle
Fri Mar 16 21:47:15 2012
ALTER DATABASE MOUNT
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/product/11.2.0/xe/dbs/ora_control2'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/product/11.2.0/xe/dbs/ora_control1'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-205 signalled during: ALTER DATABASE MOUNT...
Fri Mar 16 22:06:00 2012
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 1
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Fri Mar 16 22:06:02 2012
Stopping background process VKTM
Fri Mar 16 22:06:04 2012
Instance shutdown complete
Fri Mar 16 22:06:53 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production.
Using parameter settings in server-side pfile /u01/app/oracle/product/11.2.0/xe/dbs/initXE.ora
System parameters with non-default values:
processes = 150
memory_target = 1G
control_files = "/u01/app/oracle/product/11.2.0/xe/dbs/ora_control1"
control_files = "/u01/app/oracle/product/11.2.0/xe/dbs/ora_control2"
db_block_size = 8192
compatible = "11.2.0"
db_recovery_file_dest = "/u01/app/oracle/db_recovery/"
db_recovery_file_dest_size= 2G
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=ORCLXDB)"
audit_file_dest = "/u01/app/oracle/admin/orcl/adump"
audit_trail = "DB"
db_name = "ORCL"
open_cursors = 300
diagnostic_dest = "/u01/app/oracle/"
Fri Mar 16 22:06:53 2012
PMON started with pid=2, OS id=21376
Fri Mar 16 22:06:53 2012
PSP0 started with pid=3, OS id=21378
Fri Mar 16 22:06:54 2012
VKTM started with pid=4, OS id=21380
VKTM running at (100ms) precision
Fri Mar 16 22:06:54 2012
GEN0 started with pid=5, OS id=21384
Fri Mar 16 22:06:54 2012
DIAG started with pid=6, OS id=21386
Fri Mar 16 22:06:54 2012
DBRM started with pid=7, OS id=21388
Fri Mar 16 22:06:54 2012
DIA0 started with pid=8, OS id=21390
Fri Mar 16 22:06:55 2012
MMAN started with pid=9, OS id=21392
Fri Mar 16 22:06:55 2012
DBW0 started with pid=10, OS id=21394
Fri Mar 16 22:06:55 2012
LGWR started with pid=11, OS id=21396
Fri Mar 16 22:06:55 2012
CKPT started with pid=12, OS id=21398
Fri Mar 16 22:06:55 2012
SMON started with pid=13, OS id=21400
Fri Mar 16 22:06:55 2012
RECO started with pid=14, OS id=21402
Fri Mar 16 22:06:55 2012
MMON started with pid=15, OS id=21404
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Fri Mar 16 22:06:55 2012
MMNL started with pid=16, OS id=21406
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /u01/app/oracle
Fri Mar 16 22:06:55 2012
ALTER DATABASE MOUNT
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/product/11.2.0/xe/dbs/ora_control2'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/product/11.2.0/xe/dbs/ora_control1'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-205 signalled during: ALTER DATABASE MOUNT...
Fri Mar 16 22:25:51 2012
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 1
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Fri Mar 16 22:25:54 2012
Stopping background process VKTM
Fri Mar 16 22:25:56 2012
Instance shutdown complete
Fri Mar 16 22:25:57 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production.
Using parameter settings in server-side pfile /u01/app/oracle/product/11.2.0/xe/dbs/initXE.ora
System parameters with non-default values:
processes = 150
memory_target = 1G
control_files = "/u01/app/oracle/product/11.2.0/xe/dbs/ora_control1"
control_files = "/u01/app/oracle/product/11.2.0/xe/dbs/ora_control2"
db_block_size = 8192
compatible = "11.2.0"
db_recovery_file_dest = "/u01/app/oracle/db_recovery/"
db_recovery_file_dest_size= 2G
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=ORCLXDB)"
audit_file_dest = "/u01/app/oracle/admin/orcl/adump"
audit_trail = "DB"
db_name = "ORCL"
open_cursors = 300
diagnostic_dest = "/u01/app/oracle/"
Fri Mar 16 22:25:57 2012
PMON started with pid=2, OS id=22158
Fri Mar 16 22:25:57 2012
PSP0 started with pid=3, OS id=22160
Fri Mar 16 22:25:58 2012
VKTM started with pid=4, OS id=22162
VKTM running at (100ms) precision
Fri Mar 16 22:25:58 2012
GEN0 started with pid=5, OS id=22166
Fri Mar 16 22:25:58 2012
DIAG started with pid=6, OS id=22168
Fri Mar 16 22:25:58 2012
DBRM started with pid=7, OS id=22170
Fri Mar 16 22:25:58 2012
DIA0 started with pid=8, OS id=22172
Fri Mar 16 22:25:58 2012
MMAN started with pid=9, OS id=22174
Fri Mar 16 22:25:58 2012
DBW0 started with pid=10, OS id=22176
Fri Mar 16 22:25:58 2012
LGWR started with pid=11, OS id=22178
Fri Mar 16 22:25:58 2012
CKPT started with pid=12, OS id=22180
Fri Mar 16 22:25:59 2012
SMON started with pid=13, OS id=22182
Fri Mar 16 22:25:59 2012
RECO started with pid=14, OS id=22184
Fri Mar 16 22:25:59 2012
MMON started with pid=15, OS id=22186
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Fri Mar 16 22:25:59 2012
MMNL started with pid=16, OS id=22188
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /u01/app/oracle
Fri Mar 16 22:25:59 2012
ALTER DATABASE MOUNT
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/product/11.2.0/xe/dbs/ora_control2'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/product/11.2.0/xe/dbs/ora_control1'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-205 signalled during: ALTER DATABASE MOUNT...
Fri Mar 16 22:29:34 2012
Starting ORACLE instance (normal)
Fri Mar 16 22:31:26 2012
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 1
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Fri Mar 16 22:31:28 2012
Stopping background process VKTM
Fri Mar 16 22:31:30 2012
Instance shutdown complete
Fri Mar 16 22:31:34 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production.
Using parameter settings in server-side spfile /u01/app/oracle/product/11.2.0/xe/dbs/spfileXE.ora
System parameters with non-default values:
processes = 150
memory_target = 1G
control_files = "/u01/app/oracle/product/11.2.0/xe/dbs/ora_control1"
control_files = "/u01/app/oracle/product/11.2.0/xe/dbs/ora_control2"
db_block_size = 8192
compatible = "11.2.0"
db_recovery_file_dest = "/u01/app/oracle/db_recovery/"
db_recovery_file_dest_size= 2G
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=ORCLXDB)"
audit_file_dest = "/u01/app/oracle/admin/orcl/adump"
audit_trail = "DB"
db_name = "ORCL"
open_cursors = 300
diagnostic_dest = "/u01/app/oracle/"
Fri Mar 16 22:31:35 2012
PMON started with pid=2, OS id=22603
Fri Mar 16 22:31:35 2012
PSP0 started with pid=3, OS id=22605
Fri Mar 16 22:31:36 2012
VKTM started with pid=4, OS id=22607
VKTM running at (100ms) precision
Fri Mar 16 22:31:36 2012
GEN0 started with pid=5, OS id=22611
Fri Mar 16 22:31:36 2012
DIAG started with pid=6, OS id=22613
Fri Mar 16 22:31:36 2012
DBRM started with pid=7, OS id=22615
Fri Mar 16 22:31:36 2012
DIA0 started with pid=8, OS id=22617
Fri Mar 16 22:31:37 2012
MMAN started with pid=9, OS id=22619
Fri Mar 16 22:31:37 2012
DBW0 started with pid=10, OS id=22621
Fri Mar 16 22:31:37 2012
LGWR started with pid=11, OS id=22623
Fri Mar 16 22:31:37 2012
CKPT started with pid=12, OS id=22625
Fri Mar 16 22:31:37 2012
SMON started with pid=13, OS id=22627
Fri Mar 16 22:31:37 2012
RECO started with pid=14, OS id=22629
Fri Mar 16 22:31:37 2012
MMON started with pid=15, OS id=22631
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Fri Mar 16 22:31:37 2012
MMNL started with pid=16, OS id=22633
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /u01/app/oracle
Fri Mar 16 22:31:37 2012
ALTER DATABASE MOUNT
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/product/11.2.0/xe/dbs/ora_control2'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/product/11.2.0/xe/dbs/ora_control1'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-205 signalled during: ALTER DATABASE MOUNT...
Fri Mar 16 22:32:00 2012
ALTER SYSTEM SET local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))' SCOPE=BOTH;
Sat Mar 17 10:41:06 2012
VKTM detected a time drift. Please check trace file for more details.
VKTM detected a time drift. Please check trace file for more details.
Sat Mar 17 14:51:52 2012
VKTM detected a time drift. Please check trace file for more details.
Sat Mar 17 15:02:01 2012
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 1
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Sat Mar 17 15:02:03 2012
Stopping background process VKTM
Sat Mar 17 15:02:05 2012
Instance shutdown completeRafał Dąbrowski edytował(a) ten post dnia 17.03.12 o godzinie 23:57 -
Wygląda jak by startował jeszcze jeden listener, nie wiem czy to normalne.
Generalnie po ręcznym zastopowaniu lsnrctl stop -> start -> status mam już jeden:
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date 17-MAR-2012 15:08:31
Uptime 0 days 0 hr. 10 min. 20 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/11.2.0/xe/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
Co nie zmiania faktu że jak próbuje połączyć się sqldevelopera, wpisując sid 'XE':
Status : Failure -Test failed: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
a jak wpisuję jako SID PLSExtProc (?!):
Status : Failure -Test failed: Nie ma więcej danych do odczytu z gniazda
I tak źle i tak nie dobrze;]
Poniżej końcówka pliku xml.log
<txt>System parameter file is /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora
</txt>
</msg>
<msg time='2012-03-16T21:38:15.724+01:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='rafal-laptop'
host_addr='127.0.1.1'>
<txt>Log messages written to /u01/app/oracle/diag/tnslsnr/rafal-laptop/listener/alert/log.xml
</txt>
</msg>
<msg time='2012-03-16T21:38:15.724+01:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='rafal-laptop'
host_addr='127.0.1.1'>
<txt>Trace information written to /u01/app/oracle/diag/tnslsnr/rafal-laptop/listener/trace/ora_19692_139947245459200.trc
</txt>
</msg>
<msg time='2012-03-16T21:38:15.724+01:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='rafal-laptop'
host_addr='127.0.1.1'>
<txt>Trace level is currently 0
</txt>
</msg>
<msg time='2012-03-16T21:38:15.724+01:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='rafal-laptop'
host_addr='127.0.1.1'>
<txt>
</txt>
</msg>
<msg time='2012-03-16T21:38:15.725+01:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='rafal-laptop'
host_addr='127.0.1.1'>
<txt>Started with pid=19692
</txt>
</msg>
<msg time='2012-03-16T21:38:15.726+01:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='rafal-laptop'
host_addr='127.0.1.1'>
<txt>Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
</txt>
</msg>
<msg time='2012-03-16T21:38:15.727+01:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='rafal-laptop'
host_addr='127.0.1.1'>
<txt>Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=%hostname%)(PORT=%port%)))
</txt>
</msg>
<msg time='2012-03-16T21:38:15.728+01:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='rafal-laptop'
host_addr='127.0.1.1'>
<txt>TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNS:protocol adapter error
TNS-00515: Connect failed because target host or object does not exist
</txt>
</msg>
<msg time='2012-03-16T21:38:15.728+01:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='rafal-laptop'
host_addr='127.0.1.1'>
<txt>No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
</txt>
</msg>
i jakby było potrzebne info:
/etc/hosts
127.0.0.1 localhost
127.0.1.1 rafal-laptopRafał Dąbrowski edytował(a) ten post dnia 17.03.12 o godzinie 15:24 -
lsnrctl status:
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 17-MAR-2012 10:43:24
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date 16-MAR-2012 22:35:19
Uptime 0 days 12 hr. 8 min. 5 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/11.2.0/xe/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services Summary...
Service "ORCL" has 1 instance(s).
Instance "XE", status BLOCKED, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
jest status BLOKED;] -
Witam, mam problem z podłączeniem się z sqldevelopera do bazy.
Zainstalowałem sobie oracle-xe, po odpaleniu bazy poleceniem /etc/init.d/oracle-xe start
próbuje się połączyć z poziomu sqldevelopera jednak się nie udaje z błędem z tematu
plik listener.ora :
# listener.ora Network Configuration File:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/xe)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
DEFAULT_SERVICE_LISTENER = (XE)
w sqldeveloperze uzupełniam SID = XE, port 1521 i hosta: localhost a mimo to dostaje błąd
Jakieś pomysły co jest nie tak?Rafał Dąbrowski edytował(a) ten post dnia 16.03.12 o godzinie 22:56
Dołącz do GoldenLine
Oferty pracy
Sprawdź aktualne oferty pracy
Aplikuj w łatwy sposób
Aplikuj jednym kliknięciem
