Shulou(Shulou.com)06/01 Report--

Error when executing dbca after installing oracle

Sh:/bin/ksh:Nosuch file or directory

Suspected that the KSH package, yum installksh, is not installed.

Got it!

File "/ etc/oratab" is not accessible

It turns out that the root.sh script was not executed, but was executed in the oracle home directory (cd$ORACLE_HOME) under the product/11.2.0/db_1/ directory. / root.sh

There are still errors reported after the execution.

ORA-00119: invalid specification for system parameter LOCAL_LISTENER

ORA-00132: syntax error or unresolved network name'LISTENER_ORCL'

Suspected is the problem of monitoring, lsnrctlstart failed to start, the specific error message is not clear, so re-add monitoring.

An error was reported while executing netca

TNS-12545 Connect failed because target host or object does not exist

After checking, it is because the tnsname.ora file does not exist, because I did not install oracle, it is not clear why there is no such file. So I copied a copy from another server:

# tnsnames.ora Network Configuration File:/u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

Oracle11g=

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP) (HOST = *. *) (PORT = 1521))

)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SID = orcl)

)

)

ORCL =

(DESCRIPTION =

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

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = orcl)

)

Lsnrctl is executed after the copy, and the listening starts successfully.

When performing startup

SQL > startup

ORA-00845: MEMORY_TARGET not supported on this system

Root@test~] # cat / etc/fstab | grep tmpfs

Tmpfs / dev/shm tmpfs defaults 0 0

Remount the shm partition mount-oremount,size=8G / dev/shm

Modify fstab to make it permanent vi/etc/fstab

/ dev/mapper/vg_ccbfpp-lv_home/home ext4 defaults 1 2

/ dev/mapper/vg_ccbfpp-lv_swap swap swap defaults 0 0

Tmpfs / dev/shm tmpfs defaults 0 0

Devpts / dev/pts devpts gid=5,mode=620 0 0

Sysfs / sys sysfs defaults 0 0

Proc / proc proc defaults 0 0

Tmpfs / dev/shm tmpfs defaults,size=16g 0 0

Df-h | grepshm

Tmpfs 8G 0 16G 0% / dev/shm

SQL > startup

ORACLE instancestarted.

Total SystemGlobal Area 9420095488 bytes

FixedSize 2236248 bytes

VariableSize 2315255976 bytes

DatabaseBuffers 7046430720 bytes

RedoBuffers 56172544 bytes

Databasemounted.

Databaseopened.

SQL > exit

What a twist and turn.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.