OS: AIX 6
db Version: 11.2.0.3.0
here is the scenario guys, one of our servers containg the test databases crashed (don't know how), so the server is completely empty now and we have to build everthing from the scratch. What I did was, I created a tarball of Oracle home from another server and ftped it to the test server and unzipped it, changed the ownership to oracle user.
Now when I am trying to create duplicate databases I am getting the error ora-12547.
Here is what I did to try to solve the problem.
1. I changed the listener.ora file (by change I mean, I replaced the ipaddress of the production server from which the tarball was created with the ipaddress of the test server where we have to rebuild the databases)
2. After changing the listener.ora file, I restarted the listener several times and made sure that all the path variables are set and did a "*relink all*".
3. I set
LD_LIBRARY_PATH to *$ORACLE_HOME/lib* like some blogs mentioned.
4. I went through metalink and they mentioned about changing the permission of the oracle binary in $ORACLE_HOME/bin. so I did *$chmod 6751 oracle*.
Now I created the pfile and the password file for the database I want to build and tried to bring the database in a nomount stage, here is the result I got.
<oracle>chh-aix-beta/home/oracle> sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Feb 8 18:13:35 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
ERROR:
ORA-12547: TNS:lost contact
Enter user-name:
Where am I going wrong? are there any additional steps I need to follow?
I am guessing, if I could bring my database in a nomount stage 50% of my problem is solved.
I also read the following thread.
946294
either that thread didnot contain the solution i was looking for or I did not understand the thread completely.
Anyway I was wondering if anyone could provide a new insight into my problem
I dont know if the Info I provided is sufficient to come up with a solution to my problem, so please ask me If any additional Information is needed and more importantly what information is needed.
Thank You