Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Authentication Failure while Connecting Oracle DB through RCU installation Wizard

Sirish MalisettyAug 7 2017 — edited Aug 11 2017

Hi everyone,

I am facing issues connecting to Oracle database(pluggable) while installing an RCU through the wizard.

I have installed Oracle DB12.2.0.1.0 on a Virtual Machine(OS: Linux x86_64 v7.3)

below are some key parameters and configurations w.r.t my machine and the database

===============================================================================================

[oracle@biserver ~]$ pwd

/home/oracle

[oracle@biserver ~]$ echo $ORACLE_HOME

/home/oracle/app/oracle/product/12.2.0/dbhome_1

[oracle@biserver ~]$ echo $ORACLE_SID

orcl

[oracle@biserver ~]$ cat .bash_profile

# .bash_profile

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

. ~/.bashrc

fi

# User specific environment and startup programs

PATH=$PATH:$HOME/.local/bin:$HOME/bin

export PATH

# Adding Lines for Oracle 12 c DB Install 7/19

export ORAENV_ASK=NO

. oraenv #<- note, that is dot space oraenv

unset ORAENV_ASK

export TMP=/tmp

export TMPDIR=$TMP

export ORACLE_HOSTNAME=biserver.smalisetty

export ORACLE_UNQNAME=orcl

export ORACLE_BASE=/home/oracle/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/12.2.0/dbhome_1

export ORACLE_SID=orcl

export JAVA_HOME=/usr/java/latest

export TNS_ADMIN=$ORACLE_HOME/network/admin

export PATH=/usr/sbin:$PATH

export PATH=$ORACLE_HOME/bin:$PATH

export PATH=$JAVA_HOME/bin:$PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

[oracle@biserver ~]$ cat .bashrc

# .bashrc

# Source global definitions

if [ -f /etc/bashrc ]; then

. /etc/bashrc

fi

# Uncomment the following line if you don't like systemctl's auto-paging feature:

# export SYSTEMD_PAGER=

# User specific aliases and functions

export ORAENV_ASK=NO

. oraenv #<- note, that is dot space oraenv

unset ORAENV_ASK

export TMP=/tmp

export TMPDIR=$TMP

export ORACLE_HOSTNAME=biserver.smalisetty

export ORACLE_UNQNAME=orcl

export ORACLE_BASE=/home/oracle/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/12.2.0/dbhome_1

export ORACLE_SID=orcl

export JAVA_HOME=/usr/java/latest

export PATH=/usr/sbin:$PATH

export PATH=$ORACLE_HOME/bin:$PATH

export PATH=$JAVA_HOME/bin:$PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

[oracle@biserver ~]$ lsnrctl status

LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 07-AUG-2017 13:29:21

Copyright (c) 1991, 2016, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=biserver.smalisetty)(PORT=1521)))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

Linux Error: 111: Connection refused

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

lsTNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

Linux Error: 111: Connection refused

[oracle@biserver ~]$ lsnrctl start

LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 07-AUG-2017 13:29:30

Copyright (c) 1991, 2016, Oracle. All rights reserved.

Starting /home/oracle/app/oracle/product/12.2.0/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 12.2.0.1.0 - Production

System parameter file is /home/oracle/app/oracle/product/12.2.0/dbhome_1/network/admin/listener.ora

Log messages written to /home/oracle/app/oracle/diag/tnslsnr/biserver/listener/alert/log.xml

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=biserver.smalisetty)(PORT=1521)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=biserver.smalisetty)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias LISTENER

Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production

Start Date 07-AUG-2017 13:29:32

Uptime 0 days 0 hr. 0 min. 6 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /home/oracle/app/oracle/product/12.2.0/dbhome_1/network/admin/listener.ora

Listener Log File /home/oracle/app/oracle/diag/tnslsnr/biserver/listener/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=biserver.smalisetty)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

The listener supports no services

The command completed successfully

[oracle@biserver ~]$ tnsping orclpdb

TNS Ping Utility for Linux: Version 12.2.0.1.0 - Production on 07-AUG-2017 13:29:52

Copyright (c) 1997, 2016, Oracle. All rights reserved.

Used parameter files:

/home/oracle/app/oracle/product/12.2.0/dbhome_1/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = biserver.smalisetty)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orclpdb.smalisetty)))

OK (0 msec)

==============================================================================================================================

Below is the output of all 3 .ora files :

===============================================================================================================================

[oracle@biserver ~]$ cd $ORACLE_HOME

[oracle@biserver dbhome_1]$ cd network/admin/

[oracle@biserver admin]$ ls -all

total 16

drwxr-xr-x. 3 oracle oinstall 92 Aug 6 17:27 .

drwxr-xr-x. 10 oracle oinstall 98 Jul 19 16:37 ..

-rw-r--r-- 1 oracle oinstall 749 Aug 3 15:45 listener.ora

drwxr-xr-x. 2 oracle oinstall 61 Jul 19 16:33 samples

-rw-r--r--. 1 oracle oinstall 1441 Aug 28 2015 shrept.lst

-rw-r--r-- 1 oracle oinstall 574 Aug 3 15:42 sqlnet.ora

-rw-r----- 1 oracle oinstall 647 Aug 6 17:27 tnsnames.ora

[oracle@biserver admin]$ cat listener.ora

# listener.ora Network Configuration File: /home/oracle/app/oracle/product/12.2.0/dbhome_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

  (ADDRESS = (PROTOCOL = TCP)(HOST = biserver.smalisetty)(PORT = 1521))

  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

)

)

ORCL =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = biserver.smalisetty)(PORT = 1521))

(CONNECT\_DATA =

  (SERVER = DEDICATED)

  (SERVICE\_NAME = orcl.smalisetty)

)

)

ORCLPDB =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = biserver.smalisetty)(PORT = 1521))

(CONNECT\_DATA =

  (SERVER = DEDICATED)

  (SERVICE\_NAME = orclpdb.smalisetty)

)

)

[oracle@biserver admin]$ cat sqlnet.ora

# sqlnet.ora Network Configuration File: /home/oracle/app/oracle/product/12.2.0/dbhome_1/network/admin/sqlnet.ora

# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

SQLNET.ALLOWED_LOGON_VERSION_SERVER=8

ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = biserver.smalisetty)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl.smalisetty)))

ORCLPDB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = biserver.smalisetty)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orclpdb.smalisetty)))

[oracle@biserver admin]$ cat tnsnames.ora

# tnsnames.ora Network Configuration File: /home/oracle/app/oracle/product/12.2.0/dbhome_1/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

LISTENER_ORCL =

(ADDRESS = (PROTOCOL = TCP)(HOST = biserver.smalisetty)(PORT = 1521))

ORCL =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = biserver.smalisetty)(PORT = 1521))

(CONNECT\_DATA =

  (SERVER = DEDICATED)

  (SERVICE\_NAME = orcl.smalisetty)

)

)

ORCLPDB =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = biserver.smalisetty)(PORT = 1521))

(CONNECT\_DATA =

  (SERVER = DEDICATED)

  (SERVICE\_NAME = orclpdb.smalisetty)

)

)

===============================================================================================================================

below is the database starting details:

===============================================================================================================================

[oracle@biserver admin]$ sqlplus

SQL*Plus: Release 12.2.0.1.0 Production on Mon Aug 7 13:31:03 2017

Copyright (c) 1982, 2016, Oracle. All rights reserved.

Enter user-name: sys as sysdba

Enter password:

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 2415919104 bytes

Fixed Size 8795616 bytes

Variable Size 654314016 bytes

Database Buffers 1744830464 bytes

Redo Buffers 7979008 bytes

Database mounted.

Database opened.

SQL> alter pluggable database all open;

Pluggable database altered.

SQL> quit

Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

===============================================================================================================================

with this configuration, I was able to successfully install OBIEE RCU and ODI RCU without any issues.

Now I have started my installation for OBIA. OBIA RCU is the first step and it asks to connect to the Oracle Database.

here is where I am facing the authentication failure error. below are the details

===============================================================================================================================

[oracle@biserver admin]$ cd /home/oracle/app/oracle/FMW_Home/rcu/bia/bin/

[oracle@biserver bin]$ ./rcu

Here i used the same details that I used connecting SQLPLUS in above step.

pastedImage_2.png

Not sure where I am going wrong? is there a place on the server that I can see the log file for each connection (success/failure) that I can trace to see the error.

and if I have configured any of the .ora files incorrectly?

I am new to DB Administration and configuration. and this RCU all it needs is SYSDBA role. is it possible to create another sysdba role (any references on how to do that)?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 8 2017
Added on Aug 7 2017
#general-database-discussions
10 comments
837 views