BigdataLyn's TECH Blog! 刀不磨要生锈,人不学习要落后 - Thinking ahead

Oracle EM13c 01 - dbca DB18c Tips

2018-09-29

Oracle EM13c 01 - dbca DB18c Tips

DBCA create EMCC template DB in DB18c

The env in oracle user.

[oracle@oel72 ~]$ 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
# Oracle Settings

export TMP=/tmp
export TMPDIR=$TMP

export ORACLE_HOSTNAME=vedb.localdomain
export ORACLE_UNQNAME=orcl
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/18.0.0/dbhome_1
export ORACLE_SID=orcl

export PATH=/usr/sbin:$PATH
export PATH=$ORACLE_HOME/bin:$PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

alias sqlplus="rlwrap sqlplus"
alias dgmgrl="rlwrap dgmgrl"
alias rman="rlwrap rman"
alias lsnrctl="rlwrap lsnrctl"
alias asmcmd="rlwrap asmcmd"
alias adrci="rlwrap adrci"
alias impdp="rlwrap impdp"
alias expdp="rlwrap expdp"

export ORACLE_SID=EMREP

[oracle@oel72 ~]$dbca

Step 1.

Step01

Step 2.

Step02

Step 3.

Step03

Step 4.

Step04

Step 5.

Step05

Step 6.

Step06

Step 7.

Step07

Step 8.

Step08

Step 9.

Step09

Step 9-1.

Step9-1

Step 9-2.

Step9-2

Step 9-3.

Step9-3

Step 10.

Step10

Step 11.

Step11

Step 12.

Step12

Step 13.

Step13

Step 14.

Step14

Step 15-error.

Step15-1

Log:

Parsing command line arguments:
Parameter "silent" = true
Parameter "local" = true
Parameter "inscomp" = server
Parameter "insprtcl" = TCP
Parameter "orahome" = /u01/app/oracle/product/18.0.0/dbhome_1
Parameter "instype" = custom
Parameter "listener" = EMREP
Parameter "lisport" = 1521
Parameter "cfg" = local
Parameter "responsefile" = /u01/app/oracle/product/18.0.0/dbhome_1/network/install/netca_typ.rsp
Done parsing command line arguments.
Oracle Net Services Configuration:
EMREP:The information provided for this listener is currently in use by other software on this computer. 
Profile configuration complete.
Check the trace file for details: /u01/app/oracle/cfgtoollogs/netca/trace_OraDB18Home1-18092810PM0336.log
Oracle Net Services configuration failed.  The exit code is 1

Step 15-listener.

Step15-listner

Step 16.

Step16

Step 17.

Step17

[oracle@oel72 ~]$ sqlplus / as sysdba

SQL*Plus: Release 18.0.0.0.0 - Production on Fri Sep 28 22:25:22 2018
Version 18.3.0.0.0

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


Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0

SQL>

Reason is that the hostname in /etc/hosts was different with netca’s hostname. Modified the host in listener.ora.

[oracle@oel72 admin]$ pwd
/u01/app/oracle/product/18.0.0/dbhome_1/network/admin
[oracle@oel72 admin]$ ls -ltr
total 28
-rw-r--r--. 1 oracle oinstall 1441 Aug 26  2015 shrept.lst
drwxr-xr-x. 2 oracle oinstall 4096 Feb  7  2018 samples
-rw-r-----. 1 oracle oinstall  202 Sep 28 21:53 sqlnet1809289PM5357.bak
-rw-r-----. 1 oracle oinstall  202 Sep 28 22:03 sqlnet18092810PM0337.bak
-rw-r-----. 1 oracle oinstall  202 Sep 28 22:03 sqlnet.ora
-rw-r-----. 1 oracle oinstall  202 Sep 28 22:26 sqlnet18092810PM2604.bak
-rw-r-----. 1 oracle oinstall  344 Sep 28 22:29 listener.ora
[oracle@oel72 admin]$ pwd
/u01/app/oracle/product/18.0.0/dbhome_1/network/admin
[oracle@oel72 admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/18.0.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
	(DESCRIPTION =
	  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
	  (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))
	)
  )

[oracle@oel72 admin]$	
[oracle@oel72 admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/18.0.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

EMREP =
  (DESCRIPTION =
	(ADDRESS_LIST =
	  (ADDRESS = (PROTOCOL = TCP)(HOST = emsvr)(PORT = 1521))
	)
	(CONNECT_DATA =
	  (SERVICE_NAME = EMREP)
	)
  )

[oracle@oel72 admin]$

Have a good life! 2018/09 via LinHong


Similar Posts

Comments