Member Avatar for firoz.raj

i installed Oracle 9i.when i go Start->Program->Oracle-oraHome90-
i did not get Isql * plus.Kindly let me know the idea.Any help would
be highly appreciated.Kindly find the attachment also.

  • 2 Contributors
  • 35 Replies
  • 351 Views
  • 1 Year Discussion Span
  • Latest Post Latest Post by debasisdas

Dani AI

Generated

A short, practical summary that fills gaps from the thread

iSQLPlus is the web-based SQLPlus interface (it runs through Oracle's HTTP server) and is not shipped with every edition. That explains why there was no iSQL*Plus shortcut under your Oracle home after the Express/limited install; the Express Edition purposely omits that web component. (docs.oracle.com)

If the administrative passwords are unknown, use the local command-line SQL*Plus to connect with OS authentication and change the accounts rather than hunting for a Start‑menu shortcut. Example steps (run from an elevated Windows command prompt and replace ORACLE_HOME/ORACLE_SID appropriately):

set ORACLE_SID=orcl
cd "%ORACLE_HOME%\bin"
sqlplus /nolog
CONNECT SYS AS SYSDBA
ALTER USER SYS IDENTIFIED BY new_password;
ALTER USER SYSTEM IDENTIFIED BY new_password;

Oracle's docs include the exact CONNECT/ALTER USER workflow and notes about unlocking/changing accounts. (docs.oracle.com)

If you want to remove the old 9i/10g home before installing a newer client, use Oracle's deinstallation tool (deinstall) or the Oracle Universal Installer deinstall option rather than relying only on Control Panel. The deinstall utility is located under the Oracle home and will remove the software and configuration for that home (back up any datafiles first). (docs.oracle.com)

As suggested, using a GUI client is often the fastest fix for development. Oracle SQL Developer is free and supports many older database releases; it runs outside the database home (no need for the web iSQL*Plus component) and is usually easier to get started with on modern Windows installs. Choose the client download that matches your OS bitness and follow the SQL Developer install notes. (oracle.com)

Summary: XE/express installs often omit iSQLPlus (so its shortcut will be missing), use the command-line SQLPlus or SQL Developer to connect, reset SYS/SYSTEM via OS auth if needed, and use the deinstall tool to cleanly remove old Oracle homes.

Recommended Answers

All 35 Replies

Member Avatar for debasisdas

Are you getting something like SQL WORKSHEET under application development ?

Member Avatar for firoz.raj

yes. when i go development->SqlPlusWorksheet i got Oracle Enterprose Manager Login dialog box.Kindly let me know how
show i get to know the Username and password.and how should
i configure Isql*plus.Kindly let me know the idea.Any help would
be highly appreciated.Kindly find the attachment also.

issue.zip (66.21 KB)
Member Avatar for debasisdas

You don't have the user name password ?

Member Avatar for firoz.raj

i myself installed an oracle between i did not notice about password.kindly let me know. how should i check it.Kindly let me know the idea.any help would be highly appreciated.

Edited by firoz.raj because: n/a
Member Avatar for debasisdas

do you have the password for sys or system account ?

Member Avatar for firoz.raj

During installation i did not notice about default sys and system account.may be .it has taken default username.and password.
should i install again.after reinstalling.Kindly let me know debasis
my friend .any help would be highly appreciated.

Member Avatar for debasisdas

try log in as

sys/ as sysdba
password----change_on_install

If you are planning to reinstall better use any advance version .
Current version for windows is 11.1

Edited by debasisdas because: n/a
Member Avatar for firoz.raj

try log in as

sys/ as sysdba
password----change_on_install

i tried username as a sys.and password as a change_on_install But still i am getting errror.Invalid username and password.Login denied. i am getting error ora -01017 .Kindly let me know the idea.Any help would be highly appreciated.Kindly find the attachment also.

Issue.zip (341.36 KB)
Edited by firoz.raj because: n/a
Member Avatar for debasisdas

better install any latest version and set the passwords carefully.

Member Avatar for firoz.raj

sys/ as sysdba
password----change_on_install
then what is the uses of this default password.i have seen about these two username & password.in oracle university means ocp Dba Paper iii book also.Oracle Database Administration.When i tried to uninstall.and when i go to control panel Add/remove programme.i did not see .anything regarding Oracle.Kindly let me know the idea.How should i uninstall
Oracle 9I?.Any help would be highly appreciated.

Edited by firoz.raj because: n/a
Member Avatar for debasisdas

ORACLE will not come in that list of installed software. Uninstall from oracle main menu from start button or use the oracle CD.

Member Avatar for firoz.raj

If you are planning to reinstall better use any advance version .
Current version for windows is 11.1
is it windows installere version ?how should i test /come to know windows installer version ?
when i go start->program->oracle-orahome90 i did not get any option regarding Uninstallion.Kindly let me know the idea.Any
help would be highly appreciated.Kindly find the attachment.

Issue.zip (875.36 KB)
Member Avatar for debasisdas

once you start installing 10/11 g you will get the list of pre-installed oracle homes/products. You need to uninstall the existing 9 version before installing the higher version.

Member Avatar for firoz.raj

No any additional except to put oracle 10g Cd.Kindly let me know the idea.any help would be highly appreciated.

Member Avatar for debasisdas

i don't think i understood your last question.

Member Avatar for firoz.raj

can you tell me please any link on the Web So that i download
Oracle 10g.Kindly let me know the idea.Any help would be highly appreciated.

Member Avatar for debasisdas

Please find it here .

Edited by debasisdas because: n/a
Member Avatar for firoz.raj

Which version should i install.Kindly let me know the idea.any help would be highly appreciated.There are three Version here .
Oracle Database 10 G.
Oracle Database 10 G Express.
Oracle Install Client.

Member Avatar for firoz.raj

How should i start Isql*Plus.Kindly let me know the idea.i have alredy installed Oracle 10 G Express Edition Now .Kindly find the
attachment also.

IsqlIssue.jpg 41.94 KB
Member Avatar for debasisdas

Oracle Express is a free version so that tool is not available for you in the version you have installed . You need to use the 3rd item for sql queries on the screen.

Member Avatar for firoz.raj

it means i will not get Isql * Plus in the Express Edition.

Member Avatar for debasisdas

why not use sql developer , that is a free GUI tool.

Member Avatar for firoz.raj

why not use sql developer , that is a free GUI tool

From where should i get this GUI Tool .Kindly let me know the
idea.Any help would be highly appreciated.

Member Avatar for debasisdas

You can find it here.

Member Avatar for firoz.raj

hi friends,
Together with this .can anyone tell me ???.How should i install oracle 10g client for Windows 7 ???.Kindly let me know the idea.any help would be highly appreciated.

Member Avatar for debasisdas

What do you mean by How should i install ?

Are you facing any issue, during installation.

Member Avatar for firoz.raj

first of all i have tried to downlod the setup file for oracle 10g client. but i did not get the installation setup for oracle 10G Client .Kindly let me know the idea.any help would be highly appreciated.

Member Avatar for debasisdas

You need to download from .

this file

Oracle Database 10g Client Release 2 ()
10204_vista_w2k8_x64_production_client.zip (507,934,134 bytes)

Member Avatar for firoz.raj

i need to install in windows 7.together with this i have 32 bit Microprocessor .

Edited by firoz.raj because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.