Listener not getting started after db upgrade from 10.2.0.2.0 to 11.2.0.2.0

[Former Member]

Dear all

i have successfully upgrade oracle database from 10.2.0.2.0 to 11.2.0.2.0 through dbua but after upgrade i have copied listener and tnsname from realese to and new release then i follow these step

Stop listener   it get stop perfectly

start listener  it won't get start  it gives ora-12560 error

i have checked and change the  file at /usr/sap/sid/sys/profile/oracle also

if there is anything to do with control file let me know

Kindly suggest for the above

[Reagan · Accepted solution]

i have checked and change the  file at /usr/sap/sid/sys/profile/oracle also

Check the files present at $ORACLE_HOME/network/admin

Regards

RB

[Former Member · Accepted solution]

Dear

The file which i have copied from 10g to 11g i have all files in that locations $ORACLE_HOME/network/admin

regads

[divyanshu_srivastava3 · Accepted solution]

echo $ORACLE_HOME and share the value.

[Reagan · Accepted solution]

su - orasid

ls -la $ORACLE_HOME/network/admin

cat $ORACLE_HOME/network/admin/listener.ora

Regards

RB

[Reagan · Accepted solution]

Can you supply the output of the below commands ?

Regards

RB

[Former Member · Accepted solution]

Dear

Now my listener service is started with your help i am very grateful to you

Regards

[Former Member]

Hi Rajendra,

   Go to /tmp/.oracle    directory. and create temporary directory and move all the files from .oracle directory to temporary direct and start the listener.

It will work.

Regards

Yugandhar  T R

[divyanshu_srivastava3]

Open Listener.ora file.

Look for ORACLE_HOME and update it.

Also, if your listener has an alias, use it to start listner.

Divyanshu

[Former Member]

Hi Divyanshu

after i update my $ORACLE_HOME and set environmental variable  properly then it got started

i copied sqlnet.ora again from 10.2 to 11.2 it show user id and password

and not able to login from sqlplus "/ as sysdba " it shows insufficient privillages

Regards

[divyanshu_srivastava3]

Hi Rajendra,

Please refer:

1755636 - Database Administrators Segregation

480266 - Problems with the SYSDBA/SYSOPER/INTERNAL connect

700548 - FAQ: Oracle authorizations

Divyanshu

[former_member188883]

Hi Rajendra,

Please check whether oracle home is correctly maintained in the listener.ora file.

Since oracle has been upgraded oracle home gets changed.

Regards,

Deepak Kori

[former_member182657]

Hi,

Please follow SAP Notes   1734700 - ORA-12560: TNS:protocol adapter error

and  441518 - ORA-12560 composite SAP Note

Also share listener.log file for analysis.

Regards,

Gaurav