Skip to Main Content

Analytics Software

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!

Not able to connect/create schema using connection string and password after launching config.cmd -

12a31bbd-b387-4b5f-b553-b6ab42401edcOct 26 2017 — edited Feb 28 2018

Hi

I have installed java version "1.8.0_151"

I have installed Oracle 12c release 2 in Windows 10 PRO.

Then I installed WebLogic from fmw_12.2.1.0.0_infrastructure_Disk1_1of1 which was successfully installed.

Then I create repository using rcu.bat (which was also successful - Image attached)

repository.PNG

Then I launche config.cmd but here I am not able to connect to database using given connection string. I am getting below error.

  • Error in connecting to the Database: 'Oracle database at host localhost port 1521 service name orclpdb'. Error: 'ORA-01033: ORACLE initialization or shutdown in progress ' - Unable to connect to the Database with the given connect string and credentials.
  • Make sure the database is up and running and connect string, user name and password are correct.

error.PNG

Few Things that I tried:

1. Added below code to tnsnames.ora

ORCLPDB =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

(CONNECT\_DATA =

  (SERVER = DEDICATED)

  (SERVICE\_NAME = orclpdb)

)

)

2. Added below code to sqlnet.ora

SQLNET.ALLOWED_LOGON_VERSION_CLIENT = 8

SQLNET.ALLOWED_LOGON_VERSION_SERVER = 8

3. Execute below using sys

ALTER PLUGGABLE DATABASE OPEN ALL;

In SQL Developer I am using orcl service to login, there i am able to connect.

sql.PNG

Anyone knows how can I resolve this issue, and get OBIEE 12c installed for work.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 28 2018
Added on Oct 26 2017
14 comments
3,208 views