Build Oracle Client Environment remote connection database under Linux

First, Root user operation:(# is the root user,$ is Oracle User ) 1. download two rpm packages from Oracle website and place them under any path, using an rpm installation:

RPM-IVH oracle-instantclient11.2-basic-11.2.0.3.0-1.x86_64.rpm

RPM-IVH oracle-instantclient11.2-sqlplus-11.2.0.3.0-1.x86_64.rpm

The default installation is under/usr/lib/oracle/this path.

( Note: Need to register account before downloading, free, can register with confidence )

To Configure environment variables: ( my Profile )

#vim ~/.bash_profile

Path= $PATH: $HOME/bin

Export oracle_home=/usr/lib/oracle/11.2/client64/

Export tns_admin= $ORACLE _home/network/admin

Export ORACLE_BASE=/USR/LIB/ORACLE/11.2/

Export ld_library_path= $ORACLE _home/lib: $LD _library_path

Export PATH

Exit and save

# source ~/.bash_profile ( make it effective )

Create A tnsnames.ora configuration file

#cd/usr/lib/oracle/11.2/client64/ or #cd $ORACLE _home

#mkdir-P/network/admin ( create both directories )

#vim/usr/lib/oracle/11.2/client64/network/admin/tnsnames.ora

1 JK1 =

2 (DESCRIPTION =

3 (address_list =

4 (ADDRESS = (PROTOCOL = TCP) (HOST = 173.16.21.132) (PORT = 1521))

5)

6 (Connect_data =

7 (SERVER = dedicated)

8 (service_name = JK)

9)

0)

1: The name of the connection descriptor that you define.

4:host the IPof the database to be connected remotely , Port 1521 default .

8: The instance name of the database.

( Note: view instance name # ps-ef |grep Pmon

Oracle 3894 1 0 08:30? 00:00:00 ORA_PMON_JK

Root 5154 4546 0 09:56 pts/1 00:00:00 grep pmon

JK is the instance name )

2. Connect to the database:

# cd/usr/lib/oracle/11.2/client64/bin/

Error (1)

#./sqlplus System/[email Protected] (System: user name oracle: password jk1: Name of the connection descriptor you define )

Sql*plus:release 11.2.0.3.0 Production on Tue Dec 27 09:56:54 2016

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

ERROR:

Ora-21561:oid generation failed

Error Found: Error:ora-21561:oid generation failed

Workaround:

# hostname ( view machine name inconsistent with localhost after 127.0.0.1 )

Cenos

# cat/etc/hosts

127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4

:: 1 localhost localhost.localdomain localhost6 localhost6.localdomain6

# hostname localhost ( temporary modification )

# hostname

localhost

# vim/etc/sysconfig/network ( permanently modified, restart effective )

1 Networking=yes

2 Hostname=localhost ( modified )

Error (2)

Execute again:

#./sqlplus System/[email protected]

Sql*plus:release 11.2.0.3.0 Production on Tue Dec 27 10:08:11 2016

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

ERROR:

Ora-12541:tns:no Listener

error found : Error:ora-12541:tns:no listener

workaround : Check that the database server is listening ? whether the database is up ?

$ lsnrctl Start ( open monitor )

$ sqlplus/as SYSDBA ( Access database Admin user )

Sql*plus:release 10.2.0.4.0-production on mainlandclean? T. 10:17:40

Copyright (c) 1982, Oracle. All rights Reserved.

Connected to an idle instance.

Sql> Startup ( startup database )

ORACLE instance started.

Total System Global area 226492416 bytes

Fixed Size 2082912 bytes

Variable Size 184551328 bytes

Database buffers 33554432 bytes

Redo buffers 6303744 bytes

Database mounted.

Database opened.

Sql> ( database up!!) )

Error (3)

Execute again:

#./sqlplus System/[email Protected]

Sql*plus:release 11.2.0.3.0 Production on Tue Dec 27 10:15:06 2016

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

ERROR:

Ora-12543:tns:destination Host Unreachable

Error Found: Error:ora-12543:tns:destination Host Unreachable

Workaround: The service side firewall should be on, shut down the firewall.

# service Iptables Stop ( immediate effect, restart Recovery )

Clear Firewall rules: [ OK ]

set chains to ACCEPT Policy:Filter [ OK ]

Unloading in progress Iiptables module: [ OK ]

Success (4)

Execute again:

#./sqlplus System/[email Protected]

Sql*plus:release 11.2.0.3.0 Production on Tue Dec 27 10:18:26 2016

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

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0-64bit Production

With the partitioning, OLAP, Data Mining and Real application testing options

Sql>

Connection Successful!!

Second, create oralce users and oinstall groups, easy to manage the database: (1)

To create a group:

#groupadd Oinstall

#groupadd DBA

Create a user home directory /home/oracle:

#mkdir-P/home/oracle

Create user Oracle to Primary group Oinstall, Sub-group dba, home directory /home/oracle:

#useradd-G oinstall-g dba-d/home/oracle/oracle

to view the addition of user Oracle:

# ID Oracle

uid=501 (Oracle) gid=503 (oinstall) Group =503 (Oinstall), 504 (DBA)

Copy the Oracle directory under/usr/lib/oracle/to /home/oracle

#cp-R/usr/lib/oracle//home/oracle

Change owner/home to Oracle

#chown-R Oracle:oinstall/home

#ll/home/( view )

Oracle Oinstall 4096 19:14 Oracle

Error (2)

#su-oracle ( enter oracle user )

-bash-3.2$

And not

[Email protected] ~]$

workaround : the . bash* profile is missing under The Oracle User , and the root user is copied over

#ll-A ~ ( see what the bash configuration file is under root )

-RW-------. 1 root root 14941 10:24. Bash_history

-rw-r--r--. 1 root root 5 months . Bash_logout

-rw-r--r--. 1 root root 368 18:16. Bash_profile

-rw-r--r--. 1 root root 176 9 months 2004. BASHRC

copy these to /home/oracle/ and chown change their user group to Oracle:oinstall.

again :

# su-oracle

[[email protected] ~]$ pwd ( normal )

/home/oracle/

Error (3) The following are performed under Oracle user

To start connecting to the database:

$ sqlplus System/[email protected]

-bash:sqlplus:command not found

problem found:sqlplus Command not found, should be not configured environment variable

Workaround:

$ vim ~/.bash_profile

( Add this )

Export path= $PATH: $HOME/bin: $ORACLE _home/bin

Exit and save

$ source ~/.bash_profile ( make it effective )

Success (4)

Execute again:

$ sqlplus System/[email protected]

Sql*plus:release 11.2.0.3.0 Production on Tue Dec 27 11:05:09 2016

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

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0-64bit Production

With the partitioning, OLAP, Data Mining and Real application testing options

Sql>

Connection Successful!!

Recently set up Oracle client environment on the collation of the error and solution, the big God passing if found wrong place want to point out!!

Build Oracle Client Environment remote connection database under Linux