环境:
当然刚开始如果你的电脑没有vim的话先安装下,到时候还得编辑一些文件,输入如下命令进行安装
sudo apt-get install vim
Oracle数据库服务器是Ubuntu 14.0.4 X64位服务器版 客户端是ubuntu 14.0.4 桌面版
.Client客户端设置192.168.0.100
1) vim /etc/ssh/ssh_config 去掉下面行前的#
ForwardAgent yes
ForwardX11 yes
ForwardX11Trusted yes
2) 设置DISPLAY (即允许任意服务器使用Client的图形服务)
xhost +
重点:(其他教程没有的哦!而且如果按照其他教程会出现安装过程中即使按照教程做了,错误也不能解决的问题)
安装完这些包还要在安装vnc4server组件,保证 安装的oralce到时候可以调用gnome桌面图形工具
.服务器环境设置
1)安装一些必须 软件
sudoapt-get install -y zlib1g-dev elfutils libaio1 libaio-dev libstdc++6-4.4-dev numactl pdksh sysstat unixODBC-dev unixODBC build-essential libaio1 gawk libmotif3 alien libtool x11-utils
重点:后面创建oracle用户后执行sudo命令行时提示此用户不在sudoers中,事件将被报告。
解决方法:vi /etc/sudoers 后添加第三行
# User privilege specification
root ALL=(ALL:ALL) ALL
oracle ALL=(ALL:ALL) ALL
进行更新:sudo apt-get update
进行升级:sudo apt-get dist-upgrade
重启:init 6
安装环境所需要的安装包
sudo apt-get -y install alien binutils build-essential c debhelper g++-4.4 gawk gcc-4.4 gcc-4.4-base gettext html2text lib32z1 lib32ncurses5 lib32bz2-1.0 intltool-debian ksh lib32bz2-dev lib32z1-dev libaio-dev libaio1 libbeecrypt7 libc6 libc6-dev libc6-dev-i386 libelf-dev libelf1 libltdl-dev libltdl7 libmotif4 libodbcinstq4-1 libodbcinstq4-1:i386 libqt4-core libqt4-gui libsqlite3-0 libstdc++5 libstdc++6 libstdc++6-4.4-dev lsb lsb-core lsb-cxx lsb-desktop lsb-graphics lsb-qt4 make odbcinst pax po-debconf rpm rpm-common sysstat unixodbc unixodbc-dev unzip
创建用户及组
sudo addgroup oinstall
sudo addgroup dba
sudo addgroup nobody
sudo usermod -g nobody nobody
sudo useradd -g oinstall -G dba -p password -d /home/oracle -s /bin/bash oracle
sudo mkdir /home/oracle
sudo chown -R oracle:dba /home/oracle
sudo mkdir -p /u01/app/oracle
sudo mkdir -p /u01/binaries
sudo chown -R oracle:dba /u01
为oracle用户创建密码:输入两次
sudo passwd oracle
由于oracle支持redhat 系统 而不支持ubuntu所有进行伪装一下
echo 'Red Hat Linux release 6' | sudo tee -a /etc/redhat-release
为启动环境所需的安装包创建链接
sudo mkdir /usr/lib64
sudo ln -s /etc /etc
sudo ln -s /lib/x86_64-linux-gnu /lib64/
sudo ln -s /usr/bin/awk /bin/awk
sudo ln -s /usr/bin/basename /bin/basename
sudo ln -s /usr/bin/rpm /bin/rpm
sudo ln -s /usr/lib/x86_64-linux-gnu /usr/lib64/
sudo ln -s /usr/lib/x86_64-linux-gnu /usr/lib64/
sudo ln -s /usr/lib/x86_64-linux-gnu/libstdc++. /lib64/
sudo ln -s /usr/lib/x86_64-linux-gnu/libstdc++. /usr/lib64/
为oracle用户改变一些系统参数
sudo cp /etc/security /etc/security.original
echo "#Oracle 12C shell limits:" | sudo tee -a /etc/security
echo "oracle soft nproc 2048" | sudo tee -a /etc/security
echo "oracle hard nproc 16384"| sudo tee -a /etc/security
echo "oracle soft nofile 1024" | sudo tee -a /etc/security
echo "oracle hard nofile 65536" | sudo tee -a /etc/security
运行一下命令改变内核参数
echo "#" | sudo tee -a /etc
echo "# Oracle 12C entries" | sudo tee -a /etc
echo "; | sudo tee -a /etc
echo "; | sudo tee -a /etc
echo "kernel.shmall=2097152" | sudo tee -a /etc
echo "kernel.shmmni=4096" | sudo tee -a /etc
echo "kernel.sem=250 32000 100 128" | sudo tee -a /etc
echo "net.i 65500" | sudo tee -a /etc
echo "net.core.rmem_default=262144" | sudo tee -a /etc
echo "net.core.rmem_max=4194304" | sudo tee -a /etc
echo "net.core.wmem_default=262144" | sudo tee -a /etc
echo "net.core.wmem_max=1048586" | sudo tee -a /etc
echo "kernel.shmmax=1073741824" | sudo tee -a /etc
为使改变数据生效,执行:
sudo sysctl -p
创建启动脚本
mkdir /etc
for i in 0 1 2 3 4 5 6 S
do sudo ln -s /etc/rc$i.d /etc/rc$i.d
done
重启后用oracle用户登录,下载,oracle文件
linuxamd64_12102_da
linuxamd64_12102_da
创建安装路径
mkdir /u01/binaries
把下载好的文件移动到binaries路径
mv /home/lem/下载 #其中lem是本人用户名
使用unzip命令依次进行解压缩两个zip文件
一定要先解压地一个文件,当然你得先进入到该文件夹是吧,不然还得费事写上解压路径
cd /u01/binaries #进入到该目录
unzip linuxamd64_12102_da
unzip linuxamd64_12102_da
解压完成后,查看是否有database文件夹,执行ls命令查看
改变文件路径所属的用户组为oracle用户的dba组
chown -Rf oracle:dba /u01/binaries
重点:如果直接运行安装,会看到乱码的安装界面,当然,安装过程,我们不认识字符
怎么安装,所以还是有办法解决这个问题的
export LANG=US
之后看到 进行安装就会看到英文的界面我而不在是小方格的乱码界面
,好了开始安装
/u01/binaries/database/runInstaller -ignoreSysPrereqs
66
到了这里还要说句,避免由于不会设置密码而前功尽弃
密码格式如:AAAlll666,
到这里问题来了,就是安装过程中出现错误,这好办虽然错误出现好多次,表怕
我们解决问题
In installation error logs you will see following error.INFO: /usr/bin/ld: /u01/app/oracle/produc): undefined reference to symbol '__tls_get_addr@@GLIBC_2.3'/lib/x86_64-linux-gnu: error adding symbols: DSO missing from command linecollect2: error: ld returned 1 exit status
For the same you need do following
Create a backup copy of /u01/app/oracle/produc
$
cp -rip /u01/app/oracle/produc /u01/app/oracle/produc.orig
Delete folder
$: rm -rf /u01/app/oracle/produc
Create a backup copy of /u01/app/oracle/produc
$: cp -rip /u01/app/oracle/produc /u01/app/oracle/produc.orig
Open
gedit /u01/app/oracle/produc
file in vi. Search for RMAN_LINKLINE. You will see following lines.
RMAN_LINKLINE=$(LINK) $(OPT) $(S0MAIN) $(SSKRMED) $(SKRMPT) \ $(LLIBDBTOOLS) $(LLIBCLIENT) $(LLIBSQL) $(LLIBPLSQL) \ $(LLIBSNLSRTL) $(LLIBUNLSRTL) $(LLIBNLSRTL) \ $(LLIBSLAX) $(LLIBPLSQL) $(LIBPLCN) $(LINKTTLIBS)
Now change it to as follows
RMAN_LINKLINE=$(LINK) $(OPT) $(S0MAIN) $(SSKRMED) $(SKRMPT) \
$(LLIBDBTOOLS) $(LLIBCLIENT) $(LLIBSQL) $(LLIBPLSQL) \
$(LLIBSNLSRTL) $(LLIBUNLSRTL) $(LLIBNLSRTL) \
$(LLIBSLAX) $(LLIBPLSQL) $(LIBPLCN) $(LINKTTLIBS)-lons
And click onretrybutton.
Further you wee see error for all_no_orcl
In the logs for above error I have observed following line
INFO: /usr/bin/ld: /u01/app/oracle/produc: undefined reference to symbol 'ztucxtb'/u01/app/oracle/produc: error adding symbols: DSO missing from command linecollect2: error: ld returned 1 exit statusINFO: make: *** [/u01/app/oracle/produc] Error 1INFO: End output from spawned : ----------------------------------INFO: Exception thrown from action: makeException Name: MakefileExceptionException String: Error in invoking target 'all_no_orcl' of makefile '/u01/app/oracle/produc;. See '/u01/app/oraInventory/log; for de Severity: 1
So I checked the ldd output of /u01/app/oracle/produc file.
oracle@vidyadhar:~$ldd /u01/app/oracle/produc
linux-vd => (0x00007fffd6aa0000)
libcln => not found
libc. => /lib/x86_64-linux-gnu/libc. (0x00007fa13b1f8000)
/lib64 (0x00007fa13bcef000)
Run following command to rectify this
$ sudo ln -s /u01/app/oracle/produclibcln /usr/lib/
Now see the linking again
oracle@vidyadhar:~$ldd /u01/app/oracle/produc
linux-vd => (0x00007fff5c5fe000)
libcln => /usr/lib/libcln (0x00007f133b180000)
libc. => /lib/x86_64-linux-gnu/libc. (0x00007f133adb8000)
libdl. => /lib/x86_64-linux-gnu/libdl. (0x00007f133abb3000)
libm. => /lib/x86_64-linux-gnu/libm. (0x00007f133a8af000)
lib => /lib/x86_64-linux-gnu/lib (0x00007f133a692000)
librt. => /lib/x86_64-linux-gnu/librt. (0x00007f133a489000)
/lib64 (0x00007f133bdff000)
Further do following
Take a backup of /u01/app/oracle/produc
$ cp -rip /u01/app/oracle/produc
/u01/app/oracle/produc.original
Open
gedit /u01/app/oracle/produc
and search for Linking password utility (orapwd), you will see following lines
$(ORAPWD) : $(ALWAYS) $(ORAPWD_DEPS)$(SILENT)$(ECHO)
$(SILENT)$(ECHO) " - Linking password utility (orapwd)"$(RMF) $@$(ORAPWD_LINKLINE)
Now change it to as follows
$(ORAPWD) : $(ALWAYS) $(ORAPWD_DEPS)$(SILENT)$(ECHO)$(SILENT)
$(ECHO) " - Linking password utility (orapwd)"$(RMF) $@$(ORAPWD_LINKLINE)-lnnz12
Click onretryto go further.
Again you will see error for all_no_orcl
In the logs for above error I have observed following line
INFO: /usr/bin/ld: /u01/app/oracle/produc: undefined reference to symbol 'ssMemRealloc'/u01/app/oracle/produc: error adding symbols: DSO missing from command linecollect2: error: ld returned 1 exit statusINFO: make: *** [/u01/app/oracle/produc] Error 1INFO: End output from spawned : ----------------------------------INFO: Exception thrown from action: makeException Name: MakefileExceptionException String: Error in invoking target 'all_no_orcl' of makefile '/u01/app/oracle/produc;. See '/u01/app/oraInventory/log; for de Severity: 1
So I have run ldd /u01/app/oracle/produc
oracle@vidyadhar:~$ldd /u01/app/oracle/produc
linux-vd => (0x00007fff0b22a000)
libdl. => /lib/x86_64-linux-gnu/libdl. (0x00007f11a9daf000)
libclntsh.2.1 => not found
libc. => /lib/x86_64-linux-gnu/libc. (0x00007f11a99e6000)
/lib64 (0x00007f11aa399000)
To rectify run following
$ sudo ln -s /u01/app/oracle/produclibclntsh.2.1 /usr/lib/
Check the linking again
oracle@vidyadhar:~$ldd /u01/app/oracle/produc
linux-vd => (0x00007fff09f7e000)
libdl. => /lib/x86_64-linux-gnu/libdl. (0x00007f81b3599000)
libclntsh.2.1 => /usr/lib/libclntsh.2.1 (0x00007f81b08aa000)
libc. => /lib/x86_64-linux-gnu/libc. (0x00007f81b04e1000)
/lib64 (0x00007f81b3b83000)
libnnz12.so => /u01/app/oracle/produc (0x00007f81afdcb000)
libons.so => /u01/app/oracle/produc (0x00007f81afb87000)
libm. => /lib/x86_64-linux-gnu/libm. (0x00007f81af882000)
lib => /lib/x86_64-linux-gnu/lib (0x00007f81af665000)
libcln => /u01/app/oracle/produclibcln (0x00007f81af115000)
librt. => /lib/x86_64-linux-gnu/librt. (0x00007f81aef0c000)
Further you need to do changes in
$ gedit/u01/app/oracle/produc
file. Open the file using file editor and search for Linking HS OTS agent. You will see following lines.
$(HSOTS) : $(ALWAYS) $(HSOTS_DEPS) $(SILENT)$(ECHO) $(SILENT)
$(ECHO) " - Linking HS OTS agent" $(RMF) $@ $(HSOTS_LINKLINE)
Change it to as follows
$(HSOTS) : $(ALWAYS) $(HSOTS_DEPS) $(SILENT)$(ECHO)
$(SILENT)$(ECHO) " - Linking HS OTS agent" $(RMF) $@ $(HSOTS_LINKLINE)-lagtsh
Also you need to do changes in /u01/app/oracle/produc file.
First take the backup of file using following command
cp -rip /u01/app/oracle/produc
/u01/app/oracle/produc.original
Now open
$ gedit/u01/app/oracle/produc
using file editor and search for HSOTS_LINKLINE. You will see following lines in the file
HSOTS_LINKLINE=$(LINK) $(OPT) $(HSOTSMAI) $(HSALIB_SUBSET1) \
$(HS_OTS_DRIVER) $(HS_XASWITCH_ORA) $(RDBMSLIB)$(XAD_OFF) \ $(HSALIB_SUBSET2)
Change it to as follows
HSOTS_LINKLINE=$(LINK) $(OPT)-Wl,--no-as-needed$(HSOTSMAI) $(HSALIB_SUBSET1) \
$(HS_OTS_DRIVER) $(HS_XASWITCH_ORA) $(RDBMSLIB)$(XAD_OFF) \ $(HSALIB_SUBSET2)
Again you will see error for all_no_orcl
In the logs for above error I have observed following line
INFO: /usr/bin/ld: /u01/app/oracle/produc: undefined reference to symbol 'ssMemRealloc'/u01/app/oracle/produc: error adding symbols: DSO missing from command linecollect2: error: ld returned 1 exit statusINFO: make: *** [/u01/app/oracle/produc] Error 1INFO: End output from spawned : ----------------------------------INFO: Exception thrown from action: makeException Name: MakefileExceptionException String: Error in invoking target 'all_no_orcl' of makefile '/u01/app/oracle/produc;. See '/u01/app/oraInventory/log; for de Severity: 1
For above error we need to do changes in
$ gedit/u01/app/oracle/produc.
Search for HSDEPXA_LINKLINE and you will see following lines in the file.
HSDEPXA_LINKLINE=$(LINK) $(OPT) $(HSDEPMAI) $(HSALIB_SUBSET1) \
$(HS_DEP_DRIVER) $(RDBMSLIB)$(XAD_OFF) \ $(HSALIB_SUBSET2)
Change it to as follows
HSDEPXA_LINKLINE=$(LINK) $(OPT)-Wl,--no-as-needed
$(HSDEPMAI) $(HSALIB_SUBSET1) \ $(HS_DEP_DRIVER)
$(RDBMSLIB)$(XAD_OFF) \ $(HSALIB_SUBSET2)
Again you will see error for all_no_orcl
In the logs for above error I have observed following line
INFO: pp/oracle/produc: undefined reference to `kgfoCheckMount'/u01/app/oracle/produc: undefined reference to `kgfoDestroyCtx'/u01/app/oracle/produc: undefined reference to `kgfoShrinkFile'/u01/app/oracle/produc: undefined reference to `kgfoControl'/u01/app/oracle/produc: undefined reference to `kgfoCreate2P'collect2: error: ld returnedINFO: 1 exit statusmake: *** [/u01/app/oracle/produc] Error 1INFO: End output from spawned : ----------------------------------INFO: Exception thrown from action: makeException Name: MakefileExceptionException String: Error in invoking target 'all_no_orcl' of makefile '/u01/app/oracle/produc;. See '/u01/app/oraInventory/log; for de Severity: 1
For above error we need to do changes in
$ gedit /u01/app/oracle/produc. Search for KFOD_LINKLINE and you will see following lines in the file.
KFOD_LINKLINE=$(LINK) $(S0MAIN) $(SSKFODED) $(SKFODPT) $(KFODOBJ) \
$(LIBGENERIC) $(LLIBDBTOOLS) \ $(LIBGENERIC) $(LLIBSAGE)
$(LLIBSKGXP) $(LIBCORE) \ $(CSSCLNTLIBS_SERVER)
$(LLIBASMCLNT) $(LINKTTLIBS)
Change it to as follows
KFOD_LINKLINE=$(LINK) $(S0MAIN)-Wl,--no-as-needed$(SSKFODED)
$(SKFODPT) $(KFODOBJ) \ $(LIBGENERIC) $(LLIBDBTOOLS) \
$(LIBGENERIC) $(LLIBSAGE) $(LLIBSKGXP) $(LIBCORE) \
$(CSSCLNTLIBS_SERVER) $(LLIBASMCLNT) $(LINKTTLIBS)
Again you will see error for all_no_orcl
In the logs for above error I have observed following line
INFO: l.c:(text.unlikely+0x3231): undefined reference to `oss_cell_discovery_fetch'/u01/app/oracle/produc): In function `kfklCellScanTerm':kfkl.c:(text.unlikely+0x3296): undefined reference to `oss_cell_discovery_close'collect2: error: ld returned 1 exit statusmake: *** [/u01/app/oracle/produc] Error 1INFO: End output from spawned : ----------------------------------INFO: Exception thrown from action: makeException Name: MakefileExceptionException String: Error in invoking target 'all_no_orcl' of makefile '/u01/app/oracle/produc;. See '/u01/app/oraInventory/log; for de Severity: 1
For above error we need to do changes in
$ gedit/u01/app/oracle/produc. Search for AMDU_LINKLINE and you will see following lines in the file.
AMDU_LINKLINE=$(LINK) $(S0MAIN) $(SSKFMUED) $(SKFMUPT) \
$(LLIBDBTOOLS) $(LLIBCORE) $(LLIBGENERIC) $(LLIBUNLSRTL) \
$(LLIBNLSRTL) $(LLIBCORE) $(LLIBSAGE) $(LLIBSKGXP) \ $(LLIBNLSRTL)
$(CSSCLNTLIBS_SERVER) $(LLIBASMCLNT) $(LINKTTLIBS)
Change it to as follows
AMDU_LINKLINE=$(LINK) $(S0MAIN)-Wl,--no-as-needed$(SSKFMUED)
$(SKFMUPT) \ $(LLIBDBTOOLS) $(LLIBCORE) $(LLIBGENERIC)
$(LLIBUNLSRTL) \ $(LLIBNLSRTL) $(LLIBCORE) $(LLIBSAGE) $(LLIBSKGXP) \
$(LLIBNLSRTL) $(CSSCLNTLIBS_SERVER) $(LLIBASMCLNT) $(LINKTTLIBS)
Again you will see error for all_no_orcl
In the logs for above error I have observed following line
INFO: ss_finalize'/u01/app/oracle/produc): In function `kgfkOssOpen':kg:(text.unlikely+0x660b): undefined reference to `osssec_getkey'kg:(text.unlikely+0x6680): undefined reference to `oss_open'/u01/app/oracle/produc): In function `kgfkOssError':kg:(text.unlikely+0x6c4a): undefined reference to `oss_errstr'kg:(text.unlikely+0x6c79): undefined reference to `oss_errstr'collect2: error: ld returned 1 exit sINFO: tatusmake: *** [/u01/app/oracle/produc] Error 1INFO: End output from spawned : ----------------------------------INFO: Exception thrown from action: makeException Name: MakefileExceptionException String: Error in invoking target 'all_no_orcl' of makefile '/u01/app/oracle/produc;. See '/u01/app/oraInventory/log; for de Severity: 1
For above error we need to do changes in
$gedit /u01/app/oracle/produc. Search for KFED_LINKLINE and you will see following lines in the file.
KFED_LINKLINE=$(LINK) $(S0MAIN) $(SSKFEDED) $(SKFEDPT) \
$(LLIBDBTOOLS) $(LLIBSAGE) \ $(LLIBSKGXP) $(CSSCLNTLIBS_SERVER)
$(LLIBASMCLNT) $(LINKTTLIBS)
Change it to as follows
KFED_LINKLINE=$(LINK) $(S0MAIN)-Wl,--no-as-needed$(SSKFEDED)
$(SKFEDPT) \ $(LLIBDBTOOLS) $(LLIBSAGE) \ $(LLIBSKGXP) $(CSSCLNTLIBS_SERVER)
$(LLIBASMCLNT) $(LINKTTLIBS)
This time I got error for utilities
In the logs for above error I have observed following line
INFO: /usr/bin/ld: /u01/app/oracle/produc): undefined reference to symbol 'ons_subscriber_close'/u01/app/oracle/produc: error adding symbols: DSO missing from command linecollect2: error: ld returned 1 exit statusINFO: make: *** [/u01/app/oracle/produc] Error 1INFO: End output from spawned : ----------------------------------INFO: Exception thrown from action: makeException Name: MakefileExceptionException String: Error in invoking target 'utilities' of makefile '/u01/app/oracle/produc;. See '/u01/app/oraInventory/log; for de Severity: 1
For above error we need to do changes in
$ gedit /u01/app/oracle/produc.Search for PLSHPROF and you will see following lines in the file.
$(PLSHPROF) : $(ALWAYS) $(PLSHPROF_DEPS) $(SILENT)$(ECHO)
$(SILENT)$(ECHO) " - Linking hierarchical profiler utility (plshprof)" $(RMF)
$@ $(PLSHPROF_LINKLINE)
Change it to as follows
$(PLSHPROF) : $(ALWAYS) $(PLSHPROF_DEPS) $(SILENT)
$(ECHO) $(SILENT)$(ECHO) " - Linking hierarchical profiler utility (plshprof)" $(RMF) $@
$(PLSHPROF_LINKLINE)-lons
Clickretryto go further.
Again I got error for utilities
In the logs for above error I have observed following line
INFO: /usr/bin/ld: /u01/app/oracle/produc: undefined reference to symbol 'ztcsh'/u01/app/oracle/produc: error adding symbols: DSO missing from command linecollect2: error: ld returned 1 exit statusINFO: make: *** [/u01/app/oracle/produc] Error 1INFO: End output from spawned : ----------------------------------INFO: Exception thrown from action: makeException Name: MakefileExceptionException String: Error in invoking target 'utilities' of makefile '/u01/app/oracle/produc;. See '/u01/app/oraInventory/log; for de Severity: 1
For above error we need to do changes in
$ gedit /u01/app/oracle/produc
Search for TG4PWD and you will see following lines in the file.
$(TG4PWD) : $(ALWAYS) $(TG4PWD_DEPS) $(SILENT)$(ECHO)
$(SILENT)$(ECHO) " - Linking $(TG4DG4)pwd utility"
$(RMF) $@ $(TG4PWD_LINKLINE)
Change it to as follows
$(TG4PWD) : $(ALWAYS) $(TG4PWD_DEPS) $(SILENT)$(ECHO)
$(SILENT)$(ECHO) " - Linking $(TG4DG4)pwd utility" $(RMF) $@
$(TG4PWD_LINKLINE)-lnnz12
Clickretryto go further.
Again I got error for utilities
In the logs for above error I have observed following line
INFO: Linking external procedure agent (/u01/app/oracle/produc)INFO: rm -f /u01/app/oracle/producINFO: /u01/app/oracle/produc -o /u01/app/oracle/produc -m64 -z noexecstack -Wl,--disable-new-dtags -L/u01/app/oracle/produc -L/u01/app/oracle/produc -L/u01/app/oracle/produc/ /u01/app/oracle/produchormc.o /u01/app/oracle/produchomts.o -lagtsh -lpthread -lclntsh -lclntshcore `cat /u01/app/oracle/produc: ome_1/lib/sysliblist` -Wl,-rpath,/u01/app/oracle/produc -lm `cat /u01/app/oracle/producsysliblist` -ldl -lm -L/u01/app/oracle/produc -lnsgr12INFO: /usr/bin/ld: /u01/app/oracle/produc: undefined reference to symbol 'nsdisc'/u01/app/oracle/produc: error adding symbols: DSO missing from command linecollect2: error: ld returned 1 exit statusINFO: make: *** [/u01/app/oracle/produc] Error 1INFO: End output from spawned : ----------------------------------INFO: Exception thrown from action: makeException Name: MakefileExceptionException String: Error in invoking target 'utilities' of makefile '/u01/app/oracle/produc;. See '/u01/app/oraInventory/log; for de Severity: 1
For above error we need to do changes in
$ gedit /u01/app/oracle/produc
. Search forLinking external procedure agentand you will see following lines in the file.
$(EXTPROC): $(ALWAYS) $(EXTPROC_DEPS)
$(SILENT)$(ECHO) $(SILENT)$(ECHO) "Linking external procedure agent ($@)" $(RMF) $@
$(EXTPROC_LINKLINE)
Change it to as follows
$(EXTPROC): $(ALWAYS) $(EXTPROC_DEPS) $(SILENT)$(ECHO)
$(SILENT)$(ECHO) "Linking external procedure agent ($@)" $(RMF) $@
$(EXTPROC_LINKLINE)-lagtsh
Clickretryto go further.
Again I got error for utilities
In the logs for above error I have observed following line
INFO: Linking external procedure agent (/u01/app/oracle/produc)INFO: rm -f /u01/app/oracle/producINFO: /u01/app/oracle/produc -o /u01/app/oracle/produc -m64 -z noexecstack -Wl,--disable-new-dtags -L/u01/app/oracle/produc -L/u01/app/oracle/produc -L/u01/app/oracle/produc/ /u01/app/oracle/produchormc.o /u01/app/oracle/produchomts.o -lagtsh -lpthread -lclntsh -lclntshcore `cat /u01/app/oracle/produc: ome_1/lib/sysliblist` -Wl,-rpath,/u01/app/oracle/produc -lm `cat /u01/app/oracle/producsysliblist` -ldl -lm -L/u01/app/oracle/produc -lnsgr12 -lagtshINFO: /usr/bin/ld: /u01/app/oracle/produc: undefined reference to symbol 'nsdisc'/u01/app/oracle/produc: error adding symbols: DSO missing from command linecollect2: error: ld returned 1 exit statusINFO: make: *** [/u01/app/oracle/produc] Error 1INFO: End output from spawned : ----------------------------------INFO: Exception thrown from action: makeException Name: MakefileExceptionException String: Error in invoking target 'utilities' of makefile '/u01/app/oracle/produc;. See '/u01/app/oraInventory/log; for de Severity: 1
For above error we need to do changes in
$ gedit /u01/app/oracle/produc
. Search forLinking external procedure agentand you will see following lines in the file.
$(EXTPROC): $(ALWAYS) $(EXTPROC_DEPS) $(SILENT)$(ECHO)
$(SILENT)$(ECHO) "Linking external procedure agent ($@)" $(RMF) $@
$(EXTPROC_LINKLINE)
Change it to as follows
$(EXTPROC): $(ALWAYS) $(EXTPROC_DEPS) $(SILENT)
$(ECHO) $(SILENT)$(ECHO) "Linking external procedure agent ($@)" $(RMF) $@
$(EXTPROC_LINKLINE)-lagtsh
Further we also need to do changes in
$ gedit /u01/app/oracle/produc
file. Open the file with text editor and search for EXTPROC_LINKLINE and you will see following lines in the file.
EXTPROC_LINKLINE=$(LINK) $(OPT) $(EXTPMAI)
$(PROD_EXTPROC_OPT) \ $(HSALIB_SUBSET1) $(HSALIB_SUBSET2)
EXTPROC_LINKLINE=$(LINK) $(OPT)-Wl,--no-as-needed$(EXTPMAI)
$(PROD_EXTPROC_OPT) \ $(HSALIB_SUBSET1) $(HSALIB_SUBSET2)
Clickretryto go further.
This time I got error in install
In the logs for above error I have observed following line
INFO: - Linking tnslsnrINFO: rm -f tnslsnrINFO: /u01/app/oracle/produc -o tnslsnr -m64 -z noexecstack -Wl,--disable-new-dtags -L/u01/app/oracle/produc -L/u01/app/oracle/produc -L/u01/app/oracle/produc/ /u01/app/oracle/producs0nsgl.o /u01/app/oracle/producsnsglp.o -lclntsh -lclntshcore `cat /u01/app/oracle/producldflags` -lncrypt12 -lnsgr12 -lnzjs12 -ln12 -lnl12 -lnINFO: ro12 `cat /u01/app/oracle/producldflags` -lncrypt12 -lnsgr12 -lnzjs12 -ln12 -lnl12 -lnnz12 -lzt12 -lztkg12 -lztkg12 -lclient12 -lnnetd12 -lvsn12 -lcommon12 -lgeneric12 -lmm -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lxml12 -lcore12 -lunls12 -lsnls12 -lnls12 -lcore12 -lnls12 `cat /u01/app/oracle/producldflags` -lncrypt12 -lnsgr12 -lnzjs12 -ln12 -lnl12 -lnro12 `cat /u01/app/oracle/producldflags` -lncrypt12INFO: -lnsgr12 -lnzjs12 -ln12 -lnl12 -lclient12 -lnnetd12 -lvsn12 -lcommon12 -lgeneric12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lxml12 -lcore12 -lunls12 -lsnls12 -lnls12 -lcore12 -lnls12 -lclient12 -lnnetd12 -lvsn12 -lcommon12 -lgeneric12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lxml12 -lcore12 -lunls12 -lsnls12 -lnls12 -lcore12 -lnls12 `cat /u01/app/oracle/producsysliblist` -Wl,-rpath,/u01/app/oracle/produc: /lib -lm `cat /u01/app/oracle/producsysliblist` -ldl -lm -L/u01/app/oracle/produc -lons -lnl12 -ln12 -lnlsnr12 -lnlsnrc12 -lnsgr12 -lncm12 -lnro12 -ln12 -lnl12 -lnlsnr12 -lnlsnrc12 -lncm12 -ln12 -lmINFO: /usr/bin/ld: /u01/app/oracle/produc: undefined reference to symbol 'ztcr2rnd'/u01/app/oracle/produc: error adding symbols: DSO missing from command linecollect2: error: ld returned 1 exit statusINFO: make: *** [tnslsnr] Error 1INFO: End output from spawned : ----------------------------------INFO: Exception thrown from action: makeException Name: MakefileExceptionException String: Error in invoking target 'install' of makefile '/u01/app/oracle/producins_net_server.mk'. See '/u01/app/oraInventory/log; for de Severity: 1
For above error we need to do changes in /u01/app/oracle/producins_net_server.mk.
First take the backup of the file using following command
cp -rip /u01/app/oracle/producins_net_server.mk /u01/app/oracle/producins_net_server.mk.orig
Open
$ gedit /u01/app/oracle/producins_net_server.mk
file and search for TNSLSNR and you will see following lines in the file.
tnslsnr: $(S0NSGL) $(SNSGLP) $(NSGLPNP) $(SILENT)$(ECHO) " - Linking
$(TNSLSNR)" $(RMF) $@ $(TNSLSNR_LINKLINE)
Change it to as follows
tnslsnr: $(S0NSGL) $(SNSGLP) $(NSGLPNP) $(SILENT)$(ECHO) " - Linking
$(TNSLSNR)" $(RMF) $@ $(TNSLSNR_LINKLINE)-lnnz12 -lons
Clickretryto go further.
This time I got error in irman_oracle
In the logs for above error I have observed following line
INFO: - Linking OracleINFO: rm -f /u01/app/oracle/producoracleINFO: /u01/app/oracle/produc -o /u01/app/oracle/producoracle -m64 -z noexecstack -Wl,--disable-new-dtags -L/u01/app/oracle/produc -L/u01/app/oracle/produc -L/u01/app/oracle/produc/ -Wl,-E /u01/app/oracle/producopimai.o /u01/app/oracle/producssoraed.o /u01/app/oracle/producttcsoi.o -Wl,--whole-archiINFO: ve -lperfsrv12 -Wl,--no-whole-archive /u01/app/oracle/producnautab.o /u01/app/oracle/producnaeet.o /u01/app/oracle/producnaect.o /u01/app/oracle/producnaedhs.o /u01/app/oracle/producconfig.o -lserver12 -lodm12 -lcell12 -lnnet12 -lskgxp12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lxml12 -lcore12 -lunls12 -lsnls12 -lnls12 -lcore12 -lnls12 -lclient12 -lvsn12 -lcommoINFO: n12 -lgeneric12 -lknlopt `if /usr/bin/ar tv /u01/app/oracle/produclibknlopt.a | grep x > /dev/null 2>&1 ; then echo "-loraolap12" ; fi` -lskjcx12 -lslax12 -lpls12 -lrt -lplp12 -lserver12 -lclient12 -lvsn12 -lcommon12 -lgeneric12 `if [ -f /u01/app/oracle/produclibavserver12.a ] ; then echo "-lavserver12" ; else echo "-lavstub12"; fi` `if [ -f /u01/app/oracle/produclibavclient12.a ] ; then echo "-lavclient12" ; fi` -lknlopt -lsINFO: lax12 -lpls12 -lrt -lplp12 -ljavavm12 -lserver12 -lwwg `cat /u01/app/oracle/producldflags` -lncrypt12 -lnsgr12 -lnzjs12 -ln12 -lnl12 -lnro12 `cat /u01/app/oracle/producldflags` -lncrypt12 -lnsgr12 -lnzjs12 -ln12 -lnl12 -lnnzst12 -lzt12 -lztkg12 -lmm -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lxml12 -lcore12 -lunls12 -lsnls12 -lnls12 -lcore12 -lnls12 -lztkg12 `cat /u01/app/oracle/producldflags` -lncrypt1INFO: 2 -lnsgr12 -lnzjs12 -ln12 -lnl12 -lnro12 `cat /u01/app/oracle/producldflags` -lncrypt12 -lnsgr12 -lnzjs12 -ln12 -lnl12 -lnnzst12 -lzt12 -lztkg12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lxml12 -lcore12 -lunls12 -lsnls12 -lnls12 -lcore12 -lnls12 `if /usr/bin/ar tv /u01/app/oracle/produclibknlopt.a | grep "kxmn; > /dev/null 2>&1 ; then echo " " ; else echo "-lordsdo12"; fi` -L/u01/app/oracle/produc: b/ -lctxc12 -lctx12 -lzx12 -lgx12 -lctx12 -lzx12 -lgx12 -lordimt12 -lclsra12 -ldbcfg12 -lhasgen12 -lskgxn2 -lnnzst12 -lzt12 -lxml12 -locr12 -locrb12 -locrutl12 -lhasgen12 -lskgxn2 -lnnzst12 -lzt12 -lxml12 -lgeneric12 -loraz -llzopro -lorabz2 -lipp_z -lipp_bz2 -lippdcemerged -lippsemerged -lippdcmerged -lippsmerged -lippcore -lippcpemerged -lippcpmerged -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lxml12 -lcore12 -lunls12 -lsnls12 -lnls12 -lcore12 -lnls12 -lsnls12 -lunls12 -lsnINFO: ls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lxml12 -lcore12 -lunls12 -lsnls12 -lnls12 -lcore12 -lnls12 -lasmclnt12 -lcommon12 -lcore12 -laio -lons `cat /u01/app/oracle/producsysliblist` -Wl,-rpath,/u01/app/oracle/produc -lm `cat /u01/app/oracle/producsysliblist` -ldl -lm -L/u01/app/oracle/producINFO: /INFO: u01/app/oracle/produc: undefined reference to `kgfoCloseFile'/u01/app/oracle/produc: undefined reference to `kgfoShrinkFile'/u01/app/oracle/produc: undefined reference to `kgfoCommit2P'/u01/app/oracle/produc: undefined reference to `kgfoErrorMessage'/u01/app/oracle/produc: undefined reference to `kgfoGetSize'/u01/app/oracle/producINFO: : undefined reference to `kgfoOpenDirty'/u01/app/oracle/produc: undefined reference to `kgfoIO'/u01/app/oracle/produc: undefined reference to `kgfoCreateCtxExt'/u01/app/oracle/produc: undefined reference to `kgfoCreate2P'/u01/app/oracle/produc: undefined reference to `kgfoCheckHdl'/u01/app/oracle/produc/libocINFO: rb12.so: undefined reference to `kgfoDestroyCtx'/u01/app/oracle/produc: undefined reference to `kgfoRenameFile'/u01/app/oracle/produc: undefined reference to `kgfoCreateFile'/u01/app/oracle/produc: undefined reference to `kgfoDeleteFile'/u01/app/oracle/produc: undefined reference to `kgfoFnameMax'/u01/app/oracle/produc: undefinedINFO: reference to `kgfoCheckMount'/u01/app/oracle/produc: undefined reference to `kgfoControl'/u01/app/oracle/produc: undefined reference to `kgfoOpenFile'/u01/app/oracle/produc/libocru: undefined reference to `lfieno'collect2: error: ld returned 1 exit statusINFO: make: *** [/u01/app/oracle/producoracle] Error 1INFO: End output from spawned : ----------------------------------INFO: Exception thrown from action: makeException Name: MakefileExceptionException String: Error in invoking target 'irman ioracle' of makefile '/u01/app/oracle/produc;. See '/u01/app/oraInventory/log; for de Severity: 1
So I have run ldd against file /u01/app/oracle/produc
oracle@vidyadhar:~$ldd /u01/app/oracle/produc
linux-vd => (0x00007fff74de5000)
libocru => not found
libc. => /lib/x86_64-linux-gnu/libc. (0x00007fc4a3f95000)
/lib64 (0x00007fc4a4651000)
To resolve above we need to run following
sudo ln -s /u01/app/oracle/produclibocru /usr/lib
Check the linking again
oracle@vidyadhar:~$ldd /u01/app/oracle/produc
linux-vd => (0x00007fff27f8d000)
libocru => /usr/lib/libocru (0x00007f248bac5000)
libc. => /lib/x86_64-linux-gnu/libc. (0x00007f248b6fd000)
/lib64 (0x00007f248bfc9000)
Further we need to do changes in
$ gedit /u01/app/oracle/produc
. Open the file and search for ORACLE_LINKLINE and you will see following lines in the file.
ORACLE_LINKLINE=$(ORACLE_LINKER) $(PL_FLAGS) $(ORAMAI)
$(SSORED) $(TTCSOI) \ $(ORACLE_KERNEL_LIBS) $(LINKLDLIBS)
Change it to as follows
ORACLE_LINKLINE=$(ORACLE_LINKER)-Wl,--no-as-needed
$(PL_FLAGS) $(ORAMAI) $(SSORED) $(TTCSOI) \ $(ORACLE_KERNEL_LIBS) $(LINKLDLIBS)
Clickretryto go further.
Hush atleast we have almost finished the linking issues.
Now as per the instructions run the following commands withrootuser:
/u01/app/oraInventory
/u01/app/oracle/produc
Wait for some time.
Now setup will start theDatabase Configurationwizard.
Finally you will see following screens which confirms the successful installation. Remember theEM Database Express URL
This is the final screen which shows that installation is completed successfully.
Step 7 : Accessing the EM console of Oracle 12C database for Linux
As show earlier open a browser and type following URL in it
https://db_ip:5500/em
You will see following screen.
Now specify the user as sys and select as sysdba. Specify the password which we have entered during the installation process.
After inserting correct password you will see following screen.
Step 8 :Starting / stopping Oracle 12C database in Linux
First find the SID by reading/etc/oratab
Sample output is as follows
oracle@vidyadhar:/u01/app$ cat /etc/oratab
#
# This file is used by ORACLE utilities. It is created by root.sh
# and updated by either Database Configuration Assistant while creating
# a database or ASM Configuration Assistant while creating ASM instance.
# A colon, ':', is used as the field terminator. A new line terminates
# the entry. Lines beginning with a pound sign, '#', are comments.
#
# Entries are of the form:# $ORACLE_SID:$ORACLE_HOME::
#
# The first and second fields are the system identifier and home
# directory of the database respectively. The third field indicates
# to the dbstart utility that the database should , "Y", or should not,
# "N", be brought up at system boot time.
#
# Multiple entries with the same
$ORACLE_SID are not allowed.
#
#orcl:/u01/app/oracle/produc
In above orcl is SID
To start listener run following as oracle user
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/produc
export ORACLE_OWNR=oracle
export PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_SID=orcl$ORACLE_HOME/bin/lsnrctl start
To start database run following
sqlplus /nolog
connect sys as sysdba
STARTUP;
EXIT;
To stop the database run following
sqlplus /nolog
connect sys as sysdba
SHUTDOWN;
EXIT;
To stop listener run following
$ORACLE_HOME/bin/lsnrctl stop <