0

OS: Oracle Linux 7.7

Users: root, grid, oracle, userwithmyname

Installed softwares: grid infrastructure with asm in grid user, Oracle 12cR2 in oracle user

I created a database in my grid user. It is running successfully.

But when I want to create database in my oracle user using DBCA, it gives this error:

Installation steps in DBCA:

1) Create database

2) Advanced configuration

3) Oracle single instance database - general purpose or transaction processing

4) Global database name: orcl, sid: orcl, create as container database (not selected, I don't want)

5) Use following for the database storage attributes, database file storage type: ASM, database files location: +DATA/{DB_UNIQUE_NAME}, use oracle-managed files (OMF) (selected, I want)

6) Specify fast recovery area, recovery files storage type: ASM, fast recovery area: +FRA, fast recovery area size: 9 GB

7) Listener selection: listeners data is loaded from TNS_ADMIN env: /u01/app/oracle/product/12.2.0/db_home/network/admin, create a new listener (not selected, by the way I tried with selected option)

8) Use automatic shared memory management, sga size: 2.4 GB, pga size: 0.8 GB

9) Use the same administrative password for all accounts

10) Select the database creation options: create database (selected), post db creation scripts (none)

11) The problem is starting here.

Error-1: Database Configuration Assistant / ORA-12547: TNS: lost contact (options: ignore, abort)

Error-2: Database Configuration Assistant / Error while cataloging RMAN Backups (option: ok)

DBCA Log Location: ... I examined log file.

It says:

[Thread-237] [ 2020-02-22 22:31:20.820 EET ] [RMANEngine.initialize:246]  Starting Reader Thread... 
[Thread-237] [ 2020-02-22 22:31:20.820 EET ] [RMANEngine.initialize:250]  Started reader thread for RMAN process in initialize...
[Thread-250] [ 2020-02-22 22:31:20.820 EET ] [RMANEngine.run:827]  Started reader thread for RMAN process from initialize...
[Thread-250] [ 2020-02-22 22:31:20.820 EET ] [RMANEngine.run:831]  Set m_bReaderStarted  to true  in initialize...
[Thread-237] [ 2020-02-22 22:31:20.821 EET ] [RMANEngine.initialize:258]  Started error thread for RMAN process from initialize...
[Thread-237] [ 2020-02-22 22:31:20.821 EET ] [RMANEngine.initialize:263]  Created output writer for RMAN process from initialize...
[Thread-237] [ 2020-02-22 22:31:20.821 EET ] [RMANEngine.initialize:301]  Created Log writer for RMAN process from initialize...
[Thread-237] [ 2020-02-22 22:31:20.821 EET ] [RMANEngine.initialize:306]  Value of m_bReaderStarted in initialize=true
[Thread-237] [ 2020-02-22 22:31:20.821 EET ] [RMANEngine.initialize:321]  Made sure reader has started for RMAN process from initialize...
[Thread-237] [ 2020-02-22 22:31:20.824 EET ] [RMANEngine.connect:797]  NOT using OS auth to connect
[Thread-237] [ 2020-02-22 22:31:20.824 EET ] [RMANEngine.executeImpl:1285]  m_bExecQuery=false
[Thread-237] [ 2020-02-22 22:31:20.824 EET ] [RMANEngine.executeImpl:1293]  Command being written to rman process=connect target 'SYS/******
[Thread-237] [ 2020-02-22 22:31:20.824 EET ] [RMANEngine.executeImpl:1321]  Notify reader to start reading
[Thread-250] [ 2020-02-22 22:31:21.307 EET ] [RMANEngine.readSqlOutput:988]  Log RMAN Output=
[Thread-250] [ 2020-02-22 22:31:21.307 EET ] [RMANEngine.readSqlOutput:988]  Log RMAN Output=Recovery Manager: Release 12.2.0.1.0 - Production on Sat Feb 22 23:31:21 2020
[Thread-250] [ 2020-02-22 22:31:21.308 EET ] [RMANEngine.readSqlOutput:988]  Log RMAN Output=
[Thread-250] [ 2020-02-22 22:31:21.308 EET ] [RMANEngine.readSqlOutput:988]  Log RMAN Output=Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.
[Thread-250] [ 2020-02-22 22:31:21.531 EET ] [RMANEngine.readSqlOutput:988]  Log RMAN Output=
[Thread-250] [ 2020-02-22 22:31:21.531 EET ] [RMANEngine.readSqlOutput:988]  Log RMAN Output=RMAN>
[Thread-250] [ 2020-02-22 22:31:21.563 EET ] [RMANEngine.readSqlOutput:988]  Log RMAN Output=RMAN-00571: ===========================================================
[Thread-250] [ 2020-02-22 22:31:21.563 EET ] [RMANEngine.readSqlOutput:988]  Log RMAN Output=RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
[Thread-250] [ 2020-02-22 22:31:21.563 EET ] [RMANEngine.readSqlOutput:988]  Log RMAN Output=RMAN-00571: ===========================================================
[Thread-250] [ 2020-02-22 22:31:21.563 EET ] [RMANEngine.readSqlOutput:988]  Log RMAN Output=ORA-12547: TNS:lost contact
[Thread-250] [ 2020-02-22 22:31:21.563 EET ] [RMANEngine.readSqlOutput:988]  Log RMAN Output=
[Thread-250] [ 2020-02-22 22:31:21.563 EET ] [RMANEngine.readSqlOutput:988]  Log RMAN Output=RMAN>
[Thread-250] [ 2020-02-22 22:31:21.563 EET ] [RMANEngine.readSqlOutput:988]  Log RMAN Output=echo set on
[Thread-250] [ 2020-02-22 22:31:21.563 EET ] [RMANEngine.readSqlOutput:988]  Log RMAN Output=set echo off;
[Thread-250] [ 2020-02-22 22:31:21.563 EET ] [RMANEngine.readSqlOutput:1031]  hasError is true
[Thread-250] [ 2020-02-22 22:31:21.563 EET ] [RMANEngine.readSqlOutput:1037]  ERROR TRACE DETECTED
[Thread-250] [ 2020-02-22 22:31:21.563 EET ] [RMANEngine.readSqlOutput:1044]  m_errHdlr=null
[Thread-250] [ 2020-02-22 22:31:21.563 EET ] [RMANEngine.readSqlOutput:1068]  FATAL ERROR DETECTED
[Thread-250] [ 2020-02-22 22:31:21.563 EET ] [RMANEngine.readSqlOutput:1132]  Notifying writer to proceed because m_bInterrupted=falsebNotify=truem_bReaderDone=truem_bFatalErrorOccured=true
[Thread-250] [ 2020-02-22 22:31:21.563 EET ] [RMANEngine.run:841]  Return Value from readSqlOutput=null
[Thread-237] [ 2020-02-22 22:31:21.564 EET ] [RMANEngine.executeImpl:1333]  Completed wait from reader
[Thread-237] [ 2020-02-22 22:31:21.564 EET ] [RMANEngine.executeImpl:1348]  Calling done as got exception
[Thread-237] [ 2020-02-22 22:31:21.564 EET ] [RMANEngine.done:1654]  Done called
[Thread-237] [ 2020-02-22 22:31:21.564 EET ] [RMANEngine.executeImpl:1375]  GOT FATAL Error=Recovery Manager: Release 12.2.0.1.0 - Production on Sat Feb 22 23:31:21 2020
Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.
RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-12547: TNS:lost contact

Thank you.

Edit:

When I check "lsnrctl stat" I can see +ASM instance.

When I try to "lsnrctl stop" it says:

"Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

TNS-01190: The user is not authorized to execute the requested listener command"

0

Databases should never be created as the "grid" user, only "oracle". When GI is installed, the listener is owned by the "grid" user as a grid/cluster resource, not "oracle"; only grid can start and stop it with lsnrctl, and you should not attempt to create a new listener with dbca.

That said, your issue is most likely the result of improper permissions on files in the database ORACLE_HOME and of the ORACLE_HOME/lib directory. As the grid user, run "ls -l /u01/app/oracle/product/12.2.0/db_home/bin/oracle" and see if you get a permission denied error. If you get the error, then check this link for details: https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=147018806230587&id=1069517.1&displayIndex=5&_afrWindowMode=0&_adf.ctrl-state=ywoanowux_140.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.