Hiding the password

Initialization parameter

NAME TYPE VALUE
—————————— ——- ——————–
os_authent_prefix string ops$

in my init.ora. I then:

create user ops$tkyte identified externally;

grant connect to ops$tkyte;

useradd tkyte
usermod -G oinstall,dba tkyte
passwd tkyte

cd /home/oracle
cp .bash_profile /home/tkyte

su – tkyte

bash-3.2$ sqlplus /

SQL*Plus: Release 11.2.0.3.0 Production on Mon Mar 3 18:48:08 2014

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

ERROR:
ORA-12547: TNS:lost contact

-3.2$ cd $ORACLE_HOME/bom
-bash: cd: /home/oracle/u01/app/oracle/product/11.2.0/db_1/bom: No such file or directory
-bash-3.2$ cd $ORACLE_HOME/bin
-bash-3.2$ ls oracle
oracle
-bash-3.2$ ls -ltr oracle
-rwxr-x–x 1 oracle oinstall 232399473 Aug 9 2013 oracle

-bash-3.2$ sqlplus /

SQL*Plus: Release 11.2.0.3.0 Production on Mon Mar 3 19:08:31 2014

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

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show user
USER is “OPS$TKYTE”
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

-bash-3.2$ expdp userid=/ full=y

http://www.dadbm.com/how-to-fix-ora-12547-tns-lost-contact-when-try-to-connect-to-oracle/
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:142212348066

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s