mounting existing database files #8
Description
Hi,
I'm wondering what the correct mount is to mount an existing dataset, for instance /home/user/mysid to use the ORCL database. I've tried to mount my /home/user/mysid/oradata to /opt/oracle/app/oradata/orcl/oradata but the database denied connection by stating:
listener: TNS-12528: TNS:listener: all appropriate instances are blocking new connections
Any idea what could be the issue?
Checking shared memory... Filesystem Size Used Avail Use% Mounted on shm 64M 0 64M 0% /dev/shm Starting listener... tail: cannot open '/opt/oracle/app/diag/tnslsnr/0b5785e8d75c/listener/trace/listener.log' for reading: No such file or directory tail: cannot watch parent directory of '/opt/oracle/app/diag/tnslsnr/0b5785e8d75c/listener/trace/listener.log': No such file or directory tail: inotify cannot be used, reverting to polling lsnrctl: lsnrctl: LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 23-JAN-2017 09:14:29 lsnrctl: lsnrctl: Copyright (c) 1991, 2009, Oracle. All rights reserved. lsnrctl: lsnrctl: Starting /opt/oracle/app/product/11.2.0/dbhome_1/bin/tnslsnr: please wait... lsnrctl: tail: '/opt/oracle/app/diag/tnslsnr/0b5785e8d75c/listener/trace/listener.log' has appeared; following end of new file listener: Mon Jan 23 09:14:29 2017 listener: Create Relation ADR_CONTROL listener: Create Relation ADR_INVALIDATION listener: Create Relation INC_METER_IMPT_DEF listener: Create Relation INC_METER_PK_IMPTS listener: Log messages written to /opt/oracle/app/diag/tnslsnr/0b5785e8d75c/listener/alert/log.xml listener: Trace information written to /opt/oracle/app/diag/tnslsnr/0b5785e8d75c/listener/trace/ora_24_139991079151424.trc listener: Trace level is currently 0 listener: listener: Started with pid=24 lsnrctl: TNSLSNR for Linux: Version 11.2.0.1.0 - Production lsnrctl: Log messages written to /opt/oracle/app/diag/tnslsnr/0b5785e8d75c/listener/alert/log.xml lsnrctl: Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0b5785e8d75c)(PORT=1521))) lsnrctl: lsnrctl: Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) lsnrctl: STATUS of the LISTENER lsnrctl: ------------------------ lsnrctl: Alias LISTENER lsnrctl: Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production lsnrctl: Start Date 23-JAN-2017 09:14:29 lsnrctl: Uptime 0 days 0 hr. 0 min. 16 sec lsnrctl: Trace Level off lsnrctl: Security ON: Local OS Authentication lsnrctl: SNMP OFF lsnrctl: Listener Log File /opt/oracle/app/diag/tnslsnr/0b5785e8d75c/listener/alert/log.xml lsnrctl: Listening Endpoints Summary... lsnrctl: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0b5785e8d75c)(PORT=1521))) lsnrctl: The listener supports no services lsnrctl: The command completed successfully Starting database... sqlplus: sqlplus: SQL*Plus: Release 11.2.0.1.0 Production on Mon Jan 23 09:14:45 2017 sqlplus: sqlplus: Copyright (c) 1982, 2009, Oracle. All rights reserved. sqlplus: sqlplus: Connected to an idle instance. sqlplus: sqlplus: SQL> Starting with pfile='/opt/oracle/app/product/11.2.0/dbhome_1/dbs/initorcl.ora' ... listener: Mon Jan 23 09:14:45 2017 listener: Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0b5785e8d75c)(PORT=1521))) listener: Listener completed notification to CRS on start listener: listener: TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE listener: WARNING: Subscription for node down event still pending listener: 23-JAN-2017 09:14:45 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=0b5785e8d75c)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186646784)) * status * 0 alertlog: Mon Jan 23 09:14:45 2017 alertlog: Adjusting the default value of parameter parallel_max_servers alertlog: from 160 to 135 due to the value of parameter processes (150) alertlog: Starting ORACLE instance (normal) alertlog: Errors in file /opt/oracle/app/diag/rdbms/orcl/orcl/trace/orcl_ora_32.trc: alertlog: ORA-27167: Attempt to determine if Oracle binary image is stored on remote server failed alertlog: ORA-27300: OS system dependent operation:parse_df failed with status: 2 alertlog: ORA-27301: OS failure message: No such file or directory alertlog: ORA-27302: failure occurred at: parse failed alertlog: ORA-27303: additional information: Filesystem 1K-blocks Used Available Use% Mounted on alertlog: none 359238356 325915372 15051652 96% / alertlog: Image consistency checking encountered an error, checking disabled alertlog: LICENSE_MAX_SESSION = 0 alertlog: LICENSE_SESSIONS_WARNING = 0 alertlog: Picked latch-free SCN scheme 3 alertlog: Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST alertlog: Autotune of undo retention is turned on. alertlog: IMODE=BR alertlog: ILAT =27 alertlog: LICENSE_MAX_USERS = 0 alertlog: SYS auditing is disabled alertlog: Mon Jan 23 09:15:01 2017 alertlog: Starting up: alertlog: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production alertlog: With the Partitioning, OLAP, Data Mining and Real Application Testing options. alertlog: Using parameter settings in server-side spfile /opt/oracle/app/product/11.2.0/dbhome_1/dbs/spfileorcl.ora alertlog: System parameters with non-default values: alertlog: processes = 150 alertlog: sga_target = 500M alertlog: memory_target = 0 alertlog: control_files = "/opt/oracle/app/oradata/orcl/control01.ctl" alertlog: control_files = "/opt/oracle/app/flash_recovery_area/orcl/control02.ctl" alertlog: db_block_size = 8192 alertlog: compatible = "11.2.0.0.0" alertlog: db_recovery_file_dest = "/opt/oracle/app/flash_recovery_area" alertlog: db_recovery_file_dest_size= 3882M alertlog: undo_tablespace = "UNDOTBS1" alertlog: remote_login_passwordfile= "EXCLUSIVE" alertlog: db_domain = "" alertlog: dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)" alertlog: audit_file_dest = "/opt/oracle/app/admin/orcl/adump" alertlog: audit_trail = "DB" alertlog: db_name = "orcl" alertlog: open_cursors = 300 alertlog: pga_aggregate_target = 100M alertlog: diagnostic_dest = "/opt/oracle/app" sqlplus: SQL> ORACLE instance started. sqlplus: sqlplus: Total System Global Area 521936896 bytes sqlplus: Fixed Size 2214936 bytes sqlplus: Variable Size 159384552 bytes sqlplus: Database Buffers 352321536 bytes sqlplus: Redo Buffers 8015872 bytes sqlplus: ORA-00205: error in identifying control file, check alert log for more info sqlplus: sqlplus: sqlplus: SQL> sqlplus: System altered. sqlplus: sqlplus: SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production sqlplus: With the Partitioning, OLAP, Data Mining and Real Application Testing options listener: Mon Jan 23 09:15:17 2017 listener: Dynamic address is already listened on (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0b5785e8d75c)(PORT=1521))) listener: 23-JAN-2017 09:15:17 * service_register * orcl * 0 listener: 23-JAN-2017 09:15:17 * service_update * orcl * 0 listener: 23-JAN-2017 09:15:17 * service_update * orcl * 0 alertlog: Mon Jan 23 09:15:17 2017 alertlog: PMON started with pid=2, OS id=35 alertlog: Mon Jan 23 09:15:17 2017 alertlog: VKTM started with pid=3, OS id=37 alertlog: VKTM running at (100ms) precision alertlog: Mon Jan 23 09:15:17 2017 alertlog: GEN0 started with pid=4, OS id=41 alertlog: Mon Jan 23 09:15:17 2017 alertlog: DIAG started with pid=5, OS id=43 alertlog: Mon Jan 23 09:15:17 2017 alertlog: DBRM started with pid=6, OS id=45 alertlog: Mon Jan 23 09:15:17 2017 alertlog: PSP0 started with pid=7, OS id=47 alertlog: Mon Jan 23 09:15:17 2017 alertlog: DIA0 started with pid=8, OS id=49 alertlog: Mon Jan 23 09:15:17 2017 alertlog: MMAN started with pid=9, OS id=51 alertlog: Mon Jan 23 09:15:17 2017 alertlog: DBW0 started with pid=10, OS id=53 alertlog: Mon Jan 23 09:15:17 2017 alertlog: LGWR started with pid=11, OS id=55 alertlog: Mon Jan 23 09:15:17 2017 alertlog: CKPT started with pid=12, OS id=57 alertlog: Mon Jan 23 09:15:17 2017 alertlog: SMON started with pid=13, OS id=59 alertlog: Mon Jan 23 09:15:17 2017 alertlog: RECO started with pid=14, OS id=61 alertlog: Mon Jan 23 09:15:17 2017 alertlog: MMON started with pid=15, OS id=63 alertlog: Mon Jan 23 09:15:17 2017 alertlog: starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... alertlog: Mon Jan 23 09:15:17 2017 alertlog: MMNL started with pid=16, OS id=65 alertlog: starting up 1 shared server(s) ... alertlog: ORACLE_BASE from environment = /opt/oracle/app alertlog: Mon Jan 23 09:15:17 2017 alertlog: ALTER DATABASE MOUNT alertlog: ORA-00210: cannot open the specified control file alertlog: ORA-00202: control file: '/opt/oracle/app/oradata/orcl/control01.ctl' alertlog: ORA-27041: unable to open file alertlog: Linux-x86_64 Error: 13: Permission denied alertlog: Additional information: 9 alertlog: ORA-205 signalled during: ALTER DATABASE MOUNT... alertlog: Mon Jan 23 09:15:17 2017 alertlog: Checker run found 1 new persistent data failures listener: 23-JAN-2017 09:15:20 * service_update * orcl * 0 listener: Mon Jan 23 09:16:42 2017 listener: 23-JAN-2017 09:16:42 * (CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=DBeaver 3.8.0)(HOST=__jdbc__)(USER=michael))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.17.0.1)(PORT=51302)) * establish * ORCL * 12528 listener: TNS-12528: TNS:listener: all appropriate instances are blocking new connections