July 6, 2008 06:12pm pdt

1. sdstuber 15,770
2. sonicefu 13,000
3. schwertner 12,100
4. jinesh_k... 6,950
5. rolutola 4,730
6. markgeer 4,000
7. MikeOM_DBA 3,500
7. rbrooker 3,500
9. angelIII 3,000
9. LindaC 3,000
11. Milleniu... 2,800
12. aiklamha 2,600
13. sandeep_... 2,500
14. hernst42 2,200
15. dvz 2,150

1. schwertner 208,376
2. slightwv 62,348
3. Pradeepgv03 55,488
4. Henka 40,683
5. angelIII 34,793
6. rbrooker 32,690
7. RCorfman 31,331
8. BobMc 29,143
9. bmoshier 27,233
10. pennnn 27,077
11. catchmei... 26,789
12. ploubier 26,544
13. sdstuber 22,770
14. nav_kum_v 22,198
15. sujit_kumar 21,558

03.06.2008 at 11:18AM PST, ID: 23220731

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

6.5

Need help troubleshooting database startup errors

Zones: Oracle Product Info, Sun Solaris, Oracle 10.x

I am trying to help a client who is unable to startup their database. I am not sure what questions to ask at this point can someone give me advice.

Here is what I know:

Their system is running on Solaris 9 Operating System
Oracle 10g
Oracle Operating System (OS) owns the Oracle binaries

The problem
Log in as Oracle OS user
when trying to connect /as sysdba get an error "insufficient privileges"

They have not had this problem in the past. I do not know what could have happened to change this. What kind of questions should I ask to figure out what the problem could be and provide a solution?

Start your free trial to view this solution

Question Stats

Zone: Database

Question Asked By: sikyala

Solution Provided By: johnsone

Participating Experts: 3

Solution Grade: A

Translate:

Loading Advertisement...

Microsoft

Internet Protocols
Applications

Development
OS

Hardware
Windows Security

Apple

Operating Systems
Hardware

Programming
Networking

Software

Internet

Search Engines
File Sharing
WebTrends / Stats
Spy / Ad Blockers

Web Browsers
New Net Users
Web Development
Chat / IM

Anti Spam
Web Servers
Anti-Virus
Email Clients

Gamers

Tips
Online / MMORPG
Puzzle
Emulators

Action / Adventure
Role Playing
Consoles
Game Programming

Strategy
Sports
Misc
Computer Games

Digital Living

Hardware
New Net Users
New Users

Software
Digital Music
Gaming World

Home Security
Apple
Networking Hardware

Virus & Spyware

Vulnerabilities
IDS
Encryption
Anti-Virus

Operating Systems Security
Software Firewalls
WebApplications
Cell Phones

Operating Systems
Internet
Hardware Firewalls

Hardware

Handhelds / PDAs
Displays / Monitors
Components
Networking Hardware

Peripherals
Laptops/Notebooks
Storage
Servers

Desktops
New Users
Misc
Apple

Software

System Utilities
Industry Specific
Network Management
Photos / Graphics
Page Layout
VMWare
Misc
Web Development

OS
CYGWIN
Voice Recognition
Message Queue
Quality Assurance
Security
Firewalls
MultiMedia Applications

Development
Database
Office / Productivity
Business Management
OS/2 Apps
Server Software
Internet / Email

ITPro

OS
Storage
Encryption
Operating Systems Security
Apple Hardware
Laptops & Notebooks
Servers
Networking Hardware
Peripherals

Devices
Displays / Monitors
WebTrends / Stats
Search Engines
Firewalls
WebApplications
IDS
Vulnerabilities
Email Clients

File Sharing
Spy / Ad Blockers
Web Browsers
Web Servers
Networking
Anti-Virus
Chat / IM
Anti Spam

Developer

Web Servers
Web Browsers
Game Programming
Dev Tools
Industry Specific
Office / Productivity

Database
CYGWIN
Web Development
Search Engines
File Sharing
WebTrends / Stats

Programming
Content Management
Application Servers
Protocols

Storage

Removable Backup Media
Storage Technology
Servers

Grid
Remote Access
Backup / Restore

Misc
Hard Drives

Miscellaneous
Security
Development
Linux
VMWare

MainFrame OS
Unix
Apple
OS / 2
AS / 400

BeOS
Microsoft
VMS / OpenVMS

Database

Oracle
Miscellaneous
MySQL
Software
Sybase
Contact Management
PostgreSQL
Data Manipulation
Clarion
InterSystems Cache

Siebel
MUMPS
OLAP
SQLBase
SAS
GIS & GPS
4GL
Berkeley DB
DB2
Informix

Interbase / Firebird
FoxPro
Reporting
LDAP
Filemaker Pro
MS SQL Server
dBase
MS Access

Security

Misc
Web Browsers
Software Firewalls
Operating Systems Security
File Sharing

Spy / Ad Blockers
Vulnerabilities
WebApplications
IDS
Anti-Virus

Encryption
Anti Spam
Email Clients
VPN
Chat / IM

Programming

Editors IDEs
Installation
Handhelds / PDAs
Multimedia Programming
System / Kernel

Algorithms
Game
Signal Processing
Project Management
Open Source

Database
Misc
Languages
Processor Platforms
Theory

Web Development

Scripting
Blogs
Web Servers
Software
Search Engines
Web Graphics
Images

Internet Marketing
Images and Photos
Components
Document Imaging
Web Languages/Standards
Illustration
WebApplications

Fonts
WebTrends / Stats
Authoring
Digital Camera Software
Miscellaneous

Networking

Protocols
Apple Networking
Network Management
Message Queue
Application Servers
Content Management
File Servers
Email Servers
Misc
Java Editors & IDEs

Wireless
Networking Hardware
Backup / Restore
System Utilities
ISPs & Hosting
Web Servers
Storage Technology
Removable Backup Media
Servers
Broadband

Grid
OS / 2
Novell Netware
Unix Networking
Windows Networking
Security
Telecommunications
Operating Systems
Linux Networking

Other

Community Advisor
Lounge
Community Support
New Net Users

Philosophy / Religion
Math / Science
Miscellaneous
URLs

Expert Lounge
Politics
Puzzles / Riddles

Community Support

Suggestions
New to EE
New Topics
Community Advisor

CleanUp
Announcements
General

Feedback
Input
EE Bugs

03.06.2008 at 11:36AM PST, ID: 21063856

Rank: Master

johnsone:

I would look at the group you are in. By default it is the dba OS group that has the privileges to do this.

Also, check the setting of the remote_login_passwordfile parameter.

03.06.2008 at 12:53PM PST, ID: 21064650

LindaC:

This is the solution:

cd $ORACLE_HOME/dbs

vi init<SID>.ora

change REMOTE_LOGIN_PASSWORD=EXCLUSIVE in this way the remote connection must connect using sys/password as sysdba. This is better security than connecting as /as sysdba remotely. You will still can connect /as sysdba inside the server where the database resides.

03.06.2008 at 01:39PM PST, ID: 21065061

sikyala:

woulldn't the connection still be using the spfile?

03.06.2008 at 07:02PM PST, ID: 21066975

Rank: Master

johnsone:

If you are using spfile, then you cannot edit an init.ora to set any parameters.

If you have a text copy of your spfile, you can modify that and start up the database specifying pfile= in the startup command.

It certainly sounds like you have a password file. If you know the password stored in it, you should be able to connect using that. If not (depending on the setting of remote_login_password_file) deleting or recreating the password file with a new password should get you in.

Accepted Solution

03.07.2008 at 03:57AM PST, ID: 21069149

LindaC:

To recreate the "password file" please follow this command from the operating system:

<full ORACLE_HOME path >/bin/orapwd file=<full ORACLE_HOME path>/dbs/orapw<nSID NAME> password=<Sys password>

Assisted Solution

03.07.2008 at 05:41AM PST, ID: 21069826

sikyala:

Late yesterday I found out that the server has bigger problems. Now they can't log into the OS. I am not sure if that means that nothing may be wrong with Oracle. Now the SA's are involved because the client is seeing a white screen. I have to wait until the server is back up again before I can assist with the database issue.

03.07.2008 at 05:42AM PST, ID: 21069838

LindaC:

I will wait for you then.

03.07.2008 at 05:44AM PST, ID: 21069845

sikyala:

Thanks!

03.07.2008 at 06:10AM PST, ID: 21070050

Rank: Master

johnsone:

If there are bigger issues with the server, then there may be nothing wrong with the database.

When the server is back up, try to get in normally. If that still fails, let us know what errors you are getting.

03.07.2008 at 08:14AM PST, ID: 21071595

Rank: Wizard

schwertner:

Possibly you have also to look in Listener.ora file and to see if there are
lines for static registration of the instance.
BTW is there only one instance on that server or more then one?

03.07.2008 at 08:17AM PST, ID: 21071620

sikyala:

I would have to ask about the listener once trhe server is back up. There is only 1 instance.

03.11.2008 at 07:43AM PDT, ID: 21096152

sikyala:

still no word. The server is on a military base in Ohio. I will keep everyone posted

03.11.2008 at 07:44AM PDT, ID: 21096167

LindaC:

Ok.

03.11.2008 at 08:15AM PDT, ID: 21096497

Rank: Wizard

schwertner:

I guess they have no entry in Listener.ora for the Oracle service.
To check if the service is registered:

% lsnrctl services

This will check which services are known to the listener.

03.11.2008 at 08:16AM PDT, ID: 21096509

sikyala:

Last I heard the server itself is down. They can't get it to boot up.

03.11.2008 at 12:59PM PDT, ID: 21099498

sikyala:

The server is back up. I asked them to type the lsnrctl services and they saw the entry for the database. However, when they try to login they keep getting the following errors:

Logging in under sysdba

ORA-01031: insufficient privileges.

And if I try to login as compu and get

Error:

ORA-01034: Oracle not available

ORA-27101: Shared memory realm does not exist

SVR4 Error: 2: no such file or directory

These are the same errors as before. I don't know what could have changed on that server because the database has worked before.

03.11.2008 at 01:07PM PDT, ID: 21099586

LindaC:

To recreate the "password file" please follow this command from the operating system:

<full ORACLE_HOME path >/bin/orapwd file=<full ORACLE_HOME path>/dbs/orapw<nSID NAME> password=<Sys password>

Now also on your .profile add the PATH variable as this:

PATH=<Your ORACLE_HOME >/bin:/usr/ccs/bin:/usr/bin:/etc:/usr/openwin/bin:/usr/local/bin:/usr/sbin
export PATH
ORACLE_HOME=<Your ORACLE_HOME path>
export ORACLE_HOME

In the init<SID.ora> modify REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE

Assisted Solution

03.11.2008 at 01:14PM PDT, ID: 21099680

LindaC:

Also if you have not set the ORALCE_SID<Your SID name> then set it in the same way:

ORACLE_SID=<Your Sid name>
export ORACLE_SID

03.12.2008 at 01:02AM PDT, ID: 21103822

Rank: Wizard

schwertner:

They have to check again LISTENER.ORA fileand the following borreowing thing:

In ...\network\admin open listener.ora

see

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\Ora10g)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = test)
(ORACLE_HOME = D:\Ora10g)
)
)

Add the entry
(SID_DESC =
(SID_NAME = test)
(ORACLE_HOME = D:\Ora10g)
)
with regard to the particular Oracle Home and SID Name.

Restart the listener:
c:>lsnrctl stop
c:>lsnctl start

AFTER THIS NECESSARY THING THEY HAVE

to check TNSNAMES.ORA file.

Possibly the Hostname (or IP) or Port has been changed.

Check also if the box has more then one NIC (Network Card), Static IP.
Do they connect to the correct HostName (or IP)?

They can make a connection string entry using NETCA and test it.

If everything is OK investigate if the DB is adjusted for automatic startup or not.
Look for /etc/oratab file - entry 'Y' for that instance.
And dbora shell script in the startup level of the machine.

In any case try to start the instance. As Linda said check if ORACLE_SID is set (printenv command as 'oracle' user).

Start it so:
% sqlplus /nolog
SQL>connect / as sysdba
or
SQL>connect sys/<the_password>@<the tnsname_alias> as sysdba

connect to idle instance
SQL> startup

And say them that I have worked in Columbus/Ohio and send them greetings!

Assisted Solution

03.12.2008 at 06:03AM PDT, ID: 21105441

LindaC:

I had a boyfriend Pennipecker in case you know him send him greetings !

03.12.2008 at 06:04AM PDT, ID: 21105446

sikyala:

They sent me an email saying that they are editing the listener.ora and tnsnames.ora files. I have sent several emails and haven't gotten a response yet.

03.12.2008 at 06:07AM PDT, ID: 21105458

sikyala:

I called them just now and they say that after editing the listener file they were able to restart the listener. I have to wait on responses to my other emails.

03.12.2008 at 06:08AM PDT, ID: 21105469

LindaC:

Also if they can connect to the database, because "insuffici