SQL*Plus: Release 11.2.0.1.0 Production on Wed Oct 24 14:49:32 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Enter user-name: sys/sys@orc1 as sysdba
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
Reason
1) OracleOraDb11g_home1TNSListener
D:\Oracle\product\11.2.0\dbhome_1\BIN\TNSLSNR - Service was not started
2) OracleServiceORCL:
d:\oracle\product\11.2.0\dbhome_1\bin\ORACLE.EXE ORCL - Service was not started
Starting one by one
1) Started from Services.msc -
but got same error
2) Started from Services.msc -
but got same error
What the HECK, OH I WAS WRITING something WRONG :(
Enter user-name: sys/sys@orc1 as sysdba
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
Enter user-name: sys/sys@orcl as sysdba (it is L not 1)
but now
ERROR:
ORA-12541: TNS:no listener
AHHH.....ERROR CHANGED :(
OHH...... I NEED TO RESTART THE SERVICE, LET ME START ONE BY ONE AND CHECK ERRORS :P
If we start OracleServiceORCL first, then also get same error as above i.e
ERROR:
ORA-12541: TNS:no listener
If we start OracleOraDb11g_home1TNSListener first then gets following error:
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
So now we have started both Services and write following and
Enter user-name: sys/sys@orcl as sysdba
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
Yappyyyyyy!!!!
Now i will look into technical details later. I gotta go
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Enter user-name: sys/sys@orc1 as sysdba
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
Reason
1) OracleOraDb11g_home1TNSListener
D:\Oracle\product\11.2.0\dbhome_1\BIN\TNSLSNR - Service was not started
2) OracleServiceORCL:
d:\oracle\product\11.2.0\dbhome_1\bin\ORACLE.EXE ORCL - Service was not started
Starting one by one
1) Started from Services.msc -
but got same error
2) Started from Services.msc -
but got same error
What the HECK, OH I WAS WRITING something WRONG :(
Enter user-name: sys/sys@orc1 as sysdba
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
Enter user-name: sys/sys@orcl as sysdba (it is L not 1)
but now
ERROR:
ORA-12541: TNS:no listener
AHHH.....ERROR CHANGED :(
OHH...... I NEED TO RESTART THE SERVICE, LET ME START ONE BY ONE AND CHECK ERRORS :P
If we start OracleServiceORCL first, then also get same error as above i.e
ERROR:
ORA-12541: TNS:no listener
If we start OracleOraDb11g_home1TNSListener first then gets following error:
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
So now we have started both Services and write following and
Enter user-name: sys/sys@orcl as sysdba
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
Yappyyyyyy!!!!
Now i will look into technical details later. I gotta go
No comments:
Post a Comment