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.
sachin_knAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

schwertnerCommented:
About the users. DBCA normally asks for the passwords of SYS and SYSTEM users. If you can connect as sysdba via dbuser unlock that users and give them passwords.

Oracle Personal editions are not provided with a Listener. the connection is made using bequiet protocol (a protocol for local DB connections). So when you use Net CA you should use this protocol. When you install new product you should use the Net CA of THAT product (not the server) to create an entry in the local tnsnames.ora file.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sachin_knAuthor Commented:
Hi this is sachin_kn (I posted the question). Can some one please give me the specific steps of fix for this problem
schwertnerCommented:
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_GROUP                        VARCHA
 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
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

sachin_knAuthor Commented:
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
LeTayCommented:
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 !
schwertnerCommented:
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.
sachin_knAuthor Commented:
I want to close this question
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.