sachin_kn
asked on
ORA: 12560 TNS protocol adapter error Oracle 9i database and developer suite
System Description: IBM Aptiva, 128 MB RAM , P2 processor
First I installed the Oracle Personal database 9i release 2 ( 9.2.0.1.0) complete version(1.80 GB0) in the system. I followed the instructions provided at the following link
http://www.course.com/cdkit/installinstructionsguideto9i.cfm
After the installation was complete, the above instructions asked me to create a account called "dbuser/oracle " using the database configuration assistant. This also went thru fine. However when i try to connect to the databse using SQL plus i can only login using the "dbuser/oracle " login account. I cant login using the "system/manager" account. However with the "dbuser/oracle" a/c i am able to create , and retrieve tables from the database.
After this I installed the oracle Developer Suite 9i release 2 on the system again following the instructions provided at the above link. The installation was successful. For the first time I tried to run a form based developer application. The system asked me if i wanted to log on to the database. I logged on the the database using the "dbuser/oracle". After this the Java Initiator process was also successful. But after this , when the browser was beginning to load the applet, a database connect dialog Box appears with the error message " ORA: 12560 TNS protocol adapter error". Ths connect dialog box shoe text string "DBUSER" in the name field. If i try to enter the "oracle" password , it again gives the same error message.
I know the minimum memory requirements r 256 MB and i am soon upgrading to 256 MB of RAM. Also let me know if I need to re install oracle database and DS after memory upgrade.
I am teaching assistant and prompt help ll be sincerely apreciated.
First I installed the Oracle Personal database 9i release 2 ( 9.2.0.1.0) complete version(1.80 GB0) in the system. I followed the instructions provided at the following link
http://www.course.com/cdkit/installinstructionsguideto9i.cfm
After the installation was complete, the above instructions asked me to create a account called "dbuser/oracle " using the database configuration assistant. This also went thru fine. However when i try to connect to the databse using SQL plus i can only login using the "dbuser/oracle " login account. I cant login using the "system/manager" account. However with the "dbuser/oracle" a/c i am able to create , and retrieve tables from the database.
After this I installed the oracle Developer Suite 9i release 2 on the system again following the instructions provided at the above link. The installation was successful. For the first time I tried to run a form based developer application. The system asked me if i wanted to log on to the database. I logged on the the database using the "dbuser/oracle". After this the Java Initiator process was also successful. But after this , when the browser was beginning to load the applet, a database connect dialog Box appears with the error message " ORA: 12560 TNS protocol adapter error". Ths connect dialog box shoe text string "DBUSER" in the name field. If i try to enter the "oracle" password , it again gives the same error message.
I know the minimum memory requirements r 256 MB and i am soon upgrading to 256 MB of RAM. Also let me know if I need to re install oracle database and DS after memory upgrade.
I am teaching assistant and prompt help ll be sincerely apreciated.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Get oriented in yor users so:
Can you log on as sysdba?
Connect as sysdba. Show if sys and system exist. Are they open or locked?
SQL> descr dba_users
Name Null? Type
--------------------------
USERNAME NOT NULL VARCHA
USER_ID NOT NULL NUMBER
PASSWORD VARCHA
ACCOUNT_STATUS NOT NULL VARCHA
LOCK_DATE DATE
EXPIRY_DATE DATE
DEFAULT_TABLESPACE NOT NULL VARCHA
TEMPORARY_TABLESPACE NOT NULL VARCHA
CREATED NOT NULL DATE
PROFILE NOT NULL VARCHA
INITIAL_RSRC_CONSUMER_GROU
EXTERNAL_NAME VARCHA
SQL> select username, account_status from dba_users;
USERNAME ACCOUNT_STATUS
--------------------------
SYS OPEN
SYSTEM OPEN
OLAPSYS OPEN
SCOTT OPEN
DBSNMP OPEN
ICWUSER OPEN
LSCONTACTS OPEN
LSIDMAP OPEN
LSSYSTEM OPEN
LSU17 OPEN
S17 OPEN
USERNAME ACCOUNT_STATUS
--------------------------
M17 OPEN
I17 OPEN
D17 OPEN
LSUSER OPEN
C17 OPEN
T17 OPEN
LSMEDICAL OPEN
LSDOCUMENTS OPEN
LSCONTAINER OPEN
OUTLN EXPIRED & LOCKED
WMSYS EXPIRED & LOCKED
Look which user has DBA role.
SQL> select * from v$pwfile_users;
USERNAME SYSDB SYSOP
--------------------------
SYS TRUE TRUE
Can you log on as sysdba?
Connect as sysdba. Show if sys and system exist. Are they open or locked?
SQL> descr dba_users
Name Null? Type
--------------------------
USERNAME NOT NULL VARCHA
USER_ID NOT NULL NUMBER
PASSWORD VARCHA
ACCOUNT_STATUS NOT NULL VARCHA
LOCK_DATE DATE
EXPIRY_DATE DATE
DEFAULT_TABLESPACE NOT NULL VARCHA
TEMPORARY_TABLESPACE NOT NULL VARCHA
CREATED NOT NULL DATE
PROFILE NOT NULL VARCHA
INITIAL_RSRC_CONSUMER_GROU
EXTERNAL_NAME VARCHA
SQL> select username, account_status from dba_users;
USERNAME ACCOUNT_STATUS
--------------------------
SYS OPEN
SYSTEM OPEN
OLAPSYS OPEN
SCOTT OPEN
DBSNMP OPEN
ICWUSER OPEN
LSCONTACTS OPEN
LSIDMAP OPEN
LSSYSTEM OPEN
LSU17 OPEN
S17 OPEN
USERNAME ACCOUNT_STATUS
--------------------------
M17 OPEN
I17 OPEN
D17 OPEN
LSUSER OPEN
C17 OPEN
T17 OPEN
LSMEDICAL OPEN
LSDOCUMENTS OPEN
LSCONTAINER OPEN
OUTLN EXPIRED & LOCKED
WMSYS EXPIRED & LOCKED
Look which user has DBA role.
SQL> select * from v$pwfile_users;
USERNAME SYSDB SYSOP
--------------------------
SYS TRUE TRUE
ASKER
Hi everybody,
This is sachin_kn ( i am the one who posted the question). The database personal edition is now working fine after i reinstalled it (after clean windows install). But the developer part is still not working. I mean whenever I run a fron form application i still get the same error
ora:12560 TNS protocol adapter error
Please provide with specific steps to fix this problem
This is sachin_kn ( i am the one who posted the question). The database personal edition is now working fine after i reinstalled it (after clean windows install). But the developer part is still not working. I mean whenever I run a fron form application i still get the same error
ora:12560 TNS protocol adapter error
Please provide with specific steps to fix this problem
I do not have the solution for that but I have the same problem in another context, with Oracle 8i, and maybe my problem has the same reason as your.
I get exactly the same message since a few days on a test server where I installed Oracle 8i, with the svrmgrl command-line utility . As soon as I launch it, I get the ORA-12560 error (I could not find this error reported in Oracle documentation !) and the a prompt. This was not the case a couple of days ago but I do not remember what I did change, explicitely or implicitely to have now this problem. More, when then from svrmgrl I issue the connection command 'connect internal as sysdba', I am prompted for a password, which was not the case previously !
I get exactly the same message since a few days on a test server where I installed Oracle 8i, with the svrmgrl command-line utility . As soon as I launch it, I get the ORA-12560 error (I could not find this error reported in Oracle documentation !) and the a prompt. This was not the case a couple of days ago but I do not remember what I did change, explicitely or implicitely to have now this problem. More, when then from svrmgrl I issue the connection command 'connect internal as sysdba', I am prompted for a password, which was not the case previously !
Oracle developer suite do not include Application Server to establish 3 tier archtecture. You have to read the manuals to understand how to establish the environment.
ASKER
I want to close this question
ASKER